MS Excel - Managing Workbooks and Worksheets

Which of these acts as the toolbar for Microsoft Excel

• Worksheet Tab

• Ribbon

• Formula Bar

• Backstage View

Which of the following identifies rows in Excel?

• Numbers

• Letters

• Roman Numerals

• Numbers and Letters

Which of the following identifies columns in Excel?

• Numbers

• Letters

• Roman Numerals

• Numbers and Letters

Find & Replace feature is located on which of these tabs?

• File

• Insert

• Home

• Data

On which of these groups in the Data tab will you go if you wish to import data from .txt or .csv files?

• Sort & Filter

• Forecast

• Get & Transform Data

• Queries & Connections

Which of these separates data on a text file?

• Dash

• Character Space

• Division

• Delimiter

What is the shortcut key for adding hyperlinks to your workbooks?

• Ctrl + L

• Ctrl + K

• Ctrl + B

• Ctrl + V

Which of these options when adding a hyperlink will you choose if you wish to open a different worksheet in the same workbook?

• Place in this Document

• Place in this Worksheet

• Existing File or Web Pages

• Create New Worksheet

Which of these is a small text box that appears when a mouse pointer hovers over an icon or button?

• Window Note

• Hyperlink

• Find What

• Screentip

Which of these IS NOT a Workbook View?

• Worksheet View

• Page Layout View

• Normal View

• Page Break View