Exam 12: Spreadsheets

Use the Delete or Backspace keys or retype the data as desired to edit data in a cell.

Naomi has a spreadsheet set up listing the different members of the Art Museum, and the dues that they have paid. Please answer the two questions below. -In cell B1, Naomi has a formula calculating the total dues the member has paid over the past five years. She wants to copy this formula down the column and wants the cell references to change to accommodate the new location. In this case, the cell reference is ____.

You can use the Undo command (Ctrl+U) to undo your most recent actions.

Please identify the letter of the choice that best matches the numbered definitions below. -Compares the sizes of portions as they relate to the whole unit and illustrates that the parts total 100%

To sort data, select the range to be sorted, click the Sort & Filter button located in the Editing group on the Home tab, and then click Sort A to Z or Sort Z to A. _________________________

Use ____ to place information at the top of the spreadsheet.

Pressing ____ moves you to the beginning of the spreadsheet, or cell A1.

Please identify the letter of the choice that best matches the numbered definitions below. -Compares sets of three values

Please identify the letter of the choice that best matches the numbered definitions below. -Effective for emphasizing trends because it illustrates the magnitude of change over time

Individual worksheets are stored within a workset. _________________________

The symbol preceding the formula, called the ____, identifies the data as a formula and not a label.

To print the entire spreadsheet as is, click the Office button, point to Print, and then click Quick Print.

The data warehouse ____ is responsible for translating business requirements into computer solutions.

Shawn is an accountant for a busy manufacturing firm. When he works on a spreadsheet he often uses the same calculations over and over. He wants to start incorporating functions into his spreadsheets. Please answer the questions below. -If Shawn wanted to calculate the average cost of goods sold, he would use the ____ function.

You also can press the Ctrl key to enter the data and move to the next cell in the row.

When you copy cells that contain formulas, the cell references change to accommodate the new location. This is called a(n) ____ cell reference.

A ____ is an equation that performs a calculation.

A useful feature of spreadsheet software is a(n) ____________________, a recorded series of keystrokes that can be replayed as needed.

To enter a formula in a cell, you first type a(n) ____.

The ____ cell is the cell in which you are working currently and is surrounded by a thick border.