Search Header Logo

Excel 2013 Unit B

Authored by Ellison, Dr. Lynn - WREN HIGH SCHOO Teacher

Computers

9th - 12th Grade

Used 9+ times

Excel 2013 Unit B
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

26 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

An Excel complex formula uses more than one arithmetic operator.

True

False

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Using the order of precedence for arithmetic operators, these two formulas will calculate the same result: =22/2*5 =22/(2*5).

True

False

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

=D8+E8*0.5 is a complex formula.

True

False

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Clicking the Minimize button minimizes the Function Arguments dialog box so you can select cells in a worksheet.

True

False

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In this formula, =(A6*A8)+$D$1, the cell references A6 and A8 are relative cell references.

True

False

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A mixed reference means that either the column or row reference in the formula is absolute, but not both.

True

False

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is a complex formula?

=SUM(B4:B8)

=(B4/B8)*10

=AVERAGE(C6:D6)

=MIN(D5:D7)

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?