(a) Mr. Laxmichand has set his business target. Now he want to do some changes in rates of his products. Suggest the feature of spreadsheet and steps to complete his work.
Answers
The features of a spreadsheet that Laxmichand can use are cell formula, conditional formatting, Vlookup etc.
- Microsoft Excel is a powerful spreadsheet application that is commonly used to organize, store, and manipulate data.
- It allows users to create and edit spreadsheets composed of rows, columns, and cells containing text, numbers, or formulas.
- Spreadsheets are often used to keep track of financial data, such as budgets, expenses, and income, and Excel's various functions and formulas make it easy to perform calculations and analyze the data
- The features that can use Mr. Laxmichand are -
1. Conditional formatting
This will allow him to add unique formatting to spreadsheet cells matching specified requirements. The data's patterns and trends may become more apparent with its usage.
2. Vlookup
It will help to pull out the exact pieces of information that are required. For example a sheet having a male or female usage data, it can be used to figure out male data.
3. Pivot table
A dataset may be summarised in a number of different ways, which is helpful. This method will mechanically import all information from an entire table without any breaks.
4. Sorting
Mr. Laxmichand can organise and analyse his data using spreadsheet sorting and filtering features. To view products in appropriate order, he can sort them using criteria, like product name or price. He can narrow his focus to particular goods or prices via filtering.
#SPJ1