Excel Test Review Chapters 5, 6, and 8

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

• True
• False

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

• True
• False

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

• True
• False

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

• True
• False

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

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

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

• True
• False

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

• True
• False

Filtering data removes errors.

• True
• False

Hiding permanently removes a row or column from view.

• True
• False

A picture is anything that appears on the screen that you can select and work with as a whole, such as a shape, picture, or chart

• True
• False