Course completion quiz

Google Sheets Final Quiz

Answer 20 questions covering all ten lessons, including practical scenarios, troubleshooting, and choosing the right steps. Complete all ten lessons and score at least 85 percent (17 of 20 correct) to earn a printable course-completion certificate.

Final quiz

Choose one best answer for each question based on the course material. There are two questions from each lesson and four choices per question. Question and answer order changes each time. There is no time limit. After grading, read the explanations and use the lesson links to review before retaking the quiz.

1. A spreadsheet is open, but the screen reader is not identifying cells as expected. What is the best initial check? Change all cell formats before checking accessibility settings Confirm the active editing area and Sheets' screen-reader support setting Export the file immediately and assume the browser version is unusable Rename the sheet and retry the same keystroke without checking focus

2. Two similarly named spreadsheets are open in different accounts. What should you confirm before entering work data? The active account, file, worksheet, and cell Only the visible spreadsheet title Only the most recent download's filename Only the browser's product name

3. You intend to format B2:B6, but only B2 is active. What must happen before applying the change? Switch worksheets and apply the format there Select and verify the full intended range Format B2 and assume the remaining cells follow Move to B6 without selecting the intervening cells

4. A command changes the wrong worksheet. What context check would have prevented this? Confirm only that autosave is available Confirm only the selected cell's text color Confirm only the spreadsheet's title Confirm the active sheet before selecting the range

5. A filled series was expected to increase, but every destination repeats the same value. What should you inspect? Only the spreadsheet's sharing setting Only the workbook's download format Only the browser's page zoom The seed values, fill method, and resulting cells

6. You found a misspelled department name in several unrelated records. What should guide replacement? Review the intended matches and replacement scope before applying it Replace every similar-looking word across all sheets immediately Apply bold to matching cells instead of correcting their values Change the column heading and assume existing entries update

7. B2:B4 contains 4, 6, and 8. Which result should =AVERAGE(B2:B4) return? 4 6 18 8

8. A total should include B2 through B6, but the formula uses B2:B5. What must be corrected? Rename the result cell's label to Grand Total Change the cell's format to Currency Extend the formula's range to include B6 Round the existing total to fewer decimals

9. A sheet has columns labelled Value, Value, and Value. What would most improve interpretation? A different background color for each Value column A larger font for the first repeated label Wider columns with the same three labels Specific headers identifying each measure and its units where needed

10. A cost of 12.5 should display as money with two decimals. Which change preserves its numeric usefulness? Apply an appropriate currency number format Merge the cost with the item description Put the currency amount only in the sheet name Replace it with the text twelve dollars fifty

11. You sort only the Names column of a table containing names and phone extensions. What can go wrong? Every phone extension will be recalculated automatically Names may become paired with the wrong extensions The table will be converted into a chart All records will necessarily be removed

12. A filter shows three of ten records. Which conclusion is justified? Seven records were permanently deleted by filtering The visible rows necessarily have the highest values The spreadsheet now contains exactly three records in total Seven records are currently hidden by the filter, if no other changes occurred

13. You want new Status entries chosen from New, Waiting, and Closed. Which approach fits? A formula that totals an unrelated numeric column A comment listing the values with no entry rule A different font for each manually typed variant A validation rule offering those allowed values

14. A status formula should mark a target as met when completed work equals the requirement. Which boundary case must you test? Only a blank row outside the formula's range Only a record with a different text label A value exactly equal to the requirement Only a value far above the requirement

15. Monthly totals are 10, 15, and 20. Which chart summary best conveys the trend and values? The last bar is on the right side of the chart The chart contains three bars in different colors The total rose from 10 to 20, increasing by 5 each month The chart was created from three spreadsheet rows

16. A chart's bars look reasonable, but its selected source range omits the last month. What should happen? Remove the final month from the table to match the chart Change the chart colors and retain the existing range Correct the range and verify the chart and summary against the data Keep the chart because its visual trend appears plausible

17. A recipient needs editable formulas and multiple worksheets. Which export is a better starting point than CSV or PDF? A screenshot renamed with an XLSX extension XLSX, followed by a compatibility check CSV, with the expectation that every sheet and formula survives PDF, with the expectation that formulas remain editable

18. A teammate only needs to inspect the tracker. Which permission is the least needed for that task? Ownership transfer Editor Viewer Public editing access

19. Your exported tracker opens, but a status formula differs from the original. What should you do before delivery? Compare and correct the formula, then retest representative records Replace every result with an unverified typed value Change the filename and leave the formula unchanged Treat successful opening as proof of full compatibility

20. Which review best supports a usable shared-work tracker? Check data, formulas, labels, instructions, permissions, and the exchange copy Check only that all columns have equal width Check only that the first record is complete Check only that a download was created

Google Sheets Final Quiz

Final quiz

Create your certificate

Certificate of Course Completion