Skip to main content

← back to the guide

SQA Higher Administration and IT Spreadsheets overview quiz quiz

15questions. Pick an answer and you'll see why right away.

  1. What happens to an absolute cell reference such as BB2 when the formula is copied to another cell?

  2. When would a relative cell reference (such as B2) be the right choice?

  3. Which formula displays "Pass" when C2 is 50 or more and "Fail" otherwise?

  4. What does the COUNTIF function do?

  5. Which function would you use to add up only the sales for the "North" region held in a list?

  6. What does the VLOOKUP function do?

  7. Conditional formatting in a spreadsheet is used to:

  8. What is the difference between a workbook and a worksheet?

  9. Consolidating data in a spreadsheet means:

  10. A benefit of consolidating data onto a summary sheet is that it:

  11. A disadvantage of dynamically linking a spreadsheet table into a report is that:

  12. Which chart type is most appropriate for showing each product's percentage share of total sales?

  13. Which chart type best shows a trend in monthly sales over a year?

  14. Printing a spreadsheet in formulae view is useful because it:

  15. Which printing option scales a large spreadsheet so that it fits on a set number of pages?