Exam 5: Excel : Introduction to Excel

For the fill handle to work you need to have two cells selected.

In the formula, =1+(2-3)+5\6-6^2, what will Excel evaluate second?

Match the following terms with their description: I. XFD II. Range III. Value IV. Semi-selection V. Text A. A measurable amount B. Also called pointing C. The last possible column in a worksheet D. A combination of letters not used in calculations E. A group of cells selected at the same time

The ________ feature helps you complete an incremental series.

It is always a good practice to test each formula you enter for accuracy.

Using Alt + Enter is a text wrapping option.

Match the following terms with their description: I. Zoom control II. Workbook III. Worksheet IV. Sheet tab V. Cell A. Makes the text on the screen smaller or larger B. Contain labels, values and formulas C. The intersection of a column and a row D. Shows the name of the worksheet E. The same as a spreadsheet

What can you not do within the worksheet tabs shortcut menu?

The current cell is also known as the ________ cell.

________ can be used in calculations, whereas text cannot.

What can the phrase "Please Excuse My Dear Aunt Sally" help you remember?

If you want to unmerge cells you click the Unmerge alignment option.

Match the following Paste options with their description: I. Values II. Picture III. Paste Link IV. Linked Picture V. Paste A. A reference to the cells, not the cell contents B. Unformatted results of formulas C. Cell contents and all formatting D. A non-editable copy of your data E. Changes if the content changes

The ________ feature can pull only part of a cell's value and place it into another cell.

You can ________ a cell's contents to the right or left to help it stand out from the row above or below.

Where would you find the command to center the printout both horizontally and vertically on your paper?

The default number format is ________.

The ________ feature displays any values in the column that match what the user has typed so far.

A(n)________ is a type of file that organizes data in rows and columns.

A(n)________ is a line you can put around a cell or range of cells for emphasis.