Microsoft Excel Quiz MCQ 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 Mcqquestions
M
Mcqquestions
Community Contributor
Quizzes Created: 23 | Total Attempts: 616,153
Questions: 10 | Attempts: 47,143

SettingsSettingsSettings
Microsoft Excel Quiz MCQ Test! - Quiz

Do you want to become familiar with Microsoft Excel? Do you think you can pass this quiz? Microsoft Excel helps to organize information in an easy to navigate way. It does complicated math problems so that you don’t have to. It creates, builds, and edits pixelated images, and it also helps you organize data into helpful graphics and charts. If you want to learn more about Microsoft Excel, look no further than this quiz.


Questions and Answers
  • 1. 

    Which language is used to create macros in Excel?

    • A.

      Visual Basic

    • B.

      C

    • C.

      Visual C++

    • D.

      Java

    Correct Answer
    A. Visual Basic
    Explanation
    Visual Basic is the language used to create macros in Excel. It is a programming language developed by Microsoft and is specifically designed for creating applications and automating tasks in Microsoft Office, including Excel. Visual Basic for Applications (VBA) is the version of Visual Basic used in Excel, allowing users to write and run macros to automate repetitive tasks, perform calculations, and manipulate data in Excel spreadsheets.

    Rate this question:

  • 2. 

    Which of the following is not a term of MS-Excel?

    • A.

      Cells

    • B.

      Rows

    • C.

      Columns

    • D.

      Document

    Correct Answer
    D. Document
    Explanation
    The term "Document" is not a term of MS-Excel. MS-Excel is a spreadsheet program used for organizing and analyzing data. It consists of cells, rows, and columns, which are the fundamental components of a spreadsheet. However, "Document" is not a specific component or feature in MS-Excel.

    Rate this question:

  • 3. 

    How many worksheets can a workbook have?

    • A.

      3

    • B.

      8

    • C.

      255

    • D.

      None of above

    Correct Answer
    D. None of above
    Explanation
    The correct answer is none of the above because a workbook in most spreadsheet software, such as Microsoft Excel, can have more than 255 worksheets. The number of worksheets that a workbook can have is typically limited by the available memory of the computer.

    Rate this question:

  • 4. 

    Which would you choose to create a bar diagram?

    • A.

      Edit, Chart

    • B.

      Insert, Chart

    • C.

      Tools, Chart

    • D.

      Format, Chart

    Correct Answer
    B. Insert, Chart
    Explanation
    To create a bar diagram in a document, the most suitable option would be to use the "Insert, Chart" feature. This option allows the user to insert various types of charts, including a bar chart, into the document. By selecting this option, the user can easily create a bar diagram by inputting the required data and customizing the chart according to their preferences. The other options mentioned, such as "Edit, Chart," "Tools, Chart," and "Format, Chart," do not specifically indicate the ability to create a chart or diagram, making "Insert, Chart" the correct choice.

    Rate this question:

  • 5. 

    Which setting you must modify to print a worksheet using letterhead?

    • A.

      Paper

    • B.

      Margin

    • C.

      Layout

    • D.

      Orientation

    Correct Answer
    B. Margin
    Explanation
    To print a worksheet using letterhead, you must modify the margin setting. The margin setting determines the amount of space between the content of the worksheet and the edges of the paper. By adjusting the margins, you can ensure that the letterhead is properly aligned and displayed on the printed worksheet.

    Rate this question:

  • 6. 

    What do you call the chart that shows the proportions of how one or more data elements relate to another data element?

    • A.

      XY Chart

    • B.

      Line Chart

    • C.

      Pie Chart

    • D.

      Column Chart

    Correct Answer
    C. Pie Chart
    Explanation
    A pie chart is a type of chart that shows the proportions or percentages of how one or more data elements relate to another data element. It is called a pie chart because the chart resembles a pie, with each slice representing a different proportion or percentage. Each slice of the pie represents a specific category or data element, and the size of the slice corresponds to the proportion or percentage it represents. Pie charts are commonly used to visualize data in a way that is easy to understand and compare different categories or data elements.

    Rate this question:

  • 7. 

    The spelling dialog box can be involved by choosing to spell from ________ menu.

    • A.

      Insert

    • B.

      File

    • C.

      Tools

    • D.

      View

    Correct Answer
    C. Tools
    Explanation
    To access the spelling dialog box, you need to choose the "spell" option from the "tools" menu. This menu typically contains various tools and options related to editing and formatting text. By selecting the "spell" option from the "tools" menu, you can initiate the spell check process and correct any spelling errors in your document.

    Rate this question:

  • 8. 

    Which key do you press to check to spell?

    • A.

      F3

    • B.

      F5

    • C.

      F7

    • D.

      F9

    Correct Answer
    C. F7
    Explanation
    To check the spelling, you press the F7 key. This key is commonly used in word processing programs and text editors to initiate a spell check function. By pressing F7, the software will scan the document for spelling errors and provide suggestions for corrections. This feature helps ensure that the text is free from spelling mistakes and improves the overall quality and professionalism of the content.

    Rate this question:

  • 9. 

    To record a sequence of keystrokes and mouse actions to playback later we use:

    • A.

      Media Player

    • B.

      Sound Recorder

    • C.

      Calculator

    • D.

      Macro Recorder

    Correct Answer
    D. Macro Recorder
    Explanation
    A macro recorder is used to record a sequence of keystrokes and mouse actions. This allows users to automate repetitive tasks by playing back the recorded macro. It is commonly used in software testing, data entry, and other scenarios where the same sequence of actions needs to be performed multiple times. Unlike media players, sound recorders, and calculators, a macro recorder specifically focuses on recording and playing back user actions.

    Rate this question:

  • 10. 

    We can save and protect the workbook by:

    • A.

      Write Reservation Password

    • B.

      Protection Password

    • C.

      Read-only Recommended

    • D.

      Any of the above

    Correct Answer
    D. Any of the above
    Explanation
    The correct answer is "Any of the above" because all three options mentioned (Write Reservation Password, Protection Password, Read-only Recommended) can be used to save and protect the workbook. The choice depends on the specific requirements and level of security needed for the workbook.

    Rate this question:

Quiz Review Timeline +

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.