MIDTERM EXAM OP1

What does the "Save As" option allow you to do in the File tab?

• Save a copy of the workbook in a different location or format.

• Close the workbook without saving.

• Export the workbook as a PDF.

• Print the workbook.

Which of the following formats is NOT available in the "Save As" dialog box?

• .xlsx

• .csv

• .pdf

• .exe

What is the shortcut key to open the File tab in Excel?

• Ctrl + P

• Alt + F

• Ctrl + S

• Ctrl + O

Which command in the File tab would you use to create a new blank workbook?

• Open

• Save

• New

• Close

What does the "Print" option in the File tab allow you to do?

• Save the workbook to OneDrive.

• Adjust print settings and print the workbook.

• Email the workbook to a colleague.

• Convert the workbook to PDF.

Which of the following is available in the Info section of the File tab?

• Recent documents

• Workbook properties and protection options

• Document templates

• Workbook statistics

Which option in the File tab allows you to share a workbook with others?

• Save As

• Export

• Share

• Close

What does the "Close" option in the File tab do?

• Exits Excel.

• Saves the current workbook.

• Closes the current workbook without exiting Excel.

• Creates a new workbook.

In which section of the File tab can you protect a workbook with a password?

• Save As

• Info

• Print

• Export

Which of the following can be found in the "Recent" section under the File tab?

• Recent templates

• Recently opened workbooks

• Workbook history

• System settings