Microsoft Excel: Working with Spreadsheets — Quiz

Answer all 10 questions, then submit. You need 60% to pass. Log in to save progress.

Question 1
In a spreadsheet, what is a 'cell'?
A A row of numbers
B A single box where a row and column meet
C The whole worksheet
D A saved file
Question 2
How is the cell in column C, row 4 written?
A 4C
B C-4
C C4
D Row4ColC
Question 3
Every Excel formula must begin with which symbol?
A The plus sign +
B The equals sign =
C The hash sign #
D The at sign @
Question 4
If cells B2 to B6 hold 10, 20, 30, 40 and 50, what does =SUM(B2:B6) return?
A 30
B 50
C 150
D 5
Question 5
What does =AVERAGE(B2:B6) do?
A Finds the largest number in the range
B Adds up all the numbers
C Counts how many cells there are
D Finds the average (total divided by how many)
Question 6
Which formula finds the LARGEST number in a range?
A =MAX(B2:B6)
B =MIN(B2:B6)
C =COUNT(B2:B6)
D =SUM(B2:B6)
Question 7
A number cell suddenly shows ##### instead of the number. This means…
A The number was deleted
B The formula has an error
C The column is too narrow to show it
D Excel has crashed
Question 8
What does the Freeze Top Row option do?
A Deletes the top row
B Keeps the heading row visible while you scroll down
C Locks the file so no one can edit it
D Sorts the top row
Question 9
Which chart type is best for showing parts of a whole, like how a budget is split?
A A line chart
B A pie chart
C A column chart
D No chart can do this
Question 10
What is the quickest way to save your latest changes once a file already has a name?
A File > Save As every time
B Press Ctrl + S
C Close and reopen the file
D Print the file