facebook twitter pinterest google plus Youtube
www.TestsTestsTests.com

www.TestsTestsTests.com

What’s new in Excel 2016? Excel Test
Excel 2016 Training - Getting Started in Excel 2016
Free Online Microsoft Excel Test

* Tell Me Search Box
* People Graph Add-In
* Map Chart
* Quick Analysis Tools
* Smart Lookup

10 Question Multiple Choice Quiz with Answers
and Answer Explanations

What’s new in Excel 2016 Excel Test

Question 1 - Study the screenshot above.  What is the main function of the area circled in orange? What is new in Excel 2016 Test
1) Study the screenshot above.  What is the main function of the area circled in orange?
a) It is the name of the workbook, i.e., the name the user saved it as.
b) It is a shortcut link to the Microsoft Office website, where you can use the help forums to ask questions.
c) If you click the area and type any function you are looking for, Excel will make suggestions from which you can choose.
d) It is a cell in a workbook that the user created.

Question 2 - Study the screenshot above. Which function in Excel can you use to quickly create a similar graphic? What is new in Excel 2016 Test

2) Study the screenshot above.  Which function in Excel can you use to quickly create a similar graphic?
a) Unfortunately, Excel does not provide the functionality to create this kind of graphic, but you can insert the image from another application using the Picture option.
b) You can use the Pivot Table and Pivot Graph function, located under the Insert tab in the Tables group on the Ribbon, to create the graphic.
c) You can use the Shapes function, located under the Insert tab on the Ribbon, to create the different elements of the graphic.
d) You can use the People Graph, located in the Add-Ins group under the Insert tab on the Ribbon, to create this kind of graphic.


3) Excel 2016 has a built-in function called Smart Lookup. Which of the following tasks can you use Smart Lookup for?
a) Searching the web for selected words or phrases directly from Excel.
b) Searching the web for images pertaining to selected words or phrases directly from Excel.
c) Searching the web for definitions of selected words or phrases directly from Excel.
d) All of the options listed above are correct.

4) James’ boss has asked him to chart their international sales on a world map. How can James quickly and accurately do this?
a) By using the Maps Chart, James can visually display the sales data in Excel on a world map with only a few clicks.
b) By using the Smart Lookup function, James can find an online world map to insert into Excel to display the data.
c) By using the People Graph function, James can visually display the sales data in Excel on a world map image.
d) All of the options listed above are correct.

5) What is the shortcut to access the Tell Me What You Want To Do search function in Excel?
a) Alt+S
b) Ctr+Shift+Q
c) Alt+Q
d) Ctrl+S

6) When inserting a People Graph, how do you change the default information display to reflect your data?
a) A People Graph will automatically display your selected data.
b) Click on the Data button in the top right-hand corner of the People Graph to Select Data.
c) Click on the Refresh button in the Formulas group to refresh the People Graph to show your selected data.
d) None of the options listed above are correct.


Question 7 - Study the screenshot above. What is the name of the function circled in orange? What is new in Excel 2016 Test

7) Study the screenshot above.  What is the name of the function circled in orange?

a) It is the Smart Lookup tool.
b) It is the Quick Access toolbar.
c) It is the Quick Analysis tool.
d) It is the Quick Formatting tool.

8) Which of the following tools or functions can be found on the Quick Analysis Tool?
a) Recommended charts to visually display your data.
b) Conditional formatting options that allow you to format top and bottom values, icons and data bars.
c) Totals option that quickly count, average, sum selected values in a worksheet.
d) All of the above options are available on the Quick Analysis Tool.

9) How do you copy a Map Chart into another application, for example, a Microsoft Word document or PowerPoint slide?
a) Simply copy the Map Chart in Excel and paste directly into a document or slide.
b) Take a screenshot of the Map Chart from Microsoft Word or PowerPoint.
c) Save the Map Chart as an image and then insert the image into a document or slide.
d) All of the options listed above are correct.

10) What is the easiest way of inserting a title for a People Graph?
a) Insert a textbox above the People Graph and type the required name into it.
b) Right-click the People Graph and select the Title option and type the required name into it.
c) Change the Theme of the People Graph to one that contains a title, which can then be edited.
d) Click on the Data button and type a title for the People Graph in the box provided.