Please keep at least one language enabled. || కనీసం ఒక భాషను ఎంచుకోండి.
Question 1
ప్రశ్న 1
In a database-style Excel list where each row contains all details about one employee, what does one such data row represent?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• In a database-style worksheet, one record contains the related details for one entity or item.
• Each employee's complete set of values is therefore normally stored across one row.
• Fields describe individual attributes such as Employee ID, Name or Department.
• Each employee's complete set of values is therefore normally stored across one row.
• Fields describe individual attributes such as Employee ID, Name or Department.
వివరణ:
Question 2
ప్రశ్న 2
In an organized Excel list with headings Employee_ID, Name, Department and Salary, what does the Department column represent in database terminology?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• A field represents one category or attribute of information in a structured data list.
• In Excel, a field is commonly represented by a column identified by a header such as Department.
• A record normally corresponds to an entire row containing all fields for one item.
• In Excel, a field is commonly represented by a column identified by a header such as Department.
• A record normally corresponds to an entire row containing all fields for one item.
వివరణ:
Question 3
ప్రశ్న 3
Which arrangement is generally most suitable for maintaining a database-style list in Excel?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Structured data is easiest to manage when each column represents one field and each row represents one record.
• A clear header row identifies the meaning of every column.
• Consistent tabular organization improves sorting, filtering and later analysis.
• A clear header row identifies the meaning of every column.
• Consistent tabular organization improves sorting, filtering and later analysis.
వివరణ:
Question 4
ప్రశ్న 4
Which statement correctly distinguishes sorting from filtering in Excel?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Sorting rearranges data according to an order such as A to Z or smallest to largest.
• Filtering temporarily displays only rows that satisfy chosen criteria while hiding rows that do not.
• Filtering does not delete the hidden records from the underlying data.
• Filtering temporarily displays only rows that satisfy chosen criteria while hiding rows that do not.
• Filtering does not delete the hidden records from the underlying data.
వివరణ:
Question 5
ప్రశ్న 5
A column contains the names Ravi, Anil, Zoya and Babu. Which order results from sorting the column from A to Z?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• An A-to-Z sort places text values in ascending alphabetical order.
• Among the given names, Anil comes first, followed by Babu, Ravi and Zoya.
• The resulting sequence is therefore Anil, Babu, Ravi, Zoya.
• Among the given names, Anil comes first, followed by Babu, Ravi and Zoya.
• The resulting sequence is therefore Anil, Babu, Ravi, Zoya.
వివరణ:
Question 6
ప్రశ్న 6
An Excel column contains the numbers 450, 125, 900 and 300. What order results from sorting the column from Smallest to Largest?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Smallest to Largest is the ascending sort order for numeric values.
• Ordering 450, 125, 900 and 300 numerically gives 125, 300, 450 and 900.
• Numeric sorting is based on value rather than alphabetical text order.
• Ordering 450, 125, 900 and 300 numerically gives 125, 300, 450 and 900.
• Numeric sorting is based on value rather than alphabetical text order.
వివరణ:
Question 7
ప్రశ్న 7
When a column containing valid Excel dates is sorted from Oldest to Newest, which date should appear first among 15-Jan-2024, 10-Mar-2022, 25-Jul-2023 and 01-Dec-2025?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Oldest to Newest arranges valid date values chronologically from the earliest date to the latest.
• Of the four dates, 10-Mar-2022 is the earliest.
• Therefore 10-Mar-2022 appears first after an ascending chronological sort.
• Of the four dates, 10-Mar-2022 is the earliest.
• Therefore 10-Mar-2022 appears first after an ascending chronological sort.
వివరణ:
Question 8
ప్రశ్న 8
An employee list must first be sorted by Department and, within each Department, by Employee Name. Which Excel feature is most appropriate?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Excel's Custom Sort allows more than one sorting level to be defined.
• Department can be selected as the first level and Employee Name as the next level.
• The second level determines the order of records that have the same value in the first sort field.
• Department can be selected as the first level and Employee Name as the next level.
• The second level determines the order of records that have the same value in the first sort field.
వివరణ:
Question 9
ప్రశ్న 9
In Excel's Custom Sort dialog box, what is the purpose of selecting 'My data has headers' when the first row contains field names?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• My data has headers tells Excel that the first row contains labels identifying the data columns.
• The header row is then excluded from the ordinary data values being sorted.
• This prevents headings such as Name or Salary from being mixed into the sorted records.
• The header row is then excluded from the ordinary data values being sorted.
• This prevents headings such as Name or Salary from being mixed into the sorted records.
వివరణ:
Question 10
ప్రశ్న 10
What is the main effect of applying a filter to a properly organized Excel data range?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Filtering allows the user to focus on a subset of records that meet specified conditions.
• Rows failing the filter criteria are hidden rather than deleted.
• Clearing the filter can make the hidden records visible again.
• Rows failing the filter criteria are hidden rather than deleted.
• Clearing the filter can make the hidden records visible again.
వివరణ:
Question 11
ప్రశ్న 11
Which command path is normally used to enable filtering for a selected Excel data range?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• The Data tab contains Excel's Filter command.
• Enabling Filter adds filter controls to the header cells of a suitable data range.
• Those controls can then be used to select values or specify text, number or date criteria.
• Enabling Filter adds filter controls to the header cells of a suitable data range.
• Those controls can then be used to select values or specify text, number or date criteria.
వివరణ:
Question 12
ప్రశ్న 12
What normally happens when a data range is converted into an Excel Table with a header row?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Excel Tables normally provide filter drop-down controls in their header row automatically.
• These controls support both filtering and sorting of table data.
• Converting data to a table does not prevent sorting or convert all values into numbers.
• These controls support both filtering and sorting of table data.
• Converting data to a table does not prevent sorting or convert all values into numbers.
వివరణ:
Question 13
ప్రశ్న 13
An Excel list is first filtered to show Department = 'Accounts'. A second filter is then applied to the Salary column to show values greater than 50000. What will normally be displayed?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Filters applied to different columns are cumulative on the currently filtered data.
• After Department = Accounts is applied, the Salary filter further reduces that visible subset.
• The displayed records therefore satisfy both the Department and Salary conditions.
• After Department = Accounts is applied, the Salary filter further reduces that visible subset.
• The displayed records therefore satisfy both the Department and Salary conditions.
వివరణ:
Question 14
ప్రశ్న 14
A worksheet is filtered to display only records where Status = 'Pending'. What should the user do to make all Status values visible again without deleting any records?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Clearing a filter removes the filtering condition from that field.
• Records previously hidden because they did not meet the condition become visible again.
• The underlying rows were never deleted, so no record reconstruction is required.
• Records previously hidden because they did not meet the condition become visible again.
• The underlying rows were never deleted, so no record reconstruction is required.
వివరణ:
Question 15
ప్రశ్న 15
A Salary field contains valid numeric values. The user wants to display only records with Salary greater than 60000. Which filter is most directly appropriate?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Salary values stored as numbers can be filtered using Excel's Number Filters.
• Greater Than allows the user to specify 60000 as the threshold.
• Sorting changes order but does not by itself restrict the displayed records to values above the threshold.
• Greater Than allows the user to specify 60000 as the threshold.
• Sorting changes order but does not by itself restrict the displayed records to values above the threshold.
వివరణ:
Question 16
ప్రశ్న 16
A list contains Department, Employee_Name and Salary fields. The requirement is to show the highest-paid employee first within each department while also keeping departments in alphabetical order. Which sorting setup is appropriate?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Department should be the first sorting level because departmental grouping has priority.
• Salary should be the next level and use Largest to Smallest so the highest value appears first within each department.
• Multi-level sorting maintains the required hierarchical organization.
• Salary should be the next level and use Largest to Smallest so the highest value appears first within each department.
• Multi-level sorting maintains the required hierarchical organization.
వివరణ:
Question 17
ప్రశ్న 17
Consider the following statements about sorting and filtering Excel data:
1. Sorting can rearrange records according to values in one or more fields.
2. Filtering can temporarily hide records that do not satisfy specified criteria.
3. Clearing a filter permanently deletes the hidden records.
4. Text can normally be sorted A to Z or Z to A.
Which statements are correct?
1. Sorting can rearrange records according to values in one or more fields.
2. Filtering can temporarily hide records that do not satisfy specified criteria.
3. Clearing a filter permanently deletes the hidden records.
4. Text can normally be sorted A to Z or Z to A.
Which statements are correct?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Statements 1 and 2 correctly describe sorting and filtering operations.
• Statement 3 is false because clearing a filter redisplays hidden records rather than deleting them.
• Statement 4 is correct because text fields support ascending A-to-Z and descending Z-to-A sorting.
• Statement 3 is false because clearing a filter redisplays hidden records rather than deleting them.
• Statement 4 is correct because text fields support ascending A-to-Z and descending Z-to-A sorting.
వివరణ:
Question 18
ప్రశ్న 18
An employee table has columns Employee_ID, Name, Department and Salary. The user clicks one Salary cell and starts a sort. Excel warns that adjacent data exists and offers 'Expand the selection' or 'Continue with the current selection'. To preserve each employee's complete record, which choice is generally appropriate?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Related fields in one record must remain together when database-style data is sorted.
• Expanding the selection allows Excel to reorder the whole associated data range rather than moving only one isolated column.
• Sorting only the Salary cells could separate salaries from the employees to whom they belong.
• Expanding the selection allows Excel to reorder the whole associated data range rather than moving only one isolated column.
• Sorting only the Salary cells could separate salaries from the employees to whom they belong.
వివరణ:
Question 19
ప్రశ్న 19
Assertion (A): Filtering an Excel data list can reduce the number of rows currently visible without deleting those hidden rows.
Reason (R): A filter displays records meeting specified criteria and temporarily hides records that do not meet those criteria.
Choose the correct answer.
Reason (R): A filter displays records meeting specified criteria and temporarily hides records that do not meet those criteria.
Choose the correct answer.
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Filtering changes which records are displayed rather than permanently removing records from the data range.
• Rows that fail the criteria remain in the worksheet but are temporarily hidden from the filtered view.
• Both statements are true, and the Reason correctly explains the Assertion.
• Rows that fail the criteria remain in the worksheet but are temporarily hidden from the filtered view.
• Both statements are true, and the Reason correctly explains the Assertion.
వివరణ:
Question 20
ప్రశ్న 20
Match List I with List II:
List I
(a) Record
(b) Field
(c) Sort
(d) Filter
List II
1. Reorders data according to selected values or criteria
2. One category or attribute of data, commonly represented by a column
3. Displays a subset of records meeting specified conditions
4. Related field values describing one item, commonly represented by a row
Choose the correct matching code.
List I
(a) Record
(b) Field
(c) Sort
(d) Filter
List II
1. Reorders data according to selected values or criteria
2. One category or attribute of data, commonly represented by a column
3. Displays a subset of records meeting specified conditions
4. Related field values describing one item, commonly represented by a row
Choose the correct matching code.
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• A record contains related information about one item and normally corresponds to a row, giving (a)-4.
• A field represents one attribute and commonly corresponds to a column, giving (b)-2.
• Sort reorders data and Filter displays records meeting conditions, giving (c)-1 and (d)-3.
• A field represents one attribute and commonly corresponds to a column, giving (b)-2.
• Sort reorders data and Filter displays records meeting conditions, giving (c)-1 and (d)-3.
వివరణ:
Answer Key సమాధానాల పట్టిక
-
Question 1 ప్రశ్న 1Answer: B. A record సమాధానం: B.
-
Question 2 ప్రశ్న 2Answer: D. A field సమాధానం: D.
-
Question 3 ప్రశ్న 3Answer: A. Use one header row, store one record per row, and keep each type of field in its own column. సమాధానం: A.
-
Question 4 ప్రశ్న 4Answer: C. Sorting changes the order of data, while filtering displays rows meeting specified criteria and hides other rows. సమాధానం: C.
-
Question 5 ప్రశ్న 5Answer: C. Anil, Babu, Ravi, Zoya సమాధానం: C.
-
Question 6 ప్రశ్న 6Answer: A. 125, 300, 450, 900 సమాధానం: A.
-
Question 7 ప్రశ్న 7Answer: D. 10-Mar-2022 సమాధానం: D.
-
Question 8 ప్రశ్న 8Answer: B. Custom Sort with multiple sort levels సమాధానం: B.
-
Question 9 ప్రశ్న 9Answer: A. It identifies the first row as headings so those labels are not treated as ordinary data records during sorting. సమాధానం: A.
-
Question 10 ప్రశ్న 10Answer: C. It displays rows satisfying the selected criteria while temporarily hiding other rows. సమాధానం: C.
-
Question 11 ప్రశ్న 11Answer: D. Data > Filter సమాధానం: D.
-
Question 12 ప్రశ్న 12Answer: B. Filtering controls are automatically provided in the table's header row. సమాధానం: B.
-
Question 13 ప్రశ్న 13Answer: B. Only records that satisfy both the existing Department filter and the Salary filter సమాధానం: B.
-
Question 14 ప్రశ్న 14Answer: D. Clear the filter applied to the Status field. సమాధానం: D.
-
Question 15 ప్రశ్న 15Answer: C. Number Filters > Greater Than సమాధానం: C.
-
Question 16 ప్రశ్న 16Answer: A. First sort Department A to Z, then add a Salary level from Largest to Smallest. సమాధానం: A.
-
Question 17 ప్రశ్న 17Answer: C. 1, 2 and 4 only సమాధానం: C.
-
Question 18 ప్రశ్న 18Answer: B. Expand the selection so the related values in each record move together. సమాధానం: B.
-
Question 19 ప్రశ్న 19Answer: D. Both Assertion and Reason are true, and Reason is the correct explanation of Assertion. సమాధానం: D.
-
Question 20 ప్రశ్న 20Answer: A. (a)-4, (b)-2, (c)-1, (d)-3 సమాధానం: A.