write the step to search a particular record in Excel
Answers
How to use search criteria to find table records:-
For larger Excel tables, use the Criteria button in the data form to find records. Follow these steps:
1-Click the Form button in the Quick Access toolbar to open the data form.
Remember that you must add this button to the Quick Access toolbar.
Click the Criteria button in the data form.
2-Excel clears all the field entries in the data form (and replaces the record number with the word Criteria) so that you can enter the criteria to search for in the blank text boxes.
3-Enter criteria in one or more fields of the data form.
You can use wildcards (such as a ? for a single character and * for multiple characters) and comparison operators (such as < and >=) as well as text and values.
.For example, if you are searching for a record in an employee table and you know that the person’s last name begins with C and they are located in Boston, you would type C* in the Last Name field and Boston in the Location field to locate the record.
(Attached image no1)
4-Click the Find Next button or the Find Prev button.
Excel finds the first record that matches the specified criteria. Repeat this step as needed until you find the desired record.
(Attached image no2)
5-Click the Form button to return to the data form or click Close to close the data form.
Hope it helps you!!!
Mark Me as Brainliest Please!
lollllllll,,........... xd