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
Q12: Which of the following series of clicks
Q13: After drilling down,Esteban wants to drill up
Q14: Which of the following will you select
Q15: In which of these boxes will you
Q16: Amin wants to extract data from a
Q18: To illustrate different data levels using small
Q19: Ned wants to calculate the total sale
Q20: Johan wants to create a PivotTable using
Q21: If Power View is enabled,one can create
Q22: To add a title to a Power
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents