WorksheetsCAB+ Term 6 - Spreadsheets
Total questions: 24
Worksheet time: 25mins
Each box / rectangle on a spreadsheet is called a ...
Your "best friend" on a computer if you make a mistake is...
Dr. Haines
undo (CTRL Z)
A line of cells that runs vertically (up and down) on a spreadsheet is called a...
A line of cells that run horizontally (side to side) on a spreadsheet is called a...
What is the file extension for MS Excel worksheet file ?
.doc
.html
.exl
.xlsx
A group of cells in a spreadsheet is called a...
Active cell
Formula
Cell Address or Cell Reference
Which is an example of a cell address / reference in a spreadsheet?
CAB
Click and drag the ___________ tool to apply the same formula to neighbouring cells.
If you select (click in) a cell to start working in it, it is now called the what?
cell
selected range
active cell
worksheet
Which of these is what we call an equation to answer a maths question in a spreadsheet?
program
formula
cell
row
Which function is used to find the BIGGEST value in a range of values?
MAX( )
MIN( )
The function to add-up a range of numbers is called...
The function to find the SMALLEST value in a range of values is called:
When working with money, which format should use use on the cells?
Which function is used to only count cells with NUMBERS in?
COUNTIF
COUNTA
COUNTBLANK
COUNT
Which function is used to count cells that have either TEXT or NUMBERS in?
COUNT
COUNTIF
COUNTA
COUNTBLANK
