Please keep at least one language enabled. || కనీసం ఒక భాషను ఎంచుకోండి.
Question 1
ప్రశ్న 1
Cells B2 and C2 contain 15 and 4 respectively. What is the result of the Excel formula =B2*C2+5?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Excel performs multiplication before addition according to operator precedence.
• B2*C2 is calculated first: 15*4 = 60.
• Excel then calculates 60+5 = 65.
• B2*C2 is calculated first: 15*4 = 60.
• Excel then calculates 60+5 = 65.
వివరణ:
Question 2
ప్రశ్న 2
Cells A1, A2 and A3 contain 10, 20 and 30 respectively, while B1 contains 5. What is the result of =SUM(A1:A3)+B1?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• SUM(A1:A3) adds 10+20+30 and returns 60.
• The formula then adds the value 5 stored in B1.
• Therefore the final result is 60+5 = 65.
• The formula then adds the value 5 stored in B1.
• Therefore the final result is 60+5 = 65.
వివరణ:
Question 3
ప్రశ్న 3
Cell D4 contains the formula =B2+C3. If this formula is copied to F6, what will the copied formula become?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Copying D4 to F6 moves the formula two columns to the right and two rows down.
• B2 is a relative reference, so it moves two columns right and two rows down to D4.
• C3 also moves by the same displacement to E5, producing =D4+E5.
• B2 is a relative reference, so it moves two columns right and two rows down to D4.
• C3 also moves by the same displacement to E5, producing =D4+E5.
వివరణ:
Question 4
ప్రశ్న 4
Cell C3 contains the formula =$A1+B$2. If it is copied to E5, what will the copied formula be?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• The copy from C3 to E5 moves two columns right and two rows down.
• In $A1, Column A is fixed but the row is relative, so it becomes $A3.
• In B$2, Row 2 is fixed but the column is relative, so B moves two columns right to D, producing D$2.
• In $A1, Column A is fixed but the row is relative, so it becomes $A3.
• In B$2, Row 2 is fixed but the column is relative, so B moves two columns right to D, producing D$2.
వివరణ:
Question 5
ప్రశ్న 5
Cell B4 contains 25 and cell C1 contains 12%. If D4 contains the formula =B4*$C$1, what result will D4 return?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• The percentage value 12% is numerically equivalent to 0.12 in the calculation.
• The formula therefore evaluates 25*0.12.
• 25*0.12 = 3, so D4 returns 3.
• The formula therefore evaluates 25*0.12.
• 25*0.12 = 3, so D4 returns 3.
వివరణ:
Question 6
ప్రశ్న 6
Cell C2 contains the formula =A2*$E$1, where E1 contains 8%. The formula is copied down to C3, and A3 contains 3000. What result will C3 return?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• A2 is relative, so copying the formula one row down changes it to A3.
• $E$1 is absolute and therefore remains $E$1, containing 8% or 0.08.
• The copied formula calculates 3000*0.08 = 240.
• $E$1 is absolute and therefore remains $E$1, containing 8% or 0.08.
• The copied formula calculates 3000*0.08 = 240.
వివరణ:
Question 7
ప్రశ్న 7
Cell E3 contains the formula =$B3+C$1. If the formula is copied to G6, what will it become?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Moving E3 to G6 shifts the formula two columns right and three rows down.
• $B3 has an absolute column and relative row, so it becomes $B6.
• C$1 has a relative column and absolute row, so it becomes E$1, giving =$B6+E$1.
• $B3 has an absolute column and relative row, so it becomes $B6.
• C$1 has a relative column and absolute row, so it becomes E$1, giving =$B6+E$1.
వివరణ:
Question 8
ప్రశ్న 8
Cell D2 contains =SUM(A2:C2). If the formula is copied to F4, which formula will appear in F4?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• D2 to F4 is a movement of two columns right and two rows down.
• Both endpoints A2 and C2 are relative references, so both move by that same displacement.
• A2 becomes C4 and C2 becomes E4, producing =SUM(C4:E4).
• Both endpoints A2 and C2 are relative references, so both move by that same displacement.
• A2 becomes C4 and C2 becomes E4, producing =SUM(C4:E4).
వివరణ:
Question 9
ప్రశ్న 9
Cells B2 and C2 contain 120 and 15 respectively. What is the result of the formula =B2-C2*2?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Multiplication has higher precedence than subtraction in Excel formulas.
• Excel first calculates C2*2 = 15*2 = 30.
• It then calculates 120-30 = 90.
• Excel first calculates C2*2 = 15*2 = 30.
• It then calculates 120-30 = 90.
వివరణ:
Question 10
ప్రశ్న 10
Cell E2 contains the formula =($A$1+B2)*C$1. If it is copied to G4, what will the copied formula become?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• E2 to G4 moves the formula two columns right and two rows down.
• $A$1 is completely absolute and remains unchanged, while B2 is fully relative and becomes D4.
• C$1 has a relative column and fixed row, so it becomes E$1, giving =($A$1+D4)*E$1.
• $A$1 is completely absolute and remains unchanged, while B2 is fully relative and becomes D4.
• C$1 has a relative column and fixed row, so it becomes E$1, giving =($A$1+D4)*E$1.
వివరణ:
Question 11
ప్రశ్న 11
Cell C5 contains the formula =A$1+$B5. If it is copied to F8, what will the formula become?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• C5 to F8 moves three columns right and three rows down.
• A$1 has a relative column and absolute row, so it becomes D$1.
• $B5 has an absolute column and relative row, so it becomes $B8, producing =D$1+$B8.
• A$1 has a relative column and absolute row, so it becomes D$1.
• $B5 has an absolute column and relative row, so it becomes $B8, producing =D$1+$B8.
వివరణ:
Question 12
ప్రశ్న 12
Cell D1 contains the formula =A1+B$1+$C1. If it is copied one column right and one row down to E2, what will the formula become?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• A1 is fully relative, so moving one column right and one row down changes it to B2.
• B$1 has a relative column and fixed row, so it becomes C$1.
• $C1 has a fixed column and relative row, so it becomes $C2, producing =B2+C$1+$C2.
• B$1 has a relative column and fixed row, so it becomes C$1.
• $C1 has a fixed column and relative row, so it becomes $C2, producing =B2+C$1+$C2.
వివరణ:
Question 13
ప్రశ్న 13
Cells A1, B1 and C1 contain 5, 4 and 3 respectively. What is the result of =A1+B1*C1?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Excel evaluates multiplication before addition when parentheses do not alter the order.
• B1*C1 is calculated first: 4*3 = 12.
• The final calculation is 5+12 = 17.
• B1*C1 is calculated first: 4*3 = 12.
• The final calculation is 5+12 = 17.
వివరణ:
Question 14
ప్రశ్న 14
Cells A1, B2 and C1 contain 20, 5 and 2 respectively. What is the result of =($A$1+B2)*C$1?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Parentheses require Excel to calculate $A$1+B2 first: 20+5 = 25.
• C$1 contains the value 2.
• The final calculation is 25*2 = 50.
• C$1 contains the value 2.
• The final calculation is 25*2 = 50.
వివరణ:
Question 15
ప్రశ్న 15
Cell B1 contains 10%. Cell C2 contains =A2*(1+$B$1), where A2 contains 500. The formula is copied to C3, where A3 contains 800. What result will C3 return?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• When copied from C2 to C3, relative reference A2 becomes A3 while absolute reference $B$1 remains unchanged.
• $B$1 contains 10%, so 1+$B$1 equals 1.10.
• The copied formula therefore calculates 800*1.10 = 880.
• $B$1 contains 10%, so 1+$B$1 equals 1.10.
• The copied formula therefore calculates 800*1.10 = 880.
వివరణ:
Question 16
ప్రశ్న 16
Cell F4 contains the formula =SUM(B4:D4). If this formula is copied to H6, what will the copied formula be?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Copying F4 to H6 shifts the formula two columns right and two rows down.
• B4 therefore becomes D6, while D4 becomes F6.
• The resulting relative range is =SUM(D6:F6).
• B4 therefore becomes D6, while D4 becomes F6.
• The resulting relative range is =SUM(D6:F6).
వివరణ:
Question 17
ప్రశ్న 17
Consider the following statements about copying Excel formulas:
1. A relative reference normally adjusts when a formula is copied.
2. A fully absolute reference remains fixed when a formula is copied.
3. In $A1, the column is fixed and the row is relative.
4. In A$1, the column is relative and the row is fixed.
Which statements are correct?
1. A relative reference normally adjusts when a formula is copied.
2. A fully absolute reference remains fixed when a formula is copied.
3. In $A1, the column is fixed and the row is relative.
4. In A$1, the column is relative and the row is fixed.
Which statements are correct?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Statement 1 correctly describes relative references, while Statement 2 correctly describes fully absolute references.
• $A1 fixes Column A but permits its row to adjust, so Statement 3 is correct.
• A$1 permits the column to adjust while Row 1 remains fixed, so Statement 4 is also correct.
• $A1 fixes Column A but permits its row to adjust, so Statement 3 is correct.
• A$1 permits the column to adjust while Row 1 remains fixed, so Statement 4 is also correct.
వివరణ:
Question 18
ప్రశ్న 18
Assertion (A): If the formula =B2+C2 in cell D2 is copied one row down to D3, it normally becomes =B3+C3.
Reason (R): B2 and C2 are relative references, so their row numbers adjust by the same one-row displacement as the copied formula.
Choose the correct answer.
Reason (R): B2 and C2 are relative references, so their row numbers adjust by the same one-row displacement as the copied formula.
Choose the correct answer.
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• B2 and C2 contain no dollar signs and are therefore relative references.
• Copying the formula from D2 to D3 moves it one row downward, so both referenced rows also increase by one.
• Both statements are true, and the Reason correctly explains why the copied formula becomes =B3+C3.
• Copying the formula from D2 to D3 moves it one row downward, so both referenced rows also increase by one.
• Both statements are true, and the Reason correctly explains why the copied formula becomes =B3+C3.
వివరణ:
Question 19
ప్రశ్న 19
Match List I with List II:
List I
(a) B4
(b) $B$4
(c) $B4
(d) B$4
List II
1. Absolute column, relative row
2. Relative column, absolute row
3. Relative column, relative row
4. Absolute column, absolute row
Choose the correct matching code.
List I
(a) B4
(b) $B$4
(c) $B4
(d) B$4
List II
1. Absolute column, relative row
2. Relative column, absolute row
3. Relative column, relative row
4. Absolute column, absolute row
Choose the correct matching code.
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• B4 has neither component locked and is therefore relative column/relative row, giving (a)-3.
• $B$4 locks both components, giving (b)-4, while $B4 locks only the column, giving (c)-1.
• B$4 locks only the row, giving (d)-2.
• $B$4 locks both components, giving (b)-4, while $B4 locks only the column, giving (c)-1.
• B$4 locks only the row, giving (d)-2.
వివరణ:
Question 20
ప్రశ్న 20
Cell C2 contains the formula =A2*$B$1. Cell B1 contains 4. The formula is copied from C2 to C4, where A4 contains 30. What result will C4 return?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Copying C2 to C4 changes relative reference A2 to A4 because the formula moves two rows downward.
• Absolute reference $B$1 remains fixed and continues to refer to the value 4.
• The copied formula is =A4*$B$1, so the result is 30*4 = 120.
• Absolute reference $B$1 remains fixed and continues to refer to the value 4.
• The copied formula is =A4*$B$1, so the result is 30*4 = 120.
వివరణ:
Answer Key సమాధానాల పట్టిక
-
Question 1 ప్రశ్న 1Answer: D. 65 సమాధానం: D.
-
Question 2 ప్రశ్న 2Answer: B. 65 సమాధానం: B.
-
Question 3 ప్రశ్న 3Answer: A. =D4+E5 సమాధానం: A.
-
Question 4 ప్రశ్న 4Answer: C. =$A3+D$2 సమాధానం: C.
-
Question 5 ప్రశ్న 5Answer: C. 3 సమాధానం: C.
-
Question 6 ప్రశ్న 6Answer: A. 240 సమాధానం: A.
-
Question 7 ప్రశ్న 7Answer: B. =$B6+E$1 సమాధానం: B.
-
Question 8 ప్రశ్న 8Answer: D. =SUM(C4:E4) సమాధానం: D.
-
Question 9 ప్రశ్న 9Answer: A. 90 సమాధానం: A.
-
Question 10 ప్రశ్న 10Answer: C. =($A$1+D4)*E$1 సమాధానం: C.
-
Question 11 ప్రశ్న 11Answer: D. =D$1+$B8 సమాధానం: D.
-
Question 12 ప్రశ్న 12Answer: B. =B2+C$1+$C2 సమాధానం: B.
-
Question 13 ప్రశ్న 13Answer: C. 17 సమాధానం: C.
-
Question 14 ప్రశ్న 14Answer: A. 50 సమాధానం: A.
-
Question 15 ప్రశ్న 15Answer: B. 880 సమాధానం: B.
-
Question 16 ప్రశ్న 16Answer: D. =SUM(D6:F6) సమాధానం: D.
-
Question 17 ప్రశ్న 17Answer: B. 1, 2, 3 and 4 సమాధానం: B.
-
Question 18 ప్రశ్న 18Answer: C. Both Assertion and Reason are true, and Reason is the correct explanation of Assertion. సమాధానం: C.
-
Question 19 ప్రశ్న 19Answer: A. (a)-3, (b)-4, (c)-1, (d)-2 సమాధానం: A.
-
Question 20 ప్రశ్న 20Answer: D. 120 సమాధానం: D.