Page 1 :
Class Notes, Class: IX, Subject: INFORMATION TECHNOLOGY, , Topic: SPREADSHEET APPLICATIONS, (ELEMENTARY), , GETTING STARTED WITH SPREADSHEETS (SESSION 1), WORKING WITH DATA (SESSION 2), Answer the following Questions:, 1. Write a short note on OpenOffice Calc., Answer:, OpenOffice Calc is the spreadsheet part of the OpenOffice software package., Calc is similar to Microsoft Excel, with almost the same abilities. Calc is capable of, opening and saving spreadsheets in Microsoft Excel's file format. It provides a, number of features not present in Excel, including a system which automatically, defines a series for graphing based on the layout of the user's data. Calc is also, capable of writing spreadsheets directly as PDF files., 2. Define cell., Answer:, A cell is a rectangular box that occurs at the intersection of a vertical column and a, horizontal row in a worksheet. Vertical columns are numbered with alphabetic, values such as A, B, C. Horizontal rows are numbered with numeric values such as, 1, 2, 3 ., , 3. Write a short note on Cell range., Answer:, A cell range is a collection of selected cells. This cell range is usually symmetrical, (square)., 4. Write a short note on Workbook., Answer:, A workbook is the name given to an spreadsheet document and has the file, This content is prepared absolutely from home

Page 2 :
extension (". xlsx"). A workbook contains one or more worksheets and there are 3, worksheets in the default workbook., 5. Write down the steps to insert new blank Cells in Excel worksheet., Answer:, Step 1 - Select the location and number of Cells you want to insert in Excel, worksheet. You can insert a single Cell or Range of Cells in Excel worksheet, either, in rectangle or square shape., Step 2 - After selecting the location and number of Cells, right-click on any of the, selected Cell and select "Insert" from context menu as shown in below image., 5. Write down the steps to Split a sheet into panes., Answer:,  Select below the row where you want the split, or the column to the right of where you, want the split.,  On the View tab, in the Window group, click Split. To remove the split panes, click Split, again., 6. What is cell pointer?, Answer:, A rectangular highlight that indicates the active cell in a spreadsheet program., 7. What is formula and function?, Answer:, A formula is an expression that operates on values in a range of cells or a cell. For, example, =A1+A2+A3, which finds the sum of the range of values from cell A1 to, cell A3., Functions are predefined formulas in Excel., 8. Write a short note on cell reference., Answer:, , A cell reference in Excel refers to the value of a different cell or cell range on the, current worksheet or a different worksheet within the spreadsheet. A cell, reference can be used as a variable in a formula., Types of Cell Reference, We have three different types of Cell References

Page 3 :
 Relative Cell Reference,  Absolute Cell Reference,  Mixed Cell Reference, , Relative Cell References,  This is the most widely used type of cell reference in formulas. Relative cell, references are basic cell references that adjust and change when copied or when, using AutoFill., Absolute Cell References,  Situations arise in which the cell reference must remain the same when copied or, when using AutoFill. Dollar signs are used to hold a column and/or row reference, constant., Mixed cell references, Mixed cell references are a bit more tricky than the absolute and relative cell references., There can be two types of mixed cell references:, The row is locked while the column changes when the formula is copied., The column is locked while the row changes when the formula is copied., 9. Explain different types of function., Answer:, The SUM function adds values. You can add individual values, cell references or ranges, or a mix of all three. For example: =SUM(A2:A10) Adds the values in cells A2:A10., Average: Returns the average (arithmetic mean) of the arguments. For example, if the, range A1:A20 contains numbers, the formula =AVERAGE(A1:A20) returns the average of, those numbers.

Page 4 :
Use the COUNT function to get the number of entries in a number field that is in a range, or array of numbers. For example, you can enter the following formula to count the, numbers in the range A1:A20: =COUNT(A1:A20). In this example, if five of the cells in the, range contain numbers, the result is 5., The COUNTA function does not count empty cells., MAX will return the largest value in a given list of arguments. From a given set of numeric, values, it will return the highest value., MAXA function returns the largest numeric value in a range of values. The MAXA function, ignores empty cells, but evaluates the logical values TRUE and FALSE as 1 and 0,, respectively., The IF function checks whether a condition is met, and returns one value if true and, another value if false., 10. Define Regular expression., Answer:, RegEx stands for regular expression and is a sequence of characters that defines a, pattern that can be used to match against strings., , This content is prepared absolutely from home, , N.B.:, 1. Students are instructed to write the above content in their computer notebook and, prepare it as well.