1 Which option in Excel allows you to import data from an external file, such as a CSV or text file?
a) Data Tab > Get External Data
b) File Tab > Open
c) Data Tab > From Text/CSV
d) Home Tab > Import Data
Answer: c) Data Tab > From Text/CSV
2 What is the primary purpose of the “Power Query” tool in Excel?
a) To perform basic calculations
b) To import, clean, and transform data from various sources
c) To create charts and graphs
d) To format cells and ranges
Answer: b) To import, clean, and transform data from various sources
3 Which feature allows you to export an Excel worksheet to a PDF file?
a) File Tab > Save As > PDF
b) Home Tab > Export > PDF
c) Data Tab > Export > PDF
d) Review Tab > Save As PDF
Answer: a) File Tab > Save As > PDF
4 How can you import data from an SQL database into Excel?
a) Data Tab > Get Data > From Database > From SQL Server
b) Data Tab > Import Data > From SQL
c) Data Tab > Get External Data > From SQL
d) Data Tab > From Other Sources > From SQL Server
Answer: a) Data Tab > Get Data > From Database > From SQL Server
5 What format is commonly used to export data for compatibility with other applications and systems?
a) XLSX
b) CSV
c) DOCX
d) XML
Answer: b) CSV
6 Which Excel feature allows you to link data from an external source so that it updates automatically?
a) Power Query
b) External Data Connections
c) Data Validation
d) Conditional Formatting
Answer: b) External Data Connections
7 How can you import data from a web page into Excel?
a) Data Tab > Get Data > From Web
b) File Tab > Open > Web
c) Data Tab > Import Data > From Web Page
d) Home Tab > Get External Data > From Web
Answer: a) Data Tab > Get Data > From Web
8 What is the purpose of the “Text Import Wizard” in Excel?
a) To clean and format imported text data
b) To import text data and specify delimiters and data formats
c) To convert text files to Excel format
d) To merge multiple text files
Answer: b) To import text data and specify delimiters and data formats
9 Which option should you use to export data from Excel to an XML file?
a) File Tab > Save As > XML Data
b) File Tab > Export > XML
c) Data Tab > Export > XML
d) File Tab > Save As > XML Data
Answer: a) File Tab > Save As > XML Data
10 How can you import data from an Excel workbook into a new worksheet in the same workbook?
a) Data Tab > Get Data > From Workbook
b) File Tab > Open > Import Data
c) Home Tab > Copy and Paste
d) Data Tab > From Other Sources > From Workbook
Answer: a) Data Tab > Get Data > From Workbook