Exam 1: Excell: Creating a Worksheet and Charting Data

The keyboard shortcut to display Print Preview is ________.

If you move formulas by inserting additional rows or columns in your worksheet,Excel automatically adjusts the formulas.

An Excel workbook contains one or more ________ that are stored in the workbook.

A(n)________ is a prewritten formula that uses one or more cell references,performs an operation,and then returns a value.

When you delete a column,the remaining columns shift to the left.

Match each of the following terms to its definition: i.cell II.worksheet III.spreadsheet IV.workbook v.column

The Percent Style button formats selected cells as a percentage with ________.

A chart value that originates in a worksheet cell is referred to as ________.

The orientation of a worksheet can be changed on the Home tab as well as in Print Preview.

Match each of the following terms to its definition: i.cell style II.theme III.format IV.Accounting Number Format v.Comma Style

A(n)________ is a chart element that identifies the patterns or colors that are assigned to each category in the chart.

A(n)________ is a symbol with which you can specify the type of calculation that you want in a formula.

A(n)________ is an Excel document that stores data.

Which of the following is NOT part of the Accounting Number Format?

Comma Style format displays a number with ________.

Normal view maximizes the number of cells visible on your screen.

The ________ displays the current cell mode,the page number,and the zoom buttons.

Selecting the range before you enter data saves time because it confines the movement of the active cell to the selected range.

Cell content can be one of two things: a constant value or a(n)________.

When you type data in a cell and press Enter,what cell becomes the active cell?