162 | MASTERNPND CHAPTERWISE CJuzsTion aanx column chart, select the range of data, click on Insert —> chart and select the type of chart. Now, click on Finish to display the chart. > Keyboard Shortcuts: Ctrl+ Home — [Move cursor to AT Ctrl + End Move cursor to last cell with data inside Home ‘Move cursor to first cell of the row End Move cursor to last cell of the row Shift + Home _ | Select from current cell to first cell of the row Shift + End Select from current cell to last cell of the row ‘Shift + Page up | Select from the current cell up a page Shift + Page | Select from the current cell dawn 3 down page Cert +1 Open Format cells Ctrl + Shift +1 | Two decimal places Ctrl + shift +2 | Exponential format Ctrl + shift +3. | Date format Ctr + shift +4 | Currency format Ctr + shift +5 | Percentage format Ctrl + Shift +6 | Standard format certs FY Show comment FSyMultipte Choice Questions y QL Which of the following help us to perform various calculations? a. Writer b. Spreadsheet Impress 4. None of these Q2. Spreadsheet Is used for: a, managing financial and accounting documents b. creating data reports data analysis d. Allof the above Q3. Spreadsheet packages also provide _bullt-In enna FOFTMULAE, ‘a, Mathematical b, Statistical ¢ Both a. and b. 4. None of these Q4. Which of the following is not a Spreadsheet Software? a, Microsoft Excel b. LibreOffice Cate © OpenOffice Cale: 4. None of these Q5. IN ernnrrmnennees ODEFating System, the LibreOffice gets installed by default. a. Windows ¢ Botha. and b: . Linux (Ubuntu) . None of these erver Et ode 2a [penta cr Cet ora ove cao ope ee |e cee shift + Ctrt + Fa | Show/hide Database explorer Rearrange references a Show/hide Navigator Shift +5 Traces dependents Shift + Ctet + F5 | Moves cursor to Sheet area "7 Check spelling Shift + F7 Traces precedents cert + F7 Opens Thesaurus, Fe Enable/disable additional selection mode tet + FB Highlight cells containing values F9 Recalculate formulas in current sheet cert + 9 Update chart Cet « Shift + F9| Recalculate formulas in all sheets Fu ‘Open Stytes shift + FN Create a document template Shift + Ctet + FU] Update the template FIZ Group the selected data range Ungroup the selected data range cet + FIZ © Practice Exercise ————————— Q6. Method to open LibreOffice Calc in Windows is: ‘a. double-click the shortcut of LibreOffice Calc on desktop b.click the window menu. select UbreOtfice application. then click LibreOffice Cale € Botha andb d. None of the above Q7. Quick Access Tool bar icon Is present on a. Menu bar b. Standard Toot bar Title bar ¢. Status bar Q8. Default name of spreadsheet open in LibreOffice CALE IS sera . untitled X, where X is a number b. cale X, where X is a number © Spreadsheet X, where X Is a number d. None of the above Q9. In LibreOffice Calc Scroll bar Is present on side of window. a. left. right b. right. top. ¢ bottom. right 4. top. bottom Q10. By default........ sheets is/are present LibreOffice Cale: ‘Spreadsheet. al b2 3 a4b. alphabets 4. None of th contains the menus wits tasks. ‘with commands b. Standard Toolbar d. Menu bar is Located just bel low the B.Menu bor = te Ba. 4. None of these the shortcut to ex Cte UbreOtce. Gre bedi Fri it Format ser Cells Insert Rows, Insert Columns opti FPAIDBIE TP enn MOM. omeare aFie Db. Incert any icon displays a -vmsmane Which gives a Bret » Toolbox 4. All of these am—nrennenee SHOWS the address of Active Cell. 2. Name Box Current Cett Ic Formuta bar 1. None of these |The Worksheet In Cale Is also referred to at ‘a Workbook c Sheet ‘Columns are b. Spreadsheet . None of these omennnnes iM the table. a horizontal b. vertical c diagonal 4d. None of these Ja. Column Heading of 27th Column In Calc sheet Is aA bAB CZ 4.28 ‘The intersection of a row and column Is called a. Cell Address b.Cell c Point of intersection _d. None of these 23. Which of the following Is invalid Cell Address? aa b.2247 SIA d. None of these 24. Which of the following Is not true about Currently Selected Cell? a. Currently Selected cell is called Active cell bb. Currently Selected Cell's Address Is visible in Name box Currently Selected Cell have thick border 4. None of the above 25. Address of cell formed by Intersection of tenth column and nineteenth rOW 1S vrnemneres a KIS bik = cS 4.19) 26, Cell address of first row and first column al bw cat dd. None of these = Information Technology | Class 9| 163 Which key combination moves the active cell (elected Cel) to {Slected Cl) to the end ofthe dita range In 2 2. Ctr + Home b.cert+ End © Ctrl + Arrow k d. None of these 28. Which ey combination moves the active cell (Selected Cell) to Ai cell? a. Ctrl + Home b. Ctrl + End © Ctrl + Arrow keys d. None of these Q29. Which key / key combination moves the worksheet ‘one screen up? @. Ctrl + Up Arrow Key —b. Ctrl + Page Up & Page Up d. None of these A block of adjacent cells in a worksheet which is highlighted or selected is called.... a 2. Block of cells b. Range of cells Both a. and b None of these Q3L In LibreOffice Calc, .....- is any text entered by using a keyboard. Q30. a. Values b. Poster € Label 4. None of these 132. By default Labels 2F€ wanennenrenenn aligned. a lett bright © top 4. None of these 33. The data consisting of only numbers are called a Labels b. values « Functions 4d. None of these 034. By default Valves af anennnnnnnenne aligned. 3. top bright cleft 4. None of these Q35. Any expression that begins with an equal “= Is treated 25, * 2. function ». formula € both a.and b 4. None of these Fei Assertion & Reason Type Questions Y Directions (Q. Nos. 36-40): In the questions given below, there are two statements marked as Assertion (A) and Reason (R). Read the statements and choose the correct option. ‘a. Both Assertion (A) and Reason (R) are true and Reason (R) isthe correct explanation of Assertion (A). b, Both Assertion (A) and Reason (R) are true, but Reason (R) is not the correct explanation of Assertion (A). c Assertion (A) is true, but Reason (R) is false. 4d. Assertion (A) is false, but Reason (R) is true. 36. Assertion (A): A spreadsheet software or a spreadsheet processor is a system software that Is Used to organise and to analyse data in a tabular form. Reason (R): Spreadsheet software is utilised for manipulation of data and creation of workbook files comprising one/more related worksheets. eee ee