stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
Excel Module 2 Formulas and Functions Flashcards | StudBud
Explore
/
Excel Module 2 Formulas and Functions
Excel Module 2 Formulas and Functions
10 terms
·
StudBud Administration
·
73 plays
Excel Chapter 2 Formulas, Functions
Flashcards
10 cards
F
Practice quiz
P
Host live
L
Questions
10
Answers
1
the rule used when more than one mathematical operator is involved in formula
area
order of operations
intervals
function rules
2
Any equation entered into a cell on a spreadsheet
command
formula
function
cell
3
What is the equivalent FUNCTION for the formula =(C3+C4+C5+C6+C7+C8)/6?
=AVERAGE(C3:C8)
=AVERAGE(C3:C8)/6
=MAX(C3:C8/6)
=SUM(C3:C8)/6
4
Function that finds the highest number in a range
HIGHEST
MAX
AVERAGE
MIN
5
Function that finds the lowest number in a range
MIN
LOW
MAX
AVERAGE
6
What is one difference between a formula and a function?
A formula is more important than a function.
A function is more important than a formula.
A formula is easy and a function is not.
A formula has mathematical operators and a function does not
7
What symbol do you need at the beginning of every formula and function?
*
/
=
-
8
Function that calculates the average in a range of cells
MIN
MAX
AVERAGE
9
Prewritten formula that is built in Excel
fromula view
chart
function
themes
10
How do you enter 16% in Excel as a decimal?
0.016
0.16
16.0
1.6
