# Excel 2007 Intermediate Course Short 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 Ria Madonna
Ria Madonna, Document Control
Ria is a Document Control Specialist with 11 years at Fluor Corporation and 7 years at Luzon Electronics Technology, Inc., led significant projects, oversaw document management, and excelled in supervisory roles.
Quizzes Created: 2 | Total Attempts: 580
Questions: 13 | Attempts: 422

Settings

• 1.

• 2.

### A formula cannot contain any of the following: functions, references, operators, and constants.

• A.

True

• B.

False

B. False
Explanation
The given statement is false. A formula can indeed contain functions, references, operators, and constants. These elements are essential for creating complex calculations and performing various operations in spreadsheets or mathematical equations. Therefore, the correct answer is false.

Rate this question:

• 3.

### Excel calculates the formula from right to left, according to a specific order for each operator in the formula.

• A.

True

• B.

False

B. False
Explanation
Excel actually calculates formulas from left to right, not from right to left. This means that it evaluates the operators and operands in the order they appear in the formula, following the specific order of operations for each operator. Therefore, the given statement is false.

Rate this question:

• 4.

### Splitting cells content based on a column break is applicable if your data to be separated have a fixed column break location

• A.

True

• B.

False

A. True
Explanation
Splitting cells content based on a column break is applicable if your data to be separated have a fixed column break location. This means that if you have data in a single cell that needs to be divided into separate columns, you can use a fixed column break location to split the content accurately. This method is useful when working with structured data that follows a consistent pattern, allowing you to easily separate the information into different columns for analysis or organization purposes.

Rate this question:

• 5.

### When you remove duplicate values, only the values in the range of cells or table are affected. Any other values outside the range of cells or table are not altered or moved

• A.

True

• B.

False

A. True
Explanation
When removing duplicate values, only the values within the specified range of cells or table are affected. This means that any duplicate values within that range will be removed, while the values outside of that range will remain unchanged. Therefore, the statement "only the values in the range of cells or table are affected" is true.

Rate this question:

• 6.

### You can use conditional formatting if you want to check if there are duplicate values in the range of cells

• A.

False

• B.

True

B. True
Explanation
Conditional formatting is a feature in spreadsheet software that allows users to apply formatting to cells based on specified conditions. By using conditional formatting, it is possible to check if there are duplicate values in a range of cells. This can be done by setting a condition that identifies duplicates and applying a formatting style to those cells. Therefore, the statement "You can use conditional formatting if you want to check if there are duplicate values in the range of cells" is true.

Rate this question:

• 7.

### If you want to restrict data entry to a certain range of cells you will use paste special feature in Excel

• A.

True

• B.

False

B. False
Explanation
The statement is false because the correct feature to restrict data entry to a certain range of cells in Excel is Data Validation, not Paste Special. Data Validation allows users to set specific criteria for data entry in a selected range of cells, such as restricting values to a certain range, whole numbers, or specific text. Paste Special, on the other hand, is used for performing various operations while pasting data, such as pasting only values, formats, or formulas.

Rate this question:

• 8.

### To change the order of evaluation, enclose in parentheses the part of the formula to be calculated first

• A.

True

• B.

False

A. True
Explanation
The statement is true because parentheses can be used to change the order of evaluation in a formula. By enclosing a specific part of the formula in parentheses, it will be calculated first before the rest of the formula. This allows for more control and precision in the calculation process.

Rate this question:

• 9.

### For cell H9, the relative reference is H9, the absolute reference is \$H\$9 and the mixed reference is either \$H9 or H\$9.

• A.

True

• B.

False

A. True
Explanation
The statement is true because it correctly describes the relative, absolute, and mixed references for cell H9. A relative reference refers to a cell in relation to the current cell, so H9 is the relative reference for cell H9. An absolute reference refers to a specific cell, regardless of the current cell, so \$H\$9 is the absolute reference for cell H9. A mixed reference combines relative and absolute references, so either \$H9 or H\$9 can be considered the mixed reference for cell H9.

Rate this question:

• 10.

### You can change column width, but you cannot change row height.

• A.

True

• B.

False

B. False
Explanation
The statement is false because in most spreadsheet programs, including Excel, you have the ability to change both the column width and the row height. This allows you to adjust the size of cells in order to fit the content or make it more visually appealing.

Rate this question:

• 11.

### You can use numbers or cell references in formulas.

• A.

True

• B.

False

A. True
Explanation
The given correct answer is "True." This means that the statement or question being asked is true or accurate.

Rate this question:

• 12.

### Which of the following is not an example of an Excel function?

• A.

=SUM(A4:A10)

• B.

=AVERAGE(A4:A10)

• C.

=MIN(A4:A10)

• D.

=A4:A10

• E.

Not Sure

D. =A4:A10
Explanation
The answer =A4:A10 is not an example of an Excel function because it is a cell reference, not a function. In Excel, functions are predefined formulas that perform calculations or operations on data. The other options, =SUM(A4:A10), =AVERAGE(A4:A10), and =MIN(A4:A10), are all examples of Excel functions as they perform specific calculations on the range A4:A10.

Rate this question:

• 13.

### When working with validation, you can only filter one column at a time.

• A.

True

• B.

False

B. False
Explanation
When working with validation, you can filter multiple columns at a time. This allows you to apply validation rules and criteria to multiple columns simultaneously, making the process more efficient and effective.

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 17, 2023
Quiz Edited by
ProProfs Editorial Team
• Jun 02, 2015
Quiz Created by