Microsoft Excel 2016 Test

Approved & Edited by ProProfs Editorial Team

The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.

Learn about Our Editorial Process

| By Timmy198

Timmy198

Community Contributor

Quizzes Created: 577 | Total Attempts: 302,656

Questions: 10 | Attempts: 5,222 | Updated: Mar 22, 2023

Questions

Settings

Create your own Quiz

Share on Facebook Share on Twitter Share on Whatsapp Share on Pinterest Share on Email Copy to Clipboard Embed on your website

Comparing Excel 2016 with 2013 and 2010, you might still come to notice quite a similarity and a little bit of familiarity. Nonetheless, working on the excel 2016 brings you up to a whole new interface and a smoother mode of operation, unlike its predecessors. What do you know about Excel 2016? Here you have a short quiz.

Questions and Answers

1.

What cloud service does the excel 2016 implements?
- A.
  
  Cloud drive
- B.
  
  4shared
- C.
  
  Google drive
- D.
  
  One drive
Correct Answer
D. One drive

Explanation
Excel 2016 implements OneDrive as its cloud service. OneDrive is a file hosting and synchronization service provided by Microsoft. It allows users to store and share files in the cloud, making them accessible from any device with an internet connection. With OneDrive integration, Excel 2016 users can save their spreadsheets to the cloud, collaborate with others in real-time, and easily access their files from different devices.

Rate this question:

1
0
2.

You can see people's edits highlighted and marked by a
- A.
  
  A red mark
- B.
  
  Green Dot
- C.
  
  Flag
- D.
  
  A cycle
Correct Answer
C. Flag

Explanation
The correct answer is "Flag" because it is the only option listed that represents a symbol used to mark or indicate something. In this context, a flag is commonly used to highlight or draw attention to edits made by people. The other options (red mark, green dot, and a cycle) do not typically serve this purpose.

Rate this question:

1
0
3.

What is the function of the Tell-me box?
- A.
  
  Suggests design
- B.
  
  Saving documents
- C.
  
  For encrypting the documents
- D.
  
  Functions as a searc box
Correct Answer
D. Functions as a searc box

Explanation
The Tell-me box functions as a search box. It allows users to easily search for specific features, commands, or options within a software program or application. By typing in keywords or phrases, users can quickly find the desired functionality without having to navigate through menus or options. This feature enhances user efficiency and productivity by providing a convenient and intuitive search tool within the software interface.

Rate this question:

1
1
4.

What feature can help create a chart future plot based on historical data?
- A.
  
  Flash Fill
- B.
  
  Forecast
- C.
  
  Excel future
- D.
  
  Excel Forcast
Correct Answer
B. Forecast

Explanation
Forecast is the correct answer because it is a feature that can help create a chart future plot based on historical data. With the forecast feature in Excel, users can analyze historical data and predict future trends, allowing them to make informed decisions and plan accordingly. This feature uses statistical algorithms to analyze the data and generate accurate forecasts, making it a valuable tool for businesses and individuals who need to make predictions based on historical data.

Rate this question:
5.

MS Excel includes these chart types except?
- A.
  
  Starlight
- B.
  
  Pareto
- C.
  
  Sunburst
- D.
  
  Waterfall
Correct Answer
A. Starlight

Explanation
MS Excel includes various chart types such as Pareto, Sunburst, and Waterfall. However, "Starlight" is not a recognized chart type in MS Excel.

Rate this question:

1
0
6.

What is the ribbon in excel 2016?
- A.
  
  A tab where you create new project
- B.
  
  A tab which saves project automatically
- C.
  
  It contain multiple tabs with several group of commands which performs most common tasks
- D.
  
  A tab of multiple colors which helps apply colors to texts
Correct Answer
C. It contain multiple tabs with several group of commands which performs most common tasks

Explanation
The ribbon in Excel 2016 is a tab that contains multiple tabs with several groups of commands which perform the most common tasks. This means that the ribbon provides a user-friendly interface where users can easily access various commands and tools to perform tasks such as formatting, data manipulation, and analysis in Excel. The ribbon organizes these commands into logical groups, making it easier for users to find and use the tools they need.

Rate this question:
7.

Can additional tabs be possibly added to the ribbons?
- A.
  
  Yes
- B.
  
  No
- C.
  
  Not sure
- D.
  
  Undetermined
Correct Answer
A. Yes

Explanation
Additional tabs can be added to the ribbons. This implies that the user has the ability to customize and add more tabs to the existing ribbons in order to suit their specific needs or preferences.

Rate this question:

3
0
8.

What position of the MS excel 2016 window can you find the buttons responsible for the changing of worksheet views?
- A.
  
  Top Right
- B.
  
  Botom Left
- C.
  
  Top Left
- D.
  
  Bottom Right
Correct Answer
D. Bottom Right

Explanation
In MS Excel 2016, the buttons responsible for changing worksheet views can be found in the bottom right position of the window. This is where the "Normal view," "Page Layout view," and "Page Break Preview" buttons are located. By clicking on these buttons, users can easily switch between different views to suit their needs and preferences.

Rate this question:

2
0
9.

This is not a type of Worksheet views
- A.
  
  Normal view
- B.
  
  Page layout View
- C.
  
  Page break view
- D.
  
  Page extended viee
Correct Answer
D. Page extended viee

Explanation
The given answer, "Page extended view," is not a valid option among the listed Worksheet views. The correct options for Worksheet views are Normal view, Page layout view, and Page break view. Therefore, "Page extended view" is not a type of Worksheet view.

Rate this question:

2
1
10.

Backstage views do not include which of these options?
- A.
  
  Encrypt
- B.
  
  Printing
- C.
  
  Saving
- D.
  
  Sharing
Correct Answer
A. Encrypt

Explanation
Backstage views in a software application typically provide access to various file management options. These options may include printing, saving, and sharing files. However, encrypting files is not typically included in backstage views. Encryption is a security feature that allows users to protect their files by converting them into a coded format, making them unreadable to unauthorized individuals. Since encrypting files is not a file management option, it is not included in backstage views.

Rate this question:

1
0