Excel Lesson 2

Sam has painstakingly created a worksheet of Sales figures for the Eastern region. His worksheet is beautifully formatted and contains accurate formulas. Now he needs to create a worksheet just like it for the Western region. How should Sam proceed?

He should create a copy of the Eastern worksheet, rename the copy Western, and then enter the figures as appropriate.

How many new worksheets can you add to an Excel workbook?

Unlimited

Ruby wants all the entries in Column D in her worksheet to display fully. What is the best method for ensuring Column D is wide enough?

Using the AutoFit command.

Which of the following is the keyboard shortcut key combination for pasting data?

CTRL+V

Which sequence of steps will allow you to change the color of a worksheet tab?

To change the color of a worksheet tab, right-click the worksheet tab, then click Tab Color.

Suppose you used the Copy and then the Paste command to copy the contents of cells A1 to cell B1, but you do not want to copy the cell formatting to cell B1. What can you do to fix it?

Use the Paste Special command instead and select the Formats option.

Which statement about inserting rows or columns into a worksheet is TRUE?

You can insert multiple rows or columns at the same time.

What is the maximum length of a worksheet tab name?

31 characters

How many worksheets can you hide in a workbook?

All except one.

What is the difference between pressing DELETE to delete the contents of a cell and using the Delete Cells command?

Deleting the contents of a cell leaves the structure of the worksheet intact. If you use the Delete Cells command, you have the option of shifting the cells after the delete action is complete.

Which key/combination activates Edit mode in Excel?

F2

When you insert a new worksheet using Insert, Insert Sheet on the Home tab, the new worksheet tab appears:

Inserting or Deleting WorksheetsWhen inserting a new worksheet using the Insert command in the Cells group of the Home tab the worksheet is inserted to the left of the active worksheet.

Dean needs to print a worksheet for distribution at a meeting. The worksheet currently includes sensitive information that Dean needs to see, but which should not be seen by the meeting attendees. What is the easiest way for Dean to print an appropriate version of the worksheet for his meeting?

You may want to hide rows or columns when you want to prevent other users from seeing the data in these hidden rows or columns. In other situations, you may be improving the readability of your worksheet by reducing the number of rows or columns of data to print together on a single page, or to hide cells that only contain intermediate calculations for otherwise complex formulas.

Which key should you press in order to copy cells using drag-and-drop?

ctrl