Excel/Access 1

What type of database contains multiple collections of data that are related to one another?

• Joined
• Relational
• Flat
• Managed

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

• Exit
• Open
• Save
• Save As

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

• Cell
• Column
• Range
• Row

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

• Quick Access Toolbar
• Title bar
• Status bar
• Formula bar

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

Which command do you use to close an open file and completely exit the Microsoft Excel program?

• Close
• Save As
• Exit
• Quit

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 + Home
• Ctrl + End
• Ctrl + Up Arrow
  Ctrl + 1

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?

• Entry
• Workbook
• Row
• Column

Which tab do you use to display the area that contains the print command?

• Home
• Page Layout
• View
• File

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