Tour Of Excel: Formulas, Formatting, Sort, Filter Quiz
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.
- 1.
By default, how many worksheets are in a workbook?
- A.
2
- B.
3
- C.
6
- D.
5
Correct Answer
B. 3Explanation
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 dataExplanation
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 cellsExplanation
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 spreadsheetExplanation
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 referenceExplanation
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 copyingExplanation
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 TextExplanation
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 ribbonExplanation
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. FormatExplanation
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 inbetweenExplanation
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 conditionExplanation
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 mistakesExplanation
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 ribbonExplanation
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 outExplanation
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,033Explanation
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 workbookExplanation
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 followsExplanation
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 valueExplanation
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:
-
Back to top