Please keep at least one language enabled. || కనీసం ఒక భాషను ఎంచుకోండి.
Question 1
ప్రశ్న 1
Which Excel function is specifically designed to add numbers supplied as individual arguments, cell references or ranges?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• SUM adds numbers supplied as arguments, including individual values, cell references and ranges.
• For example, =SUM(A1:A5) adds the numeric values in cells A1 through A5.
• PRODUCT multiplies values, ROUND performs rounding and ABS returns an absolute value.
• For example, =SUM(A1:A5) adds the numeric values in cells A1 through A5.
• PRODUCT multiplies values, ROUND performs rounding and ABS returns an absolute value.
వివరణ:
Question 2
ప్రశ్న 2
What is the result of the Excel formula =PRODUCT(2,3,4)?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• PRODUCT multiplies all numerical arguments supplied to the function.
• The calculation is 2 × 3 × 4 = 24.
• Therefore =PRODUCT(2,3,4) returns 24.
• The calculation is 2 × 3 × 4 = 24.
• Therefore =PRODUCT(2,3,4) returns 24.
వివరణ:
Question 3
ప్రశ్న 3
What is the result of the Excel formula =ROUND(12.345,2)?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• ROUND(number, num_digits) rounds a number to the specified number of digits.
• A num_digits value of 2 requests two decimal places.
• Since the third decimal digit in 12.345 is 5, Excel rounds the value to 12.35.
• A num_digits value of 2 requests two decimal places.
• Since the third decimal digit in 12.345 is 5, Excel rounds the value to 12.35.
వివరణ:
Question 4
ప్రశ్న 4
What value is returned by the Excel formula =ABS(-27)?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• ABS returns the absolute value, or unsigned magnitude, of a number.
• The absolute value of -27 is 27.
• ABS does not merely remove a value or convert every input to zero.
• The absolute value of -27 is 27.
• ABS does not merely remove a value or convert every input to zero.
వివరణ:
Question 5
ప్రశ్న 5
Cells A1, A2, A3 and A4 contain 5, 10, 15 and 20 respectively. What is the result of =SUM(A1:A4)?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• A1:A4 represents the continuous range containing 5, 10, 15 and 20.
• SUM adds these values: 5 + 10 + 15 + 20 = 50.
• Therefore the formula returns 50.
• SUM adds these values: 5 + 10 + 15 + 20 = 50.
• Therefore the formula returns 50.
వివరణ:
Question 6
ప్రశ్న 6
Cells B1:B4 contain the values 2, 5, 3 and 4. What does the formula =PRODUCT(B1:B4) return?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• PRODUCT multiplies all numeric values in the referenced range.
• The calculation is 2 × 5 × 3 × 4 = 120.
• The function therefore returns 120.
• The calculation is 2 × 5 × 3 × 4 = 120.
• The function therefore returns 120.
వివరణ:
Question 7
ప్రశ్న 7
What is the result of =ROUND(1265.49,-2) in Excel?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• A negative num_digits value causes ROUND to round to positions to the left of the decimal point.
• Using -2 rounds the number to the nearest hundred.
• 1265.49 is nearer to 1300 than to 1200, so the result is 1300.
• Using -2 rounds the number to the nearest hundred.
• 1265.49 is nearer to 1300 than to 1200, so the result is 1300.
వివరణ:
Question 8
ప్రశ్న 8
What result does Excel return for =ROUND(12.5,0)?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• A num_digits value of 0 tells ROUND to return the nearest integer.
• Excel's ROUND function rounds a halfway value away from zero.
• Therefore 12.5 is rounded to 13.
• Excel's ROUND function rounds a halfway value away from zero.
• Therefore 12.5 is rounded to 13.
వివరణ:
Question 9
ప్రశ్న 9
What is the result of the Excel formula =ABS(5-12)?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Excel first evaluates the expression inside ABS: 5 - 12 = -7.
• ABS then returns the unsigned magnitude of -7.
• Therefore the final result is 7.
• ABS then returns the unsigned magnitude of -7.
• Therefore the final result is 7.
వివరణ:
Question 10
ప్రశ్న 10
Which Excel formula correctly returns the positive square root of 144?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• SQRT(number) returns the positive square root of the supplied number.
• Since 12 × 12 = 144, =SQRT(144) returns 12.
• ABS, PRODUCT and ROUND perform different mathematical operations.
• Since 12 × 12 = 144, =SQRT(144) returns 12.
• ABS, PRODUCT and ROUND perform different mathematical operations.
వివరణ:
Question 11
ప్రశ్న 11
What is the result of the Excel formula =POWER(3,4)?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• POWER(number, power) raises the first argument to the exponent specified by the second argument.
• POWER(3,4) therefore means 3⁴.
• The calculation 3 × 3 × 3 × 3 equals 81.
• POWER(3,4) therefore means 3⁴.
• The calculation 3 × 3 × 3 × 3 equals 81.
వివరణ:
Question 12
ప్రశ్న 12
What does the Excel formula =MOD(29,6) return?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• MOD returns the remainder after one number is divided by another.
• Dividing 29 by 6 gives 4 complete groups because 6 × 4 = 24.
• The remainder is 29 - 24 = 5, so =MOD(29,6) returns 5.
• Dividing 29 by 6 gives 4 complete groups because 6 × 4 = 24.
• The remainder is 29 - 24 = 5, so =MOD(29,6) returns 5.
వివరణ:
Question 13
ప్రశ్న 13
What is the result of the Excel formula =QUOTIENT(29,6)?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• QUOTIENT returns the integer portion of a division and discards the remainder.
• 29 ÷ 6 equals 4 with a remainder of 5.
• Therefore =QUOTIENT(29,6) returns 4, whereas ordinary division would return a decimal value.
• 29 ÷ 6 equals 4 with a remainder of 5.
• Therefore =QUOTIENT(29,6) returns 4, whereas ordinary division would return a decimal value.
వివరణ:
Question 14
ప్రశ్న 14
What value is returned by the Excel formula =INT(8.9)?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• INT rounds a number down to the nearest integer.
• The greatest integer less than or equal to 8.9 is 8.
• Therefore =INT(8.9) returns 8.
• The greatest integer less than or equal to 8.9 is 8.
• Therefore =INT(8.9) returns 8.
వివరణ:
Question 15
ప్రశ్న 15
What is the result of the Excel formula =ROUND(-1.475,2)?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• ROUND(-1.475,2) requests rounding to two decimal places.
• Excel's ROUND function rounds a halfway digit away from zero.
• Therefore -1.475 is rounded to -1.48.
• Excel's ROUND function rounds a halfway digit away from zero.
• Therefore -1.475 is rounded to -1.48.
వివరణ:
Question 16
ప్రశ్న 16
What is the result of the nested Excel formula =SUM(10,20,PRODUCT(2,5))?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Excel first evaluates the nested PRODUCT function: PRODUCT(2,5) = 10.
• The SUM function then evaluates SUM(10,20,10).
• The final result is 10 + 20 + 10 = 40.
• The SUM function then evaluates SUM(10,20,10).
• The final result is 10 + 20 + 10 = 40.
వివరణ:
Question 17
ప్రశ్న 17
Cells A1, A2 and A3 contain 10, 20 and 25. What is the result of =ROUND(SUM(A1:A3)/3,2)?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• SUM(A1:A3) gives 10 + 20 + 25 = 55.
• Dividing by 3 gives 18.333333..., and ROUND(...,2) rounds this to two decimal places.
• The final result is 18.33.
• Dividing by 3 gives 18.333333..., and ROUND(...,2) rounds this to two decimal places.
• The final result is 18.33.
వివరణ:
Question 18
ప్రశ్న 18
Assertion (A): The Excel formula =INT(-3.2) returns -4.
Reason (R): INT rounds a number down to the nearest integer, and for a negative number this can move the result farther away from zero.
Choose the correct answer.
Reason (R): INT rounds a number down to the nearest integer, and for a negative number this can move the result farther away from zero.
Choose the correct answer.
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• INT rounds toward the next lower integer rather than simply deleting the decimal portion.
• The nearest integer in the downward direction from -3.2 is -4.
• Both statements are true, and the Reason correctly explains why =INT(-3.2) returns -4.
• The nearest integer in the downward direction from -3.2 is -4.
• Both statements are true, and the Reason correctly explains why =INT(-3.2) returns -4.
వివరణ:
Question 19
ప్రశ్న 19
Consider the following statements about Excel mathematical functions:
1. SUM adds numerical arguments.
2. PRODUCT multiplies numerical arguments.
3. ABS always converts a positive number into its negative equivalent.
4. ROUND uses a number and a num_digits argument to control rounding.
Which statements are correct?
1. SUM adds numerical arguments.
2. PRODUCT multiplies numerical arguments.
3. ABS always converts a positive number into its negative equivalent.
4. ROUND uses a number and a num_digits argument to control rounding.
Which statements are correct?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Statements 1 and 2 correctly describe SUM and PRODUCT.
• Statement 3 is false because ABS returns the absolute magnitude; a positive input remains positive rather than becoming negative.
• Statement 4 correctly describes the basic ROUND(number, num_digits) syntax, so Statements 1, 2 and 4 are correct.
• Statement 3 is false because ABS returns the absolute magnitude; a positive input remains positive rather than becoming negative.
• Statement 4 correctly describes the basic ROUND(number, num_digits) syntax, so Statements 1, 2 and 4 are correct.
వివరణ:
Question 20
ప్రశ్న 20
Match List I with List II:
List I
(a) SUM
(b) PRODUCT
(c) ABS
(d) ROUND
List II
1. Returns the absolute value of a number
2. Multiplies supplied numerical arguments
3. Rounds a number to a specified number of digits
4. Adds supplied numerical arguments
Choose the correct matching code.
List I
(a) SUM
(b) PRODUCT
(c) ABS
(d) ROUND
List II
1. Returns the absolute value of a number
2. Multiplies supplied numerical arguments
3. Rounds a number to a specified number of digits
4. Adds supplied numerical arguments
Choose the correct matching code.
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• SUM adds its numerical arguments, giving (a)-4, while PRODUCT multiplies them, giving (b)-2.
• ABS returns absolute value, giving (c)-1.
• ROUND rounds a number according to its num_digits argument, giving (d)-3.
• ABS returns absolute value, giving (c)-1.
• ROUND rounds a number according to its num_digits argument, giving (d)-3.
వివరణ:
Answer Key సమాధానాల పట్టిక
-
Question 1 ప్రశ్న 1Answer: D. SUM సమాధానం: D.
-
Question 2 ప్రశ్న 2Answer: A. 24 సమాధానం: A.
-
Question 3 ప్రశ్న 3Answer: C. 12.35 సమాధానం: C.
-
Question 4 ప్రశ్న 4Answer: B. 27 సమాధానం: B.
-
Question 5 ప్రశ్న 5Answer: A. 50 సమాధానం: A.
-
Question 6 ప్రశ్న 6Answer: D. 120 సమాధానం: D.
-
Question 7 ప్రశ్న 7Answer: B. 1300 సమాధానం: B.
-
Question 8 ప్రశ్న 8Answer: C. 13 సమాధానం: C.
-
Question 9 ప్రశ్న 9Answer: C. 7 సమాధానం: C.
-
Question 10 ప్రశ్న 10Answer: A. =SQRT(144) సమాధానం: A.
-
Question 11 ప్రశ్న 11Answer: B. 81 సమాధానం: B.
-
Question 12 ప్రశ్న 12Answer: D. 5 సమాధానం: D.
-
Question 13 ప్రశ్న 13Answer: A. 4 సమాధానం: A.
-
Question 14 ప్రశ్న 14Answer: C. 8 సమాధానం: C.
-
Question 15 ప్రశ్న 15Answer: D. -1.48 సమాధానం: D.
-
Question 16 ప్రశ్న 16Answer: B. 40 సమాధానం: B.
-
Question 17 ప్రశ్న 17Answer: C. 18.33 సమాధానం: C.
-
Question 18 ప్రశ్న 18Answer: D. Both Assertion and Reason are true, and Reason is the correct explanation of Assertion. సమాధానం: D.
-
Question 19 ప్రశ్న 19Answer: B. 1, 2 and 4 only సమాధానం: B.
-
Question 20 ప్రశ్న 20Answer: A. (a)-4, (b)-2, (c)-1, (d)-3 సమాధానం: A.