1.
Your Name
2.
A formula cannot contain any of the following: functions, references, operators, and constants.
Correct Answer
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.
3.
Excel calculates the formula from right to left, according to a specific order for each operator in the formula.
Correct Answer
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.
4.
Splitting cells content based on a column break is applicable if your data to be separated have a fixed column break location
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.
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
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.
6.
You can use conditional formatting if you want to check if there are duplicate values in the range of cells
Correct Answer
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.
7.
If you want to restrict data entry to a certain range of cells you will use paste special feature in Excel
Correct Answer
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.
8.
To change the order of evaluation, enclose in parentheses the part of the formula to be calculated first
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.
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.
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.
10.
You can change column width, but you cannot change row height.
Correct Answer
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.
11.
You can use numbers or cell references in formulas.
Correct Answer
A. True
Explanation
The given correct answer is "True." This means that the statement or question being asked is true or accurate.
12.
Which of the following is not an example of an Excel function?
Correct Answer
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.
13.
When working with validation, you can only filter one column at a time.
Correct Answer
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.