Exam 8: Formats, Functions, and Formulas

Fill color can be used to categorize information.

When text and numbers are organized in labeled columns and numbered rows,they are in graphical format.

To find the greatest numerical value in a range of cells,you would use the ________ function.

Tables allow for calculations in a total row such as summations,averages,or counts.

The COUNT function returns the total number of cells in a cell range that are blank.

The format that organizes information in labeled columns and numbered rows is ________ format.

Conditional formatting can be used to highlight information by changing formats such as cell fill color,font color,and font style.

The Accounting Number format structures a cell with a comma at the thousand and two decimal places.

Formatting will change the value stored in a cell,as well as add information value.

Which of the following is NOT true about the Accounting Number format?

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

A ________ is a built-in program that performs operations on data.

The cell that receives the result of an operation such as Paste or the AutoSum function is the ________ cell.

An important part of building a good worksheet is using ________.

On a worksheet,rows and columns can be hidden as long as they do not have functions in any of the cells.

The base date for date and time data in Excel 2016 is ________.

In Excel,there are ________ ways to use the AutoSum function.

The keyboard shortcut for the Comma format is ________.

Excel has more than ________ functions organized into several categories.