stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
Duplicate of Excel - Formulas Flashcards | StudBud
Explore
/
Duplicate of Excel - Formulas
Duplicate of Excel - Formulas
22 terms
·
StudBud Administration
·
17 plays
Imported from external platform
Flashcards
22 cards
F
Practice quiz
P
Host live
L
Questions
22
Answers
1
A symbol that indicates what mathematical operation to perform
operator
operand
2
Which of the following is NOT part of a function?
equal sign
function name
title
argument
3
The cell reference D$5 is an example of a(n)
absolute cell reference
mixed cell reference
relative cell reference
4
Which formula would subtract the contents of B3 from A3 and then divide by 5
=B3-A3/5
(A3-B3)/5
=(B3-A3)/5
=(A3-B3)/5
5
Which function would return the average number in a range of cells?
MIN
MAX
AVERAGE
SUM
6
You can use the ___ handle to copy a cell's contents and/or formatting to adjacent cells.
duplicate
fill
adjacent
copy
7
Which of the following would not be part of a function's argument?
function name
range
text
cell reference
8
The cell reference D5 is an example of a(n)
absolute cell reference
mixed cell reference
relative cell reference
9
What is the default number format in Excel?
Math
Accounting
General
Currency
10
What comes last in the Order of Operations?
Subtraction
Parenthesis
Division
11
Which function would add together all of the numbers in a range of cells?
MIN
MAX
SUM
AVERAGE
12
Which function would return the lowest number in a range of cells?
SUM
MIN
AVERAGE
MAX
13
What comes first in the Order of Operations?
Parenthesis
Division
Subtraction
14
Sorts text from largest to smallest, latest to earliest, Z to A
Ascending Sort
Descending Sort
15
Which formula would divide B3 by 5 and then subtract it from A3?
=B3/5-A3
=A3-(B3/5)
=A3-B3/5
=(B3/5)-A3
16
The cell reference $D5 is an example of a(n)
mixed cell reference
relative cell reference
absolute cell reference
17
Sorts text from earliest to latest, smallest to largest, A to Z
Descending Sort
Ascending Sort
18
A number or cell reference used in a formula
operand
operator
19
The equation used to calculate values based on operators and operands entered in a cell.
operator
function
operand
formula
20
The cell reference $D$5 is an example of a(n)
relative cell reference
mixed cell reference
absolute cell reference
21
A ____ is a shorthand way to write an equation that performs a calculation
operand
function
operator
formula
22
What text displays if a number is too big to fit in the cell?
###
Error
2BIG
$$$
