stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
Excel Module 2 Test Review Flashcards | StudBud
Explore
/
Excel Module 2 Test Review
Excel Module 2 Test Review
20 terms
·
StudBud Administration
·
201 plays
Imported from external platform
Flashcards
20 cards
F
Practice quiz
P
Host live
L
Questions
20
Answers
1
The COUNT function in Excel returns the number of all cells in a range that contain any type of data
False
True
2
Which formula contains a mixed cell reference?
=($A6+$A$7)*0.20
=(A6+A7)*0.20
=($A$6+A7)*0.20
=($A$6+$A$7)*0.20
3
Which of the following is a complex formula?
=SUM(B4:B8)
=(B4/B8)*10
=AVERAGE(C6:D6)
=MIN(D5:D7)
4
An Excel user should use a relative cell reference when it is important to ____.
preserve the relationship to the formula location
preserve the exact cell address in a formula
memorize the formula
never change the formula
5
With AutoFill, dragging the fill handle copies the cell's contents or continues a series of data to adjacent cells
False
True
6
According to the order of precedence, operations contained within parentheses are performed last.
False
True
7
Predefined formulas in Excel are called functions and can be accessed using the Insert Function button
True
False
8
When using the Insert Function button or the AutoSum list arrow, it is necessary to type the equal sign
True
False
9
All functions begin with the formula prefix ____.
@ (at symbol)
= (equals sign)
+ (plus sign)
# (number symbol)
10
Which keyboard shortcut turns on Edit mode?
[F4]
[F1]
[F8]
[F2]
11
In the formula =D1+C1/F3, which calculation will be performed first?
D1/F3
C1/F3
D1+F3
D1+C1
12
An absolute cell reference changes the cell references when the formula is copied to a new location
True
False
13
Once the Office Clipboard reaches its maximum of 24 items, how does it handle new items that are copied or cut?
The user sees a “clipboard full” message
The clipboard automatically deletes the oldest item on the clipboard
The clipboard prompts the user to delete items
The clipboard automatically deletes all items and starts over with the new
14
Using the order of precedence for arithmetic operators, these 2 formulas will calculate the same result:=22/2*5=22/(2*5)
False
True
15
In the formula =(G15-G14)*$M$3/4, which mathematical operation is performed first?
(G15-G14)
(G15-G14)/4
(G15-G14)*$M$3
$M$3/4
16
=D8+E8*0.5 is a complex formula
False
True
17
In Excel, MAX and AVERAGE are examples of ____.
buttons
arguments
functions
lists
18
The COUNTA function is used to count the number of cells in a range that contain which type of data?
formulas
numbers
All of the above
dates
19
When cells or rows are inserted or deleted in a worksheet, how are cell references affected by the insertion or deleted
The user is prompted to enter new cell references
Cell references are not affected
Cell references are automatically adjusted
The user must insert new cell references
20
An Excel complex formula uses more than one arithmetic operator.
True
False
