NEW
Font size
S
M
L
XL
WorksheetsExcel - Module 1 and 2 - Getting Started - Working with Formulas
Total questions: 45
Worksheet time: 15mins
Name
Class
Date
1.
Using the order of precedence for arithmetic operators, these two formulas will calculate the same result: =22/2*5 =22/(2*5).
a)
true
b)
false
2.
According to the order of precedence for arithmetic operators, operations contained within parentheses are performed last.
a)
true
b)
false
3.
An absolute cell reference changes the cell references when the formula is copied to a new location.
a)
true
b)
false
4.
An Excel complex formula uses more than one arithmetic operator.
a)
true
b)
false
5.
Arguments are Excel’s built-in formulas.
a)
true
b)
false
6.
To print the formulas in a worksheet, click the Formulas tab, then click the Show Formulas button in the Formula Auditing group.
a)
true
b)
false
7.
=D8+E8*0.5 is a complex formula.
a)
true
b)
false
8.
The cell in which you are working is called the active cell.
a)
true
b)
false
9.
You use formulas in Excel to perform calculations such as adding, multiplying, and averaging.
a)
true
b)
false
10.
When copying or moving formulas in an Excel worksheet, the default type of cell reference is absolute.
a)
true
b)
false
11.
The formula =A4+A8*($B$12) is an example of a(n) _____ formula.
a)
complex
b)
relative
c)
simple
d)
absolute
12.
The name Peter is entered in cell B4. This is a ____.
a)
label
b)
number
c)
formula
d)
value
13.
In the formula =D1+C1/F3, which calculation will be performed first?
a)
C1/F3
b)
D1/F3
c)
D1+F3
d)
D1+C1
14.
Which keyboard shortcut turns on Edit mode?
a)
[F1]
b)
[F2]
c)
[F3]
d)
[F4]
15.
Once the Office Clipboard reaches its maximum of 24 items, how does it handle new items that are copied or cut?
a)
The user sees a “clipboard full” message.
b)
The clipboard automatically deletes the oldest item on the clipboard.
c)
The clipboard automatically deletes all items and starts over with the new item.
d)
The clipboard prompts the user to delete items.
16.
____ below the worksheet grid let you switch from sheet to sheet in a workbook.
a)
Sheet tabs
b)
Cell pointers
c)
Mode indicators
d)
Scroll bars
17.
You can use a spreadsheet to ____ by using variable values to investigate and sample different outcomes.
a)
organize data
b)
represent values graphically
c)
create what-if data scenarios
d)
perform calculations
18.
Which formula contains a mixed cell reference?
a)
=(A6+A7)*0.20
b)
=($A$6+A7)*0.20
c)
=($A$6+$A$7)*0.20
d)
=($A6+$A$7)*0.20
19.
The entry in cell B15 is =SUM(B5:B14) which is a ____.
a)
formula
b)
label
c)
value
d)
calculation
20.
Which function key on the keyboard allows the Excel user to cycle through all possible combinations of relative, mixed, and absolute cell references for a formula?
a)
[F1]
b)
[F10]
c)
[F12]
d)
[F4]
21.
How can the order of precedence in this formula, =C12+C13*F4, be changed so that cells C12 and C13 are added together as the first operation that occurs?
a)
=C12*F4+C13
b)
=(C12+C13)*F4
c)
=C12+(C13*F4)
d)
=$C12+$C13*F4
22.
Excel’s _____ feature suggests functions depending on the first letters typed by the user.
a)
Formula Flash Fill
b)
Formula AutoComplete
c)
Formula AutoFill
d)
Formula AutoCorrect
23.
A(n) ____ is a built-in formula that uses arguments to calculate information.
a)
label
b)
indicator
c)
template
d)
function
24.
In Excel, the electronic spreadsheet you work in is called a ____.
a)
databook
b)
worksheet
c)
tablet
d)
numericsheet
25.
The default file extension for an Excel 2016 workbook is ____.
a)
.xlts
b)
.xslx
c)
.xltx
d)
.xlsx
26.
In a payroll worksheet, Peter worked 40 hours and actual hours are stored in cell B5. This is a ____.
a)
graphic
b)
value
c)
formula
d)
label
27.
If cell A1 contained 10, cell A2 contained 2 and cell A3 contained =A1^A2, what would cell A3 show on the worksheet?
a)
100
b)
20
c)
=A1^A2
d)
10^2
28.
You can create an absolute cell reference by placing a ____ in front of both the column letter and the row number of the cell address.
a)
%
b)
&
c)
@
d)
$
29.
A(n) ____ cell reference tells Excel to substitute new cell references within the copied formulas as necessary.
a)
parameter
b)
absolute
c)
relative
d)
mixed
30.
Case 1-1
You have created a simple worksheet like the one in the accompanying figure to help you keep track of your available funds based on your monthly costs for rent, gas, food, and entertainment. You have a monthly income of 2000 that is stored in cell B3. Your rent expense is 450 that is stored in cell B6.
Write a formula using an absolute cell reference that would return a value of 1550 in cell C6.
a)
=B$3-B6
b)
=$B$9-B6
c)
=$B$4-B6
d)
=$B$3-B6
31.
Which of the following is a complex formula?
a)
=AVERAGE(C6:D6)
b)
=(B4/B8)*10
c)
=MIN(D5:D7)
d)
=SUM(B4:B8)
32.
An electronic ____ is an application you use to perform numeric calculations and to analyze and present numeric data.
a)
spreadsheet
b)
database
c)
dataform
d)
project
33.
All functions begin with the formula prefix ____.
a)
# (number symbol)
b)
+ (plus sign)
c)
@ (at symbol)
d)
= (equals sign)
34.
____ operators perform mathematical calculations such as adding and subtracting.
a)
Reference
b)
Comparison
c)
Arithmetic
d)
Text concatenation
35.
All Excel formulas begin with the ____.
a)
plus sign (+)
b)
equal sign (=)
c)
asterisk (*)
d)
slash (/)
36.
In the formula =(G15-G14)*$M$3/4, which mathematical operation is performed first?
a)
(G15-G14)
b)
$M$3/4
c)
(G15-G14)*$M$3
d)
(G15-G14)/4
37.
The cell _____ is a dark rectangle that outlines the cell you are working in.
a)
indicator
b)
bar
c)
tablet
d)
pointer
38.
In the formula =ROUND(D4:F4,0), what does the zero indicate?
a)
A null value.
b)
The number of times the formula should be repeated.
c)
The value for cell F4.
d)
The number of decimal places in the rounded number.
39.
The Excel operator for division is ____.
a)
%
b)
\
c)
^
d)
/
40.
While you are entering a formula in a cell, the cell references and arithmetic operators appear in the _____.
a)
insert bar
b)
name box
c)
taskbar
d)
formula bar
41.
Possible paper orientations for printing a worksheet are landscape and ____.
a)
portrait
b)
preview
c)
page break
d)
normal
42.
The Undo button allows you to reverse up to ____ previous actions, one at a time.
a)
1000
b)
10
c)
1
d)
100
43.
In Excel, a worksheet is contained in a file called a ____.
a)
datapad
b)
notebook
c)
workpad
d)
workbook
44.
The Excel operator for exponent is ____.
a)
%
b)
\
c)
/
d)
^
45.
If cell A1 contained 10, cell A2 contained 2 and cell A3 contained =A1/A2, what would cell A3 show on the worksheet?
a)
=5
b)
5
c)
=10/2
d)
=A1/A2
Reset
