12 Accounting Advanced Excel Lessons 1 & 2

What command will arrange Microsoft Excel windows so that they appear side-by-side on the screen?

• Zoom to Selection 
• New Window
• Arrange All
• Freeze Panes

Joyce needs to access a spreadsheet she saved yesterday. Which command would she select?

• Exit 
• Open 
• Save
• Save As

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

• Workbook

• Worksheet

• Notepad

• Folder

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

• Formula Bar
• Title Bar
• Status Bar 
• Quick Access Toolbar

Sharon’s spreadsheet contains information about the number of music downloads in F25.  In this address, ‘25’ identifies the:

• cell
• column
• row 
• range

John wants to be able to view multiple areas of his spreadsheet at the same time.  What would be his best option?

• Freeze Panes
• Split
• Hide 
• Unhide

Which command among the window control buttons is used to close an open file and completely exit the Microsoft Excel program?

• Close
• Save As
• Exit
• Quit

Which ribbon option opens a related dialog box?

• Ellipse
• Drop-down Arrow
• Launcher
• Slider

Which area on the left side of the formula bar indicates the cell address of a selected cell?

• Cell Box 
• Address Box
• Name Box
• Formula Box

Which tab is used to display the area that contains the print command?

• Home
• Page Layout
• View 
• File