Excel 2007 Intermediate Course Short 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.
Questions and Answers
- 1.
Your Name
- 2.
A formula cannot contain any of the following: functions, references, operators, and constants.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
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
Correct Answer
B. FalseExplanation
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
Correct Answer
A. TrueExplanation
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
Correct Answer
A. TrueExplanation
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
Correct Answer
B. TrueExplanation
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
Correct Answer
B. FalseExplanation
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
Correct Answer
A. TrueExplanation
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
Correct Answer
A. TrueExplanation
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
Correct Answer
B. FalseExplanation
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
Correct Answer
A. TrueExplanation
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
Correct Answer
D. =A4:A10Explanation
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
Correct Answer
B. FalseExplanation
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, 2023Quiz Edited by
ProProfs Editorial Team -
Jun 02, 2015Quiz Created by
Ria Madonna
Back to top