MIDTERM EXAM IN OP1

Which option in the File tab allows you to save a workbook with a new name?

• Open

• Save

• Save As

• Print

Which of the following actions can be performed using the File tab?

• Print the worksheet

• Insert a table

• Format cells

• Merge cells

The File tab allows you to:

• Insert shapes

• Create a chart

• Save a workbook

• Perform a spelling check

Which option in the File tab is used to export the workbook as a PDF?

• Print

• Share

• Export

• Open

Under which option in the File tab can you check for compatibility with earlier versions of Excel?

• Info

• Save As

• Open

• Options

To protect a workbook with a password, you can find this option under:

• Home

• File -> Info

• Insert

• View

Which option in the File tab allows you to access recent documents?

• New

• Info

• Recent

• Options

Which of the following can be found under the Info option in the File tab?

• Protect Workbook

• View Macros

• Format Cells

• Insert Table

To print a worksheet, which of the following options would you use from the File tab?

• Open

• Export

• Print

• Save As

The Options command in the File tab allows you to:

• Insert a new chart

• Change Excel's default settings

• Create a new workbook

• Apply conditional formatting