Exam 1: Introduction to Excel

The default number format is ________.

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.

Right-clicking a column heading, then selecting Insert, will add a new column to the left of the current column.

Besides the Page Setup dialog box, where else can you create headers or footers?

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

If you do not need a row or column any more it is best to hide it instead of deleting it in case you change your mind.

A range is specified by its ________.

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

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

You cannot hide column A or row 1 because they cannot be unhidden.

The intersection between a column and a row is called a(n)________.

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

The ________ feature allows you to see how a document would print before you actually print it.

In Excel, columns are identified by numbers and rows by letters.

What Paste option would you choose if you wanted to maintain the formatting of the copied cell, but not its contents?

Where is the Show Formulas command found?

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

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

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

Using Alt + Enter is a text wrapping option.