Microsoft Excel 2016 Test
-
What is the ribbon in excel 2016?
-
A tab where you create new project
-
A tab which saves project automatically
-
It contain multiple tabs with several group of commands which performs most common tasks
-
A tab of multiple colors which helps apply colors to texts
-
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.
(144).jpg "Microsoft Excel 2016 Test - Quiz")
Quiz Preview
- 2.
Can additional tabs be possibly added to the ribbons?
-
Yes
-
No
-
Not sure
-
Undetermined
Correct Answer
A. YesExplanation
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.
What is the function of the Tell-me box?
-
Suggests design
-
Saving documents
-
For encrypting the documents
-
Functions as a searc box
Correct Answer
A. Functions as a searc boxExplanation
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:
-
- 4.
What cloud service does the excel 2016 implements?
-
Cloud drive
-
4shared
-
Google drive
-
One drive
Correct Answer
A. One driveExplanation
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:
-
- 5.
Backstage views do not include which of these options?
-
Encrypt
-
Printing
-
Saving
-
Sharing
Correct Answer
A. EncryptExplanation
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:
-
- 6.
This is not a type of Worksheet views
-
Normal view
-
Page layout View
-
Page break view
-
Page extended viee
Correct Answer
A. Page extended vieeExplanation
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:
-
- 7.
You can see people's edits highlighted and marked by a
-
A red mark
-
Green Dot
-
Flag
-
A cycle
Correct Answer
A. FlagExplanation
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:
-
- 8.
What feature can help create a chart future plot based on historical data?
-
Flash Fill
-
Forecast
-
Excel future
-
Excel Forcast
Correct Answer
A. ForecastExplanation
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:
-
- 9.
What position of the MS excel 2016 window can you find the buttons responsible for the changing of worksheet views?
-
Top Right
-
Botom Left
-
Top Left
-
Bottom Right
Correct Answer
A. Bottom RightExplanation
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:
-
- 10.
MS Excel includes these chart types except?
-
Starlight
-
Pareto
-
Sunburst
-
Waterfall
Correct Answer
A. StarlightExplanation
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:
-
Quiz Review Timeline (Updated): Mar 22, 2023 +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 22, 2023Quiz Edited by
ProProfs Editorial Team -
Mar 08, 2018Quiz Created by
Timmy198