Importing and Exporting Data in Excel MCQs

1. Which feature in Excel allows you to bring in data from external sources like databases and text files?
(A) Data Validation
(B) Import Wizard
(C) Pivot Table
(D) AutoFilter

2. Which file format is commonly used to import/export large datasets into Excel?
(A) exe
(B) jpg
(C) mp3
(D) csv

3. In Excel, which tab is commonly used to access options for importing and exporting data?
(A) Home
(B) Insert
(C) Data
(D) Review

4. What happens if you import a CSV file into Excel?
(A) Data is split into columns based on commas
(B) Data is displayed in a single cell
(C) Data is converted into images
(D) Data is encrypted

5. Which Excel feature is used to export data for use in other software applications?
(A) Export Wizard
(B) Save As
(C) Goal Seek
(D) Macro Recorder