# Excel Formulas And Functions Trivia 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 Oflodac
O
Oflodac
Community Contributor
Quizzes Created: 13 | Total Attempts: 54,648
Questions: 10 | Attempts: 12,998  Settings  Get ready for this 'excel formulas and functions trivia quiz'. Have you ever worked on a spreadsheet application or MS Excel? Do you know all the functions and formulas? If yes, then take this quiz to test where you stand and learn new formulas and functions used in excel. Microsoft Excel is spreadsheet software that is used for data processing and financial presentation. To become an expert, one needs to learn the formulas and functions. So, let's try out the quiz. All the best!

• 1.

### All formulas in Excel begin with the following symbol.

• A.

+

• B.

=

• C.

%

• D.

#

B. =
Explanation
In Excel, all formulas begin with the "=" symbol. This symbol is used to indicate that the following characters are part of a formula and should be evaluated as such. By starting a cell entry with "=", Excel knows that it should interpret the content as a formula and perform calculations accordingly.

Rate this question:

• 2.

### Which formula below will add the value of B2 to the value of C3

• A.

=B2+C3

• B.

=C3+B3

• C.

=6+4

• D.

=B+C

A. =B2+C3
Explanation
The correct answer is =B2+C3 because this formula will add the value of B2 to the value of C3. The plus sign (+) is used to indicate addition in Excel formulas, and the cell references B2 and C3 specify the cells from which the values will be taken. By using this formula, the values of B2 and C3 will be added together to give the desired result.

Rate this question:

• 3.

### For calculating which of the following options, An Excel spreadsheet is primarily used?

• A.

Data

• B.

Finances

• C.

Numbers

• D.

All of the above

D. All of the above
Explanation
An Excel spreadsheet is primarily used for calculating all of the above options, including data, finances, and numbers. Excel provides a wide range of functions and tools that allow users to perform various calculations and analysis on different types of data. It is commonly used in business and finance for tasks such as budgeting, financial analysis, and data management. Additionally, Excel's mathematical functions make it suitable for performing calculations involving numbers. Therefore, all of the given options can be effectively managed and calculated using an Excel spreadsheet.

Rate this question:

• 4.

### This is a formula.

• A.

=SUM(A1:A5)

• B.

• C.

Subtract the numbers from A1 to A5

• D.

A1 = A5

A. =SUM(A1:A5)
Explanation
The correct answer is =SUM(A1:A5). This formula calculates the sum of the values in cells A1 to A5. It adds up all the numbers in this range and gives the total sum as the answer.

Rate this question:

• 5.

### At the beginning of an Excel spreadsheet formula, the function of the word '=SUM' is

• A.

• B.

To tell the person viewing that this is a function and it should be added together.

• C.

To calculate all the data correctly without any mistakes.

• D.

To inform the computer that an arithmetic function will occur.

Explanation
The function of the word '=SUM' at the beginning of an Excel spreadsheet formula is to add all the data together using addition only. This is because the SUM function in Excel is specifically designed to calculate the sum of a range of cells or values. By using the '=SUM' at the beginning of the formula, it indicates to Excel that the following values should be added together.

Rate this question:

• 6.

### A worksheet is a(n) ___________

• A.

Piece of graph paper

• B.

A single page in a workbook

• C.

Excel file

• D.

All of the above

B. A single page in a workbook
Explanation
A worksheet refers to a single page in a workbook. A workbook is a collection of multiple worksheets that are used to organize and store data in Excel. Each worksheet within the workbook functions as an individual page where users can input and manipulate data, perform calculations, and create charts or graphs. Therefore, the correct answer is "A single page in a workbook."

Rate this question:

• 7.

### A selection of multiple cells is called a

• A.

Group

• B.

Range

• C.

Reference

• D.

Package

B. Range
Explanation
A selection of multiple cells is called a range.

Rate this question:

• 8.

### Using a cell address in a formula is known as:

• A.

Formularizing

• B.

Prefixing

• C.

Cell referencing

• D.

Cell mathematics

C. Cell referencing
Explanation
Cell referencing is the correct answer because it refers to the practice of using a specific cell address in a formula. By referencing a cell, the formula can retrieve the value or perform calculations based on the data in that particular cell. This allows for dynamic and flexible formulas that can automatically update when the referenced cell's value changes.

Rate this question:

• 9.

### In which view can you see the header and footer areas of a worksheet

• A.

Normal view

• B.

Page layout view

• C.

Page break preview

• D.

B. Page layout view
Explanation
In Page layout view, you can see the header and footer areas of a worksheet. This view allows you to see how the worksheet will appear when printed, including any headers and footers that have been added. It provides a more accurate representation of the printed document compared to Normal view. In Normal view, the header and footer areas are not visible, and in Page break preview, the focus is on adjusting page breaks rather than viewing headers and footers. The Header/Footer option is not a view but rather a feature that allows you to customize and add content to the header and footer areas.

Rate this question:

• 10.

### Which of the following is the correct way to write the IF function?

• A.

=IF(condition, condition if false, condition if true)

• B.

=IF(condition, condition if true, condition if false)

• C.

=IF(condition:condition if true:condition if false)

• D.

None of these

B. =IF(condition, condition if true, condition if false)
Explanation
The correct way to write the IF function is =IF(condition, condition if true, condition if false). This formula allows you to test a condition and return one value if the condition is true, and another value if the condition is false.

Rate this question:

Related Topics Back to top