COMP APPS II: 5.3.9 Applied Lab: Organize Sales Data

How do you insert a new column to the left of sales data?

• Right-click the heading for column A and choose Insert

• Right-click the heading for row 1 and choose Insert.

• Right-click the heading for cell A1 and choose Insert.

• Right-click the heading for column B and choose Insert.

How do you enter row titles for days of the week?

• Select cells A1 through A7 and enter the days of the week, starting with Monday.

• Select cells A2 through A8 and enter the days of the week, starting with Monday.

• Select cells B2 through B8 and enter the days of the week, starting with Monday.

• Select cells B1 through B7 and enter the days of the week, starting with Monday.

How do you copy a range of cells?

• Select cells by clicking and dragging with the mouse, then press Ctrl + V.

• Select cells by clicking and dragging with the mouse, then press Ctrl + X.

• Select cells by clicking and dragging with the mouse, then press Ctrl + C.

• Select cells by clicking and dragging with the mouse, then press Ctrl + Z.

How do you paste a range of cells?

• Select destination cell(s), then press Ctrl + V.

• Select destination cell(s), then press Ctrl + C.

• Select destination cell(s), then press Ctrl + X.

• Select destination cell(s), then press Ctrl + Z.

How do you clear contents of multiple cells?

• Select cells to clear contents from then go to Home tab then Editing group then Clear then Clear Contents

• Select cells to clear contents from then go to Home tab then Editing group then Clear All

• All of theseNone of these

How do you save changes made to workbook?

• Click Save on quick access toolbar near top left corner of Excel window

• Click Save As on quick access toolbar near top left corner of Excel window

• All of these

• None of these

How do you insert new rows at top of worksheet?

• Right click heading for row 1 then choose Insert

• Right click heading for row 2 then choose Insert

• All of these

• None of these

How do you add content to a cell?

• Select cell

• Type content

• Press Enter

• All of these

How do you change contents of a cell?

• Select cell

• Type new content

• Press Enter

• All of these

How do you deselect a range of cells?

• Press Esc

• Press Enter

• All of these

• None of these