- Foundation
- About 25 min
- 15 practice questions
Final self-assessment: Spreadsheet basics
Test yourself on the whole course: 15 questions with answers explained.
If something looks wrong, please tell us.
Attempt all 15 questions in one sitting of about 25 minutes, working out each formula on paper before you look at the options. The questions mix ideas from all five lessons and are a little harder than the lesson checks. Check your answers only when you have finished, and read every explanation.
Final self-assessment
-
1. How many cells are in the range C4:F10?
- 24
- 21
- 32
- 28
Show answer
Answer: D. Columns C, D, E, F are 4 columns; rows 4 to 10 are 7 rows. Cells = 4 × 7 = 28.
-
2. Which column is the 30th column of a sheet?
- AC
- AD
- AE
- BD
Show answer
Answer: B. Columns 1-26 are A-Z. Column 27 is AA, 28 AB, 29 AC and 30 AD.
-
3. In Microsoft Excel, a formula refers to cell A1 of a sheet named Sheet2. How is it written?
- =Sheet2!A1
- =Sheet2.A1
- =A1!Sheet2
- =Sheet2:A1
Show answer
Answer: A. Excel separates the sheet name and the cell with an exclamation mark: Sheet2!A1. LibreOffice Calc's own form uses a dot, Sheet2.A1.
-
4. A1 holds 1234.5 formatted as currency with no decimal places, so it shows ₹1,235. What does =A1*2 return?
- 2470
- 2468
- 2469
- 1235
Show answer
Answer: C. Formatting changes only the display. The stored value is still 1234.5, so =A1*2 = 2469.
-
5. Which entry will a spreadsheet store as text rather than a number, with default settings?
- 110001
- =110001
- '110001
- 110001.0
Show answer
Answer: C. An apostrophe in front forces text, so '110001 is stored as text (useful for codes). The others are all stored or calculated as the number 110001.
-
6. You select A1:A2 holding 3 and 7 and drag the fill handle to A5. What is in A5?
- 15
- 19
- 11
- 28
Show answer
Answer: B. The step is 7 − 3 = 4: A3 = 11, A4 = 15, A5 = 19.
-
7. What does =3*4+6/2^1 return?
- 15
- 9
- 12
- 21
Show answer
Answer: A. Power first: 2^1 = 2. Then multiply and divide left to right: 3 × 4 = 12 and 6 ÷ 2 = 3. Finally add: 12 + 3 = 15.
-
8. B2 holds =$A2*B$1. It is copied to E4. What formula is in E4?
- =$A2*E$1
- =$D4*E$3
- =$A4*B$1
- =$A4*E$1
Show answer
Answer: D. The move is 3 columns right and 2 rows down. In $A2 the column is fixed and the row moves 2 to row 4: $A4. In B$1 the row is fixed and the column moves 3 from B to E: E$1.
-
9. B2 holds =A2*E1 (no dollar signs) and E1 holds 18%. B2 is copied to B3, and E2 is empty. What does B3 show if A3 holds 500?
- 90
- 18
- #REF!
- 0
Show answer
Answer: D. Copying one row down moves both relative references, so the new formula multiplies A3 by E2 instead of E1. E2 is empty, which counts as zero, so 500 × 0 = 0. Making the rate absolute ($E$1) would have given 500 × 18% = 90.
-
10. A1:A3 hold 15, 25 and 35, and A4 is empty. What does =AVERAGE(A1:A4) return?
- 18.75
- 75
- 25
- 20
Show answer
Answer: C. AVERAGE ignores empty cells: (15 + 25 + 35) ÷ 3 = 75 ÷ 3 = 25. Dividing by 4 to get 18.75 would be wrong.
-
11. A1:A3 hold 8, 0 and 12. What does =COUNT(A1:A3) return?
- 3
- 2
- 20
- 1
Show answer
Answer: A. Zero is a number, so COUNT counts all three cells: 3. Only text and empty cells are left out.
-
12. What does =ROUND(1234.567,-2) return?
- 1234.57
- 1200
- 1230
- 1300
Show answer
Answer: B. A digit count of −2 rounds to the nearest hundred. 1234.567 lies between 1200 and 1300 and is nearer 1200 (the tens digit is 3), so the result is 1200.
-
13. A1 holds Rahul and B1 holds Kumar. What does =LEFT(A1,1)&B1 return?
- R Kumar
- RKumar
- Rahul Kumar
- RahulK
Show answer
Answer: B. LEFT(A1,1) takes the first character, R, and & joins it to Kumar with nothing in between, giving RKumar.
-
14. You select only the Marks column of a name-and-marks table and sort it from largest to smallest. What is the likely result?
- The whole table is sorted correctly
- Nothing changes, because sorting needs two columns
- The names are sorted alphabetically too
- Marks are reordered but names stay put, so rows no longer match
Show answer
Answer: D. Sorting one column alone moves only that column's cells, which breaks every row. Click inside the table (or select the whole table) before sorting.
-
15. A teacher wants to compare the average marks of 12 subjects whose names are long. Which chart suits best?
- Pie chart
- Line chart
- Bar chart
- Doughnut of one subject
Show answer
Answer: C. Comparing many categories with long labels is easiest with horizontal bars, which leave room for the names. A line suggests a time trend, and a pie shows parts of one whole.
Use your results to choose what to revise. Questions 1-3: lesson 1 (cells, ranges, columns and sheets). Questions 4-6: lesson 2 (entering data, formats and AutoFill). Questions 7-9: lesson 3 (order of operations and references). Questions 10-13: lesson 4 (functions). Questions 14-15: lesson 5 (sorting and charts). Redo each wrong formula question by hand before moving on.
Sign in to keep track of the lessons you finish.