Modifying a Worksheet Answers

8 verified answers2 views
1
Free Preview

What are some ways to insert a row or column? Check all that apply.double-clicking on the row or column and clicking Insert Row or Insert Columnright-clicking on the row or column heading and clicking Insertopening the Page Layout tab, clicking Cells in the Tables group, and clicking Rows or Columnsopening the Home tab, clicking Insert in the Cells group, and clicking Insert Sheet Rows or Insert Sheet Columns

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
192041
Free Preview

Use the drop-down menus to complete the steps for deleting a range of cells in a worksheet.

Answers:
On the Home tab, in the group, click Delete, or .:Cells
On the Home tab, in the group, click Delete, or .:right-click the selection and click Delete
192042

left-click the selection and press the Backspace keydouble-click the selection and click Delete✔ right-click the selection and click Deleteclick and drag the selection outside the worksheet

A
left-click the selection and press the Backspace key
B
double-click the selection and click Delete
C
✔ right-click the selection and click Delete
D
click and drag the selection outside the worksheet
192043

What are some ways to change column width? Check all that apply.clicking and dragging the border between the column namesclicking and dragging the column letterdouble-clicking a column, clicking Width, and then clicking OKselecting a column, clicking the Format drop-down list in the Cells group, and then clicking AutoFit Column Widthright-clicking a selected column, clicking Column Width, typing the width in numbers, and clicking OKselecting 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
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
192045

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
192047

Use the drop-down menus to complete the steps for deleting a range of cells in a worksheet.

Answers:
On the Home tab, in the group, click Delete, or .:Cells
On the Home tab, in the group, click Delete, or .:right-click the selection and click Delete

Did you find these answers helpful?

Modifying a Worksheet Answers — CR Computer…