Lesson 1

Question 1

Joyce needs to access a spreadsheet she saved yesterday. Which command would she select? 
A.Exit
B.Open
C. Save
D. Save as

Answer 1

B. Open

Question 2

Which view is the default view used in Microsoft Excel?
A. Page Layout
B. Print
C. Normal
D. Web

Answer 2

C. Normal

Question 3

Which area, on the left side of the formula bar, can you look at to determine the cell address of a selected
cell?
A. Cell box
B. Address box
C. Name box
D. Formula box

Answer 3

C. Name Box

Question 4

Which Microsoft Office object would you use for quick, convenient, one-click access to frequently used Excel
commands?
A. Quick Access Toolbar
B. Title bar
C. Status bar
D. Formula Bar

Answer 4

A. Quick Access Toolbar

Question 5

Which command do you use to close an open file and completely exit the Microsoft Excel program?
A. Close
B. Save As
C. Exit
D. Quit

Answer 5

C. Exit

Question 6

What feature was created for users who prefer to use the keyboard rather than the mouse, and provides
keyboard code icons that may be used in conjunction with the ALT key?
A. Quick Access Toolbar
B. Hot Keys
C. Mini Toolbar
D. Key Tips

Answer 6

D. Key Tips

Question 7

What command do you use to increase or decrease the view of a selected cell or range of cells to fill the Excel
Window area for better visibility?
 A. Magnify Area
 B. Enlarge Selected Area
 C. Amplify Range
 D. Zoom to Selection

Answer 7

D. Zoom to Selection

Question 8

Which tab do you use to display the area that contains the print command?
 A. Home
 B. Page Layout
 C. View
 D. File

Answer 8

D. File

Question 9

Joan has a table that includes demographic information about her employees. What does all the information
about one employee represent?
 A. Entry
 B. Workbook
 C. Row
 D. Column

Answer 9

C. Row

Question 10

Joan wants to add a new entry at the bottom of her spreadsheet. What is the shortcut that will take her to
the last record on her spreadsheet?
 A. Ctrl + Home
 B. Ctrl + End
 C. Ctrl + Up Arrow
 D. Ctrl + 1

Answer 10

B. Ctrl + End

Question 11

Sharon's spreadsheet contains information about the number of music downloads in F25. "25" identifies
the:
 A. Cell
 B. Column
 C. Range
 D. Row

Answer 11

D. Row

Question 12

Joan has entered her name in the First Name field in cell B2 of her table. What does her First Name
represent in the table?
 A. Entry
 B. Workbook
 C. Row
 D. Column

Answer 12

A. Entry

Question 13

Which of the following software programs is a powerful spreadsheet program that allows users to organize
data, complete calculations, and graph data?
A. Word
B. Publisher
C. Excel
D. PowerPoint

Answer 13

C. Excel

Question 14

What command will arrange Microsoft Excel windows so that they appear side by side on the screen?
 A. Zoom to Selection
 B. New Window
 C. Arrange All
 D. Freeze Panes

Answer 14

C. Arrange All

Question 15

Which of the following notebook- like features organizes the sheets for use in Excel?
 A. Workbook
 B. Worksheet
 C. Notepad
 D. Folder

Answer 15

A. Workbook

Question 16

Which ribbon option opens a related dialog box?
 A. Ellipse
 B. Drop-down Arrow
 C. Launcher
 D. Slider

Answer 16

C. Launcher

Question 17

John wants to be able to view multiple areas of his spreadsheet at the same time. What would be his best
option?
 A. Freeze Panes
 B. Split
 C. Hide
 D. Unhide

Answer 17

B. Split

Question 18

Which group on the View Ribbon enables a user to show or hide the ruler, gridlines, Formula Bar, or
headings?
 A. Workbook views
 B. Show
 C. Zoom
 D. Window

Answer 18

B. Show

Question 19

Which view enables a user to create or modify a worksheet while seeing how it will look in printed format?
 A. Page Layout
 B. Print
 C. Normal
 D. Web

Answer 19

A. Page Layout

Question 20

Which of the following would you use to enter, calculate, manipulate, and analyze data such as numbers and
text in Excel?
 A. Workbook
 B. Worksheet
 C. Notepad
 D. Folder

Answer 20

B. Worksheet