
Excel 5 & 6 Vocab
Business
9th - 12th Grade
Used 1+ times

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
21 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 5 pts
A formula that calculates (by default) the total from the adjacent cell through the first nonnumeric cell using the SUM function.
AutoSum
COUNT function
COUNTA function
COUNTBLANK function
2.
MULTIPLE CHOICE QUESTION
30 sec • 5 pts
A function that calculates (by default) the total from the adjacent cell through the first nonnumeric cell using the AVERAGE function in its formula.
AVERAGE function
COUNT function
COUNTBLANK function
function
3.
MULTIPLE CHOICE QUESTION
30 sec • 5 pts
A function that determines how many cells in a range contain a number.
COUNT function
COUNTA function
function
COUNTBLANK function
4.
MULTIPLE CHOICE QUESTION
30 sec • 5 pts
A function that returns the number of cells in the selected range that contain text or values, but not blank cells.
COUNTA function
COUNTBLANK function
MAX function
merged cells
5.
MULTIPLE CHOICE QUESTION
30 sec • 5 pts
A function that counts the number of blank cells in a range.
COUNTBLANK function
function
MAX function
merged cells
6.
MULTIPLE CHOICE QUESTION
30 sec • 5 pts
A function that returns the largest value in a set of values.
MAX function
function
merged cells
SUM function
7.
MULTIPLE CHOICE QUESTION
30 sec • 5 pts
A predefined formula that performs a calculation.
function
merged cells
MIN function
COUNTBLANK function
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
Already have an account?