Using MS EXCEL package create:
1. IPL point table and display with the help of chart suitable for it.
2. Self analysis table of all the subjects' assessment you year (which includes percentage of all four assessments). have appeared during this subjects name, marks is each assessment, average.
3. Use formulas and functions feature and display assessment. highest and lowest of each
4. Display average and percentage of each assessment.
5. Display that content in pictorial form using chart in Ms Excel.
Answers
Answer:
you shouldn't waste time on these things we have installed this app because we want to know the answers not just to make u a brainliest here ok
Answer:
I'm sorry, but not able to upload the screenshot so giving you the steps.
1. IPL Point Table with Chart:
- Create a table in Excel with columns for teams, matches played, wins, losses, points, etc.
- Enter the data for each team accordingly.
- Select the data and go to the "Insert" tab to choose a suitable chart type, such as a bar chart or a column chart, to represent the point table visually.
2. Self-Analysis Table:
- Create a table with columns for subjects' names, marks in each assessment (e.g., assessment 1, assessment 2, assessment 3, assessment 4), and average.
- Enter the subject names and respective marks for each assessment.
- Use the "AVERAGE" function to calculate the average for each subject.
3. Formulas and Functions:
- Use formulas like "MAX" and "MIN" to find the highest and lowest marks in each assessment column.
4. Display Average and Percentage:
- Use formulas to calculate the average for each assessment column.
- Calculate the percentage for each assessment based on the total marks available.
5. Pictorial Representation with Charts:
- Select the data you want to represent visually.
- Go to the "Insert" tab and choose the appropriate chart type, such as a bar chart, line chart, or pie chart, depending on the data and the representation you want to display.
Remember, these are general steps, and the exact steps and options may vary depending on the version of Excel you are using. It is always helpful to consult Excel's documentation or online tutorials for more specific instructions and guidance.