Multiple Choice
Which of these series of clicks will you select to import a text file by opening it in Excel?
A) File > Open > Open Dialog box > Text files > Locate and double-click the text file you want to open > Finish
B) File > Save As > Save As dialog box > Save As type box > click Text (Tab delimited) or CSV (Comma delimited) > Browse to location where you want to save the new text file > Save.
C) Cell to insert data from the text file >Data tab > Get External Data > From Text/CSV > Locate and double-click the text file that you want to import > Finish > Import data dialog box > Where do you want to put the data? > New Worksheet > OK
D) Cell to insert data from the text file >Data tab > Get External Data > From Text/CSV > Locate and double-click the text file that you want to import > Finish > Import data dialog box > Properties > Select formatting,and layout options for the imported data > Ok
Correct Answer:

Verified
Correct Answer:
Verified
Q1: A student creates data for trees in
Q3: On which of the following tabs of
Q4: In which of these boxes will you
Q5: How can one filter a PivotTable using
Q6: To illustrate different data levels using small
Q7: After drilling down,Esteban wants to drill up
Q8: Ned wants to calculate the total sale
Q9: Amin wants to extract data from a
Q10: Which of the following will you select
Q11: If Power View is enabled,one can create