Exam 2: Formatting, functions, and Formulas

You can use AutoSum function be selecting either the destination cell or the source cell(s).

A(n)________ is a data-formatting tool that simplifies data sorting,filtering,and calculations.

Clicking the AutoSum button displays a list of additional numeric functions such as COUNT and MAX.

is the ________ button.

The default Excel theme is the Office theme.

The argument for the COUNT function is limited to a range of contiguous cells.

is the ________ button.

To apply the MIN or MAX function to a selected range of cells,you begin by clicking the ________ arrow.

The first argument in the SUBTOTAL function identifies the ________.

Which of the following lists follows Excel's order of operations?

The symbol used in Excel to indicate division is ________.

The ________ number formatting displays commas and decimal points but not currency symbols.

The AutoSum button is located in the ________.

The keyboard shortcut for apply the Comma format is ________.

Ctrl + & is the keyboard shortcut to hide or show formulas in a worksheet.

To remove conditional formatting from a range of cells,after selecting the range of cells,________.

You can hide an individual cell by right-clicking the cell and selecting Hide from the shortcut menu.

Show Formulas is a toggle button.