Modifying a Worksheet

Use the drop-down menus to complete the steps for deleting a range of cells in a worksheet. 1. Select the range of cells to delete. 2. On the home tab, in the _____ group, click Delete or ____________ 3. Specify where to shift the adjacent cells. 4. Click OK.

2. Cells, right click the selection and click Delete

What are some ways to change column width? Check all that apply. A) clicking and dragging the border between the column names B) clicking and dragging the column letter C) double-clicking a column, clicking Width, and then clicking OK D) selecting a column, clicking the Format drop-down list in the Cells group, and then clicking AutoFit Column Width E) right-clicking a selected column, clicking Column Width, typing the width in numbers, and clicking OK F) selecting a column, clicking the Width drop-down list in the Format group, and then clicking AutoFit

A) clicking and dragging the border between the column names D) selecting a column, clicking the Format drop-down list in the Cells group, and then clicking AutoFit Column Width E) right-clicking a selected column, clicking Column Width, typing the width in numbers, and clicking OK

Which features would work well for text entered into cells? Check all that apply. A) thesaurus B) spelling C) autosum D) average E) find F) replace

A) thesaurus B) spelling E) find F) replace

What are some ways to insert a row or column? Check all that apply. A) double-clicking on the row or column and clicking Insert Row or Insert Column B) right-clicking on the row or column heading and clicking Insert C) opening the Page Layout tab, clicking Cells in the Tables group, and clicking Rows or Columns D) opening the Home tab, clicking Insert in the Cells group, and clicking Insert Sheet Rows or Insert Sheet Columns

B) right-clicking on the row or column heading and clicking insert D) opening the Home tab, clicking Insert in the Cells group, and clicking Insert Sheet Rows or Insert Sheet Columns

Asher wants to replace the word commission with a synonym. Which group in the Review tab would help him most? A) Accessibility B) Insights C) Proofing D) Comments

C) Proofing

What symbol indicates that a cell is not wide enough to display its numbers? A) an asterisk B) a dollar sign C) a percentage sign D) a pound sign

D) a pound sign