Microsoft Word And Excel 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 Timmy198
T
Timmy198
Community Contributor
Quizzes Created: 577 | Total Attempts: 324,749
Questions: 10 | Attempts: 6,010

SettingsSettingsSettings
Microsoft Word And Excel Test - Quiz

MS word and Excel are the most common office tools which both has their differences and their similarities. Both of them can make printable documents and the kind of documents they make differs alot. Get on this short quiz and find out what you know.


Questions and Answers
  • 1. 

    What must all excel formulas begin with?

    • A.

      *

    • B.

      "

    • C.

      !

    • D.

      =

    Correct Answer
    D. =
    Explanation
    All Excel formulas must begin with the equals sign (=). This is because the equals sign is used to indicate that the following characters are part of a formula and not just regular text. By starting a formula with the equals sign, Excel knows that it needs to evaluate the expression and perform the necessary calculations. Without the equals sign, Excel will treat the characters as regular text and not as a formula.

    Rate this question:

  • 2. 

    What is the most widely used used chart in excel?

    • A.

      Bar

    • B.

      Histogram

    • C.

      Pie

    • D.

      Pivot

    Correct Answer
    A. Bar
    Explanation
    The most widely used chart in Excel is the bar chart. Bar charts are effective for comparing data across different categories or groups. They use horizontal or vertical bars to represent data values, making it easy to visualize and understand the data. Bar charts are versatile and can be used for various purposes, such as showing sales figures, comparing different products, or tracking progress over time. They are commonly used in business, finance, and data analysis to present information in a clear and concise manner.

    Rate this question:

  • 3. 

    Does Ms Word have more formatting abilities than excel?

    • A.

      Yes

    • B.

      No

    • C.

      None

    • D.

      Unknown

    Correct Answer
    A. Yes
    Explanation
    Ms Word has more formatting abilities than Excel because Word is primarily designed for creating and formatting documents, while Excel is mainly used for numerical calculations and data analysis. Word offers a wide range of formatting options such as font styles, paragraph formatting, page layout settings, headers and footers, and more. On the other hand, Excel focuses more on organizing and manipulating data, offering features like formulas, charts, and tables. Therefore, when it comes to formatting abilities, Word surpasses Excel in terms of versatility and options.

    Rate this question:

  • 4. 

    What kind of documents can be created by both Ms Word and Excel

    • A.

      Auditable documents

    • B.

      Printable Documents

    • C.

      Analysis Documents

    • D.

      Modelling documents

    Correct Answer
    B. Printable Documents
    Explanation
    Both Microsoft Word and Excel have the capability to create printable documents. In Word, users can create various types of documents such as letters, reports, resumes, and brochures, which can be easily printed. Excel, on the other hand, allows users to create spreadsheets and tables that can be formatted and customized for printing purposes. Therefore, printable documents can be created by both Word and Excel.

    Rate this question:

  • 5. 

    Can Ms word also be used to make layouts of Rows and Columns?

    • A.

      Yes

    • B.

      No

    • C.

      None

    • D.

      Unknown

    Correct Answer
    A. Yes
    Explanation
    Microsoft Word can be used to create layouts of rows and columns by using tables. Tables provide a structured way to organize and present information in a grid format. Users can easily insert tables, adjust the number of rows and columns, merge cells, apply formatting, and add content within each cell. This feature allows for the creation of organized and visually appealing layouts for various purposes such as reports, newsletters, resumes, and more.

    Rate this question:

  • 6. 

    What do you use to identify the location of each column?

    • A.

      Formulas

    • B.

      Numbers

    • C.

      Letters

    • D.

      Colors

    Correct Answer
    C. Letters
    Explanation
    To identify the location of each column, letters are used. In most spreadsheet software, columns are labeled with letters from A to Z, and then continue with AA, AB, AC, and so on. This labeling system helps users easily locate and reference specific columns within a spreadsheet.

    Rate this question:

  • 7. 

    What bears the equations that calculatees values to be displayed?

    • A.

      Cells

    • B.

      Labels

    • C.

      Formulas

    • D.

      Constants

    Correct Answer
    C. Formulas
    Explanation
    Formulas are the correct answer because they are the equations that calculate values to be displayed. In a spreadsheet or mathematical software, formulas are used to perform calculations and manipulate data. They can include mathematical operations, functions, and references to other cells or data. By inputting formulas, users can automate calculations and update values dynamically based on changes in input data. Therefore, formulas are essential for generating accurate and dynamic results in various applications.

    Rate this question:

  • 8. 

    What is the multiplication sign in excel?

    • A.

      X

    • B.

      +

    • C.

      *

    • D.

      #

    Correct Answer
    C. *
    Explanation
    The multiplication sign in Excel is represented by the asterisk symbol (*). It is used to perform multiplication operations between two or more values in a formula. For example, if you want to multiply the values in cell A1 and B1, you would use the formula =A1*B1. The asterisk acts as a mathematical operator to indicate multiplication in Excel.

    Rate this question:

  • 9. 

    Which of these is not a basic part of a spread sheet

    • A.

      Rows

    • B.

      Margins

    • C.

      Columns

    • D.

      Cells

    Correct Answer
    B. Margins
    Explanation
    Margins are not a basic part of a spreadsheet. A spreadsheet consists of rows, columns, and cells, which are used to organize and store data. Rows are horizontal lines that contain data, columns are vertical lines that organize data, and cells are the individual boxes where data is entered. Margins, on the other hand, are typically used in word processing or page layout software to define the empty space around the edges of a printed page. In a spreadsheet, margins are not necessary as the focus is on organizing and manipulating data within the rows, columns, and cells.

    Rate this question:

  • 10. 

    Which of these is not a type of data that can be found in a cell?

    • A.

      Word sets

    • B.

      Constants

    • C.

      Label

    • D.

      Formula

    Correct Answer
    A. Word sets
    Explanation
    Word sets are not a type of data that can be found in a cell. In a cell, one can find constants, labels, and formulas. Constants are fixed values, labels are used to represent text or alphanumeric values, and formulas are used to perform calculations or manipulate data. However, word sets are not a recognized data type in cells.

    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
  • Mar 12, 2018
    Quiz Created by
    Timmy198
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.