WorksheetsExcel Checkup 7 (Get Data) 1.06
Total questions: 10
Worksheet time: 5mins
To import a file into Excel go to:
Insert tab -> Object
Data tab -> From Text/CSV
Insert tab
Data tab -> From Other Sources
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
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
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
In an excel worksheet, which choice must you use to import data into a specific sheet and location?
Load
Delimit with
Text/CSV
Load To
Which group on which ribbon, is used to import data in Excel 2019?
Insert->Add-ins
Data -> Get & Transform Data
Data -> Sort & Filter
Insert -> Filters
When importing data from text, what should you change if your preview does not look the way you would like it to?
Spacing
Load to existing sheet
import range
delimiter
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
