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