AIM :- Use of graph , table and printing documents in spreadsheet
1. Creating and Customizing Graphs
Graphs transform raw data into visual insights. In most spreadsheet software, this is done via the Insert menu.
Select Data: Highlight the range of cells containing the labels and values.
Choose Chart Type: Select a Column Chart for comparisons or a Line Chart for trends over time.
Customization: Add a Chart Title, Axis Titles (X and Y), and a Legend to make the data self-explanatory.
2. Organizing Data with Tables
Tables provide a structured way to manage and analyze a group of related data.
Format as Table: Selecting your data and using the "Format as Table" option automatically adds filter toggles to headers.
Benefits:
Sorting: Arrange data alphabetically or numerically.
Filtering: Temporarily hide data that doesn't meet specific criteria.
Total Row: Quickly calculate sums or averages at the bottom of the table.
3. Preparing Documents for Printing
Spreadsheets can be infinite, so defining what gets printed is crucial for a professional look.
Page Setup and Print Area
Set Print Area: Highlight the specific cells you want to print, go to the Page Layout tab, and select Print Area > Set Print Area.
Scaling: Use "Fit All Columns on One Page" to prevent data from being cut off on the right side.
Gridlines and Headings: In the Page Layout menu, check the boxes for Print Gridlines if you want the cell borders to appear on paper.
Margins and Orientation
Orientation: Use Landscape for wide tables and Portrait for long lists.
Margins: Adjust to "Narrow" if you need more space for large datasets.
Practical Exercise
Enter a list of 10 items with their quantities and prices.
Create a Total column using a formula (Quantity $\times$ Price).
Generate a Pie Chart showing the distribution of total costs.
Set the Print Area to include only the table and the chart, then preview the document in Landscape orientation.
0 Comments
If you have any doubts, please let me know