Quiz : How Well Aware Are You With MS Spreadsheets?

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 Jhangen
J
Jhangen
Community Contributor
Quizzes Created: 3 | Total Attempts: 4,290
| Attempts: 4,011
SettingsSettings
Please wait...
  • 1/10 Questions

    Which formula can be used for date and time functions?

    • DATEVALUE()
    • INDEX MATCH
    • RAND()
    • VLOOKUP
Please wait...
About This Quiz

Working on MS has become an integral part of office life. Are you curious to know how well aware-you are of MS spreadsheets? Take this quiz to see if you can answer all the technical and theoretical questions in excel. All the questions given in the quiz are in MCQ format & you are expected to choose the correct option. Your score will be reflected after you've attempted all the questions in the quiz. We challenge you a get a high score. We are sure that you'll love it! All the best!

Quiz : How Well Aware Are You With MS Spreadsheets? - Quiz

Quiz Preview

  • 2. 

    How does an Excel spreadsheet know that =10/12 is a formula and not the date October 12?

    • The equal sign (=) signals it.

    • The division (/) sign signals it.

    • Dates cannot be shown that way.

    • It would not know.

    Correct Answer
    A. The equal sign (=) signals it.
    Explanation
    The equal sign (=) is used to indicate that a formula is being entered in an Excel spreadsheet. This is a convention established by Excel to differentiate formulas from other types of data. Therefore, when Excel encounters the equal sign followed by numbers or mathematical operators like division (/), it recognizes it as a formula and performs the calculation accordingly.

    Rate this question:

  • 3. 

    All changes to value, labels, or formulas in a spreadsheet are made in the

    • Formula bar.

    • Cell.

    • Frame.

    • Function line.

    Correct Answer
    A. Formula bar.
    Explanation
    In a spreadsheet, the formula bar is where you can make changes to the value, labels, or formulas of a cell. It is a designated area where you can input or edit the content of a cell. This allows you to easily modify the data within the cell without directly altering the cell itself. The formula bar provides a convenient and organized way to manage and update the information in a spreadsheet.

    Rate this question:

  • 4. 

    Operations are carried out in the following order:

    • A - D - E - M - P - S

    • M - D - E - P - S - A

    • P - M - D - A - S - E

    • P - E - M - D - A - S

    Correct Answer
    A. P - E - M - D - A - S
    Explanation
    The given operations are carried out in a specific order: A, D, E, M, P, S. The correct answer is P - E - M - D - A - S, which means that the operations are performed in the order of P, E, M, D, A, S.

    Rate this question:

  • 5. 

    Tables in spreadsheets are better than tables in word processors because they

    • Use numbers only.

    • Will have unchanging formats.

    • Can be easily updated.

    • Have accurate data.

    Correct Answer
    A. Can be easily updated.
    Explanation
    Tables in spreadsheets can be easily updated because spreadsheets are designed to handle numerical data and perform calculations. Unlike word processors, spreadsheets provide built-in functions and formulas that allow users to manipulate and update data effortlessly. Additionally, spreadsheets offer features like sorting, filtering, and conditional formatting, which make it easier to organize and update data in a table format. This flexibility and functionality make tables in spreadsheets a preferred choice for managing and updating data compared to tables in word processors.

    Rate this question:

  • 6. 

    How is the pivot table used in Ms Excel?

    • To delete a large set of data

    • To summarize a large data set

    • To add new tabular data

    • None of the above

    Correct Answer
    A. To summarize a large data set
    Explanation
    The pivot table in MS Excel is used to summarize a large data set. It allows users to analyze and condense extensive amounts of data into a more manageable and organized format. With a pivot table, users can easily group and categorize data, calculate totals and averages, and generate meaningful insights from the data. It is a powerful tool for data analysis and reporting purposes.

    Rate this question:

  • 7. 

    What are the two essential macro languages used in Ms. Excel?

    • Tally and C#

    • ZNM and oracle 

    • XLM and VBA (Visual Basic Applications)

    • None of the above

    Correct Answer
    A. XLM and VBA (Visual Basic Applications)
    Explanation
    XLM (Excel Macro Language) and VBA (Visual Basic for Applications) are the two essential macro languages used in Ms. Excel. XLM is an older macro language that was used in earlier versions of Excel, while VBA is a more modern and powerful macro language that is widely used in current versions of Excel. These macro languages allow users to automate tasks, create custom functions, and enhance the functionality of Excel.

    Rate this question:

  • 8. 

    Values, by default, are aligned

    • To the left.

    • To the right.

    • Centered in the cell.

    • At the top of the cell.

    Correct Answer
    A. To the right.
    Explanation
    By default, values in a cell are aligned to the right. This means that the numbers or text will be positioned towards the right side of the cell. This alignment is commonly used for numerical data or when the text is expected to be read from left to right.

    Rate this question:

  • 9. 

    It is best to write formulas using cell references so that a spreadsheet

    • Has no hidden information.

    • Has all correct values.

    • Can be updated easily.

    • Can be more easily graphed.

    Correct Answer
    A. Can be updated easily.
    Explanation
    Writing formulas using cell references allows for easy updating of a spreadsheet because if the values in the referenced cells change, the formulas automatically recalculate based on the new values. This eliminates the need to manually update each formula whenever there is a change in the underlying data. By using cell references, the spreadsheet can be easily modified and maintained, ensuring accuracy and efficiency in data analysis and calculations.

    Rate this question:

  • 10. 

    What are the two reports formats used in Excel?

    • Landscape and A4

    • Horizontal and Vertical

    • Still and Moving

    • Tabular and Compact

    Correct Answer
    A. Tabular and Compact
    Explanation
    The two report formats used in Excel are tabular and compact. Tabular format refers to organizing data in rows and columns, making it easier to analyze and compare information. Compact format, on the other hand, refers to condensing the data to fit more information in a smaller space, usually by using smaller fonts or eliminating unnecessary elements. These formats help users present and view data in a clear and concise manner.

    Rate this question:

Quiz Review Timeline (Updated): Jan 31, 2023 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Jan 31, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Oct 23, 2009
    Quiz Created by
    Jhangen
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.