Modifying a Worksheet

Question 1

What is the shortcut for the Go/To dialog box?

Revolt · Accepted Answer

F5

Question 2

Ranges✔ CellsClipboardInsert

Revolt · Accepted Answer

✔ Cells

Question 3

Go To:Special:✔ Reference:Cancel:

Revolt · Accepted Answer

✔ Reference:

Question 4

Replace✔ Replace AllFind AllX Find Next

Revolt · Accepted Answer

✔ Replace All

Question 5

Use the drop-down menus to complete the steps for using Find and Replace commands.

Revolt · Accepted Answer

✔ Home; Under the tab, go to the command group.: Home; Under the tab, go to the command group.: Editing; Choose the option.: Replace; Type in the information you want to find and what it should be replaced with. To make sure all instances are changed at once, select .: Replace All

Question 6

Sarah used the Hide command on her Excel worksheet. What would be the most likely reason to use this command?

Revolt · Accepted Answer

Sarah hid the cells because the information they contained wasn’t relevant to her task.

Question 7

What is the default setting Excel shows when Insert is clicked?

Revolt · Accepted Answer

shift cells down

Question 8

To adjust the height or width to fit the dialog within it, you should use these options. Click all that apply.manually drag the box to adjust the celldouble-click the cell to adjust to largest size neededclick the File tab and adjustclick the View tab and insert sizeclick Format in the Home tab’s Cell group

Revolt · Accepted Answer

manually drag the box to adjust the cell; double-click the cell to adjust to largest size needed; click Format in the Home tab’s Cell group

Question 9

Which tab houses the Spelling feature?

Revolt · Accepted Answer

Review tab

Question 10

Marco is editing a worksheet for Hunter and doesn’t understand one of the items on the sheet. What should he do to get more information?

Revolt · Accepted Answer

Select Smart Lookup in the Review tab.

Modifying a Worksheet Answers

More from this Course

TRY EDGENUITY HACKS