MS Excel
🔒 Log in to trackSpreadsheet structure, cell references, functions, formula errors, charts and shortcuts. Excel gives the most 'compute-the-answer' questions in CKT - COUNT/IF/VLOOKP outputs are verifiable, so marks are safe.
One page per subtopic: detailed notes, every question type, formulas, tricks and practice sets.
Every formula on one printable page, grouped by subtopic.
5 exam-level questions worked step by step.
83 questions — untimed practice or a timed test with analysis.
Track record in the exam
Test difficulty mix (83 questions)
Question patterns exams keep repeating
Taken from previous-year papers. If a pattern is marked "very common", expect to see it in your exam.
Output of an Excel function
very commonA few cells (may include text or blanks) and "=AVERAGE(...) gives?"
Work the function by hand.
SUM and AVERAGE skip text and blank cells.
A1 = 10, A2 = 20, A3 = "abc" (text), A4 = 30. What does =AVERAGE(A1:A4) return?
Text cell is skipped, so numbers are 10, 20, 30
Sum = 60
Count of numbers = 3
Average = 60 ÷ 3 = 20
Excel shortcut keys
very common"Shortcut for AutoSum" or "shortcut to insert the current date".
Learn: Alt+= AutoSum, Ctrl+; today's date, F2 edit cell.
Ctrl+D is Fill Down, not date.
The shortcut for AutoSum in MS Excel is:
AutoSum writes the SUM formula for you
It uses the Alt key with the equals key
Ctrl+D is Fill Down, not AutoSum
Answer: Alt+=
Excel error messages
very commonA cell shows an error code and the reason is asked.
#DIV/0! = divide by zero. #NAME? = unknown name.
#VALUE! = wrong data type. #REF! = deleted cell. #N/A = not found.
A cell shows #NAME?. What is the most likely reason?
#NAME? means Excel does not know a word in the formula
Example: =SUIM(A1:A5) has a misspelt function
So the function name is wrong
Answer: Misspelt function name
Choose the right chart
common"Which chart best shows a trend over time?"
Line = trend over time. Pie = parts of one whole.
Column or bar = compare categories.
Which chart best shows the monthly growth of users during a year?
Months in a row = time
Showing change over time needs a line
A pie cannot show time
Answer: Line chart
Formula after copy-paste
commonA formula is copied to another cell and the new formula is asked.
References without $ move with the copy.
1 never moves.
C1 has =A1+B1. It is copied to C3. What does C3 contain?
C3 is 2 rows below C1
Both references have no $, so both move down 2 rows
A1 becomes A3, B1 becomes B3
Answer: =A3+B3
COUNT, COUNTA and COUNTBLANK
commonA range with numbers, text and blanks, and "=COUNT(...) gives?"
COUNT counts only numbers.
COUNTA counts all filled cells. COUNTBLANK counts empty cells.
A1 = 5, A2 = "word", A3 is blank, A4 = 9. What does =COUNT(A1:A4) give?
Numbers are 5 and 9
"word" is text, A3 is empty
COUNT counts only numbers
Answer: 2
Rows and columns in a sheet
common"How many rows does an Excel 2007 sheet have?" or "the last column label".
Excel 2007 and later: 1,048,576 rows and 16,384 columns.
The last column is XFD. Old Excel 2003 had 65,536 rows and 256 columns (last IV).
What is the last column label of an Excel 2016 worksheet?
Excel 2016 has 16,384 columns
Column labels run A to Z, then AA and so on
The 16,384th column is XFD
Answer: XFD