Class – 9th IT (402)
Book- Domestic Data Entry Operator
Unit-4 Electronic Spreadsheet
Fill in the blanks
1) A spreadsheet software can also store, manipulate and create graphical representations of data.
2) The Title bar, located at the top, shows the name of the current spreadsheet.
3) The column range is the number of cells spread across the column.
4) The row range is the number of cells spread across the row.
5) A function should start with = ( is equal to sign ).
6) A chart has two axes .
7) The column immediately next to column “Z” is AA .
8) Selected cell is called active cell.
9) The default extension of a workbook created using a LibreOffice Calc spreadsheet is .ods .
10) The spreadsheet feature used to continue the series is called as Fill handle .
11) The formula “=MIN(C1:C5)” stored in cell C6 when copied to cell D6 changes to =MIN(D1:D5) .
12) The formula in cell A2 is =B2+C3. On copying this formula to cell C2, C2 will change to =D2+E3 .
13) The cell address of the cell formed by the intersection of the ninth column and the eighth row will be 18 .
14) $A1$B2 is an example of mixed referencing in spreadsheet software.
15) Numbers entered into a cell are automatically right aligned.
16) If A1:A5 contain the numbers 16, 10, 3, 25 and 6 then =Average(A1:A5;60) will display 20 .
18) A spreadsheet is a grid which interactively manages and organises data in rows and columns.
19) In Absolute referencing, a $ symbol is used before the column name as well as row number to make it constant in any formula. For example, $C$12, $D$5, etc.
20) Sum function is used to add all the values within a range of cells.
21) COUNT function is used to count the number of data.
22) AVERAGE function is used to find the average of a given number of cells.
23) A Pie Chart can only display one series of data. A data series is a row or column of numbers used for charting.
24) The Column Chart very effectively shows the comparison of one or more series of data points.
25) Area Charts are like Line Charts except that the area below the plot line is solid.
26) Sorting is mechanism to arrange the data in a particular order.
27) Validating is mechanism to filter out unnecessary data.
28) Extension of a worksheet created in Calc is .ods
29) A spreadsheet is also called as worksheet.
30) Graphical representation of data is called chart.
31) A spreadsheet is a grid which interactively manages and organises data in rows and columns. It is also called as Electronic Spreadsheet.
32) Arranging data in ascending and descending order is called sorting.
33) The Title bar, located at the top, shows the name of the current spreadsheet.
34) Menu bar is located just below the Title bar. It contains the menus with commands for various tasks. Each menu item has a submenu called pull-down menu.
35) Name box shows the cell reference, for example A1.
36) Functions wizard search the function from the list of available functions.
37) In built formula in calc is called function.
38) The sheet tab shows its default name as Sheet1, Sheet2, Sheet3.
39) The intersection of a row and column is called a cell.
40) A block of adjacent cells in a worksheet which is highlighted or selected is called a range of cells.
41) Label is the any text entered by using a keyboard. It may combine with letters, numbers, and special symbols.
42) The numerical data consisting of only numbers are called values.
43) By default values are right aligned.
44) By default the labels are left aligned.
45) Any expressions that begins with an equals ‘=’ is treated as formula.
46) The Calc Fill Handle tool is used to fill the next cells till you drag it with the next predefined value. For example, if you want to fill the numbers in sequence of 1,2,3.
47) Referencing is the way to refer the formula or function from one cell to the next cell along the row or column.
48) There are three types of referencing. • Relative referencing • Mixed referencing • Absolute referencing.
49) When you drag any formula in any row or column in any direction, the formula gets copied in the new cell with the relative reference.
50) In Mixed Referencing, the $ sign is used before row number or column name to make it constant.
51) : In Absolute referencing, a $ symbol is used before the column name as well as row number to make it constant in any formula. For example, $C$12, $D$5, etc.
52) AutoSum is a function in a spreadsheet program that inserts a formula in the selected cell that adds the numbers in the column above it. It sets the range of cells by looking for numeric data above the selected cell.
No comments:
Post a Comment