CSV and file types: Excel Quiz

5 quick questions. Pick an answer to see if you are right.

You save a workbook with 3 sheets as CSV. How many sheets are saved?
- A. 3
- B. 0
- C. 1
- D. 2
Show the answer
C — 1. A CSV keeps only the sheet you are on.
A1 has =B1*2 and shows 20. You save as CSV and open the file again. What is in A1?
- A. The formula =B1*2
- B. 0
- C. The number 20
- D. An error
Show the answer
C — The number 20. A CSV keeps the results, not the formulas.
A CSV file has 00123 in it. You open it in Excel. What does the cell show?
- A. An error
- B. 00123
- C. 0
- D. 123
Show the answer
D — 123. Excel reads it as a number and drops the zeros at the front.
Your workbook has macros. Which file type keeps them?
- A. .xlsm
- B. .csv
- C. .txt
- D. .xlsx
Show the answer
A — .xlsm. Save as .xlsm. A normal .xlsx file removes the macros.
You press F12 in Excel. What opens?
- A. Print
- B. Help
- C. Save As
- D. Find
Show the answer
C — Save As. F12 opens Save As, where you pick the file type.