Understanding Microsoft Excel For Grade: 9mj

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 Sean_yungprezi
S
Sean_yungprezi
Community Contributor
Quizzes Created: 1 | Total Attempts: 458
Questions: 15 | Attempts: 458

SettingsSettingsSettings
Microsoft Excel Quizzes & Trivia

Class test


Questions and Answers
  • 1. 

    Which is CORRECT about spreadsheet ??

    • A.

      A game we play in class

    • B.

      Fill with lines and we just play with them

    • C.

      This is a piece of software that make it easy for you to carry out calclations

    • D.

      A software used for many task that are important to the boot up

    Correct Answer
    C. This is a piece of software that make it easy for you to carry out calclations
    Explanation
    The correct answer is "This is a piece of software that makes it easy for you to carry out calculations." This answer accurately describes a spreadsheet as a software that allows users to perform calculations easily. Spreadsheets are commonly used for organizing and manipulating data, performing mathematical operations, and creating charts and graphs. They are not a game, nor are they solely used for booting up tasks.

    Rate this question:

  • 2. 

    ALL is a part of Microsoft excel EXCEPT ?

    • A.

      Active cell

    • B.

      Column heading

    • C.

      Window file

    • D.

      Formula bar

    Correct Answer
    C. Window file
    Explanation
    The correct answer is "Window file" because in Microsoft Excel, there is no specific feature or component called "Window file." Excel does have features such as active cell, column headings, and formula bar, which are all essential elements of the software. However, a "Window file" is not a recognized term or function within Excel.

    Rate this question:

  • 3. 

    Which is correct about CHARTS in Microsoft excel?

    • A.

      they are visual representation of the worksheet data

    • B.

      Maps to the world

    • C.

      Graphics

    • D.

      Designs

    Correct Answer
    A. they are visual representation of the worksheet data
    Explanation
    Charts in Microsoft Excel are used to visually represent the data present in a worksheet. They provide a clear and concise way to analyze and interpret the data by displaying it in various graphical formats such as bar charts, line charts, pie charts, etc. Charts help in identifying trends, patterns, and relationships between different data points, making it easier for users to understand and make informed decisions based on the data. Therefore, the statement "they are visual representation of the worksheet data" accurately describes the purpose and functionality of charts in Microsoft Excel.

    Rate this question:

  • 4. 

    Row heading are rows labeled with numbers, starting with 1

    • A.

      True

    • B.

      False

    Correct Answer
    A. True
    Explanation
    Row headings are indeed rows labeled with numbers, starting with 1. This means that each row in a table or spreadsheet is assigned a number as its label, with the first row being labeled as 1, the second row as 2, and so on. This labeling system helps to easily identify and refer to specific rows in a table or spreadsheet, especially when working with large amounts of data.

    Rate this question:

  • 5. 

    A Range is a group of books of calls in a workstation

    • A.

      True

    • B.

      False

    Correct Answer
    B. False
    Explanation
    The statement is false because a range is not a group of books of calls in a workstation. A range typically refers to a series or sequence of numbers or values within a specified range or interval. It can be used in various contexts such as mathematics, statistics, or programming to define a set of values within a specific range.

    Rate this question:

  • 6. 

    Value contains numbers and can be used in calculations

    • A.

      True

    • B.

      False

    Correct Answer
    A. True
    Explanation
    The statement suggests that the value contains numbers and can be used in calculations. This means that the value is numeric and can be manipulated mathematically. Therefore, the correct answer is True.

    Rate this question:

  • 7. 

     Start a formula with ___________________________ ?

    Correct Answer
    N/A
  • 8. 

    One box in a spreadsheet. The place where a row and a column intersect

    • A.

      Cell

    • B.

      Row

    • C.

      Column

    • D.

      Alignment

    Correct Answer
    A. Cell
    Explanation
    A cell in a spreadsheet refers to the specific location where a row and a column intersect. It is the smallest unit of data in a spreadsheet and can contain text, numbers, formulas, or functions. Cells are used to organize and store data in a structured manner, allowing users to perform calculations, analyze data, and create visual representations such as charts and graphs.

    Rate this question:

  • 9. 

    A computer program with Rows, columns, cells that lets you organize information and do math

    • A.

      Autosum

    • B.

      Descending

    • C.

      Format

    • D.

      Spreadsheet

    Correct Answer
    A. Autosum
    Explanation
    A spreadsheet is a computer program that allows users to organize information and perform mathematical calculations. One of the features commonly found in spreadsheets is the autosum function, which automatically calculates the sum of a selected range of cells. Therefore, the correct answer in this case is "autosum."

    Rate this question:

  • 10. 

    The horizontal space (across) that has numbers on the left side

    • A.

      Column

    • B.

      Cell

    • C.

      Allignment

    • D.

      Row

    Correct Answer
    D. Row
    Explanation
    The correct answer is "row". In a table or grid, a row is a horizontal line that contains information or data. It is identified by the numbers or labels on the left side of the grid. The other options, such as column, cell, and alignment, refer to different aspects of a table or grid but do not specifically relate to the horizontal space with numbers on the left side.

    Rate this question:

  • 11. 

    Tell how  you would open Microsoft excel ?

    Correct Answer
    N/A
  • 12. 

    AVERAGE  is used to find the size of the smallest class

    • A.

      True

    • B.

      False

    Correct Answer
    B. False
    Explanation
    The statement that "AVERAGE is used to find the size of the smallest class" is false. The AVERAGE function is used to calculate the average value of a set of numbers, not to determine the size of a class. The size of a class is typically determined by counting the number of students or individuals in the class.

    Rate this question:

  • 13. 

    MAX is used to show the size of the largest class

    • A.

      True

    • B.

      False

    Correct Answer
    A. True
    Explanation
    The statement is true because the MAX keyword is commonly used in programming languages to determine the size of the largest class or data type. It allows programmers to allocate the necessary memory or define the appropriate boundaries for their variables or arrays. By using MAX, they can ensure that their program can handle the largest possible value or object within the specified constraints.

    Rate this question:

  • 14. 

    MIN is used to show the average class size 

    • A.

      True

    • B.

      False

    Correct Answer
    B. False
    Explanation
    The given statement is incorrect. MIN is not used to show the average class size. MIN is a function used to find the minimum value in a set of numbers. It returns the smallest value from a given range of values. Therefore, the correct answer is False.

    Rate this question:

Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.