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 a related value from a table row
  2. Sorts table rows by one column
  3. Counts cells matching a rule
  4. Combines two worksheets into one

Question 10

Which spreadsheet reference remains fixed when a formula is copied?
  1. $A$1
  2. A1
  3. $A1
  4. A$1

Question 11

A formula containing A1 is copied one column right. What happens to the relative reference?
  1. It changes to B1
  2. It stays as A1
  3. It changes to A2
  4. It becomes $A$1

Question 12

What is a workbook?
  1. A file containing one or more worksheets
  2. A single grid of cells
  3. A selected group of cells
  4. A visual display of data

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 a chart in a spreadsheet?
  1. Show patterns and comparisons visually
  2. Calculate values using cell references
  3. Restrict entries to permitted values
  4. Store raw data in worksheet cells

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. Changes cell appearance when rules are met
  2. Rejects entries outside permitted rules
  3. Changes the value calculated by a formula
  4. Reorders rows by their values

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 formulas or continues patterns
  2. Fixes selected references as absolute
  3. Filters rows by selected criteria
  4. Creates a chart from selected cells

Question 22

What does ascending sort do to numbers?
  1. Orders them from smallest to largest
  2. Orders them from largest to smallest
  3. Keeps them in their original order
  4. Groups equal values without ordering them

Question 23

What does the range A1:A10 represent?
  1. Cells A1 to A10
  2. Cells A1 and A10
  3. All cells in row 1
  4. All cells in column 10

Question 24

Which function finds the mean of values in B2:B8?
  1. =AVERAGE(B2:B8)
  2. =TOTAL(B2:B8)
  3. =MEAN(B2:B8)
  4. =COUNT(B2:B8)

Question 25

What does a spreadsheet filter do?
  1. Shows rows matching chosen criteria
  2. Reorders every row by one column
  3. Rejects new entries outside a range
  4. Changes matching cells to a new colour

Question 26

Why would a spreadsheet use data validation?
  1. To restrict entries to suitable values
  2. To check that a formula gives an expected result
  3. To prevent a cell being edited
  4. To sort rows into order

Question 27

Which chart is best for showing change over time?
  1. Line chart
  2. Pie chart
  3. Scatter graph
  4. Table

Question 28

What is a spreadsheet formula?
  1. An instruction that calculates a value
  2. A built-in named calculation
  3. An address identifying one cell
  4. A visual display of selected data

Question 29

What does the $ sign do in $B4?
  1. Keeps the column fixed when copied
  2. Keeps the row fixed
  3. Turns the cell into text
  4. Multiplies the value by a dollar

Question 30

Why use cell references instead of typed totals in a formula?
  1. The result updates when source data changes
  2. The formula needs fewer arithmetic operators
  3. The source cells become locked
  4. The input values are checked for validity

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