MS Excel Honors Question Preview (ID: 54099)


Microsoft Excel Associate Expert. TEACHERS: click here for quick copy question ID numbers.

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

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

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

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) Notebook
d) Folder

Which view is the default view used in Microsoft Excel?
a) Page Layout
b) Print
c) Normal
d) Web

Joyce needs to access a spreadsheet she saved yesterday. Which command would she select?
a) Exit
b) Open
c) Save
d) Save As

Sharon’s spreadsheet contains information about the number of music downloads in F25.  In this address, ‘25’ identifies the:
a) Cell
b) Column
c) Range
d) Row

Joan has a table that includes demographic information about her employees. If the demographic information is listed across the top and employee names down the left side of the table, what does all the information about one employee represent?
a) Entry
b) Workbook
c) Row
d) Column

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

Which software program is a powerful spreadsheet program that allows users to organize data, complete calculations, and graph data?
a) Word
b) Publisher
c) Excel
d) PowerPoint

Which notebook-like feature organizes the sheets for use in Excel?
a) Workbook
b) Worksheet
c) Notepad
d) Folder

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

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

What occurs when the cursor is moved over a cell and a user clicks?
a) The row is selected.
b) The cell is selected.
c) The column is selected.
d) The worksheet is selected.

Which tab is used to display the area that contains the print command?
a) Home
b) Page Layout
c) View
d) File

Which command among the window control buttons is used to close an open file and completely exit the Microsoft Excel program?
a) Close
b) Save As
c) Exit
d) Quit

Which area on the left side of the formula bar indicates the cell address of a selected cell?
a) Cell box
b) Address box
c) Name Box
d) Formula Box

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

Which ribbon option opens a related dialog box?
a) Ellipse
b) Drow-down arrow
c) Launcher
d) Slider

What command is used to insert information into a worksheet that will display at the top and bottom edges of the printed page?
a) Margins
b) Print Titles
c) Header/Footer
d) Setup

Play Games with the Questions above at ReviewGameZone.com
To play games using the questions from above, visit ReviewGameZone.com and enter game ID number: 54099 in the upper right hand corner or click here.

TEACHERS / EDUCATORS
Log In | Sign Up / Register

Help / Support / FAQ




Gaming Links