Search Header Logo

Excel Summative (Last)

Authored by Albert Linis

Computers

10th Grade

Used 2+ times

Excel Summative (Last)
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

12 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is required in creating an IF function?

Cell reference
Value if false
Logical test
Value if true

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following symbols can be used in IF function?

?

~

<>

;

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following returns a value you specify if a formula evaluates to an error?

IFERROR
VALUEERROR
ERRORIF
IFERRORR

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

IF function is an example of _____.

Statistical function
Logical function
Mathematical function
Text function

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which functions requires Logical Test?

AVERAGE

ERROR

OR

SUM

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following IS function returns TRUE if Value refers to any error value except #N/A?

ISNA
ISERROR
ISBLANK
ISERR

7.

MULTIPLE CHOICE QUESTION

30 sec • 2 pts

The function ISERROR returns TRUE if _____.

Value refers to any error value (#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!).

Value refers to the #N/A (value not available) error value.

Value refers to any error value except #N/A.

Value refers to an empty cell.

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?

Discover more resources for Computers