facebook twitter pinterest google plus Youtube
www.TestsTestsTests.com

www.TestsTestsTests.com

Excel Ribbon & Quick Access Toolbar Test – Excel Test 2016 – Learn Excel Basics – Free Online Microsoft Excel Quiz

Excel Ribbon & Quick Access Toolbar Test
Excel Test 2016 – Learn Excel Basics

Free Online Microsoft Excel Quiz

* What is the Ribbon in Excel 2016?
* Show Ribbon in Excel – Hide Ribbon in Excel 2016
* How to find Excel Functions on the Ribbon in Excel 2016
* Contextual tabs that disappear
* Quick Access Toolbar Excel 2016 – The shortcut menu or QAT
* Adding buttons to the Quick Access Toolbar Excel 2016

10 Question Multiple Choice Quiz with Answers and Answer Explanations

***GO TO THE TEST ANSWER EXPLANATIONS PAGE

  Excel Ribbon & Quick Access Toolbar Test

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.




* More from TestsTestsTests.com