Spreadsheet notes class 10 👈👈
👆CLICK here👆
What do you mean by Spreadsheet
A spreadsheet is a computer application for computation, organization, analysis and storage of data in tabular form. Spreadsheets were developed as computerized analogs of paper accounting worksheets. The program operates on data entered in cells of a table. Each cell may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells. A spreadsheet may also refer to one such electronic document.
Open Office Calc is an electronic powerful spreadsheet program used to record and analyze numerical and statistical data with formulas and functions. Open office calc extension is .ods
A worksheet is a single page spreadsheet or page.
A workbook is just a book. The workbook consists of one or more worksheets, having various sorts of related information.
Cell
A cell is the intersection of a row and a column. In other words, it's where a row and column meet.
Some basic functions
1. SUM Function
The sum function is the most used function when it comes to computing data on Excel. This function works to sum a group of numbers in a specific set of cells.
Syntax:- =SUM(number1, number2, etc.).
2. AVERAGE Function
The average function is an extremely useful tool for getting the average value in a range of cells. Like the sum function, it is frequently used in computing and analyzing data on spreadsheet.
Syntax:- =AVERAGE (number1, number2, etc.).
3. MAX Function
Excel MAX function is categorized under statistical functions in Microsoft Excel. The Excel MAX Formula is used to find out the maximum value from a given set of data/ array. MAX function in Excel returns the highest value from a given set of numeric values.
Syntax:- =MAX(A1:D5)
4. MIN function
The MIN function returns the smallest numeric value in the data provided. The MIN function can be used to return the smallest value from any type of numeric data.
Syntax :- =MIN(A1:D5)
5. COUNT function
The COUNT function counts the number of cells that contain numbers, and counts numbers within the list of arguments. Use the COUNT function to get the number of entries in a number field that is in a range or array of numbers.
Syntax:- =COUNT(A1:D5)
6. IF function
The IF function is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and what you expect.
So an IF statement can have two results. The first result is if your comparison is True, the second if your comparison is False.
For example, =IF(C2="60",Pass, Fail) says IF(C2 = 60, then return Pass, otherwise return Fail).
Freezing and Unfreezing rows and columns
Freezing locks number of rows at the top of a spreadsheet or number of columns on the left of a spreadsheet or both. Frozen columns and rows remain the view during scroling, whereas other rows and columns gets scrolled.
Freezing rows or columns:
1. Click on the Header for the row below where to the freeze or for the column to the right of where to freeze.
2. Choose the Window -> Freeze. A dark line appears, indicating where the freeze is put.
Freezing locks number of rows at the top of a spreadsheet or number of columns on the left of a spreadsheet or both. Frozen columns and rows remain the view during scroling, whereas other rows and columns gets scrolled.
Freezing rows or columns:
1. Click on the Header for the row below where to the freeze or for the column to the right of where to freeze.
2. Choose the Window -> Freeze. A dark line appears, indicating where the freeze is put.
Hide a row/Column
When elements are hidden, they are neither visible nor printed, but can still be selected for copying if you select the elements around them.
• To hide a row/column, first select the row/column, and then use menu options,
• Format → Row → Hide or Format → Column → Hide to hide row and column respectively.
• To show the hidden row / column, choose Format→ Row → Show or Format →Column → Show
(or)
• Right-click and choose Show from pop-up menu.
What do you mean by Charts?
A chart is a graphical representation of data. Charts allow users to see what the results of data to better understand and predict current and future data.
Types of charts
There are a wide variety of charts available to display data.
Bar
chart
Column
sparklines
Line chart
Pie chart
Point chart
Bubble chart
Scatter
Creating Chart
1. Select the cells that contain the data that you want to present in your chart.
2. Click the Insert->Chart option or click Insert Chart icon
on the Standard toolbar.
3. The Chart Wizard has three main parts:
4. Choose a Chart type and its option type. Then click Next button.
5. In the Data Series list box contains a list of all data series in the current chart.
• To organize the data series, select an entry in the list.
• Then click Next button
6. On the Chart Elements page, chart a title and, if desired, a subtitle.
Click on Finish
When elements are hidden, they are neither visible nor printed, but can still be selected for copying if you select the elements around them.
• To hide a row/column, first select the row/column, and then use menu options,
• Format → Row → Hide or Format → Column → Hide to hide row and column respectively.
• To show the hidden row / column, choose Format→ Row → Show or Format →Column → Show
(or)
• Right-click and choose Show from pop-up menu.
What do you mean by Charts?
A chart is a graphical representation of data. Charts allow users to see what the results of data to better understand and predict current and future data.
Types of charts
There are a wide variety of charts available to display data.
Bar
chart
Column
sparklines
Line chart
Pie chart
Point chart
Bubble chart
Scatter
Creating Chart
1. Select the cells that contain the data that you want to present in your chart.
2. Click the Insert->Chart option or click Insert Chart icon
on the Standard toolbar.
3. The Chart Wizard has three main parts:
4. Choose a Chart type and its option type. Then click Next button.
5. In the Data Series list box contains a list of all data series in the current chart.
• To organize the data series, select an entry in the list.
• Then click Next button
6. On the Chart Elements page, chart a title and, if desired, a subtitle.
Click on Finish