WorksheetsExcel Intermediate
Total questions: 21
Worksheet time: 5hrs 15mins
Name
Class
Date
1.
If the parenthesis is removed, what will 9.5% be multiplied by?
a)
D2 +D3+D4+D5
b)
D5
c)
D2
d)
None
2.
Which response best completes the following statement: A formula is used to
a)
perform calculations or other actions.
b)
find averages.
3.
Cell value references should always be used when possible to avoid having to make multiple updates when one key value changes.
a)
True
b)
False
4.
Excel follows the ___________________ and first adds the values inside the parentheses.
a)
Order of Operations
b)
Formula Guidelines
5.
___________ are often the best way to define which calculations will be performed first in Excel.
a)
Parentheses
b)
Forumlas
6.
By default, all cell references are _________ references.
a)
Absolute
b)
Relative
7.
Unlike _________ references, _________ references do not change when copied or filled.
a)
Absolute, Relative
b)
Relative, Absolute
8.
An absolute reference is designated in a formula by the addition of a _______ sign.
a)
%
b)
$
c)
&
d)
#
9.
What does the Average formula return?
a)
Returns the lowest argument.
b)
Returns the middle argument.
c)
Returns the three highest arguments.
d)
Returns the mean of all its arguments.
10.
Which operator is used to multiply in Excel?
a)
+
b)
-
c)
/
d)
*
11.
All formulas begin with a(n) _______________.
a)
&
b)
=
c)
+
d)
#
12.
Formulas can be copied to adjacent cells with the ____________.
a)
Fill handle
b)
PgDn Key
c)
Function key F4
d)
None of the above
13.
__________________is an alphanumeric value used to identify a specific cell in a spreadsheet.
a)
Formula
b)
Calculation
c)
Cell address
d)
None of the above
14.
Multiple arguments must be separated by a ______________.
a)
Space
b)
Comma
c)
= Sign
d)
!
15.
If a column has joint-data (such as last name, first name), you can automatically "pull" sections of the data into a new column by using:
a)
Flashfill
b)
Autofill
c)
Merge & Center
d)
Copy and Paste
16.
When using the SUBTOTAL command, you must sort by the column you are wanting to subtotal.
a)
True
b)
False
17.
Sparklines are tiny charts that fit into one cell.
a)
True
b)
False
18.
What is an advantage, if any, to using cell references instead of just typing in values?
a)
It will automatically create a sparkline in the next cell
b)
It will allow you to format your spreadsheet quicker
c)
If the cell is changed, your formula will automatically update
d)
There is no advantage
19.
Jun is the director of a summer camp. This spreadsheet contains campers’ names, information, and their counselors.
Which two features will help him sort the list by counselor, and then print out a list containing only the campers’ and counselors’ names?
Which two features will help him sort the list by counselor, and then print out a list containing only the campers’ and counselors’ names?
a)
Sort and Track Changes
b)
Format and Hide Columns
c)
Custom Sorting and Formatting
d)
Custom Sorting and Hide Columns
20.
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)
21.
When creating a table in Excel, what will clicking the drop down arrows in the headings allow you to do?
a)
Fill the column with color
b)
Filter the data
c)
Format the cells
d)
Hide the column
100 %
