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