NEW
Font size
WorksheetsSpreadsheets
Total questions: 25
Worksheet time: 13mins
What is an electronic spreadsheet?
A table of data that can be processed
A table of data in a word document
A table of data on a piece of paper
A large piece of cloth spread over a flat surface
Which of these could a spreadsheet NOT be used for?
Creating a graph from your science investigation results
Calculating the cheapest mobile phone package from a range of choices
Finishing your English writing homework
Storing the test results for a class of year eight pupils
Which of the following is capable of producing a spreadsheet?
Microsoft Access
Microsoft Excel
Microsoft Word
Notepad
The place where a row and a column cross in a spreadsheet is called a ______
Cell
Formula
Data
Point
What word is used to describe re-organising the order of data?
Search
Sort
Fill
Filter
In a cell reference, for example A1, what does the letter refer to?
The row the cell is in
The column the cell is in
The worksheet the cell is in
The precise location of the cell.
A formula must always start with which symbol?
Equals =
Add +
Brackets (
The name of the formula (e.g. ADD)
What symbol is used to make a cell reference absolute?
Dollar $
Exclamation mark !
Ampersand &
Colon :
Why might charts and graphs be a way of making the data in a spreadsheet easier to understand?
Because bar charts are taught early and so everyone understands them.
Because they don't require you to enter any formula.
Because the data is presented in a more visual way.
In a cell reference, for example A1, what does the number refer to?
The row the cell is in
The column the cell is in
The worksheet the cell is in
The precise location of the cell
What is a group of cells in a spreadsheet called?
Cell range
Cell reference
Formula
Table
A single page in a Spreadsheet is called a:
Worksheet
Workbook
Data
Table
To quickly add up all the values in multiple cells we use the formula
SUM
TOTAL
ADDALL
PRODUCT
To find a value associated with another value we can use the formula...
VLOOKUP
MAX
SEARCH
MATCH
To find the highest value in across multiple cells we can use the formula...
MAX
BIGGEST
LARGEST
TOP
Fill in the blank:
A formula tells the computer to __________ data held in specific cells.
Process
Program
Punctuate
Delete
What symbol is used for division in a spreadsheet?
*
/
^
\
Which of the following is NOT a valid formula?
=SUM(A1:A6)
=SUM(A1,A2,A3,A4,A5,A6)
=SUM(A1 to A6)
=SUM(A1:A4,A5,A6)
In the formula
=VLOOKUP(A1, A2:D10, 3)
What cell contains the value being searched for in the table
A2
A1
D10
3
In the formula
=VLOOKUP(A1, A2:D10, 3)
The value in A1 will be compared to the values in which column?
A
B
C
D
Which formula would count the number of cells containing the word Yes in the D column?
=COUNT("Yes",D:D)
=COUNTIF("Yes",D:D)
=COUNT(D:D,"Yes")
=COUNTIF(D:D,"Yes")
Which option would subtract D12 from D13?
=D13-D12
=MINUS(D13-D12)
=SUB(D13,D12)
=D12-D13
It is possible to create a graph from the data in a spreadsheet
TRUE
FALSE
You are creating a spreadsheet to calculate the cost of a party. You want to know how much you will spend on food. Why is it better to use a formula rather than working out the total yourself?
It will make it easier if you want to rearrange your spreadsheet
A formula will instantly calculate the change in cost if you update the price of the food
The spreadsheet will look tidier if your use a formula
It is always faster to calculate the answer in your head, you should not use a formula.
It is possible to automatically change how a cell looks based on the contents of the cell
TRUE
FALSE
