Tour Of Excel: Formulas, Formatting, Sort, Filter Quiz

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 MarieLamb
M
MarieLamb
Community Contributor
Quizzes Created: 1 | Total Attempts: 526
Questions: 20 | Attempts: 526

SettingsSettingsSettings
Microsoft Quizzes & Trivia

Please answer the questions honestly and to the best of your ability. If you have no idea what the answer is, choose the "not sure" answer. Please do not leave the answer blank or "wild guess" any of the questions. Remember, the purpose of this assessment is to obtain accurate information on your skill level, and provide personally tailored training based on your scores.


Questions and Answers
  • 1. 

    By default, how many worksheets are in a workbook?

    • A.

      2

    • B.

      3

    • C.

      6

    • D.

      5

    Correct Answer
    B. 3
    Explanation
    By default, a workbook in many spreadsheet programs, such as Microsoft Excel, contains three worksheets. These worksheets are labeled as Sheet1, Sheet2, and Sheet3. This default setting allows users to organize and input data into separate sheets within the workbook, making it easier to manage and analyze different sets of data.

    Rate this question:

  • 2. 

    If you see this sign within a cell ####### what does it mean?

    • A.

      You have an error with numbers and text

    • B.

      The cell is not formatted

    • C.

      There is not enough room in the cell to accommodate the data

    • D.

      You have an error within the formula

    Correct Answer
    C. There is not enough room in the cell to accommodate the data
    Explanation
    The sign "#######" within a cell indicates that there is not enough room in the cell to display the data. This usually happens when the content of the cell is too wide to fit within the column width. The cell may need to be resized or the column width adjusted in order to properly display the data.

    Rate this question:

  • 3. 

    What does a range of cells mean?

    • A.

      A column

    • B.

      A Row

    • C.

      A Spreadsheet

    • D.

      A number of cells

    Correct Answer
    D. A number of cells
    Explanation
    A range of cells refers to a group or collection of multiple cells within a spreadsheet. It can include cells from multiple rows and columns, allowing for the selection and manipulation of data in a specific area. This range can be used for various purposes such as performing calculations, applying formatting, or referencing data in formulas. Overall, a range of cells represents a set of cells that are selected together to perform specific actions or operations within a spreadsheet.

    Rate this question:

  • 4. 

    Why would you put a filter on your spreadsheet?

    • A.

      To view the top row at all times

    • B.

      To view specific criteria in your spreadsheet

    • C.

      To help with formulas

    • D.

      In order to freeze the columns

    Correct Answer
    B. To view specific criteria in your spreadsheet
    Explanation
    By putting a filter on your spreadsheet, you can easily view specific criteria in your data. This allows you to focus on specific information and analyze it more effectively. Filtering helps you narrow down your data based on certain conditions or criteria, making it easier to find and analyze the information you need.

    Rate this question:

  • 5. 

    A Relative formula is....?

    • A.

      The same formula but different cell reference

    • B.

      Anchors the cell reference

    • C.

      Anchors one cell

    • D.

      A function

    Correct Answer
    A. The same formula but different cell reference
    Explanation
    A relative formula refers to a formula that is copied or filled into different cells, but the cell references within the formula change accordingly based on their relative positions. In other words, the formula remains the same, but the cell references adjust relative to the new location. This allows the formula to be applied to multiple cells without having to manually adjust each individual reference.

    Rate this question:

  • 6. 

    What must all formulas start with?

    • A.

      +

    • B.

      =

    • C.

      Sum

    • D.

      ##

    Correct Answer
    B. =
    Explanation
    All formulas must start with the equal sign (=). This is because the equal sign tells the spreadsheet program that what follows is a formula and not just a regular text entry. By starting with the equal sign, the program knows to evaluate the expression and perform the necessary calculations.

    Rate this question:

  • 7. 

    What is an absolute Formula?

    • A.

      One cell reference remains anchored when dragged down for copying

    • B.

      The cell reference changes as it is being dragged down for copying

    • C.

      A filter

    • D.

      A function

    Correct Answer
    A. One cell reference remains anchored when dragged down for copying
    Explanation
    An absolute formula is a type of formula in which one cell reference remains fixed or anchored, while the other cell references change as the formula is dragged down for copying. This allows the formula to always refer to the same cell, regardless of its position, while still being able to calculate values based on the changing cell references. This is useful when you want to apply a formula to multiple cells but want to keep a specific reference constant.

    Rate this question:

  • 8. 

    What does the CountA function do?

    • A.

      Counts Text

    • B.

      Counts numbers

    • C.

      Counts anything

    • D.

      Counts blanks rows

    Correct Answer
    A. Counts Text
    Explanation
    The CountA function counts the number of cells in a range that are not empty or contain any type of data, including text.

    Rate this question:

  • 9. 

    Which one would you choose to add more commands to the ribbon?

    • A.

      File, Options, Formulas

    • B.

      File, advanced

    • C.

      File add-ins

    • D.

      File,options customise ribbon

    Correct Answer
    D. File,options customise ribbon
    Explanation
    To add more commands to the ribbon, you would choose "File, options customise ribbon." This option allows you to customize the ribbon by adding or removing commands as per your preference.

    Rate this question:

  • 10. 

    What command would you use to put decimal places on the amounts?

    • A.

      Format

    • B.

      File

    • C.

      Edit

    • D.

      Copy

    Correct Answer
    A. Format
    Explanation
    To put decimal places on the amounts, you would use the "Format" command. This command allows you to customize the appearance of the data, including the number of decimal places displayed. By selecting the "Format" command, you can specify the desired decimal format for the amounts, ensuring they are displayed correctly according to your preferences.

    Rate this question:

  • 11. 

    Which one is not a logical operator?

    • A.

      +

    • B.

      /

    • C.

      *

    • D.

      #

    Correct Answer
    D. #
    Explanation
    The given options consist of mathematical operators, such as +, /, *, and #. However, # is not a logical operator. Logical operators are used in programming to perform logical operations, such as AND, OR, and NOT. They are used to combine and manipulate boolean values. Therefore, # does not fit the category of logical operators.

    Rate this question:

  • 12. 

    What does the colon do between the formula?

    • A.

      A formula which can be copied to adjacent cells

    • B.

      A function

    • C.

      A Condition

    • D.

      It adds both outside cells references and anything inbetween

    Correct Answer
    D. It adds both outside cells references and anything inbetween
    Explanation
    The colon in a formula is used to indicate a range of cells. It adds both the reference of the first cell and the reference of the last cell in the range, as well as any cells in between. This allows the formula to be copied to adjacent cells, with the range automatically adjusting based on the relative position of the copied formula.

    Rate this question:

  • 13. 

    What does the countif function do?

    • A.

      Counts the no of cells in a range that contains numbers

    • B.

      CountIf counts the no of cells in a given range that meets a condition

    • C.

      Counts the blank rows

    • D.

      Counts rows which contain numbers and blanks

    Correct Answer
    B. CountIf counts the no of cells in a given range that meets a condition
    Explanation
    The countif function is used to count the number of cells in a given range that meet a specific condition. It allows you to specify a criteria and then counts the number of cells in the range that satisfy that criteria. This function is useful for analyzing data and getting a count of cells that meet certain criteria.

    Rate this question:

  • 14. 

    What is a validation check?

    • A.

      It is put on to eliminate mistakes

    • B.

      It is a function

    • C.

      A formula

    • D.

      A condition

    Correct Answer
    A. It is put on to eliminate mistakes
    Explanation
    A validation check is a process or mechanism put in place to eliminate mistakes or errors. It ensures that data or information entered into a system meets certain criteria or conditions. By implementing validation checks, potential errors can be caught and corrected before they cause any issues or problems. This helps to improve the accuracy and reliability of the data being processed.

    Rate this question:

  • 15. 

    The developer tab helps you to create macro and forms etc.  How would you add the developer tab to the ribbon?

    • A.

      Edit, add developer tab

    • B.

      File, Options customise ribbon

    • C.

      File Advanced

    • D.

      Edit, insert

    Correct Answer
    B. File, Options customise ribbon
    Explanation
    To add the developer tab to the ribbon, you need to go to the "File" menu and select "Options". In the options menu, you will find the "Customize Ribbon" tab. Click on it and then check the box next to "Developer" in the list of tabs on the right side. Finally, click on "OK" to save the changes.

    Rate this question:

  • 16. 

    What is conditional format?

    • A.

      A Format of colour etc applied to cells to make them stand out

    • B.

      A list in which you can choose from various options

    • C.

      A pattern which you need to set-up and drag to cells

    • D.

      A built in pattern

    Correct Answer
    A. A Format of colour etc applied to cells to make them stand out
    Explanation
    Conditional formatting is a feature in spreadsheet software that allows users to apply formatting, such as color, to cells based on certain conditions or criteria. This formatting helps to visually highlight specific data or patterns in the spreadsheet, making it stand out and easier to interpret.

    Rate this question:

  • 17. 

    If you entered the following number in a cell; £12032.50 but chose no decimal places - what would appear in the cell?

    • A.

      £12,032

    • B.

      £12,033

    • C.

      £1232.0

    • D.

      £12,031

    Correct Answer
    B. £12,033
    Explanation
    If you enter the number £12032.50 in a cell and choose no decimal places, the number will be rounded up to the nearest whole number. Therefore, the number that would appear in the cell is £12,033.

    Rate this question:

  • 18. 

    What is the difference between a worksheet and a workbook?

    • A.

      A worksheet is a workbook within a workbook

    • B.

      A worksheet is a sheet within a workbook

    • C.

      A worksheet has to be inserted into a workbook

    • D.

      A worksheet is part of the cells in a workbook

    Correct Answer
    B. A worksheet is a sheet within a workbook
    Explanation
    A worksheet is a single sheet or page within a workbook. A workbook, on the other hand, is a collection of multiple worksheets. Each worksheet in a workbook can contain data, formulas, and other elements, and they can be used to organize and analyze different sets of information. Therefore, the correct answer is that a worksheet is a sheet within a workbook.

    Rate this question:

  • 19. 

    What is BODMAS

    • A.

      It is a specific order of calculations Excel follows

    • B.

      Percentage

    • C.

      Date

    • D.

      Conditional Format

    Correct Answer
    A. It is a specific order of calculations Excel follows
    Explanation
    BODMAS stands for Brackets, Orders (exponents and roots), Division and Multiplication (from left to right), and Addition and Subtraction (from left to right). It is a mathematical rule that determines the order in which calculations should be performed. In Excel, BODMAS is used to ensure that formulas are calculated correctly, following the same order of operations as in mathematics. By following the BODMAS rule, Excel ensures that calculations are carried out in a logical and consistent manner.

    Rate this question:

  • 20. 

    What is the sole purpose of an IF statement?

    • A.

      It returns the largest value in a set

    • B.

      If a condition is met it returns a true/false value

    • C.

      Returns the largest number in a set of values

    • D.

      Returns the absolute value of a number

    Correct Answer
    B. If a condition is met it returns a true/false value
    Explanation
    An IF statement is used to check a condition and execute a block of code if the condition is true. It allows for conditional execution, where different actions can be taken based on whether the condition evaluates to true or false. Therefore, the sole purpose of an IF statement is to return a true/false value if a condition is met.

    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 19, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Feb 02, 2012
    Quiz Created by
    MarieLamb
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.