Microsoft Excel Test II

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 PCDAC
P
PCDAC
Community Contributor
Quizzes Created: 11 | Total Attempts: 6,928
Questions: 13 | Attempts: 164

SettingsSettingsSettings
Microsoft Excel Test II - Quiz

Questions and Answers
  • 1. 

    Microsoft Excel is an ______________  spreadsheet

    • A.

      Easy

    • B.

      Electronic

    • C.

      Empty

    Correct Answer
    B. Electronic
    Explanation
    Microsoft Excel is an electronic spreadsheet. This means that it is a computerized tool used for organizing, analyzing, and manipulating numerical data. Excel allows users to create tables, perform calculations, and generate graphs and charts. It is widely used in various industries and professions for tasks such as budgeting, financial analysis, data tracking, and project management. As an electronic spreadsheet, Excel offers a range of features and functions that make it a powerful tool for data management and analysis.

    Rate this question:

  • 2. 

    You Can Only Edit Data In The Formula Bar

    • A.

      True

    • B.

      False

    Correct Answer
    B. False
    Explanation
    The statement "You can only edit data in the formula bar" is false. In many software applications, including spreadsheet programs like Microsoft Excel, users have the ability to edit data not only in the formula bar but also directly in the cells. This allows for easier and more convenient data manipulation and editing. Therefore, the correct answer is false.

    Rate this question:

  • 3. 

    The Only Way To Get The Sum of A Set of Numbers Is To Use The Button Below

    • A.

      True

    • B.

      False

    Correct Answer
    B. False
    Explanation
    This statement is false because there are multiple ways to get the sum of a set of numbers. One can manually add up the numbers using pen and paper or a calculator, or they can use a computer program or online tool to calculate the sum. The button mentioned in the statement is not the only way to obtain the sum of a set of numbers.

    Rate this question:

  • 4. 

    What Tab Is The Wrap Text Button Found?

    • A.

      Home

    • B.

      House

    • C.

      Review

    Correct Answer
    A. Home
    Explanation
    The Wrap Text button is found on the Home tab.

    Rate this question:

  • 5. 

    You Can Spell Check In Excel By Doing The Following

    • A.

      Clicking F7 Only

    • B.

      Selecting Spelling On The Reference Tab

    • C.

      Selecting Spelling On The Review Tab or Clicking F7

    • D.

      All of The Above

    Correct Answer
    C. Selecting Spelling On The Review Tab or Clicking F7
    Explanation
    The correct answer is "Selecting Spelling On The Review Tab or Clicking F7". This is because in Excel, you can perform spell check by either selecting the "Spelling" option on the "Review" tab or by simply pressing the F7 key. Both methods allow you to check the spelling of your data and make necessary corrections.

    Rate this question:

  • 6. 

    To Save A Worksheet In Excel You Must Click On The _______  _______ and then click ______.

    Correct Answer
    office button save
    Office Button Save
    Explanation
    To save a worksheet in Excel, you need to click on the "Office Button" (located at the top left corner of the Excel window), then select the "Save" option from the drop-down menu that appears. The "Office Button" is represented by the Microsoft Office logo. By selecting "Save", you can save the changes made to the worksheet.

    Rate this question:

  • 7. 

    What Is This Area Called

    • A.

      Title Bar

    • B.

      Menu Bar

    • C.

      Ribbon Bar

    Correct Answer
    C. Ribbon Bar
    Explanation
    The correct answer is Ribbon Bar because it is the area in a software application, typically located at the top of the window, that contains a collection of tabs and buttons. The Ribbon Bar is used to organize and display various commands and options related to the specific application or task. It provides easy access to frequently used features and functions, improving user efficiency and productivity.

    Rate this question:

  • 8. 

    OPEN AN EXCEL SPREADSHEET 1. Enter 25 in A1 2. Enter 30 in A2 3. Enter The Formula For The Sum (DO NOT USE THE AUTOSUM)

  • 9. 

    ON THE SAME SPREADSHEET 1. Enter 5 in B1 2. Enter 6 in B2 3. Enter The Formula To DIVIDE A1 By B1 In Cell C1 4. Enter The Formula To DIVIDE A2 By B2 In Cell C2

  • 10. 

    'B10' Is Indicated In The ________ Box Area

    • A.

      Number

    • B.

      Nancy

    • C.

      Name

    Correct Answer
    C. Name
    Explanation
    The correct answer is "Name" because the question is asking where "B10" is indicated. Since "B10" is a combination of a letter and a number, it is most likely referring to a specific location or identifier. Out of the given options, "Name" is the most logical choice as it is common to label or indicate specific names in a designated box area.

    Rate this question:

  • 11. 

    ON THE SAME SPREADSHEET 1. Enter 10 In A6 2. Enter 5 In A7 3. Enter The Formula To Subtract A7 From A6 In Cell A8

  • 12. 

    ON THE SAME SPREADSHEET 1. Enter 2 In B6 2. Enter 5 In B7 3. Enter The Formula To Multiply A6 By B6 In Cell C6 4. Enter The Formula To Multiply A7 By B7 In Cell C7

  • 13. 

    1. In Cell A10 Type The Below Statement: In Word 2007 I Can Create A Document. I Can Use The Spell Check F7 Functon Key To Check My Spelling. In Excell 2007 I Can Create A Spreadsheet To Track Numberic or Alpha Text Data.  I Can Also Calculate Numbers. 2.  Use The Wrap Text Button To Format The Text You Just Typed. 3.  Center The Text 4.  Save As Week 3 Test II 5.  Print The Spreadsheet

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 21, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Jun 23, 2011
    Quiz Created by
    PCDAC
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.