Exam 2: Formatting, functions, and Formulas

The financial,mathematical,and text functions that are provided by Excel are called ________ functions.

Formatting does not change the data value,it only changes its appearance.

When adding a fill color to a cell,the color palette is displayed by clicking the Fill Color button.

Excel's ________ format is used to present information in charts,graphs,and pictures.

Excel can present information in tabular and graphical formats.

________ is the SUM keyboard shortcut.

To remove conditional formatting from a range of cells,you select the range of cells and then press Delete.

To change a table back into a range,you click Convert to Range in the ________.

Which of the following is NOT a numerical format?

When using the ________ number format,negative numbers can be displayed with a dash (-),parentheses,or in red.

Conditional formatting allows you to dynamically change the appearance of cells so that it adds information to your worksheet.

is the ________ button.

Gridlines is a toggle button.

The keyboard shortcut to hide or show formulas in a worksheet is ________.

Exporting worksheets in Formula View to a PDF file is an excellent way to document your workbook.

________ Format Painter allows you to use it multiple times.

is the Currency button.

When first argument in the SUBTOTAL function is in the range 101-111,only the visible values in the specified range are used.

The Total Row check box is located in the ________ group on the DESIGN tab.

When a text format is applied to a cell,its contents are ________ aligned in the cell.