Exam 7: Creating and Enhancing a Worksheet

The ____________________ button allows you to merge several cells into one cell and center the text in the merged cell.

According to the order of precedence, which operation below should be performed first?

You are working on a very large spreadsheet that you know will print on several pages. Describe how you can visualize the entire document before you print it.

You can add more worksheets to a workbook if you need more than the default number.

_____ referencing is when you copy a formula to a new cell and Excel automatically replaces the original cell references with cell references that are in the same relative position as those in the original formula.

In the accompanying figure, item 2 points to the ____.

A(n) ____________________ is information included at the top of every page in your worksheet.

You are using Microsoft Excel to create a budget for your team at work. The budget includes numbers, formulas, and text that spans several columns. You made a mistake in one of the formulas, how do you correct the error?

When you copy a formula to a new cell, the original cell references are replaced with cell references that are in the same ____ position as those in the original formula.

A ____ can contain one or more worksheets.

Sometimes a worksheet or workbook is referred to as a spreadsheet.

Describe how to change cell alignment.

The formula bar shows the address of the selected cell.

A(n) value is text that describes data in a worksheet

In the accompanying figure, item 1 points to the ____.

In the accompanying figure, item 2 points to the ____.

You can refer to a cell by its ____, a column letter followed by a row number.

If a page is taller than it is wide and some columns are cut off from view, you need to adjust the _________________ in the Settings area of the Print Preview area.

To preview a worksheet, click the ______ button in Backstage view.