Microsoft Excel 2016 Test

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Timmy198
T
Timmy198
Community Contributor
Quizzes Created: 577 | Total Attempts: 336,844
| Attempts: 5,876
SettingsSettings
Please wait...
  • 1/10 Questions

    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
Please wait...
About This Quiz

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.

Microsoft Excel 2016 Test - Quiz

Quiz Preview

  • 2. 
    Can additional tabs be possibly added to the ribbons? - ProProfs

    Can additional tabs be possibly added to the ribbons?

    • Yes

    • No

    • Not sure

    • 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. 
    What is the function of the Tell-me box? - ProProfs

    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 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:

  • 4. 
    What cloud service does the excel 2016 implements? - ProProfs

    What cloud service does the excel 2016 implements?

    • Cloud drive

    • 4shared

    • Google drive

    • One drive

    Correct Answer
    A. 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:

  • 5. 
    Backstage views do not include which of these options?  - ProProfs

    Backstage views do not include which of these options? 

    • Encrypt

    • Printing

    • Saving

    • 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:

  • 6. 
    This is not a type of  Worksheet views - ProProfs

    This is not a type of  Worksheet views

    • Normal view

    • Page layout View

    • Page break view

    • Page extended viee

    Correct Answer
    A. 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:

  • 7. 
    You can see people's edits highlighted and marked by a - ProProfs

    You can see people's edits highlighted and marked by a

    • A red mark

    • Green Dot

    • Flag

    • A cycle

    Correct Answer
    A. 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:

  • 8. 
    What feature can help create a chart future plot based on historical data? - ProProfs

    What feature can help create a chart future plot based on historical data?

    • Flash Fill

    • Forecast

    • Excel future

    • Excel Forcast

    Correct Answer
    A. 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:

  • 9. 
    What position of the MS excel 2016 window can you find the buttons responsible for the changing of worksheet views? - ProProfs

    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 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:

  • 10. 
    MS Excel includes these chart types except? - ProProfs

    MS Excel includes these chart types except?

    • Starlight

    • Pareto

    • Sunburst

    • 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:

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, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Mar 08, 2018
    Quiz Created by
    Timmy198
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.