Font size
WorksheetsMicrosoft Excel
Total questions: 22
Worksheet time: 11mins
Which is the formula sign to multiply?
=
*
x
+
Which is the term for the blank “rectangles” on a worksheet?
boxes
rectangles
squares
cells
Which symbol must you use at the beginning of a formula?
=
#
-
:
Which is the best tool to use if you want to continue a series of numbers down a column or across a row?
Cut & Paste
Spell Checker
Autofill
Find & Replace
If you left click on a letter at the top of your worksheet, what does this do?
Select a range of cells
Select a cell
Select the row
Select the column
Which is the name of the bar above the worksheet that always shows the contents of the active cell?
Cell Bar
Formula Bar
Status Bar
Information Bar
If you click on a number on the left of the worksheet, what have you done?
Selected a row
Selected a column
Autofilled that row
Copied that row
Columns are …….
diagonal.
vertical.
horizontal.
absolute cells.
If you see ##### in a cell, what does this usually mean?
The contents are too large/wide to display
The formula has an error
Text was entered where numbers should be
There was a spelling error
If you selected A1:C6, for example, what is this called?
Row
Group of cells
Cell range
Column
What kind of software is Microsoft Excel?
Spreadsheet software
Word Processing software
Presentation software
Database software
Rows are ......
Diagonal
Horizontal
Vertical
What are the lines than can be added around cells called?
Squares
Boxes
Gridlines
Rectangles
What does "merge" mean in Microsoft Excel?
to join cells together
to add borders around cells
to fill cells with colour
to save the file
What happens when the cursor changes to the black plus sign with the sideways arrows in this image?
You can move the contents of the selected area to another area
You can change the height of the row or rows to fit the contents
You can change the width of the column or columns to fit the contents
You can Autofill either down the column or across the row
What happens when your cursor changes to the black plus sign with up and down arrows in this image?
You can change the height of the row or rows
You can change the width of the column or columns
You can Autofill either down the column or across the row
You can move the contents of the selected area to another area
What is the cell reference for the active cell in the image?
C4
4C
A4
D5
What can you do when the cursor changes to the big plus sign in this image?
You can Autofill either down a column or across a row
You can move the cells to another position on the worksheet
You can select cells when you drag your cursor over the cells
You can change either the height of the row or rows and the width of the column or columns
In the formula in the image you can see that A3 is absolute so when you autofill across the row it will stay on A3. (True or False)
False
True
In the formula in the image you can see that C1 is absolute so when you autofill across the row it will stay on C1. (True or False)
False
True
What happens if you left click on the grey triangle in the top left of your worksheet? (The red arrow is pointing to it)
Selects Column B
Selects row 1
Selects the worksheet
Selects the grey triangle
Which could be the correct formula for G5?
=G1*A5
=A5*G1
=$A$5*G1
=G1*$A$5
