Microsoft Excel Quiz: Test On Functions!

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 Mcqquestions
M
Mcqquestions
Community Contributor
Quizzes Created: 23 | Total Attempts: 626,307
| Attempts: 65,587
SettingsSettings
Please wait...
  • 1/10 Questions

    In EXCEL, you can sum a large range of data by simply selecting a tool button called …..

    • AutoFill
    • Auto correct
    • Auto sum
    • Auto format
Please wait...
About This Quiz

Microsoft excel quiz: test on functions! Microsoft Excel is considered to be one of the most diverse Microsoft office tools as it not only allows calculations but can also allow processing of different sets of data. Are you confident in your ability to carry out different tasks with this tool? How about you take this quiz and see how true that is and which aspects of excel you may have forgotten!

Microsoft Excel Quiz: Test On Functions! - Quiz

Quiz Preview

  • 2. 

    Microsoft Excel is powerful………..

    • Word processing package

    • Spreadsheet package

    • Communication S/W Package

    • DBMS package

    Correct Answer
    A. Spreadsheet package
    Explanation
    Microsoft Excel is a spreadsheet package. It is a powerful tool that allows users to create, organize, and analyze data in a tabular format. Excel provides various features such as formulas, functions, charts, and graphs, which make it suitable for tasks related to data management, calculations, and data visualization. It is widely used for financial analysis, budgeting, data tracking, and creating reports. Therefore, the given answer, "Spreadsheet package," accurately describes Microsoft Excel's functionality and purpose.

    Rate this question:

  • 3. 

    How do you rearrange the data in ascending or descending order?

    • Data, Sort

    • Data, Form

    • Data, Table

    • Data Subtotals

    Correct Answer
    A. Data, Sort
    Explanation
    To rearrange data in ascending or descending order, you can use the "Data, Sort" function. This feature allows you to organize your data based on specific criteria, such as alphabetical order, numerical value, or date. By selecting the "Data, Sort" option, you can easily arrange your data in either ascending or descending order, making it more organized and easier to analyze.

    Rate this question:

  • 4. 

    Which function is not available in the Consolidate dialog box?

    • Pmt

    • Average

    • Max

    • Sum

    Correct Answer
    A. Pmt
    Explanation
    The function "Pmt" is not available in the Consolidate dialog box. The Consolidate dialog box is used to combine data from multiple ranges into a single range. It allows users to perform calculations such as averaging, finding the maximum value, and summing the values. However, the "Pmt" function, which is used to calculate the payment for a loan or investment, is not available in this dialog box.

    Rate this question:

  • 5. 

    MS-EXCEL is based on ……….

    • WINDOWS

    • DOS

    • UNIX

    • OS/2

    Correct Answer
    A. WINDOWS
    Explanation
    MS-EXCEL is based on WINDOWS operating system. This is because Microsoft Excel is a spreadsheet software developed by Microsoft, and it is designed to run on the Windows operating system. Windows provides the platform and environment for Excel to function and perform its tasks effectively.

    Rate this question:

  • 6. 

    To select an entire column in MS-EXCEL, press?

    • CTRL + C

    • CTRL + Arrow key

    • CTRL + S

    • None of the above

    Correct Answer
    A. None of the above
    Explanation
    To select an entire column in MS-EXCEL, you can press CTRL + Spacebar. This keyboard shortcut allows you to select the entire column where the active cell is located. CTRL + C is used to copy, CTRL + Arrow key is used to navigate to the last cell in a column or row, and CTRL + S is used to save the workbook. None of these options are used to select an entire column.

    Rate this question:

  • 7. 

    An Excel Workbook is a collection of …….

    • Workbooks

    • Worksheets

    • Charts

    • Worksheets and Charts

    Correct Answer
    A. Worksheets and Charts
    Explanation
    An Excel Workbook is a collection of worksheets and charts. In Excel, a workbook is a file that can contain multiple worksheets, which are used to organize and manipulate data. Worksheets are the primary tool for entering, calculating, and analyzing data in Excel. Charts, on the other hand, are graphical representations of data that provide a visual representation of the information in the worksheets. By including both worksheets and charts, an Excel Workbook allows users to store and present data in a comprehensive and visually appealing manner.

    Rate this question:

  • 8. 

    Which is not the function of the “Edit, Clear” command?

    • Delete contents

    • Delete notes

    • Delete cells

    • Delete formats

    Correct Answer
    A. Delete cells
    Explanation
    The "Edit, Clear" command is used to delete various elements in a document, such as contents, notes, and formats. However, it does not have the function to delete cells. This means that when using the "Edit, Clear" command, the user cannot delete entire cells from the document.

    Rate this question:

  • 9. 

    What do you mean by a Workspace?

    • Group of Columns

    • Group of Worksheets

    • Group of Rows

    • Group of Workbooks

    Correct Answer
    A. Group of Workbooks
    Explanation
    A workspace refers to a group of workbooks. It is a collection of multiple workbooks that are related to each other and can be opened and worked on simultaneously. Workspaces are useful when dealing with multiple files or projects that need to be organized and accessed together. They allow users to switch between different workbooks easily without having to open and close them individually. By grouping workbooks together in a workspace, it becomes more efficient and convenient to manage and navigate through multiple files simultaneously.

    Rate this question:

  • 10. 

    To return the remainder after a number is divided by a divisor in EXCEL we use the function?

    • ROUND ( )

    • FACT ( )

    • MOD ( )

    • DIV ( )

    Correct Answer
    A. MOD ( )
    Explanation
    The MOD() function in Excel is used to return the remainder after a number is divided by a divisor. This function takes two arguments, the number to be divided and the divisor, and returns the remainder as the result. Therefore, MOD() is the correct function to use in this scenario.

    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
  • Oct 24, 2010
    Quiz Created by
    Mcqquestions
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.