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

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

Question 17

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

Question 18

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 19

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

Question 20

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 21

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 22

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 23

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 24

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 25

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

Question 26

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 27

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

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