NEW
Font size
S
M
L
XL
WorksheetsExcel function quiz
Total questions: 20
Worksheet time: 10mins
Name
Class
Date
1.
Which feature in Excel allows you to view two spreadsheets in one window?
a)
Freeze panes
b)
Split
c)
View side by side
2.
A_________ is a built in mathematical formula included in excel.
a)
Function
b)
Cell
c)
Formula
3.
Which of the following is an mixed cell reference with a fixed column address?
a)
G$9
b)
$K356
c)
$F$8
4.
Formulas in a cell start with a _______.
a)
:
b)
=
c)
(
5.
Which of the following is a relative cell reference?
a)
P72
b)
G$9
c)
$K356
6.
Which function would you use to find the largest number of a selected range?
a)
maximum
b)
max
c)
largeest
7.
Which of the following is mixed cell reference with a fixed row address?
a)
G$9
b)
$K356
c)
$F$8
8.
What name is given to the chart background?
a)
Chart area
b)
Background area
c)
Plot area
9.
When number signs (#####) are displayed in the cell, it means:
a)
The formula in the cell is wrong
b)
There are too many characters in the cell to be displayed with the current cell width
c)
The decimal point placement in the cell is wrong
10.
Which of the following buttons on the Excel toolbar will format selected cells so that they appear as currency values?
a)
%
b)
&
c)
$
11.
What does the following error mean - #REF! ?
a)
The #REF! error value occurs when a cell reference is not valid.
b)
The #REF! error value occurs when a cell has been formatted as a currency but contains text.
c)
The #REF! error value occurs when a cell contains a number with two decimal separators (points) present.
12.
How do you select noncontiguous cells
a)
Click a cell, then hold down SHIFT on the keyboard and select the other cells
b)
Click in a cell, then hold down ALT on the keyboard as you select the other cells
c)
Click in a cell, hold down CTRL on the keyboard and then select the other cells
13.
"Month 1, Month 2, Month 3" is an example of what?
a)
Series
b)
Function
c)
Formula
14.
Inserting Page Number is in Header and Footer
a)
True
b)
False
15.
Is it possible to insert an image from a file into an Excel spreadsheet?
a)
Yes
b)
No
16.
The cell range that starts in cell A1 and goes over to column J and down to row 15 is _____
a)
A1-J15
b)
A1;J15
c)
A1:J15
17.
When changing the margins on your spreadsheet does not solve the problem with the printout width, what do you need to do?
a)
Seperate the page into two for easier printing
b)
Use the Fit to Page option
c)
Highlight all cells to print and print selection
18.
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
19.
Symbol $ representing _____________ in a formula
a)
Absolute Reference
b)
Currency
20.
What will be the formula in the cell B3 if you want to calculate the profit?
a)
=A1-A2
b)
=B2-B1
c)
=B1-B2
Reset
