NEW
Font size
S
M
L
XL
WorksheetsEnd of year quiz: Spreadsheet Modelling
Total questions: 20
Worksheet time: 40mins
Name
Class
Date
1.
What is the Sum formula?
a)
Sum( )
b)
Sum( )=
c)
=Sum( )
d)
=( )Sum
2.
When starting a formula what is the first thing you type in the cell?
a)
+
b)
-
c)
%
d)
=
3.
The letters in Excel represent the _______?
a)
columns
b)
rows
c)
data
d)
functions
4.
The numbers in Excel represent the _____?
a)
columns
b)
rows
c)
data
d)
functions
5.
How would you write a cell reference formula for cell A1 subtracted by Cell C3?
a)
A1-C3
b)
A1-C3=
c)
=A1-C3
d)
=C3-A1
6.
You can only work in one cell at a time. The actual cell that you are working in is called what?
a)
Column
b)
Name Box
c)
Active Cell
d)
Row
7.
What is the term used where a column and row intersect?
a)
Toolbar
b)
Cell
c)
Name Box
d)
Formula Bar
8.
What would be a correct formula for SUM in excel?
a)
=SUM(B3:B9)
b)
=SUMB3+B9
c)
SUM(B3:B9)
d)
=ADD(B3:B9)
9.
If the cell contains hashtags (#), what do you need to do?
a)
Expand the column
b)
Expand the row
c)
Change the formula
10.
Which formula gets the biggest value of a range of cells?
a)
MAX
b)
MIN
c)
LARGE
d)
SUM
11.
Which symbol must all formula begin with?
a)
=
b)
+
c)
(
d)
@
12.
Which of these symbols is used for divide on a computer?
a)
\
b)
*
c)
/
d)
|
13.
An absolute reference is designated in a formula by the addition of a _______ sign.
a)
%
b)
$
c)
&
d)
#
14.
If you want a cell reference to change when copied to other cells, use _________ references
a)
Absolute
b)
Relative
15.
The most common way to identify a cell reference is
a)
$D2
b)
$D$2
c)
D$2
d)
D2$
16.
Which feature would allow you to change the formatting of any cells that are less than $100.00?
a)
Cell Formatting
b)
Easy Formatting
c)
Auto Formatting
d)
Conditional Formatting
17.
(Let the GIF Play)
How are we sorting the data in this clip?
How are we sorting the data in this clip?
a)
Custom Sort by T-Shirt Size
b)
Alphabetically by First Name
c)
Alphabetically by Last Name
d)
Numerically by Homeroom Number
18.
What is the cell range in this diagram?
a)
A1:F1
b)
A1:A8
c)
A1:F8
d)
A1:1A
19.
Gerilynn wanted to find the total amount of vanilla cakes ordered. Which of the following formulas should she use?
a)
=(C3+C5+C9)/3
b)
=SUM(C2:C10)
c)
=AVERAGE(C2:C10)
d)
=(C3+C5+C9)
20.
A(n) _________ is a prewritten formula that is built into EXCEL.
a)
function
b)
problem
c)
equation
d)
equal sign
Reset
