Spreadsheets questions

By Interwoven Maths

Spreadsheets question collection

Review Spreadsheets questions for Computer Science, with correct answers shown and coverage across cells, rows and columns; formulae and functions; formatting and charts.

Back to Spreadsheets practice Back to Computer Science

Question 1

What does cell reference A3 mean?
  1. Column A, row 3
  2. Row A, column 3
  3. Sheet 3, column A
  4. Cell format A3

Question 2

What starts a spreadsheet formula?
  1. =
  2. +
  3. #
  4. @

Question 3

What does SUM do?
  1. Adds values
  2. Finds average
  3. Finds largest value
  4. Counts matching cells

Question 4

What does AVERAGE do?
  1. Finds the mean
  2. Finds median
  3. Finds maximum
  4. Finds total

Question 5

What does MAX do?
  1. Finds largest value
  2. Finds smallest value
  3. Finds mean
  4. Counts cells

Question 6

What does MIN do?
  1. Finds smallest value
  2. Finds largest value
  3. Finds mean
  4. Adds values

Question 7

What does IF do?
  1. Returns different results based on a condition
  2. Adds all values in a selected range
  3. Finds the largest value in a range
  4. Counts cells that match a condition

Question 8

What does COUNTIF do?
  1. Counts cells matching a rule
  2. Adds all cells
  3. Finds smallest value
  4. Looks up table data

Question 9

What does VLOOKUP do?
  1. Returns related table data
  2. Sorts a table
  3. Counts blanks only
  4. Creates a chart

Question 10

Which is an absolute reference?
  1. $A$1
  2. A1
  3. $A1
  4. A$1

Question 11

What happens to A1 when copied?
  1. It changes position
  2. It stays fixed
  3. It becomes text
  4. It locks the sheet

Question 12

What is a workbook?
  1. A file of worksheets
  2. A single cell
  3. A chart title
  4. A formula list only

Question 13

In B7, which part is the row?
  1. 7
  2. B
  3. B7
  4. Sheet name

Question 14

In B7, which part is the column?
  1. B
  2. 7
  3. B7
  4. Workbook name

Question 15

Which is a valid formula?
  1. =A1+B1
  2. A1+B1
  3. =A1+B1=
  4. SUM=A1+B1

Question 16

Why use charts?
  1. To visualise data
  2. To lock cells
  3. To remove errors
  4. To write formulas

Question 17

Which chart is best for comparing categories?
  1. Bar chart
  2. Pie chart
  3. Line chart
  4. Scatter chart

Question 18

Which chart is best for showing parts of a whole?
  1. Pie chart
  2. Bar chart
  3. Line chart
  4. Histogram

Question 19

What does conditional formatting do?
  1. Formats cells by rules
  2. Locks worksheet
  3. Deletes duplicates
  4. Builds macros

Question 20

What is a spreadsheet function?
  1. Built-in formula
  2. Worksheet name
  3. Chart label
  4. Keyboard shortcut

Question 21

What does the fill handle do?
  1. Copies patterns or formulas
  2. Locks selected cells
  3. Deletes empty rows
  4. Creates a pivot table

Question 22

What does ascending sort do?
  1. Smallest to largest
  2. Largest to smallest
  3. Random order
  4. Newest to oldest always

About this topic

Review Spreadsheets questions for Computer Science, with correct answers shown and coverage across cells, rows and columns; formulae and functions; formatting and charts.

This topic covers

Example question types