Lesson 2 Flashcards
1
Q
Jennifer needs to identify the values in column B for a statistics report. Which type of entry should she use in the column header? A. values B. formulas C. labels D. functions
A
C. labels
2
Q
Alicia needs to delete the data in cell B5. Which command would she select? A. Clear B. Copy C. Cut D. Format Painter
A
A. Clear
3
Q
John wants to print only the Inventory worksheet that he is currently working on in his workbook. Which option should he choose? A. Print Selection B. Print Active Sheet C. Print Entire Workbook D. Fit to One Page
A
B. Print Active Sheet
4
Q
David wants to key the numbers 1 to 1,000 in Column A of his spreadsheet. What command should he use to complete this task? A. AutoFill B. Filter C. Find and Replace D. Sort
A
A. AutoFill
5
Q
What is the name of the small black square in the lower-right corner of the heavy border of an active cell
that repeats a cell’s value in adjacent cells?
A. Fill handle
B. Filler
C. Copy handle
D. Copy box
A
A. Fill handle
6
Q
Which command on the Fill options dialog box is the default option if you enter a month or day? A. Copy Cells B. Fill Formatting Only C. Fill without Formatting D. Fill Series
A
D. Fill Series
7
Q
Joyce has updated the data in an existing spreadsheet. Which command would she select to preserve the data for future use? A. Exit B. Open C. Save D. Save As
A
C. Save
8
Q
In an Microsoft Excel worksheet, how do you change the width of a column so that the widest entry will fit? A. Smart Fit B. AutoFit C. Best Fit D. True Fit
A
B. AutoFit
9
Q
To help organize and identify Microsoft Excel files by providing details about the files, which of the following would you use? A. File details B. Document properties C. File facts D. Document options
A
B. Document properties
10
Q
Which term refers to a group of selected cells that may be formatted, moved, copied or deleted as a group? A. Segment B. Set C. Range D. Cluster
A
C. Range
11
Q
Alicia needs to move the data in cell B5 to cell E5. Which command would she select? A. Clear B. Copy C. Cut D. Format Painter
A
C. Cut
12
Q
Which command on the Home ribbon allows data to be moved from one worksheet location to another? A. Cut B. Move C. Copy D. Duplicate
A
A. Cut
13
Q
Sharon's spreadsheet contains information about the number of music downloads in F1:F25. F1:F25 represents a: A. Cell B. Column C. Range D. Row
A
C. Range
14
Q
What is the process of using the mouse to move or copy cells called? A. Click and paste B. Drag and move C. Dragging D. Drag and drop
A
D. Drag and drop
15
Q
When entering data into a cell, which keyboard key is used to remove characters to the left of the insertion point? A. Delete key B. Backspace key C. Left arrow key D. Enter key
A
B. Backspace key
