Question

"In cells A1 through A4, enter the labels Audience, Action, Communication, and Big Idea, respectively. In cells B1 to B4, briefly answer the questions a to d based on the chart you created and the hypothetical scenario given. You should answer one question per cell, and each answer should be 1-3 sentences in length. You may stretch out the cells and use text wrapping to make the format tidy."

Answer 1

Which key/combination activates Edit mode in Excel?

F2

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 Values option.

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.

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.

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?

Hide the rows or columns that contain the sensitive information before printing the worksheet

What is the maximum length of a worksheet tab name?

31 characters.

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

As many as the available memory of your system will permit.

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

To the right of the current worksheet tab.