5.3 Excel Quizizz

Which command is used to insert a cut or copied selection to a cell or range of cells?

• Paste

• Document Properties

• Copy

• Range

Content that has been cut or copied to the clipboard will have a marching dashed green border around it.

• TRUE

• FALSE

To select cells that are not adjacent (next to) each other, use which of the following keys while clicking on each cell?

• Ctrl

• Alt

• Shift

• Fn

Look at the picture. If I want to move 'horse' up to blank cell above it, I will need to ​ (a)   the cell and ​ (b)   cells up. If I want to remove all of the colors but leave the same number of cells, I will need to ​ (c)   the contents. Pressing the delete key on the ​ (d)   is the same thing as clearing the ​ (e)   .

• delete
• clear
• keyboard
• contents
• shift

Which of the following statements describes how to unhide a hidden row or column?

• Select a range of cells in the row or column, right-click, and select Unhide.

• Use the Page Setup dialog box.

• Remove all page breaks.

• Select the rows/columns before and after the hidden rows/columns and then right-click and select Unhide.

Which cell would you click to freeze Rows 1-5 and Column A?

• A5

• B5

• A6

• B6

In order for you to freeze the first column of a worksheet into a frozen pane:

• The entire contents of the column must be visible.

• The first row of the column must be non-blank.

• Duplicate worksheets must also be able to have their first columns frozen.

• You can click Freeze First Column in the Freeze Panes menu.

How do you insert a new row?

• Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu
• Select the row heading where you want to insert the new row and select Edit >Row from the menu
• Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar
• All of the above

How do you select an entire column?

• Select Edit > Select > Column from the menu
• Click the column heading letter
• Hold down the shift key as you click anywhere in the column.
• Hold down the Ctrl key as you click anywhere in the column

In a cell reference, for example A1, what does the letter refer to?

• The column
• The cell
• The row