Excel 2007 Intermediate Course Short 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 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: 585

| Attempts: 427

Questions

Feedback

During the Quiz End of Quiz

Difficulty

Sequential Easy First Hard First

Share on Facebook Share on Twitter Share on Whatsapp Share on Pinterest Share on Email Copy to Clipboard Embed on your website

1/13 Questions

Your Name

About This Quiz

This short quiz for the Excel 2007 Intermediate Course assesses key functionalities such as formula calculation, cell operations, and data management. It verifies understanding of Excel's features like conditional formatting, duplicate management, and data entry restrictions.

2.

A formula cannot contain any of the following: functions, references, operators, and constants.
- True
- False
Correct Answer

A. 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.
- True
- False
Correct Answer

A. 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
- True
- False
Correct Answer

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
- True
- False
Correct Answer

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
- False
- True
Correct Answer

A. 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
- True
- False
Correct Answer

A. 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
- True
- False
Correct Answer

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.
- True
- False
Correct Answer

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.
- True
- False
Correct Answer

A. 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.
- True
- False
Correct Answer

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?
- =SUM(A4:A10)
- =AVERAGE(A4:A10)
- =MIN(A4:A10)
- =A4:A10
- Not Sure
Correct Answer

A. =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.
- True
- False
Correct Answer

A. 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 (Updated): Mar 17, 2023 +

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
Ria Madonna

Excel 2007 Intermediate Course Short Quiz

Your Name

Quiz Preview

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

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

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

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

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

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

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

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

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

You can use numbers or cell references in formulas.

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

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