L04 Using Basic Formulas

L04 Using Basic Formulas

University

10 Qs

quiz-placeholder

Similar activities

Excel Quiz 2

Excel Quiz 2

University

14 Qs

Quiz in Excel 2

Quiz in Excel 2

University

10 Qs

Office Automation Tools

Office Automation Tools

University

15 Qs

Microsoft Excel Basics

Microsoft Excel Basics

5th Grade - University

10 Qs

CSP Vocabulary

CSP Vocabulary

9th Grade - University

8 Qs

Excel 2013 Lesson 5

Excel 2013 Lesson 5

9th Grade - University

10 Qs

Intermediate Excel

Intermediate Excel

University

10 Qs

DES Revision

DES Revision

University

7 Qs

L04 Using Basic Formulas

L04 Using Basic Formulas

Assessment

Quiz

Computers

University

Medium

Created by

Chutchonook Charutwinyo

Used 22+ times

FREE Resource

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is not an arithmetic operator?

+

-

*

]

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Per the order of operations, which of the following is calculated first?

Addition (+) and subtraction (−) (left to right)

Exponentiation (ˆ)

Percent (%)

Negative number (−)

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is an acceptable name for a named range?

C7

subtotal_west

subtotal west

subtotal/west

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is an example of an absolute cell reference?

A9

A$9

$A$9

A9:E9

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is an example of a mixed cell reference?

A9

A$9

$A$9

A9:E9

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

To allow Excel to distinguish formulas from data, all formulas begin with an

equal sign (=).

TRUE

FALSE

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Regarding a named range, the scope of a name is the location within which

Excel recognizes the name without qualification.

TRUE

FALSE

Create a free account and access millions of resources

Create resources
Host any resource
Get auto-graded reports
or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?