Rachel wants to use Microsoft Query to retrieve data from her corporate databases and files so that she doesn't have to retype the data that she wants to analyze in Excel.To do so,she can click and/or enter the following information in the following series of clicks: Data tab > Get External Data group > From Other Sources > From Microsoft Query > Databases tab (To specify a data source for a database,text file,or Excel workbook)> <New Data Source> OK > Create New Data Source dialog box > Type a name to identify the data source > Click a driver for the type of database for use as data source > Connect (Provide the information needed to connect to the data source)> OK.
Correct Answer:
Verified
Q2: Which of the following scene effects move
Q3: Which of the following will you click
Q4: Avery wants to transform data from data
Q5: One can use Get & Transform (Power
Q6: Which of the following can X be
Q7: What is the default value (in seconds)for
Q8: How can you rename a column in
Q9: Chris wants to remove the rows with
Q10: In which of the following groups on
Q11: Which of these will you click select
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