Exam 1: Introduction to Excel

You can hide or delete multiple rows or columns by using the Ctrl or Shift key and then selecting the rows or columns you want to hide or delete.

The ________ feature helps you complete an incremental series.

A range is specified by its ________.

Using Alt + Enter is a text wrapping option.

Use the Find command to jump to a cell that is not currently visible.

The ________ area is where you store the variable you will be using in the worksheet.

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

One point is how big?

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

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

The ________ color is what is visible behind the value in a cell.

Which of the following is not a valid keystroke for navigating around a worksheet?

The ________ feature allows you to move some text to another line in the same row.

When you want to format your spreadsheet with a consistent look you should use the ________ feature.

How is text aligned by default?

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

When you insert rows or columns all relative references are updated but not any absolute references.

Which of the following is not a way to widen a column?

A(n)________ is a group of cells which have been selected at the same time.