The Microsoft Excel 2010 Quiz! Trivia

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 SamGl
S
SamGl
Community Contributor
Quizzes Created: 1 | Total Attempts: 2,036
| Attempts: 2,036
SettingsSettings
Please wait...
  • 1/10 Questions

    What appears in a cell when a column is not wide enough for its numerical contents?

    • ??????????
    • ##########
    • >>>>>>>>>>
    • !!!!!!!!!!
Please wait...
About This Quiz


Are you ready to test your Microsoft Excel 2010 knowledge? There is so much that one can do when they understand how to use spreadsheets correctly. Is it possible to have a header and footer on a spreadsheet, and what is the right way of writing formulas on a set of data? This quiz is perfect for those of you who have a hard time when it comes to using this Microsoft Tool. Check it out!

The Microsoft Excel 2010 Quiz! Trivia - Quiz

Quiz Preview

  • 2. 

    Which of the following tasks can be performed with Excel?

    • Create a spreadsheet

    • Create a chart

    • Summarise numerical data

    • All of the above

    Correct Answer
    A. All of the above
    Explanation
    Excel is a powerful spreadsheet software that allows users to create spreadsheets, charts, and summarize numerical data. With Excel, users can organize and analyze data by creating spreadsheets, which are tables that store data in rows and columns. Additionally, Excel offers various chart types that can be used to visually represent data. Lastly, Excel provides functions and formulas that enable users to calculate and summarize numerical data, making it a versatile tool for data analysis. Therefore, all of the given tasks can be performed with Excel.

    Rate this question:

  • 3. 

    When you enter a formula in Excel, what sign must go in front of the formula?

    • >

    • #

    • =

    • !

    Correct Answer
    A. =
    Explanation
    When entering formulas, you need to put an equal (=) sign in front. Otherwise, the formula will merely be text in a cell.

    Rate this question:

  • 4. 

    Excel's Find and Replace feature can find words, numbers, and formatting.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    This statement is true. You can search for information or formatting.

    Rate this question:

  • 5. 

    Pressing the control key whilst inserting a semicolon enters the current date.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    To insert the current date, press CTRL+; (semi-colon).

    Rate this question:

  • 6. 

    If you were asked to double-click something, what would you do?

    • Press and release the left mouse button quickly twice

    • Press and release the right mouse button quickly twice

    • Press and release the left and right mouse buttons together

    • Press and release the left and right mouse buttons together quickly twice

    Correct Answer
    A. Press and release the left mouse button quickly twice
    Explanation
    To double-click something, you need to press and release the left mouse button quickly twice. This action is commonly used to open files, folders, or launch applications on a computer. By quickly clicking the left mouse button twice, you are indicating to the computer that you want to perform a double-click action, which triggers the corresponding function associated with the item you are clicking on.

    Rate this question:

  • 7. 

    What font must be used to comply with our Standard Document Rules?

    • Calibri 11 point

    • Times New Roman 12 point

    • Arial 10 point

    • Century Gothic 10 point

    Correct Answer
    A. Arial 10 point
    Explanation
    Font should be Arial 10 point.

    Rate this question:

  • 8. 

    By clicking Control+Home it will take you to the cell in Column A of the current row.

    • True

    • False

    Correct Answer
    A. False
    Explanation
    This statement is false. By clicking Control+Home it will take you to the very first cell of the worksheet (A1).

    Rate this question:

  • 9. 

    Headers and footers only apply to a specific worksheet, not the entire workbook.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    Headers and footers typically appear on every page of a report. In Excel 2010, a header is printed in the top margin, and a footer is printed in the bottom margin. Headers and footers are often used to identify the document and to display the page numbers. Unless you specify otherwise, Excel does not automatically add either a header or footer to a new workbook.

    Rate this question:

  • 10. 

    Which of the following can be used for emphasis in all of Rollits' documents?

    • Bold

    • Underline

    • Block capitals

    • All of the above

    Correct Answer
    A. Bold
    Explanation
    Emphasis is to be given by bold typeface. Underlining and block capitals should never be used anywhere in documents. Italics may be used in draft documents.

    Rate this question:

Quiz Review Timeline (Updated): Mar 21, 2023 +

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

  • Current Version
  • Mar 21, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Apr 19, 2013
    Quiz Created by
    SamGl
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.