Seat 1

Is this your test? Login to manage it. If not, you can develop a quiz just like it.

This is a non-interactive preview of the quiz content.

1 point

Where will the formula show up in your workbook?

Status Bar

Sheet Tab

Formula Bar

Name Box

1 point

These appear horizontally and are identified by numbers on the left side of the worksheet window?

Columns

Tabs

Rows

Formulas

1 point

What is the formula for the total sum of a set of numbers?

=SUM(Range)

=Total(Range)

=Average(Range)

=Totalsum(range)

1 point

What does a formula always start with?

( )

1 point

What formula gives you the max number in a range of numbers?

=Max(Range)

=Maximum(Range)

=Min(Range)

=Sum(Range)

1 point

What does the minimum formula provide you with?

Total minimum numbers from a set

Average numbers from a set

Minimum number from a set

Maximum number from a set

1 point

What should you surround a range reference with in a formula?

[ ]

{ }

$ $

( )

1 point

What is the formula used to find the average number in a set of numbers?

Average(Range)

(Range)Average

Average

=Average(Range)

1 point

These appear vertically and are identified by letters at the top of the worksheet window?

Tabs

Formulas

Rows

Columns

10.

1 point

What is the cell reference area located below the Ribbon, which displays the cell reference of the active cell?

Name Box

Formula Bar

Reference Bar

Status Bar

Home Features Pricing FAQs Legal Sample Tests Build a Test Login/Sign Up