facebook twitter pinterest google plus Youtube
www.TestsTestsTests.com

www.TestsTestsTests.com

The different parts of the Excel Screen Test
Excel 2016 - Learn Excel Basics Test

Free Online Microsoft Excel Tests

* How does the Excel Ribbon work?
* QAT - Quick Access Toolbar options
* Rows and columns in a worksheet
* Worksheet tabs in a workbook
* The Name Box and Formula Bar


10 Question Multiple Choice Quiz with Answers and Answer Explanations


The different parts of the Excel Screen Test

Question 1 - The different parts of the Excel Screen Test - Excel 2016
1) Study the screenshot above. What is the function of the small triangle circled in yellow?

a) It is the show and hide button for the Excel 2016 Ribbon.
b) It is the dialog box launcher for the Excel Font group.
c) It is the Formula Bar expander in Excel.
d) None of the options listed above are correct.


Question 2 - The different parts of the Excel Screen Test - Excel 2016

2) Study the screenshot above.  What is the name and purpose of the section outlined in yellow?
a) This is the Name Box, which displays the names of all the Excel functions used on the Ribbon.
b) This is the File Menu, which displays all the functions relating to saving, opening and closing a workbook.
c) This is the Quick Access Toolbar, which contains shortcuts to Excel functions.
d) This is the Save Menu List, which provides quick access only to very basic Excel functions.

Question 3 - The different parts of the Excel Screen Test - Excel 2016

3) Study the screenshot above.  What are the areas outlined in yellow and numbered 1 and 2, respectively, called?
a) These are the Excel Formula Bar addresses.
b) These are the Excel Ribbon function groups.
c) These are the Excel column and row labels.
d) All the above options are incorrect.


Question 4 - The different parts of the Excel Screen Test - Excel 2016
4) Looking at the screenshot above, can you identify the cell address for the cell boxed in yellow with a question mark icon?
a) The Excel cell address for this cell is D6. 
b) The Excel cell address for this cell is D18.
c) The Excel cell address for this cell is 6D.
d) The Excel cell address for this cell is D.



Question 5 - The different parts of the Excel Screen Test - Excel 2016

5) What is the name of the area outlined in yellow in the screenshot above?
a) It is called the Excel Name Box.
b) It is called the Excel Ribbon.
c) It is called the Excel Column Title.
d) It is called the Excel Formula Bar.


Question 6 - The different parts of the Excel Screen Test - Excel 2016
6) In the screenshot above, what is the section in the yellow box called?
a) These are the Excel Workbook tabs.
b) These are the Excel Worksheet tabs.
c) These are the Excel Workbook and Worksheet tabs.
d) These are the Excel Month Tabs.


Question 7 - The different parts of the Excel Screen Test - Excel 2016
7) In the screenshot above, what part of the Excel screen is outlined in the yellow box?
a) This is the entire Excel Ribbon.
b) This is the Excel Quick Access Toolbar.
c) These are Ribbon tabs, which are an integral part of the Excel Ribbon.
d) These are the Excel Worksheet tabs.


Question 8 - The different parts of the Excel Screen Test - Excel 2016
8) The Excel Ribbon is carefully organized according to function types.  Study the screenshot above and select a description which best describes the area outlined in the yellow box.
a) This is the Font and Text group.
b) This is the Alignment group.
c) This is the Wrap Text group.
d) This is the Home Tab group.



Question 9 - The different parts of the Excel Screen Test - Excel 2016

9) Study the screenshot above.  What is the area highlighted in the yellow box called?
a) This is the Excel Formula Bar.
b) This is the Excel Row address.
c) This is the Excel Column address.
d) This is the Excel Name Box.

10) Which of the following are tabs you will find on the Excel Ribbon?
a) The Home tab, the Page Layout tab, the Data tab and the View tab.
b) The Home tab, the Formulas tab and the Developer tab.
c) The Insert tab, the Page Layout tab and the Formulas tab.
d) All the options listed above are tabs on the Excel 2016 Ribbon.