Scribd
Upload
11 views2 pages

Module 9 Test Questions

The document consists of test questions related to Excel and data connections, covering topics such as importing data from external sources, refreshing data connections, using Power Query, and cleaning and transforming data. Key concepts include the Get External Data feature, automatic refresh configurations, and the importance of data cleaning for accuracy. The questions assess understanding of practical Excel functionalities and best practices.

Uploaded by

Ife
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
11 views2 pages

Module 9 Test Questions

The document consists of test questions related to Excel and data connections, covering topics such as importing data from external sources, refreshing data connections, using Power Query, and cleaning and transforming data. Key concepts include the Get External Data feature, automatic refresh configurations, and the importance of data cleaning for accuracy. The questions assess understanding of practical Excel functionalities and best practices.

Uploaded by

Ife
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

MODULE 9 TEST QUESTIONS: EXCEL AND DATA CONNECTIONS

Question 1: Importing Data from External Sources

1.1. How can you import data from external sources like text files or databases into Excel?

a) Use the Copy-Paste feature.


b) Write custom VBA code.
c) Utilize the Get External Data feature.
d) Manually type the data.

1.2. What is one of the key benefits of using Get External Data in Excel?

a) It automatically formats the imported data.


b) It allows you to edit data directly from the source.
c) It provides real-time data updates.
d) It simplifies data import from various sources.

Question 2: Refreshing Data Connections

2.1. How can you configure data connections in Excel for automatic refresh?

a) By clicking the Refresh button in the Data tab.


b) By enabling the Developer tab.
c) In the Options menu.
d) By setting up a scheduled task in Windows.

2.2. When is it important to refresh data from external sources in Excel?

a) Only when opening a new Excel file.


b) Only when making changes to the imported data.
c) Whenever you need to ensure your data is up-to-date.
d) Never, as Excel automatically updates the data.

Question 3: Using Power Query to Connect to Data Sources

3.1. What is the primary function of Power Query in Excel?

a) To create pivot tables.


b) To import data from web pages and APIs.
c) To calculate complex formulas.
d) To create charts and graphs.

3.2. Which feature of Power Query allows you to import data from web pages and APIs?

a) Power Tables
b) Power Link
c) Power Source
d) Power Query

Question 4: Cleaning and Transforming Imported Data

4.1. How can you clean and transform imported data in Excel using Power Query?

a) By using the Filter tool in Excel.


b) By manually editing each cell.
c) By applying transformations and formatting in Power Query Editor.
d) By creating new worksheets for each transformation.

4.2. Why is data cleaning important before analysis?

a) To increase the file size.


b) To remove duplicate records.
c) To improve data accuracy and consistency.
d) To create additional data backups.

Good Luck

You might also like