stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
MOAC Excel Flashcards | StudBud
Explore
/
MOAC Excel
MOAC Excel
18 terms
·
StudBud Administration
#excel
Flashcards
18 cards
F
Practice quiz
P
Host live
L
Questions
18
Answers
1
What defines a condition and can be a number, text, or expression?
range
arguments
dialog
criteria
2
Is the value does COUNTIFS treat empty cells as having zero?
False
True
3
Which function adds the cells in a range specified by a given criteria?
COUNTIF
SUMIF
VLOOKUP
AVERAGEIF
4
In HLOOKUP, what will happen when TRUE is used in the Range_lookup?
find an exact match in the first column
find the closest match in the first column
find an exact match in the top row
find the closest match in the top row
5
How are values treated when you enter an AVERAGEIF or AVERAGEIFS formula?
If a cell in the Average_range is empty AVERAGEIF ignores it
If Average_range is omitted, range is used
If no cells match the criteria, the #div/0 error is returned
If Average_range is omitted, you get a #DIV0 error
6
What is the term for the values that a function uses to perform operations or calculations?
criteria
dialog
range
arguments
7
How many conditions can you enter in an AVERAGEIFS formula?
99
255
127
12
8
Which letters are on the Insert Function button, which displays the function arguments box?
InF
fx
iF
FUN
9
The function ______ returns the arithmetic mean of cells in a range that meet a criteria.
SUMIF
VLOOKUP
AVERAGEIF
COUNTIF
10
In a VLOOKUP formula, the comparison value must be located in the ___ and in ___ order
last column, descending
first column, ascending
11
Do conditional formulas use and, or, or not functions?
Yes
No
12
Which tab will find in the Function Library
Data
Formulas
Insert
Home
13
Which of the following wildcard characters can be used when you create a formula?
%
? and *
^
@ and #
14
Is the maximum number of ranges you can have in a COUNTIF function 128?
no, 127
yes, it is 128
15
What function adds the cells in Sum_Range that meet multiple criteria?
arguments
sumifs
averageif
insert
16
Which function counts the number of cells within a range that meet the criteria?
VLOOKUP
SUMIF
AVERAGEIF
COUNTIF
17
For a VLOOKUP and HLOOKUP, data must be arranged in rows and columns also known as:
table column
table array
table row
table lookup function
18
Which function library contains the functions for COUNTIF and AVERAGEIF?
financial
more functions
logical
math and trigonometry
