Excel HR 2019 Module 5 Review # 2

When modifying a spreadsheet, to revert back after pressing the Enter key, what do you click?

• Undo button

• Backspace key

• Delete key

• Shift key

In order to display all formulas in your worksheet, what do you do?

• Highlight the entire worksheet.

• Click the Connections command button on the Data tab.

• Click the fx command button on the Formulas tab.

• Click the Show Formulas command button on the Formulas tab.

The Name Manager, where named cell ranges can be edited, is found on which tab?

• Data

• Page Layout

• Home

• Formula

All formulas begin with which character?

• =

• f

• e

• c

Which function does the opposite of the MIN function?

• MaxY

• MinEY

• MAX

• Average

Which of the following is true of cells in a formula?

• They must be adjacent.

• They must be next to each other in a column.

• They must be next to each other in a single row.

• They can be anywhere on a worksheet.

Both the COUNT and COUNTA functions ignore blank cells!

• True

• False

The MIN function returns the smallest value in a range of cells.

• True

• False

Which is a valid syntax (structure) for the COUNT function?

• =COUNT(A1:C38)

• =(A1:C38)COUNT

• =COUNTA

• =COUNT:A1:C38

Which of the following is the arithmetic operator for multiplication in EXCEL?

• x

• /

• +

• *