Excel 2007 Intermediate Course Short Quiz

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

True

False

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

Explanation

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

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

True

False

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.

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.

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

True

False

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.

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.

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

True

False

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.

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.

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

True

False

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.

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.

6. 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

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.

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.

7. 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

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.

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.

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

True

False

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.

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.

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

True

False

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.

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.

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

True

False

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.

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.

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

False

True

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.

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.

12. 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

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.

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.