NEW
Font size
WorksheetsMS Excel - Managing Workbooks and Worksheets
Total questions: 15
Worksheet time: 6mins
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
If your selection is C5 and you applied Freeze Pane, which of the following columns will be in place?
Column A
Column B
Columns A and B
Columns A, B, and C
If your selection is D4 and you applied Freeze Pane, which of the following rows will be in place?
Rows 1 and 2
Rows 1, 2 and 3
Rows 1, 2, 3 and 4
Rows 1 and 3
Which of these pertains to is a toolbar that contains commonly-used Excel commands that you can add or remove
Quick Access Toolbar
Tabs
Ribbon
Navigation Bar
On which of these tabs will you find the Freeze Panes feature?
Insert
View
Data
File
Under the Freeze Panes feature, which of these IS NOT part of its menu?
Freeze Panes
Freeze Top Row
Freeze First Column
Freeze Selected Cell
