Please keep at least one language enabled. || కనీసం ఒక భాషను ఎంచుకోండి.
Question 1
ప్రశ్న 1
Which symbol normally indicates the beginning of a formula in Microsoft Excel?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• An Excel formula normally begins with an equal sign (=).
• The equal sign tells Excel to interpret the following characters as a formula rather than ordinary cell content.
• The formula can then contain constants, cell references, operators and functions.
• The equal sign tells Excel to interpret the following characters as a formula rather than ordinary cell content.
• The formula can then contain constants, cell references, operators and functions.
వివరణ:
Question 2
ప్రశ్న 2
Which arithmetic operator is used for exponentiation in an Excel formula?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• The caret symbol (^) is Excel's exponentiation operator.
• For example, =2^3 calculates 2 raised to the power 3 and returns 8.
• The asterisk is used for multiplication, while the slash is used for division.
• For example, =2^3 calculates 2 raised to the power 3 and returns 8.
• The asterisk is used for multiplication, while the slash is used for division.
వివరణ:
Question 3
ప్రశ్న 3
What is the result of the Excel formula =5+2*3?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Excel follows operator precedence when evaluating formulas.
• Multiplication is performed before addition, so 2*3 = 6 first.
• Excel then calculates 5+6 = 11.
• Multiplication is performed before addition, so 2*3 = 6 first.
• Excel then calculates 5+6 = 11.
వివరణ:
Question 4
ప్రశ్న 4
What is the result of the Excel formula =(5+2)*3?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Parentheses force Excel to evaluate the enclosed expression first.
• Therefore 5+2 = 7 is calculated before multiplication.
• The final result is 7*3 = 21.
• Therefore 5+2 = 7 is calculated before multiplication.
• The final result is 7*3 = 21.
వివరణ:
Question 5
ప్రశ్న 5
Which of the following is a relative cell reference in the standard Excel A1 reference style?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• B5 is a relative reference because neither the column nor the row is locked with a dollar sign.
• Relative references adjust when a formula is copied or filled to another location.
• $B$5 is absolute, while $B5 and B$5 are mixed references.
• Relative references adjust when a formula is copied or filled to another location.
• $B$5 is absolute, while $B5 and B$5 are mixed references.
వివరణ:
Question 6
ప్రశ్న 6
Which Excel reference keeps both its column and row fixed when a formula is copied to another cell?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• $A$1 is an absolute reference because both the column A and Row 1 are preceded by dollar signs.
• Copying a formula containing $A$1 does not change that reference.
• A1 is fully relative, while $A1 and A$1 lock only one component.
• Copying a formula containing $A$1 does not change that reference.
• A1 is fully relative, while $A1 and A$1 lock only one component.
వివరణ:
Question 7
ప్రశ్న 7
Which reference has a relative column but an absolute row in Excel?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• B$3 has no dollar sign before B, so its column is relative.
• The dollar sign before 3 locks the row, making Row 3 absolute.
• This is therefore a mixed reference with a relative column and fixed row.
• The dollar sign before 3 locks the row, making Row 3 absolute.
• This is therefore a mixed reference with a relative column and fixed row.
వివరణ:
Question 8
ప్రశ్న 8
Which Excel reference has an absolute column but a relative row?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• $C7 locks Column C because a dollar sign appears before the column identifier.
• Row 7 has no dollar sign and therefore remains relative.
• This is a mixed reference with an absolute column and relative row.
• Row 7 has no dollar sign and therefore remains relative.
• This is a mixed reference with an absolute column and relative row.
వివరణ:
Question 9
ప్రశ్న 9
Cell C2 contains the formula =A2+B2. If the formula is copied down one row from C2 to C3, what will the copied formula normally become?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• A2 and B2 are relative references.
• Copying the formula one row downward changes each relative row number by one.
• Therefore =A2+B2 becomes =A3+B3.
• Copying the formula one row downward changes each relative row number by one.
• Therefore =A2+B2 becomes =A3+B3.
వివరణ:
Question 10
ప్రశ్న 10
Cell C2 contains the formula =$A$2+B2. If it is copied one column to the right into D2, what will the formula become?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• $A$2 is absolute, so it remains unchanged when the formula is copied.
• B2 is relative and the formula moves one column to the right, so B2 changes to C2.
• The resulting formula is therefore =$A$2+C2.
• B2 is relative and the formula moves one column to the right, so B2 changes to C2.
• The resulting formula is therefore =$A$2+C2.
వివరణ:
Question 11
ప్రశ్న 11
Cell D4 contains the formula =$B4+C$2. It is copied two columns to the right and three rows down into F7. What will the copied formula be?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• In $B4, Column B is absolute but Row 4 is relative; moving three rows down changes it to $B7.
• In C$2, Column C is relative but Row 2 is absolute; moving two columns right changes it to E$2.
• Therefore the copied formula becomes =$B7+E$2.
• In C$2, Column C is relative but Row 2 is absolute; moving two columns right changes it to E$2.
• Therefore the copied formula becomes =$B7+E$2.
వివరణ:
Question 12
ప్రశ్న 12
In desktop Excel for Windows, which key is commonly used while editing a formula to cycle a selected cell reference through relative, absolute and mixed reference forms?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• F4 can cycle a selected formula reference through relative, absolute and mixed-reference combinations in desktop Excel for Windows.
• For example, A1 can cycle through forms such as $A$1, A$1 and $A1.
• This provides a faster alternative to typing the dollar signs manually.
• For example, A1 can cycle through forms such as $A$1, A$1 and $A1.
• This provides a faster alternative to typing the dollar signs manually.
వివరణ:
Question 13
ప్రశ్న 13
Which operator is used to concatenate, or join, text values in an Excel formula?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• The ampersand (&) is Excel's text-concatenation operator.
• For example, ="Telangana"&" Police" produces the text Telangana Police.
• The other listed symbols perform arithmetic operations rather than text concatenation.
• For example, ="Telangana"&" Police" produces the text Telangana Police.
• The other listed symbols perform arithmetic operations rather than text concatenation.
వివరణ:
Question 14
ప్రశ్న 14
Which comparison operator means 'not equal to' in an Excel formula?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Excel uses as the not-equal comparison operator.
• For example, =A1B1 evaluates whether the values in A1 and B1 are different.
• Operators such as != and == are used in some programming languages but are not Excel's standard not-equal and equality operators.
• For example, =A1B1 evaluates whether the values in A1 and B1 are different.
• Operators such as != and == are used in some programming languages but are not Excel's standard not-equal and equality operators.
వివరణ:
Question 15
ప్రశ్న 15
In the Excel reference A1:D5, what is the purpose of the colon (:)?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• The colon is Excel's range reference operator.
• A1:D5 refers to the rectangular range beginning at A1 and ending at D5, including both endpoints and the cells between them.
• The colon does not perform arithmetic or convert references to absolute form.
• A1:D5 refers to the rectangular range beginning at A1 and ending at D5, including both endpoints and the cells between them.
• The colon does not perform arithmetic or convert references to absolute form.
వివరణ:
Question 16
ప్రశ్న 16
What is the result of the Excel formula =200*10%?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• In Excel, 10% represents the numeric value 0.10.
• The formula therefore calculates 200*0.10.
• The result is 20.
• The formula therefore calculates 200*0.10.
• The result is 20.
వివరణ:
Question 17
ప్రశ్న 17
Consider the following statements about Excel cell references:
1. Relative references normally adjust when a formula is copied.
2. $A$1 is an absolute reference.
3. $A1 fixes the row but allows the column to change.
4. A$1 fixes the row while allowing the column to change.
Which statements are correct?
1. Relative references normally adjust when a formula is copied.
2. $A$1 is an absolute reference.
3. $A1 fixes the row but allows the column to change.
4. A$1 fixes the row while allowing the column to change.
Which statements are correct?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Statement 1 is correct because relative references adjust according to the formula's new location when copied.
• Statement 2 is correct, and Statement 4 correctly describes A$1 as a relative column with an absolute row.
• Statement 3 is false because $A1 fixes Column A, not the row.
• Statement 2 is correct, and Statement 4 correctly describes A$1 as a relative column with an absolute row.
• Statement 3 is false because $A1 fixes Column A, not the row.
వివరణ:
Question 18
ప్రశ్న 18
Assertion (A): The reference $D$8 remains $D$8 when a formula containing it is copied to another cell.
Reason (R): Dollar signs before both the column and row make $D$8 an absolute reference.
Choose the correct answer.
Reason (R): Dollar signs before both the column and row make $D$8 an absolute reference.
Choose the correct answer.
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• $D$8 is an absolute cell reference because both its column and row are locked.
• Copying a formula does not adjust the locked Column D or Row 8 components.
• Both statements are therefore true, and the Reason correctly explains the Assertion.
• Copying a formula does not adjust the locked Column D or Row 8 components.
• Both statements are therefore true, and the Reason correctly explains the Assertion.
వివరణ:
Question 19
ప్రశ్న 19
Match List I with List II:
List I
(a) A1
(b) $A$1
(c) $A1
(d) A$1
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) A1
(b) $A$1
(c) $A1
(d) A$1
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:
• A1 is fully relative, giving (a)-3, while $A$1 is fully absolute, giving (b)-4.
• $A1 locks only the column, giving (c)-1.
• A$1 locks only the row, giving (d)-2.
• $A1 locks only the column, giving (c)-1.
• A$1 locks only the row, giving (d)-2.
వివరణ:
Question 20
ప్రశ్న 20
Cell C5 contains the formula =A$1+$B5. The formula is copied two columns to the right and three rows down into E8. What will the copied formula be?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• A$1 has a relative column and absolute row; moving two columns right changes A to C while Row 1 remains fixed, producing C$1.
• $B5 has an absolute column and relative row; moving three rows down keeps Column B fixed and changes Row 5 to Row 8, producing $B8.
• Therefore the copied formula is =C$1+$B8.
• $B5 has an absolute column and relative row; moving three rows down keeps Column B fixed and changes Row 5 to Row 8, producing $B8.
• Therefore the copied formula is =C$1+$B8.
వివరణ:
Answer Key సమాధానాల పట్టిక
-
Question 1 ప్రశ్న 1Answer: B. = సమాధానం: B.
-
Question 2 ప్రశ్న 2Answer: D. ^ సమాధానం: D.
-
Question 3 ప్రశ్న 3Answer: A. 11 సమాధానం: A.
-
Question 4 ప్రశ్న 4Answer: C. 21 సమాధానం: C.
-
Question 5 ప్రశ్న 5Answer: A. B5 సమాధానం: A.
-
Question 6 ప్రశ్న 6Answer: C. $A$1 సమాధానం: C.
-
Question 7 ప్రశ్న 7Answer: D. B$3 సమాధానం: D.
-
Question 8 ప్రశ్న 8Answer: B. $C7 సమాధానం: B.
-
Question 9 ప్రశ్న 9Answer: C. =A3+B3 సమాధానం: C.
-
Question 10 ప్రశ్న 10Answer: A. =$A$2+C2 సమాధానం: A.
-
Question 11 ప్రశ్న 11Answer: D. =$B7+E$2 సమాధానం: D.
-
Question 12 ప్రశ్న 12Answer: B. F4 సమాధానం: B.
-
Question 13 ప్రశ్న 13Answer: B. & సమాధానం: B.
-
Question 14 ప్రశ్న 14Answer: D. సమాధానం: D.
-
Question 15 ప్రశ్న 15Answer: C. It acts as a range operator referring to all cells from A1 through D5. సమాధానం: C.
-
Question 16 ప్రశ్న 16Answer: A. 20 సమాధానం: A.
-
Question 17 ప్రశ్న 17Answer: C. 1, 2 and 4 only సమాధానం: C.
-
Question 18 ప్రశ్న 18Answer: B. Both Assertion and Reason are true, and Reason is the correct explanation of Assertion. సమాధానం: B.
-
Question 19 ప్రశ్న 19Answer: A. (a)-3, (b)-4, (c)-1, (d)-2 సమాధానం: A.
-
Question 20 ప్రశ్న 20Answer: D. =C$1+$B8 సమాధానం: D.