Saving Excel Files

Question 1

How many different formats can Excel spreadsheets be saved in?

Answer 1

27 different formats. Most of these are for backward compatibility and not often used.

Question 2

What is the primary format used for Excel 2007 and later?

Answer 2

Xlsx (These files are safer than xlsm files because they do not contain macros or programming code).

Question 3

What is the format for Macro-Enabled Excel files?

Answer 3

Xlsm

Question 4

When should you use the Xlsm format?

Answer 4

Only if you’re saving a file that already contains macros and you want to preserve the macro format.

Question 5

What format can be created from Excel’s Save As dialog box?

Answer 5

.pdf

Question 6

What is the purpose of the Browse button in Excel?

Answer 6

To display a traditional Save As dialog box

Question 7

In which version of Excel does the traditional Save As dialog box appear after step 2?

Answer 7

Excel 2010 and later

Question 8

What are Macros?

Answer 8

Programming code that can automate various tasks. Macros can also be used maliciously.

Question 9

xls files

Answer 9

compatible with excel 2003 and earlier. can open them in any version of excel but downside is that certain functions will not be available.

Question 10

Can PDF files be opened back into excel?

Answer 10

No. Its and “one way trip out”. PDF are for sharing a spreadsheet for viewing only.