2016 Excel Lesson 1 - Study Guide

Which ribbon option opens a related dialog box?

• Ellipse

• Drop-down Arrow

• Launcher

• Slider

Which Microsoft Office object would you use for quick, convenient, one-click access to frequently used Excel commands?

• Formula Bar

• Quick Access Toolbar

• Status Bar

• Title Bar

Which of the following software programs is a powerful spreadsheet program that allows users to organize data, complete calculations, and graph data?

• Excel

• Publisher

• PowerPoint

• Word

What occurs when the cursor is moved over a cell and a user clicks?

• The row is selected

• The cell is selected

• The column is selected

• The worksheet is selected

Which area, on the left side of the formula bar, can you look at to determine the cell address of a selected cell?

• Address Box

• Cell Box

• Formula Box

• Name Box

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?

• Quick Access Toolbar

• Hot Keys

• Mini Toolbar

• Key Tips

Sharon's spreadsheet contains information about the number of music downloads in F25. "25" identifies the:

• Cell

• Column

• Range

• Row

Which of the following would you use to enter, calculate, manipulate, and analyze data such as numbers and text in Excel?

• Folder

• Notepad

• Worksheet

• Workbook

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?

• Ctrl + 1

• Ctrl + End

• Ctrl + Home

• Ctrl + Up Arrow

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?

• Amplify Range

• Enlarge Selected Area

• Magnify Area

• Zoom to Selection