Write the steps to – ‘search a record’ in excel
pls dont copy from google
Answers
Answer:
Spreadsheets excel at crunching numbers. Add a column of figures—your sales or expenses, perhaps—and a quick formula =SUM(A1:A10) can add them up or =AVERAGE(A1:A10) returns the average price. They’re flexible yet powerful.
Databases are better at connecting enormous amounts of data across different tables. You could have a list of your product details in one table, a list of your orders in another, and have each order linked to the products people purchased. Then, instead of typing the price in each time, you’d link the product name in the order table to the product details table and let the database pull in the data on its own. That interconnectivity makes databases more confusing—but also more powerful if you have time to tame the beast.
Explanation:
Follow these steps:
1. Click the Form button in the Quick Access toolbar to open the data form. ...
2.Click the Criteria button in the data form. ...
3. Enter criteria in one or more fields of the data form. ...
4. Click the Find Next button or the Find Prev button.