Exam 1: Applying Fundamental Excel Skills and Tools in Problem Solving

The ____ Style button formats numbers as percentages, displayed to the nearest percent, with no decimal places.

____ is/are third in the order of precedence rules.

The error message #DIV/0! means that there is ____.

When working with multiple worksheets in a workbook, it's a good idea to rename each worksheet tab based on the default labels (Sheet1, Sheet2, and so on).

Identify the letter of the choice that best matches the phrase or definition. -Wrong argument type or operand

Functions are predefined formulas that perform calculations. _________________________

B3,C4, D5:D6, 6 represents ____.

____ are predefined formulas that perform calculations.

The ____ button formats numbers in the Accounting Number Format.

The ____________________ format displays the dollar sign immediately in front of the value and does not align values on the decimal point.

A(n) value is an equation that performs calculations. _________________________

The dollar sign syntax is used by Excel to indicate that a cell reference is absolute. _________________________

The ____ function calculates the maximum in a list of values.

Changing the cell background, bolding the text, and applying a border can be accomplished using the buttons in the ____ group on the HOME tab.

$B$1 is an example of a(n) ____ reference.

A cell formatted with the Proportion Style displays the % symbol following the value. _________________________

The labels and values upon which Excel calculations are based are outputs.

____________________ are predefined formulas that perform calculations.

Excel provides a variety of tools for designing and working with a spreadsheet, which is referred to as a ____ in the Excel application.

B3:B7 represents ____.