Saving and file formats (xlsx, csv) in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to save the workbook as an Excel file.

Excel

workbook.SaveAs("report.[1]")

Drag options to blanks, or click blank then click option'

Atxt

Bpdf

Cxlsx

Dcsv

Attempts:

3 left

💡 Hint

Common Mistakes

Using .csv instead of .xlsx for Excel files

Using .txt or .pdf which are not Excel formats

The .xlsx extension is used to save files in Excel's default workbook format.

2fill in blank

medium

Complete the code to save the worksheet as a CSV file.

Excel

worksheet.SaveAs("data.[1]")

Drag options to blanks, or click blank then click option'

Axlsm

Bcsv

Cxlsx

Ddocx

Attempts:

3 left

💡 Hint

Common Mistakes

Using .xlsx which is Excel's default but not CSV

Using .docx which is a Word document format

The .csv extension saves the worksheet as a comma-separated values file, which is plain text.

3fill in blank

hard

Fix the error in the code to save the file as CSV format.

Excel

workbook.SaveAs("export.[1]")

Drag options to blanks, or click blank then click option'

Acsv

Bxlsx

Cxls

Dpdf

Attempts:

3 left

💡 Hint

Common Mistakes

Using .xlsx or .xls which save Excel formats, not CSV

Using .pdf which is not a spreadsheet format

To save as CSV, the file extension must be .csv. Other extensions save in different formats.

4fill in blank

hard

Fill both blanks to save the workbook as an Excel macro-enabled file.

Excel

workbook.SaveAs("macro_file.[1]", FileFormat=[2])

Drag options to blanks, or click blank then click option'

Axlsm

Bxlsx

C52

D56

Attempts:

3 left

💡 Hint

Common Mistakes

Using .xlsx extension which does not support macros

Using wrong FileFormat code like 56 which is for .xls

The .xlsm extension is for macro-enabled Excel files. The FileFormat code 52 corresponds to this format.

5fill in blank

hard

Fill all three blanks to save the worksheet as a CSV file with UTF-8 encoding.

Excel

worksheet.SaveAs("[1].[2]", FileFormat=[3])

Drag options to blanks, or click blank then click option'

Autf8_data

Bcsv

C62

Dxlsx

Attempts:

3 left

💡 Hint

Common Mistakes

Using .xlsx extension for CSV files

Using wrong FileFormat code for UTF-8 CSV

Saving as CSV with UTF-8 encoding uses a specific FileFormat code 62. The filename can be any name, here utf8_data is used.