Excel Lesson 2 Quiz

Sharon’s spreadsheet contains information about the number of music downloads in F1:F25. F1:F25 represents a:

• cell

• cell

• range

• row

Alicia needs to delete the data in cell B5. Which command would she select?

• Clear Contents

• Copy

• Cut

• Format Painter

Which term refers to a group of selected cells that may be formatted, moved, copied or deleted as a group?

• Segment

• Set

• Range

• Cluster

Which Microsoft Excel feature automatically inserts data into a cell that begins with the same characters as a previous entry?

• AutoComplete

• AutoFill

• AutoCorrect

• AutoSpell

Which command on the Fill options dialog box is the default option if a month or day is entered?

• Copy Cells

• Fill Formatting Only

• Fill without Formatting

• Fill Series

Which command on the Home ribbon allows data to be moved from one worksheet location to another?

• Cut

• Move

• Copy

• Duplicate

What is the process of using the mouse to move or copy cells called?

• Click and paste

• Drag and move

• Dragging

• Drag and drop

In Microsoft Excel, which feature makes an exact replica of the cell data and format while keeping the original cell intact?

• Paste

• Move

• Cut

• Copy

In a Microsoft Excel worksheet, how do you change the width of a column so that the widest entry will fit?

• Smart Fit

• AutoFit

• Best Fit

• True Fit

When entering data into a cell, which keyboard key is used to remove characters to the left of the insertion point?

• Delete key

• Backspace key

• Left arrow key

• Enter key