Please keep at least one language enabled. || కనీసం ఒక భాషను ఎంచుకోండి.
Question 1
ప్రశ్న 1
What is the primary purpose of Data Validation in Microsoft Excel?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Data Validation is used to control the type of data or the values that can be entered into selected cells.
• It can restrict entries by number, date, time, text length, list choices or a custom formula.
• Validation helps improve consistency and reduce invalid data entry in worksheets.
• It can restrict entries by number, date, time, text length, list choices or a custom formula.
• Validation helps improve consistency and reduce invalid data entry in worksheets.
వివరణ:
Question 2
ప్రశ్న 2
Which command path is normally used to create a validation rule for selected cells in current desktop Microsoft Excel?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Excel provides Data Validation on the Data tab.
• After selecting the required cells, Data > Data Validation opens the settings used to define permitted entries.
• The Settings, Input Message and Error Alert options are available as part of the validation configuration.
• After selecting the required cells, Data > Data Validation opens the settings used to define permitted entries.
• The Settings, Input Message and Error Alert options are available as part of the validation configuration.
వివరణ:
Question 3
ప్రశ్న 3
A Marks column must accept only integer values from 1 through 100. Which Data Validation setting is most appropriate?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Whole number validation is specifically intended to restrict entries to integers.
• Using Between with Minimum 1 and Maximum 100 permits integers within the required inclusive range.
• Decimal validation would also permit fractional values and therefore would not satisfy the requirement.
• Using Between with Minimum 1 and Maximum 100 permits integers within the required inclusive range.
• Decimal validation would also permit fractional values and therefore would not satisfy the requirement.
వివరణ:
Question 4
ప్రశ్న 4
A worksheet Status field must permit only the values Pending, Approved and Rejected. Which Data Validation type is most suitable?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• List validation restricts a cell to a defined collection of permitted entries.
• Pending, Approved and Rejected can be supplied as the list source.
• This approach also allows Excel to provide an in-cell drop-down for convenient and consistent selection.
• Pending, Approved and Rejected can be supplied as the list source.
• This approach also allows Excel to provide an in-cell drop-down for convenient and consistent selection.
వివరణ:
Question 5
ప్రశ్న 5
An application form should permit an Appointment_Date only from 1 August 2026 through 31 August 2026. Which validation setup is most appropriate?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Date validation is designed to restrict cells according to valid Excel date values.
• A Between condition can specify 1-Aug-2026 as the start date and 31-Aug-2026 as the end date.
• The other validation categories do not directly test whether the entered value falls within a required date interval.
• A Between condition can specify 1-Aug-2026 as the start date and 31-Aug-2026 as the end date.
• The other validation categories do not directly test whether the entered value falls within a required date interval.
వివరణ:
Question 6
ప్రశ్న 6
An Employee_Code field must contain exactly 8 characters. Which Data Validation configuration directly meets this requirement?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Text Length validation restricts entries according to the number of characters they contain.
• Setting the condition to Equal to 8 requires an entry of exactly eight characters.
• Whole Number validation would test the numerical value rather than the character count.
• Setting the condition to Equal to 8 requires an entry of exactly eight characters.
• Whole Number validation would test the numerical value rather than the character count.
వివరణ:
Question 7
ప్రశ్న 7
A cell must accept numeric measurements from 0 through 1, including fractional values such as 0.25 and 0.75. Which validation type is most appropriate?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Decimal validation permits fractional numeric entries as well as values such as 0 and 1 within the specified limits.
• A Between condition with 0 and 1 permits values such as 0.25 and 0.75.
• Whole number validation would reject those fractional values.
• A Between condition with 0 and 1 permits values such as 0.25 and 0.75.
• Whole number validation would reject those fractional values.
వివరణ:
Question 8
ప్రశ్న 8
After setting Data Validation to List, which option must normally be enabled if the user should be able to choose an item through a drop-down arrow in the cell?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• The In-cell dropdown option controls whether the drop-down arrow appears for a List validation cell.
• When enabled, users can choose an allowed item directly from the displayed list.
• Ignore blank and Input Message have different purposes and do not themselves create the drop-down arrow.
• When enabled, users can choose an allowed item directly from the displayed list.
• Ignore blank and Input Message have different purposes and do not themselves create the drop-down arrow.
వివరణ:
Question 9
ప్రశ్న 9
A worksheet designer wants the message 'Enter an age from 18 to 60' to appear when a user selects a validated Age cell, before any invalid value is entered. Which Data Validation feature should be configured?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• An Input Message provides instructions about permitted data when the validated cell is selected.
• The message can contain a title and explanatory text to guide the user before data entry.
• An Error Alert is instead associated with an attempt to enter data that violates the validation rule.
• The message can contain a title and explanatory text to guide the user before data entry.
• An Error Alert is instead associated with an attempt to enter data that violates the validation rule.
వివరణ:
Question 10
ప్రశ్న 10
Which Data Validation Error Alert style should be used when Excel must prevent a directly typed invalid value from being accepted until the user corrects or cancels the entry?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• The Stop Error Alert style prevents directly typed invalid data from being accepted under the validation rule.
• The user must retry with a valid value or cancel the invalid entry.
• Warning and Information alerts can permit the user to continue with an otherwise invalid entry.
• The user must retry with a valid value or cancel the invalid entry.
• Warning and Information alerts can permit the user to continue with an otherwise invalid entry.
వివరణ:
Question 11
ప్రశ్న 11
What is the behaviour of the Warning style in an Excel Data Validation Error Alert?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• The Warning style informs the user that the entered value does not satisfy the validation rule.
• It provides a choice about whether to continue with the invalid entry.
• This differs from Stop, which is intended to prevent the invalid directly typed value from being accepted.
• It provides a choice about whether to continue with the invalid entry.
• This differs from Stop, which is intended to prevent the invalid directly typed value from being accepted.
వివరణ:
Question 12
ప్రశ్న 12
In a Data Validation rule, what is the effect of enabling the 'Ignore blank' option?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Ignore blank allows blank or null entries under the relevant validation configuration.
• It is useful when a validated field is optional rather than compulsory.
• The option does not fill blank cells with zero or remove validation from nonblank entries.
• It is useful when a validated field is optional rather than compulsory.
• The option does not fill blank cells with zero or remove validation from nonblank entries.
వివరణ:
Question 13
ప్రశ్న 13
Cells A1:A4 contain the following entries: A1 = Status, A2 = Pending, A3 = Approved, A4 = Rejected. If these values are to be used as the source of a Data Validation drop-down and the heading must not appear as a selectable item, which source range should be used?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• The permitted list items are located in A2, A3 and A4.
• A1 contains the field heading Status and should therefore be excluded from the selectable values.
• Using A2:A4 provides exactly Pending, Approved and Rejected as the source entries.
• A1 contains the field heading Status and should therefore be excluded from the selectable values.
• Using A2:A4 provides exactly Pending, Approved and Rejected as the source entries.
వివరణ:
Question 14
ప్రశ్న 14
Cell C2 must accept a Product ID only when it begins with 'ID-' and contains more than 9 characters in total. Which Custom Data Validation formula correctly implements both conditions?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• LEFT(C2,3)="ID-" checks whether the first three characters are exactly ID-.
• LEN(C2)>9 checks that the complete entry contains more than nine characters.
• AND requires both conditions to be true, so the complete formula correctly implements the stated rule.
• LEN(C2)>9 checks that the complete entry contains more than nine characters.
• AND requires both conditions to be true, so the complete formula correctly implements the stated rule.
వివరణ:
Question 15
ప్రశ్న 15
Data Validation is being applied to A2:A10, and duplicate values must be rejected so that each entry in this range remains unique. Which Custom validation formula, entered initially for A2 and then applied appropriately through the range, is suitable?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• COUNTIF($A$2:$A$10,A2) counts how many times the current entry occurs within the full validated range.
• Requiring that count to equal 1 permits an entry only when it occurs once in the range.
• The range is absolute while the second argument is relative so that the current cell reference changes appropriately through A2:A10.
• Requiring that count to equal 1 permits an entry only when it occurs once in the range.
• The range is absolute while the second argument is relative so that the current cell reference changes appropriately through A2:A10.
వివరణ:
Question 16
ప్రశ్న 16
A worksheet already contains some values that violate newly defined validation rules. Which Excel command can visually identify invalid cells by drawing red circles around them?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Circle Invalid Data identifies cells whose current contents do not satisfy their Data Validation criteria.
• Excel marks those cells with red circles so that they can be located and corrected.
• Clear Validation Circles can later remove the visual circles without deleting the cell data.
• Excel marks those cells with red circles so that they can be located and corrected.
• Clear Validation Circles can later remove the visual circles without deleting the cell data.
వివరణ:
Question 17
ప్రశ్న 17
Which statement about Excel Data Validation is accurate?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Excel's validation alerts are primarily designed to control values entered directly into validated cells.
• Microsoft notes that invalid values can still appear through operations such as copying, filling, formula results or macros in some circumstances.
• Circle Invalid Data can be used to locate existing values that fail the validation criteria.
• Microsoft notes that invalid values can still appear through operations such as copying, filling, formula results or macros in some circumstances.
• Circle Invalid Data can be used to locate existing values that fail the validation criteria.
వివరణ:
Question 18
ప్రశ్న 18
Assertion (A): List Data Validation can provide users with a drop-down containing permitted entries from a specified source range.
Reason (R): The List validation type uses its Source setting to define the values that are permitted for the validated cells.
Choose the correct answer.
Reason (R): The List validation type uses its Source setting to define the values that are permitted for the validated cells.
Choose the correct answer.
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• List validation can use a worksheet range containing the permitted entries as its source.
• With the in-cell drop-down enabled, those permitted source values can be presented for user selection.
• Both statements are true, and the Reason directly explains how the List validation rule determines the available entries.
• With the in-cell drop-down enabled, those permitted source values can be presented for user selection.
• Both statements are true, and the Reason directly explains how the List validation rule determines the available entries.
వివరణ:
Question 19
ప్రశ్న 19
Consider the following statements about Excel Data Validation:
1. Whole Number can restrict entries to integers within specified limits.
2. Decimal can permit fractional numeric values within specified limits.
3. Text Length is used primarily to restrict the numerical magnitude of a number rather than the number of characters entered.
4. Custom validation can use a formula to determine whether an entry is valid.
Which statements are correct?
1. Whole Number can restrict entries to integers within specified limits.
2. Decimal can permit fractional numeric values within specified limits.
3. Text Length is used primarily to restrict the numerical magnitude of a number rather than the number of characters entered.
4. Custom validation can use a formula to determine whether an entry is valid.
Which statements are correct?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Statements 1 and 2 correctly describe the Whole Number and Decimal validation types.
• Statement 3 is false because Text Length controls the number of characters in an entry rather than its numerical magnitude.
• Statement 4 is correct because Custom validation evaluates a user-specified formula.
• Statement 3 is false because Text Length controls the number of characters in an entry rather than its numerical magnitude.
• Statement 4 is correct because Custom validation evaluates a user-specified formula.
వివరణ:
Question 20
ప్రశ్న 20
Match List I with List II:
List I
(a) Whole Number
(b) List
(c) Text Length
(d) Custom
List II
1. Uses a formula to define the validity condition
2. Restricts the number of characters entered
3. Restricts entries to permitted integers according to specified conditions
4. Restricts entries to values supplied in a defined list
Choose the correct matching code.
List I
(a) Whole Number
(b) List
(c) Text Length
(d) Custom
List II
1. Uses a formula to define the validity condition
2. Restricts the number of characters entered
3. Restricts entries to permitted integers according to specified conditions
4. Restricts entries to values supplied in a defined list
Choose the correct matching code.
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Whole Number restricts permitted integer values, giving (a)-3.
• List restricts entries to defined choices, giving (b)-4, while Text Length controls character count, giving (c)-2.
• Custom uses a formula to define validity, giving (d)-1.
• List restricts entries to defined choices, giving (b)-4, while Text Length controls character count, giving (c)-2.
• Custom uses a formula to define validity, giving (d)-1.
వివరణ:
Answer Key సమాధానాల పట్టిక
-
Question 1 ప్రశ్న 1Answer: A. To restrict the type of data or values that users can enter into selected cells సమాధానం: A.
-
Question 2 ప్రశ్న 2Answer: C. Data > Data Validation సమాధానం: C.
-
Question 3 ప్రశ్న 3Answer: B. Allow: Whole number; Data: Between; Minimum: 1; Maximum: 100 సమాధానం: B.
-
Question 4 ప్రశ్న 4Answer: D. List సమాధానం: D.
-
Question 5 ప్రశ్న 5Answer: B. Allow: Date; Between 1-Aug-2026 and 31-Aug-2026 సమాధానం: B.
-
Question 6 ప్రశ్న 6Answer: A. Allow: Text Length; Data: Equal to; Length: 8 సమాధానం: A.
-
Question 7 ప్రశ్న 7Answer: D. Decimal between 0 and 1 సమాధానం: D.
-
Question 8 ప్రశ్న 8Answer: C. In-cell dropdown సమాధానం: C.
-
Question 9 ప్రశ్న 9Answer: D. Input Message సమాధానం: D.
-
Question 10 ప్రశ్న 10Answer: B. Stop సమాధానం: B.
-
Question 11 ప్రశ్న 11Answer: C. It warns that the value is invalid and allows the user to choose whether to continue with that entry. సమాధానం: C.
-
Question 12 ప్రశ్న 12Answer: A. Blank entries are permitted under the validation setting instead of being rejected solely for being blank. సమాధానం: A.
-
Question 13 ప్రశ్న 13Answer: A. A2:A4 సమాధానం: A.
-
Question 14 ప్రశ్న 14Answer: D. =AND(LEFT(C2,3)="ID-",LEN(C2)>9) సమాధానం: D.
-
Question 15 ప్రశ్న 15Answer: C. =COUNTIF($A$2:$A$10,A2)=1 సమాధానం: C.
-
Question 16 ప్రశ్న 16Answer: B. Data Validation > Circle Invalid Data సమాధానం: B.
-
Question 17 ప్రశ్న 17Answer: C. Invalid data can sometimes enter through operations such as copying or filling even though direct typed entries are restricted, and Circle Invalid Data can help identify such values. సమాధానం: C.
-
Question 18 ప్రశ్న 18Answer: A. Both Assertion and Reason are true, and Reason is the correct explanation of Assertion. సమాధానం: A.
-
Question 19 ప్రశ్న 19Answer: B. 1, 2 and 4 only సమాధానం: B.
-
Question 20 ప్రశ్న 20Answer: D. (a)-3, (b)-4, (c)-2, (d)-1 సమాధానం: D.