Microsoft Excel Test II

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 PCDAC
P
PCDAC
Community Contributor
Quizzes Created: 11 | Total Attempts: 7,470
| Attempts: 173
SettingsSettings
Please wait...
  • 1/13 Questions

    Microsoft Excel is an ______________  spreadsheet

    • Easy
    • Electronic
    • Empty
Please wait...
Microsoft Excel Test II - Quiz
About This Quiz

The 'Microsoft Excel Test II' assesses basic to intermediate skills in using Microsoft Excel, covering functionalities like editing, formulas, text wrapping, and spell checking. It's designed for learners aiming to enhance their proficiency in Excel for professional or academic purposes.

Quiz Preview

  • 2. 

    You Can Only Edit Data In The Formula Bar

    • True

    • False

    Correct Answer
    A. 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. 

    What Tab Is The Wrap Text Button Found?

    • Home

    • House

    • Review

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

    Rate this question:

  • 4. 
    The Only Way To Get The Sum of A Set of Numbers Is To Use The Button Below - ProProfs

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

    • True

    • False

    Correct Answer
    A. 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:

  • 5. 
    What Is This Area Called - ProProfs

    What Is This Area Called

    • Title Bar

    • Menu Bar

    • Ribbon Bar

    Correct Answer
    A. 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:

  • 6. 
    'B10' Is Indicated In The ________ Box Area - ProProfs

    'B10' Is Indicated In The ________ Box Area

    • Number

    • Nancy

    • Name

    Correct Answer
    A. 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:

  • 7. 

    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:

  • 8. 

    You Can Spell Check In Excel By Doing The Following

    • Clicking F7 Only

    • Selecting Spelling On The Reference Tab

    • Selecting Spelling On The Review Tab or Clicking F7

    • All of The Above

    Correct Answer
    A. 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:

  • 9. 

    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)

  • 10. 

    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

  • 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 (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
  • 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.