Excel 2016 Lesson 2 Review

David wants to key the numbers 1-1000 in column A of the spreadsheet. What command should he use to complete this task?

• AutoFill
• filter
• find and replace
• sort

What is the name of frequently used Excel commands when you do a right click?

• mini toolbar
• QAT
• shortcut menu
• ribbon

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

• copy cells
• fill formatting only
• fill without formatting
• fill series

How do you change the width of a column so that the widest entry will fit?

• SmartFit
• AutoFit
• BestFit
• TrueFit

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

• Cut

• Copy

• Move

• Duplicate

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

• Cell

• Column

• Range

• Row

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 is a small green square in the lower-right corner of a selected cell or range that you can use to copy one cell to adjacent cells or to create a series?

• Cell pointer
• Column marker
• Fill handle
• Formula bar

True or False:  Using the Delete key removes both text and formats from a cell.

• True
• False
• N/A
• N/A

True or False:  The formula bar is found at the bottom of the Excel window.

• True
• False
• N/A
• N/A