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

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 MarieLamb
M
MarieLamb
Community Contributor
Quizzes Created: 1 | Total Attempts: 561
| Attempts: 561 | Questions: 20
Please wait...
Question 1 / 20
0 %
0/100
Score 0/100
1. What must all formulas start with?

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.

Submit
Please wait...
About This Quiz
Excel 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... see moreinformation on your skill level, and provide personally tailored training based on your scores. see less

Personalize your quiz and earn a certificate with your name on it!
2. What is the sole purpose of an IF statement?

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.

Submit
3. Why would you put a filter on 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.

Submit
4. Which one is not a logical operator?

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.

Submit
5. What does a range of cells mean?

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.

Submit
6. What is the difference between a worksheet and 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.

Submit
7. What is BODMAS

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.

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

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.

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

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.

Submit
10. A Relative formula is....?

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.

Submit
11. What does the countif function do?

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.

Submit
12. What is a validation check?

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.

Submit
13. The developer tab helps you to create macro and forms etc.  How would you add the developer tab to the 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.

Submit
14. Which one would you choose to add more commands to the 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.

Submit
15. What does the colon do between the formula?

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.

Submit
16. What is an absolute Formula?

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.

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

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.

Submit
18. By default, how many worksheets are in a workbook?

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.

Submit
19. What is conditional format?

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.

Submit
20. What does the CountA function do?

Explanation

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

Submit
View My Results

Quiz Review Timeline (Updated): Mar 19, 2023 +

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
Cancel
  • All
    All (20)
  • Unanswered
    Unanswered ()
  • Answered
    Answered ()
What must all formulas start with?
What is the sole purpose of an IF statement?
Why would you put a filter on your spreadsheet?
Which one is not a logical operator?
What does a range of cells mean?
What is the difference between a worksheet and a workbook?
What is BODMAS
What command would you use to put decimal places on the amounts?
If you see this sign within a cell ####### what does it mean?
A Relative formula is....?
What does the countif function do?
What is a validation check?
The developer tab helps you to create macro and forms etc.  How...
Which one would you choose to add more commands to the ribbon?
What does the colon do between the formula?
What is an absolute Formula?
If you entered the following number in a cell; £12032.50 but...
By default, how many worksheets are in a workbook?
What is conditional format?
What does the CountA function do?
Alert!

Advertisement