NEW
Font size
WorksheetsSpreadsheet Overview (Basic)
Total questions: 20
Worksheet time: 20mins
What software do we use to create spreadsheet?
Word
PowerPoint
Publisher
Excel
What is the purpose of spreadsheet?
To present information on different engaging slides
To deliver a speech to a crowd
To perform basic and complex mathematical calculation
To excel your research papers and citations
Each box on a spreadsheet is called a ________________.
Box
Cell
Row
Column
Cells that run horizontally on a spreadsheet
Row
Column
Cells that run vertically on a spreadsheet
Row
Column
The letter at the top of each column is called a:
Cell reference
Column header
Row header
Range
The number to the left of a row is called a:
Cell reference
Column header
Row header
Range
The cell that is currently selected
Cell reference
Cell range
Label
Active cell
A single page in Excel is called a:
Worksheet
Workbook
Multiple pages in Excel is called a:
Worksheet
Workbook
Which is an example of a cell reference in a spreadsheet?
6C
45
fall
B9
Double-clicking between two columns will _______________ the column.
Delete
Resize
Copy
Fill
Format cells as _______________ when working with amounts of money.
Scientific
Percent
Currency
Number
If you want to change the colour of the text inside a cell, which tool would you use?
Text colour
Borders
Fill colour
Bold
A group of cells is called _______________.
Range
Autosum
Row
Column
Place where you can rename each worksheet is called _______________. It is located at the bottom of the worksheet window.
Name Box
Formula
Chart
Sheet Tab
SUM, AVERAGE, MAX and IF are examples of what?
Formulae
Function
Tables
Statistical Tools
When you key in a formulae or function in a spreadsheet, what do you key in first?
Addition symbol
Hashtag symbol
Equal symbol
Asterisk symbol
In Excel, what is this button used for?
To change the border colour
To change the colour of an image
To change the font colour
To fill the cell with a colour
Which tab in Excel has charts and tables?
Home tab
Insert tab
File tab
View tab
