Exam 2: Formatting, functions, and Formulas

When you format a range as a table,you must name every column in the table.

Which of the following is Excel's symbol for multiplication?

Following Excel's order of operations,what is the result of the formula =10-4/2*(5-2)?

The AutoSum button is located in the Editing group on the HOME tab.

+,*,and ^ are examples of Excel ________.

is the ________ button.

By applying a filter to a table,you can determine which data are shown.

A(n)________ cell style is a predefined and named combination of cell-formatting and content-formatting that can be applied to a cell or range of cells.

The Picture dialog box is displayed by clicking Pictures in the ________.

The Themes gallery is displayed by clicking Themes in the ________.

The MAX function finds the largest number in a range of numeric cells.

You can hide a column by placing the mouse pointer over the ________,right-clicking,and then selecting Hide from the shortcut menu.

Striping uses alternating background colors of rows or columns to aid in visually tracking information.

The Cell Styles gallery is displayed by clicking Cell Styles in the ________.

COUNT,AVERAGE,MIN,and MAX are examples of Excel ________.

To display a hidden row,you select the rows above and below the hidden row,right-click the selection,and then select Unhide from the shortcut menu.

Once a range of data has been converted to a table,it CANNOT be converted back into a range.

Conditional Formatting is a toggle button.