MICROSOFT EXCEL 3 FINAL STUDY GUIDE,
QUESTIONS AND ANSWERS PROVIDED 2024
UPDATE
1. In Microsoft Excel, which feature makes an exact replica
of the cell data and format while keeping the original cell
intact? A. Paste B. Move C. Cut D. Copy: D. Copy
2. Sharon's spreadsheet contains information about the
number of music downloads in Fl: F25.F1: F25 represents a: A.
Cell B. Column C. Range D. Row: C. Range
3. 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: B. Backspace
key
4. Joan is creating a table that will include demographic
information about her employees. What is each header in her
table considered? A. Label B. Value C. Formula D. Function: A.
Label
5. What is the name of the list of frequently used Excel
commands available when a user right-clicks an item in the
worksheet? A. Mini Toolbar B. Quick Access Toolbar C. Shortcut
Menu D. Shortcut Toolbar: C. Shortcut Menu
6. 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 Sheet on One Page: B. Print Active Sheet
7. 6. Which Microsoft Excel feature automatically inserts data
into a cell that begins with the same characters as a previous
entry? A. AutoComplete B.
AutoFill C. AutoCorrect D. Autopsied: A. AutoComplete
1/21
, MICROSOFT EXCEL 3 FINAL STUDY GUIDE,
QUESTIONS AND ANSWERS PROVIDED 2024
UPDATE
8. 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. AutoFill
9. 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. Fill handle
10. 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: D. Fill
Series
1 1. 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: C. Range
12. Jennifer needs to identify the values in column B for a sales
report. Which type of entry should she use in the column
header? A. Values B. formulas C. labels D. functions: C. labels
13. 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: D. Drag and Drop
14. 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: B.
Document properties 15. Joyce has updated the data in an
2/21
, MICROSOFT EXCEL 3 FINAL STUDY GUIDE,
QUESTIONS AND ANSWERS PROVIDED 2024
UPDATE
existing spreadsheet. Which command would she select to
preserve the data for future use? A. Exit B. Open C. Save
D. Save As: C. Save
16. Alicia needs to delete the data in cell B5. Which command
would she select? A. Clear B. Copy C. Cut D. Format Painter: A.
Clear
17. Alicia needs to move the date in cell B5 to cell E5. Which
command would she select? A. Clear B. Copy C. Cut D. Format
Painter: C. Cut
18. 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. Cut 19. In a 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. Trust Fit: B.
AutoFit
20. 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: C.
labels
21. What area contains the command used to customize the
print options in Microsoft Excel? A. Home Ribbon B. Page Layout
Ribbon C. File Tab D. Quick Access Toolbar: C. File Tab
22. Which command enables a user to save an existing
worksheet with a new name or save the worksheet in a new
location? A. Close B. Save C. Save As D. Exit: C. Save As
23. Steve would like to print only the worksheet he is currently
working on. What print option should he choose? A. Print Area
3/21
QUESTIONS AND ANSWERS PROVIDED 2024
UPDATE
1. In Microsoft Excel, which feature makes an exact replica
of the cell data and format while keeping the original cell
intact? A. Paste B. Move C. Cut D. Copy: D. Copy
2. Sharon's spreadsheet contains information about the
number of music downloads in Fl: F25.F1: F25 represents a: A.
Cell B. Column C. Range D. Row: C. Range
3. 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: B. Backspace
key
4. Joan is creating a table that will include demographic
information about her employees. What is each header in her
table considered? A. Label B. Value C. Formula D. Function: A.
Label
5. What is the name of the list of frequently used Excel
commands available when a user right-clicks an item in the
worksheet? A. Mini Toolbar B. Quick Access Toolbar C. Shortcut
Menu D. Shortcut Toolbar: C. Shortcut Menu
6. 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 Sheet on One Page: B. Print Active Sheet
7. 6. Which Microsoft Excel feature automatically inserts data
into a cell that begins with the same characters as a previous
entry? A. AutoComplete B.
AutoFill C. AutoCorrect D. Autopsied: A. AutoComplete
1/21
, MICROSOFT EXCEL 3 FINAL STUDY GUIDE,
QUESTIONS AND ANSWERS PROVIDED 2024
UPDATE
8. 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. AutoFill
9. 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. Fill handle
10. 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: D. Fill
Series
1 1. 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: C. Range
12. Jennifer needs to identify the values in column B for a sales
report. Which type of entry should she use in the column
header? A. Values B. formulas C. labels D. functions: C. labels
13. 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: D. Drag and Drop
14. 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: B.
Document properties 15. Joyce has updated the data in an
2/21
, MICROSOFT EXCEL 3 FINAL STUDY GUIDE,
QUESTIONS AND ANSWERS PROVIDED 2024
UPDATE
existing spreadsheet. Which command would she select to
preserve the data for future use? A. Exit B. Open C. Save
D. Save As: C. Save
16. Alicia needs to delete the data in cell B5. Which command
would she select? A. Clear B. Copy C. Cut D. Format Painter: A.
Clear
17. Alicia needs to move the date in cell B5 to cell E5. Which
command would she select? A. Clear B. Copy C. Cut D. Format
Painter: C. Cut
18. 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. Cut 19. In a 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. Trust Fit: B.
AutoFit
20. 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: C.
labels
21. What area contains the command used to customize the
print options in Microsoft Excel? A. Home Ribbon B. Page Layout
Ribbon C. File Tab D. Quick Access Toolbar: C. File Tab
22. Which command enables a user to save an existing
worksheet with a new name or save the worksheet in a new
location? A. Close B. Save C. Save As D. Exit: C. Save As
23. Steve would like to print only the worksheet he is currently
working on. What print option should he choose? A. Print Area
3/21
