CBSE Class 9 Computer Chapter 9 Electronic Spreadsheet Important Notes

                Introduction

 This CBSE Class 9 Computer Chapter 9 Electronic Spreadsheet Important Notes will Help You To Score Good Marks In Your Exams. Here We Give You CBSE Class 9 Computer Chapter 9 Electronic Spreadsheet  Important Notes According to CBSE New Pattern.


Read CBSE Class 9 Computer Chapter 9 Electronic Spreadsheet  Important Notes Carefully. If You Don’t Read This Carefully Then You Will Face Some Problems Related The Concept Of Class 9 ComputerSample Papers For ComputerCBSE Important NotesCBSE MCQs Based Question For Computer, Etc. 


  • Calc is a spreadsheet application that allows you to perform various kinds of functions, such as entering. calculating, manipulating, and analyzing different sets of data.


  •  A worksheet in the LibreOffice Calc application refers to a single sheet.


  •  A collection of worksheets is known as a workbook.


  •  The intersection of a row and a column is called a cell.


  • A worksheet in Calc has 1048576 rows and 1024 columns.


  •  The active cell refers to the cell that is currently active.


  •  Working with a spreadsheet program means working in a worksheet.


  •  Any data that you enter in a LibreOffice Calc worksheet is in the form of a number, formula, special character, or text.


  •  Overwriting data means that the current content of the selected cell will get replaced by a new entry.


  •  Partial modification means you do not need to overtype the complete content of the selected cell.


  • You can select a range of cells in a worksheet in two ways: by using mouse and by using keyboard.


  • The fill handle enables you to add duplicate entries or fill data series in the cells of a worksheet.


  •  A data series can be a text series, such as days of a A week or a number series.


  • LibreOffice Calc allows you to insert one or more blank cells in your worksheet.


  •  Formatting data helps in enhancing the appearance of a worksheet.


  •  Number formatting is used to change the appearance of numbers.


  •  Text formatting includes font style, text alignment, font size, font attribute and indentation.


  •  The Formatting toolbar contains various buttons that help you perform many functions, such as aligning the content, changing indent and changing the font colour


  • A formula is a combination of values, operators (+-/,), and cell addresses, eg., A8, B2, etc.


  •  In Calc, formulas start with the = (equal) sign.


  •  Calc supports various types of operators, such as t, -/,which are inserted in the formulas to perform desired calculations on the worksheet data.

  •  A function is ad presented formula that takes apart the result. performs a calculation on that value, and final value, returns


  •  Cell referencing is the method by which you refer cell or series of cells in a formula.


  •  In relative cell referencing, when a formula is copied to a new location in a worksheet, cell references in the formula change in relation to the new location of the formula.


  •  In absolute cell referencing, cell references in a formula remains the same even when the formula is copied to a new location.


  •  For absolute cell referencing. you need to use the S (dollar) symbol as a prefix before the column and row names in a formula.


  •  If you use the S symbol with only one part of the cell address, either with the column letter or the row number, it is called the mixed cell referencing.


  •  Arguments refer to the values or cell references that are passed to a function.


  • Arguments are passed within the parentheses used in functions.


  •  The SUM) function is used to add all the numbers in a range of cells, and the result is displayed in the active cell containing the formula.


  •  The AVERAGE) function is used to get the average (arithmetic mean) of all the passing arguments.


  •  The COUNT() function is used to count the contain numbers.


  • The MAX() function is a function that returns irnscthe largest value from a set of arguments.



  • The MIN) function returns the smallest number from a list of arguments.


  •  A chart is a medium that is used to graphically present worksheet data in Calc.


  •  Calc supports various types of charts, which includes Area chart, Column chart, Line chart, XY (Scatter) chart, Column and Line chart, Pie chart, Bar chart, Net chart, Stock chart and Bubble Chart.


  •  An area chart is generally used to highlight change Overtime.


  • A column chart is used to emphasize the comparison of data items within a specified time period.


  •  A line chart is a type of graph that displays data trends at regular intervals.

  •  To depict the relationship among numerical values using a variety of data series, you can use the XY (scatter) chart.
  •  The combination of the line and column charts is known as the column and line chart.


  •  A pie chart is a round chart that is divided into zones, which demonstrate the proportional size of an item with respect to the sum of all the items.


  • A bar chart is used to demonstrate comparison among individual items.

  • Anet chart is used to display data as points connected by some lines in a grid or net that looks like a spider net or a radar tube display.


  • A stock chart is used to demonstrate the market movement in terms of the opening price, bottom price, top price and closing price.


  • A bubble chart is used for representing relations among three variables.


  • A chart has various components, such as X-axis, Y-axis, Data Series, Chart Area, Plot Area, Chart Title, Axes Titles, Legend, Gridlines, Data Label, etc.


  •  Active Cell: A cell that is currently active


  •  Arguments: The values or cell references that are passed to a function


  •  Axes Titles: The names or titles for X, Y and Z axes


  •  Cell Referencing A method by which you refer to a cell or series of cells in a formula


  •  Cell: The area formed by the intersection of a row and column


  •  Cell: The intersection of a row and a column


  •  Chart Area: 1he total space enclosed by a chart


  •  Chart Title: The type of data plotted in a chart


  •  Chart: A visual representation of numeric data that helps the user understand the data better


  •  Data Formatting: The arrangement of data or information in a particular style or format is known as data formatting


  •  Data Label: Additional information about a value that is coming from a worksheet cell


  • Data Series: A set of data that you want to display in a chart


  •  Fill Handle: A small form of a solid square that appears at the lower right corner of the cell, when you select cell in a worksheet


  • formatting Toolbar: A bar that consists of tools for formatting the text

  • Formatting: Formatting data helps in enhancing the the appearance of your worksheet


  •  Formula: An expression or equation that calculate data in a worksheet


  •  Functions: Predefined formulas that are used to perform basic or complex operations on a specified range of cells


  •  Gridlines: The horizontal and vertical lines within the plot area in a chart


  •  Input Line: The content of the selected cell or formula applied on the selected cell


  •  Label: A text entry that contains alphabet or non- numeric characters, such as #, &, or


  •  Legend: Shows different data series with the help of a unique color pattern




  •  Menu: A drop-down list that provides several commands to operate on the content of a worksheet


  • Name Box: A box that displays the address of the active cell or a range of selected cells


  •  Number Formatting: Changes the appearance of numbers


  •  Overwriting Data: The process to replace the current content of the selected cell by a new entry


  •  Partial Modification: This means that overtyping of The complete content of the selected cell is not required

  •  Plot Area: The main region of a chart in which your data is plotted


  •  Range of Cells: A group of contiguous cells


  •  Sidebar: A bar that contains the icons for displayingthe panels, such as Properties, Styles and Formatting, Gallery, Navigator and Functions.


  •  Spreadsheet Application: An application that is mainly used for manipulating and arranging data in a grid or rows and columns


  •  Standard Toolbar: A bar that consists of tools for performing basic functions, such as open, save, copy, cut and paste

  • Text Formatting: Changes the appearance of text usin
  • font style, text alignment, font size, font attribute and indentation


  •  Toolbar: A horizontal bar that contains a number of buttons for performing various operations


  •  Workbook: A collection of worksheets


  •  Worksheet: A single sheet in the LibreOffice Calc application

  • X-axis: A horizontal axis that is also known as category axis


  •  Y-axis: A vertical axis that is also known as the value axis.

Conclusion

 This CBSE Class 9 Computer Chapter 9 Electronic Spreadsheet Important Notes will Help You To Score Good Marks In Your Exams. Here We Give You CBSE Class 9 Computer Chapter 9 Electronic Spreadsheet  Important Notes According to CBSE New Pattern.


Read CBSE Class 9 Computer Chapter 9 Electronic Spreadsheet  Important Notes Carefully. If You Don’t Read This Carefully Then You Will Face Some Problems Related The Concept Of Class 9 ComputerSample Papers For ComputerCBSE Important NotesCBSE MCQs Based Question For Computer, Etc. 


Leave a Comment