2016 Excel - Lesson 2 Study Guide

Joan is creating a table that will include demographic information about her employees. What is each header in her table condisered?

• Label

• Value

• Formula

• Function

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

John wants to print only the Inventory worksheet that he is currently working on in his workbook. Which option should he choose?

• Print Selection

• Print Active Sheet

• Print Entire Workbook

• Fit to One Page

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

• Click and paste

• Drag and move

• Dragging

• Drag and drop

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

• Cut

• Copy

• Move

• Duplicate

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

• Clear

• Copy

• Cut

• Format Painter

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

• Cell

• Column

• Range

• Row

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

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

• Clear

• Copy

• Cut

• Format Painter

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