Excel 1: Essentials

Multiple Choice

Which of the following keys should be pressed to select the cells shown in the image?

• Ctrl

• Shift

• Delete

• Enter

Multiple Choice

Which letter on the image is a Column?

• A

• B

• C

• D

Multiple Choice

Where would you click to clear a cell's content and/or format information?

• A

• B

• C

• D

• E

Multiple Choice

In a spreadsheet, what is the current selected cell called?

• The active cell

• The chosen one

• The Green cell

• The outlined cell

Multiple Choice

Which letter on the image is the Name Box?

• A

• B

• C

• D

Multiple Choice

What Clear command would you use to make cell A2 look like cell A4?

• Clear All

• Clear Format

• Clear Contents

Multiple Choice

Which command would you use if you wanted to move row 6 in between rows 3 and 4 without overwriting any data?

• Insert copied cells

• Insert

• Paste

• Merge

Multiple Choice

What group in the Home tab would be used to change the format of cell B2 to match cell B4?

• Font

• Alignment

• Number

• Styles

• Cells

Multiple Choice

Which letter on the image is a Cell?

• A

• B

• C

• D

Multiple Choice

What is the address of the currently selected cell?

• B4

• 4B

• C45

Multiple Choice

Which letter on the image is a Row?

• A

• B

• C

• D

Multiple Choice

Which method is the most common way used to select the multiple cells shown in the image?

• Click and drag method

• Ctrl key method

• Shift key method

Multiple Choice

What are the pieces of information that describe the appearance of a cell's content?

• Paste attributes

• Format attributes

• Active attributes

• • 
    

    Edit attributes

Multiple Choice

Which keyboard shortcut would you press to cancel a command?

• • 
    

    Escape

• Backspace

• Tab

• Delete

Multiple Choice

Which keyboard shortcut would you press to copy cells that are selected in a spreadsheet?

• Ctrl+C

• Ctrl+X

• Ctrl+V

• Ctrl+Z

Multiple Choice

Pressing the keyboard shortcut "Ctrl+I" will result in the cell information being:

• Italicized

• Bold

• Underlined

• Indented

Multiple Choice

Which keyboard shortcut bolds text in a cell?

• Ctrl+X

• Ctrl+B

• Ctrl+I

• Ctrl+U

Multiple Choice

Which of the following is NOT a way to change the column width in Excel?

• Click and drag the column's boundary line to the desired width.

• Double-click the column's boundary line.

• Right-click the column header and then click Column Width.

• Double-click the column header and then click Delete.

• All of the above

Multiple Choice

Which of the following statements is TRUE?

• The content and format of a cell are the same.

• The content and format of a cell are independent.

• Changing the format of a cell also affects its content.

Multiple Choice

What does the keyboard shortcut "Ctrl+Z" do?

Responses

• 
  

• Cut

• Undo

• Copy

• Paste

Multiple Choice

Which sequence of keyboard shortcuts would you use to COPY information from one cell to another?

• Ctrl+X then Ctrl+V

• Ctrl+X then Ctrl+Z

• Ctrl+C then Ctrl+V

• Ctrl+V then Ctrl+Z