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...

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

By signing up, you agree to our Terms of Service & Privacy Policy

Already have an account?