WorksheetsMicrosoft Excel Formulas and Absolute Cell References
Total questions: 13
Worksheet time: 7mins
Name
Class
Date
1.
A type to cell reference that does not change when copied or filled is called
a)
Cell reference
b)
Absolute cell reference
c)
Relative cell reference
2.
A cell reference that changes when copied is called
a)
Cell reference
b)
Absolute cell reference
c)
Relative cell reference
3.
You can use an _________________ to keep a row and/or column constant.
a)
Relative cell reference
b)
Absolute cell reference
4.
To create an absolute cell reference a ______________ must be inserted.
a)
+
b)
=
c)
*
d)
$
5.
To use multiple worksheets as possible cell reference may state ________________.
a)
Sheet1!A1
b)
Sheet1$A1
c)
=Sheet$1A$1
6.
What sybmol is used to mulitiply
a)
+
b)
*
c)
)
d)
/
7.
In Excel, all formulas must begin with what symbol?
a)
#
b)
=
c)
$
d)
!
8.
Which of these formulas uses relative cell references?
a)
=5*10+20
b)
=$A$10/100
c)
=F18+F19/2
9.
What term refers to mathematical equations used in Excel to perform calculations?
a)
Summations
b)
Cell
c)
Format
d)
Formulas
10.
Which of these number formats would you want to apply to a cell showing the total sales for the month?
a)
Currency
b)
Percentage
c)
Date
d)
None of the others
11.
What does it mean to merge cells?
a)
Combine 2 or more cells into a single cell.
b)
Apply a border around a set of cells.
c)
Split a single cell into 2 or more cells.
d)
Center the contents of the cells.
12.
What happens when you hide a column in Microsoft Excel?
a)
The data in the column is deleted.
b)
The column doesn't appear, but the data is still there.
c)
Formulas referencing cells in the column stop working.
d)
None of the others.
13.
Why would you want to change the column width?
a)
To draw attention to the data in those cells.
b)
To make sure the column headings are always visible when scrolling.
c)
To make sure all of the information in the column is visible.
100 %
