Search Header Logo

Excel Test Review Chapters 5, 6, and 8

Other

KG - University

Used 6+ times

Excel Test Review Chapters 5, 6, and 8
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

85 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

If a function contains more than one argument, semicolons separate the arguments.

True
False

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Because Excel includes so many functions, the best way to select a function is from the Excel Help.

True
False

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

You can use the SUM function to total the values stored in up to 255 non-adjacent cells or ranges.

True
False

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Some mathematical operations, such as addition, subtraction, multiplication, and division, do not require functions.

True
False

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

An example of a square root function written correctly is ____.  

SQRT(C4)
SQROOT(C4)
=SQRT(C4)
=SQROOT(C4)

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Logical functions can determine the average, standard deviation, or variance of a range of data.  

True
False

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

When you sort data contained in columns of a worksheet, Excel includes the column headings

True
False

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

Microsoft

Continue with Microsoft

or continue with

Facebook

Facebook

Apple

Apple

Others

Others

Already have an account?