Excel Module 3 Review

The Sum options you can access from the Quick Analysis button allow you to put the sums of data in either the following row or the following column.

• True

• False

You can use the Excel equation tools to insert an equation for calculating the area of a circle.

• True

• False

A student is asked to find the difference between two values of time entered in cells A1 and B1, where A1 is the greater value and B1 the lesser value. In order to do so, he will type the formula =A1-B1 in an empty cell.

• True

• False

To show formulas instead of values, click on the Formulas tab in the ribbon, then in the Formula Auditing group, click on the Show Formulas option.

• True

• False

To insert only the current date in cell B1, use the NOW function in cell B1.

• True

• False

Rohan can display the current date in a cell using the TODAY() function.

• True

• False

A date stamp shows the date a workbook, report, or other document was created or the time period it represents.

• True

• False

The path to the Logical button is (FORMULAS tab | Function Library group).

• True

• False

You can select nonadjacent ranges using the SHIFT key.

• True

• False

Jose inserts the formula =DATE(2021, 2, 15) in cell A15. When he presses ENTER, 2/15/2021 will appear in the cell.

• True

• False