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

Settings

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

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

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.

• D.

A number of cells

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.

• A.

To view the top row at all times

• B.

• C.

To help with formulas

• D.

In order to freeze the columns

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

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.

• A.

+

• B.

=

• C.

Sum

• D.

##

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

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

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.

• C.

• D.

File,options customise ribbon

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

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.

#

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

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

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

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.

• B.

File, Options customise ribbon

• C.

• D.

Edit, insert

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

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

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

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

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

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:

Related Topics