stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
Excel Review Quiz #2 - Goodall Flashcards | StudBud
Explore
/
Excel Review Quiz #2 - Goodall
Excel Review Quiz #2 - Goodall
16 terms
·
StudBud Administration
·
666 plays
Reviewing the basics about Excel to help students review for their quiz
Flashcards
16 cards
F
Practice quiz
P
Host live
L
Questions
16
Answers
1
Which of the following is an example of an operand?
function name
/
G8
*
2
The _______ displays the value of formula of an active cell.
name box
formula bar
none of the choices
status bar
3
_______ cell references adjust to a new location when copied or moved.
Operand
Operator
Absolute
Relative
4
To create a chart, select the data and then select the appropriate chart type on the __ ribbon.
Formulas
Data
Insert
Home
5
When multiple operations are in a formula, order of _____ decides what is calculated first.
filtering
formulas
operations
functions
6
The most commonly used chart types are pie, column, and _____.
radar
scatter
surface
line
7
Charts allow workbook data to be illustrated graphically to show _____ and _____.
computations and trends
computations and trials
comparisons and trends
comparisons and trials
8
What would be the formula for subtracting information?
difference(B2-B9)
B2-B9
=difference(B2-B9)
=B2-B9
9
What of the following is true about a function?
includes an argument
perform complex mathematical formulas quickly
all of the choices
includes a function name
10
A formula with both absolute and relative cell references is a(n) _ cell reference formula.
common
mixed
junction
incorrect
11
Which of the following is an example of an operator?
function name
=
G8
*
12
The "boxes" you type in on Excel are called "Cells."
FALSE
TRUE
13
A $ symbol indicates a _______ cell reference.
Absolute
Operand
Relative
Operator
14
Formulas have three parts - equal sign, operator, and _________.
function
number
function name
operand
15
The Greek letter sigma is the icon for the ____ button on the HOME ribbon.
formula bar
Autosum
function
formula
16
_______ cell references do not adjust to a new location when copied or moved.
Relative
Absolute
Operator
Operand
