Saving and file formats (xlsx, csv) in Excel - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

Understanding CSV file format

Which of the following statements about CSV files is correct?

A CSV files can store multiple sheets in one file.

B CSV files preserve cell formatting like colors and fonts.

C CSV files save data as plain text separated by commas.

D CSV files are saved in a binary format.

💡 Hint

Think about how CSV files store data compared to Excel files.

CSV files save data as plain text with values separated by commas. They do not support multiple sheets or formatting.

📊 Formula Result

intermediate

Effect of saving Excel file as CSV on formulas

You have a formula =A1+B1 in cell C1. You save the file as CSV and then reopen it. What will be the value in cell C1?

A The cell shows the last calculated value before saving.

B The formula <code>=A1+B1</code> remains and recalculates.

C The cell is empty because formulas are not saved in CSV.

D The cell shows an error like <code>#NAME?</code>.

💡 Hint

Remember what CSV files save: values or formulas?

CSV files save only the values, not formulas. So the cell shows the last calculated value before saving.

❓ Function Choice

advanced

Choosing the right save format for preserving formulas and multiple sheets

You want to save your Excel workbook so that all formulas and multiple sheets are preserved. Which file format should you choose?

A CSV (.csv)

B XML Data (.xml)

C Text (Tab delimited) (.txt)

D Excel Workbook (.xlsx)

💡 Hint

Think about which format Excel uses to save full workbooks.

The Excel Workbook (.xlsx) format preserves formulas and multiple sheets. CSV and text formats do not.

🎯 Scenario

advanced

Data loss scenario when saving as CSV

You have a sheet with dates formatted as MM/DD/YYYY and some cells with formulas. You save the file as CSV and reopen it. What problem might you see?

A Dates and formulas are preserved exactly as before.

B Dates may appear as numbers and formulas are lost.

C Only formulas are preserved, but dates are lost.

D The file will not open because CSV cannot save dates.

💡 Hint

Consider what CSV files save and how Excel handles dates.

CSV saves plain text values. Dates may convert to numbers and formulas are lost because CSV does not support formatting or formulas.

❓ data_analysis

expert

Comparing file sizes between XLSX and CSV

You have a large Excel file with 10,000 rows and 10 columns of data with formulas and formatting. You save it as XLSX and as CSV. Which statement about file sizes is true?

A CSV file is usually smaller because it saves only plain text data.

B CSV file is usually larger because it saves formulas and formatting.

C XLSX file is usually smaller because it compresses data and formatting.

D Both files have the same size because they contain the same data.

💡 Hint

Think about what data each format saves and how compression works.

CSV saves only plain text data without formulas or formatting, so it is usually smaller. XLSX files include formulas, formatting, and multiple sheets, making them larger.