facebook twitter pinterest google plus Youtube
www.TestsTestsTests.com

www.TestsTestsTests.com

The Ribbon & QAT (Quick Access Toolbar) Test
Excel 2016 Training - Getting Started in Excel 2016
Free Online Microsoft Excel Test

* What exactly is the Excel 2016 Ribbon?
* Showing and hiding the Ribbon
* How to find functions on the Ribbon
* Contextual tabs that disappear
* The shortcut menu or QAT - Quick Access Toolbar
* Adding buttons to the QAT

10 Question Multiple Choice Quiz with Answers
and Answer Explanations

The Ribbon & QAT (Quick Access Toolbar) Excel Test


1) Study your copy of Excel 2016. Which of the following options represent an accurate list of default tabs you will find on the Excel Ribbon?
a) Home, Delete, Insert, Page Design, Formulas, Review
b) Home, Insert, Page Layout, Spell Check, Formulas, View
c) Home, Insert, Page Layout, Formulas, Data, Review, View
d) Home, Save, Insert, Page Layout, Design, Mailings, Formulas, Data, Review, View


Question 2 - The Ribbon and Quick Access Toolbar - Excel 2016 Test
2) Study the screenshot above. Under which tab on the Ribbon do you expect to find these groups and command buttons?
a) Under the Page Layout tab.
b) Under the Format tab.
c) Under the Data tab.
d) Under the Home tab.

Question 3 - The Ribbon and Quick Access Toolbar - Excel 2016 Test
3) Study the screenshot above. Whilst working on the above worksheet, the Ribbon, tabs and all the command buttons disappeared. What happened and how can it be fixed?
a) The Ribbon has been hidden. Hold down the Ctrl key and press F1 (i.e. Ctrl+F1) to display it again.
b) The Excel worksheet has been zoomed into, zoom out to see the Ribbon again.
c) The current Excel sheet does not have any content that can be edited, therefore the Ribbon doesn’t display.
d) No data is selected in the current worksheet, select data to redisplay the Ribbon.




Question 4 - The Ribbon and Quick Access Toolbar - Excel 2016 Test
4) Study the screenshot above. What is the purpose of the icon outlined in orange?
a) This icon allows you to resize the Ribbon.
b) This icon launches a dialog box with more options relating to the Alignment group.
c) This icon hides the Ribbon.
d) This icon hides the Commands area of the Ribbon.


Question 5 - The Ribbon and Quick Access Toolbar - Excel 2016 Test
5) Study the screenshot above. What are the type of tabs circled in orange called and what is so special about them?
a) These are called contextual tabs as they only appear when a specific type of content, such as images and tables, are selected.
b) These are image formatting tabs that allow you to use applications such as Adobe Photoshop with Excel.
c) These are Ribbon editing tabs that allow you to edit which tabs are added to the Ribbon.
d) These are Tab expanders that appear when a specific tab is selected, such as View and Insert.


 

Question 6 - The Ribbon and Quick Access Toolbar - Excel 2016 Test

6) Study the screenshot above. What is this area of the Excel 2016 screen called?

a) This is called the File Saving Ribbon.
b) This is called the Saving Options List.
c) This is called the Quick Access Toolbar.
d) This is called the Ribbon tab.

 

7) How can you move the Quick Access Toolbar to display below the Ribbon?

a) Drag and drop it to the desired position below the Ribbon.
b) Click on Customize the Quick Access Toolbar and select Show Below the Ribbon from the list.
c) Use the shortcut key combination Ctrl+F1 to display it below the Ribbon.
d) All of the options listed below are correct.



8) Under which tab on the Excel 2016 Ribbon will you find the Spelling checker option?
a) Under the Data tab.
b) Under the View tab.
c) Under the Formulas tab.
d) Under the Review tab.



9) How can you quickly search Excel for a specific command?
a) Use the Find function located in the Editing group under the Home tab to find a specific command.
b) Use the Tell Me What You Want To Do box on the Ribbon to find a specific command.
c) Use the shortcut key combination CTRL to search for a specific command.
d) All of the options listed above are correct.



10) Study the Ribbon in your version of Excel 2016. Under which tab on the Ribbon will you find options to select and insert charts into your worksheet?
a) Under the Data tab.
b) Under the Page Layout tab.
c) Under the View tab.
d) Under the Insert tab.