1. What does the IF function in Excel do?
A. Checks whether a condition is true or false, and returns
different values based on the result
B. Adds two numbers together
C. Returns the highest value in a range
D. Calculates the sum of values in a specified range
Answer: A) Checks whether a condition is true or false, and
returns different values based on the result
Rationale: The IF function tests a condition and returns one value
if true and another if false.
2. How do you start a formula in Excel?
A. By typing an equal sign (=)
B. By typing a plus sign (+)
C. By typing a dollar sign ($)
D. By typing a question mark (?)
Answer: A) By typing an equal sign (=)
Rationale: Formulas in Excel always begin with the equal sign (=)
to indicate that the content is a formula.
,3. What is the function of the CONCAT function in Excel?
A. Concatenates (joins) two or more text strings
B. Converts text to uppercase
C. Calculates the average of a range
D. Reverses the order of text characters
Answer: A) Concatenates (joins) two or more text strings
Rationale: The CONCAT function joins multiple text strings into
one.
4. How do you apply a filter to a range of data in Excel?
A. Select the range and click Filter in the Data tab
B. Right-click the range and select Apply Filter
C. Click on the Home tab and select Sort & Filter
D. Use the shortcut Ctrl + F
Answer: A) Select the range and click Filter in the Data tab
Rationale: To apply a filter to a data range, select the range and
use the Filter option in the Data tab.
5. Which of the following is NOT a valid data type in Excel?
A. Text
B. Boolean
C. Date
, D. Sound
Answer: D) Sound
Rationale: Excel supports text, Boolean, and date data types, but
not sound as a native data type.
6. What does the PMT function in Excel calculate?
A. The interest rate of a loan
B. The payment for a loan based on constant payments and a
constant interest rate
C. The total cost of a loan
D. The number of periods for a loan
Answer: B) The payment for a loan based on constant payments
and a constant interest rate
Rationale: The PMT function calculates the periodic payment for
a loan based on constant interest and payment periods.
7. Which function would you use to calculate the highest value in
a range of numbers?
A. =SUM()
B. =AVERAGE()
C. =MAX()
D. =MIN()
Answer: C) =MAX()
A. Checks whether a condition is true or false, and returns
different values based on the result
B. Adds two numbers together
C. Returns the highest value in a range
D. Calculates the sum of values in a specified range
Answer: A) Checks whether a condition is true or false, and
returns different values based on the result
Rationale: The IF function tests a condition and returns one value
if true and another if false.
2. How do you start a formula in Excel?
A. By typing an equal sign (=)
B. By typing a plus sign (+)
C. By typing a dollar sign ($)
D. By typing a question mark (?)
Answer: A) By typing an equal sign (=)
Rationale: Formulas in Excel always begin with the equal sign (=)
to indicate that the content is a formula.
,3. What is the function of the CONCAT function in Excel?
A. Concatenates (joins) two or more text strings
B. Converts text to uppercase
C. Calculates the average of a range
D. Reverses the order of text characters
Answer: A) Concatenates (joins) two or more text strings
Rationale: The CONCAT function joins multiple text strings into
one.
4. How do you apply a filter to a range of data in Excel?
A. Select the range and click Filter in the Data tab
B. Right-click the range and select Apply Filter
C. Click on the Home tab and select Sort & Filter
D. Use the shortcut Ctrl + F
Answer: A) Select the range and click Filter in the Data tab
Rationale: To apply a filter to a data range, select the range and
use the Filter option in the Data tab.
5. Which of the following is NOT a valid data type in Excel?
A. Text
B. Boolean
C. Date
, D. Sound
Answer: D) Sound
Rationale: Excel supports text, Boolean, and date data types, but
not sound as a native data type.
6. What does the PMT function in Excel calculate?
A. The interest rate of a loan
B. The payment for a loan based on constant payments and a
constant interest rate
C. The total cost of a loan
D. The number of periods for a loan
Answer: B) The payment for a loan based on constant payments
and a constant interest rate
Rationale: The PMT function calculates the periodic payment for
a loan based on constant interest and payment periods.
7. Which function would you use to calculate the highest value in
a range of numbers?
A. =SUM()
B. =AVERAGE()
C. =MAX()
D. =MIN()
Answer: C) =MAX()
