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

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

Peter is creating a spreadsheet to summarize labor costs, which is shown above. He has entered information into the Description column, Quantity/Shoe column, and Total Cost column. However, there are several errors in the Total Cost column. -The chart shows that 30 appliques can be attached for a cost of $10/hour. If there are 6 appliques per shoe (cell B12), how much is the cost per shoe for applying the appliques?

Two cell references separated by a colon are referred to as a ____.

The Excel operator used for division is ____________________.

B3:B7 represents ____.

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

The ____ function determines the number of values in a list.

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

Each function has its own ____, which specifies the function name and order of the arguments.

When Excel rounds the display, it does so by rounding any number ____ down to the next value.