NEW
Font size
S
M
L
XL
WorksheetsQuiz - Dec 11
Total questions: 15
Worksheet time: 5mins
Name
Class
Date
1.
Which cell reference will not change if copied or moved?
a)
&A&2
b)
A*2
c)
$A$2
d)
%A%2
2.
How does a relative reference differ from an absolute reference?
a)
A relative reference specifies column and row references
b)
A relative reference adjusts to its location on the worksheet
c)
A relative reference refers to an existing cell reference
d)
A relative reference refers to an original value
3.
Which of the following is an absolute cell reference?
a)
P72
b)
G$9
c)
$K356
d)
$F$8
4.
What is the name given to a value that does NOT change when used within a formula?
a)
Reference
b)
Constant
c)
Function
d)
Address
5.
Which of the following is an mixed cell reference with a fixed column address?
a)
P72
b)
G$9
c)
$K356
d)
$F$8
6.
Which of the following is mixed cell reference with a fixed row address?
a)
P72
b)
G$9
c)
$K356
d)
$F$8
7.
Which of the following is a relative cell reference?
a)
P72
b)
G$9
c)
$K356
d)
$F$8
8.
A_________ is a built in mathematical formula included in excel.
a)
Function
b)
Cell
c)
Formula
d)
Range
9.
What does a range of cells mean?
a)
A column
b)
A Row
c)
A Spreadsheet
d)
A number of cells
10.
A Relative formula is....?
a)
The same formula but different cell reference
b)
Anchors the cell reference
c)
Anchors one cell
d)
A function
11.
What is an absolute Formula?
a)
One cell reference remains anchored when dragged down for copying
b)
The cell reference changes as it is being dragged down for copying
c)
A filter
d)
A function
12.
Under what menu and grouping of commands will you find the Sort tool in Excel?
a)
File>Edit
b)
Edit>Format
c)
Page Layout>Sheet Options
d)
Home>Editing
13.
In an Excel table, which of the following tasks allows you to arrange rows in order by the data in one of the columns?
a)
Arranging
b)
Filtering
c)
Sorting
d)
Organizing
14.
Which of the following addresses is a valid cell range address in an Excel worksheet?
a)
A1
b)
A1:C4
c)
A1-C4
d)
C4:A1
15.
What format is used for dollar amounts?
a)
Normal
b)
Accounting
c)
Date
d)
Time
Reset
