NEW
Font size
WorksheetsICT Spreadsheets
Total questions: 12
Worksheet time: 5mins
What is a correct name for a cell?
C3
Cell3
Field3
C3PO
What are spreadsheets used for?
To store, search and sort information.
To calculate data and create charts
Which is the correct formula to multiply?
=B6*C6
B6*C6
B6C6*
*B6C6
Which is the correct formula to divide?
B6/C6
=B6/C6
/B6C6
B6C6/
What are the steps to create a chart?
Highlight cells, click "Insert" and choose a chart
Click "Insert" and choose a chart
Highlight cells, click "View" and choose a chart
Highlight cells, click "Data" and choose a chart
What can you NOT do with spreadsheets?
Increase the column width
Increase the row height
Make text within a cell bold, underlined or Italic
Animate text within a cell
What function do you use to add cells together?
SUM
MIN
MAX
AVERAGE
What function do you use to find the lowest number?
SUM
MAX
MIN
AVERAGE
Name this
Cell
Row
Column
Name this
Cell
Row
Column
Name this
Cell
Row
Column
What is happening in Total Sales?
Replication
Formatting a cell
Creating a formula
Using a function
