facebook twitter pinterest google plus Youtube
www.TestsTestsTests.com

www.TestsTestsTests.com

The File Tab and Backstage View Test
Excel 2016 Test - Learn Excel Basics

Free Online Microsoft Excel Tests

* The areas of the Backstage View
* Open existing workbooks
* Create new workbooks
* Save workbooks (and recover unsaved ones)
* Create PDF copies of worksheets to share


The File Tab and Backstage View Test - Excel 2016


1) If you click on the File button in an open Excel workbook, which of the following options will be available for selection?

a) Saving and printing an Excel workbook.
b) Exporting an Excel worksheet to a PDF document.
c) Accessing Excel’s online library of templates.
d) All the options listed above are correct.


Question 2 - The File Tab and Backstage View Test - Excel 2016 Test - Learn Excel Basics
2) Study the screenshot above.  What is the purpose of the drawing pin shaped icons in the area numbered 4?
a) These denote that the workbooks have been attached to the Recent view and will always appear at the top of this list.
b) These are information icons that when clicked, provide more details about each workbook in the list.
c) These are workbook opening icons, click the pin icon to open the workbook in the Backstage view.
d) These are workbook location icons, the pin, when clicked, will show where the workbook is saved.

Question 3 - The File Tab and Backstage View Test - Excel 2016 Test - Learn Excel Basics

3) Study the screenshot above. What do the labelled images in the area outlined in orange and labelled 2 represent?
a) These are workbooks the user has saved.  Click on an icon to open one of these workbooks.
b) This is the Recent view.  Click on an icon to open one of these recently used workbooks.
c) This is the Excel Template gallery.  Click on an icon to open one of these workbooks.
d) None of the options listed above are correct.

4) What is the shortcut key combination for saving a workbook you are currently working on?
a) Shift+S
b) Ctrl+S
c) Ctrl+N
d) Ctrl+Alt+A



Question 5 - The File Tab and Backstage View Test - Excel 2016 Test - Learn Excel Basics

5) Study the screenshot above.  What is the purpose of the Create PDF/XPS Document buttons labelled 2 and 3?
a) It is to save an Excel worksheet to a format that can be opened by Adobe PDF.
b) It allows a worksheet to be opened in a read-only format in a browser.
c) It is to save an Excel worksheet so that it can be opened by people who don’t have Excel.
d) All the options listed above are correct.


6) What is the purpose of the shortcut key combination: Ctrl+N?
a) It navigates to the next open worksheet.
b) It navigates to the next open workbook.
c) It opens a new workbook.
d) It opens the Save As dialog box.


7) How can you recover a workbook you did not save?
a) Go to Info in the Backstage view, click on Manage Workbook and select Recover Unsaved Workbooks to find and restore it.
b) Go to Open in the Backstage View, click on Recover Unsaved Workbooks to find and restore it.
c) Go to Open in the Backstage View, open your computer hard drive folder browser and navigate to a folder called \AppData\Local\Microsoft\Office\UnsavedFiles, to find and restore it.
d) All the options listed above are correct.


8) Where can I find a setting to change how often my workbook is saved automatically, for example, to every 5 minutes?
a) In the Excel Options dialog box, under Save Options.
b) In the Excel Options dialog box, under Advanced Options.
c) By using the Ctr+S shortcut key combination and timing it every five minutes.
d) There is unfortunately no option to automatically save an Excel workbook every five minutes.



9) Which of the following shortcut key combinations will almost always launch the Backstage view?
a) Ctrl+O (the letter not number) and Ctrl+P
b) Ctrl+N and Ctrl+W.
c) Ctrl+B and Ctrl+S
d) All the options listed above are correct.

Question 10 - The File Tab and Backstage View Test - Excel 2016 Test - Learn Excel Basics

10) Study the screenshot above.  By clicking which of the labelled numbered areas can you exit the Backstage view and return to the active worksheet?
a) By clicking the Back Arrow labelled 1.
b) By clicking the Open tab labelled 2.
c) By clicking the Close button labelled 3.
d) All the options listed above are correct.