Std VI Unit II - Revision PDF

PODAR INTERNATIONAL SCHOOL, ICSE-ISC, NERUL Unit II Revision (2024-25) Subject: COMPUTER STUDIES GRADE: VI Portion: Ch 4: Spreadsheet - An Introduction L QI) Fill...

PODAR INTERNATIONAL SCHOOL, ICSE-ISC, NERUL Unit II Revision (2024-25) Subject: COMPUTER STUDIES GRADE: VI Portion: Ch 4: Spreadsheet - An Introduction L QI) Fill in the blanks: U 1. A spreadsheet application is used to store data in rows and columns. 2. The Menu bar is located under the Title bar. ER 3. Formatting toolbar contains icons and drop-down menus that provide easy access to select a font, font colour, alignments, number formats, border options and background colours. N 4. Function wizard option is used to open a dialog box that allows you to search through a list of available functions. SE 5. The fundamental element of a worksheet is called as a cell. 6. Rows are arranged horizontally. 7. A worksheet contains columns, rows and cells. C 8. Formulas are used for calculations which can be performed only on numbers. II 9. Ctrl + V is the shortcut key used to paste the copied content. 10. The Sheet tabs allow you to navigate between different worksheets PS Q.II Name the following 1. A feature used to reverse the action you performed earlier. - Undo 2. It contains icons that provide easy access to commands such as New, Open, Print, Copy, Paste, and so on. - Standard Toolbar 3. It is a feature that’s opposite to undo.- Redo ICSE/VI/24-25 Page | 1  4. What is the default name for the first sheet in OpenOffice Calc?- Sheet 1 5. In OpenOffice Calc, which toolbar is used for changing the font style, size, and Color? - Formatting Toolbar 6. It contains icons that provide easy access to commands such as New, Open, Print, Copy,Paste.- Standard Toolbar 7.It is the shortcut key used to paste the copied content.- Ctrl+C 8. It will display the content in a cell in multiple lines by increasing the height of the row. - Wrap Text L 9. To align the content towards the center of the cell. - Align Center U 10. This option adds a decimal place to a number in the cell. - NumberFormat- ER Add Decimal Place Q.III Select the correct option. N 1. ________ is the shortcut key used to paste the copied content. a) Ctrl+P b) Ctrl+V SE c) Ctrl+C d) Ctrl+X C 2. Which application is used to store data in rows and columns, i.e. tabular form? II (a) Spreadsheet (b) Word (c) Presentation PS 3. ____________option is used to open a dialog box that allows you to search through a list of available functions. (a) Name Box b) Function wizard c) Cell ICSE/VI/24-25 Page | 2 QIV. Answer in Brief 1. Name the Following L U Ans. a) Name Box b) Sum ER 2. Observe the following data and answer the following: N SE C a) Write the formula/function to find the total amount. Ans. =Sum(D3:D5) II b) By default what is the colour of the background and font of all the cells in Openoffice calc. PS Ans. By default the colour of the background is white and font of all the cells is black. c) What is the cell range of all Items ? Ans. (B3:B5) QV) Answer the following: 1. What is a spreadsheet? Ans: - A spreadsheet application is used to store data in rows and columns, i.e. tabular form. ICSE/VI/24-25 Page | 3 - These rows and columns are collectively called a worksheet. - On each worksheet, data is organised vertically in columns and horizontally in rows. - A spreadsheet application can also be used to sort, manipulate, calculate and analyze data. - Examples of spreadsheet software include Google Sheets, iWork Numbers, LibreOffi ce, Lotus Symphony, Microsoft Excel OpenOffice Calc. L U 2. Describe any three applications of a spreadsheet. ER Ans: It can be used in industrial modeling and planning projects. It is used in household finance planning as well as business accounts and budgeting. N It allows you to create reports and invoices. SE 3.Raj wants to help his teacher to create the Class list of his class in Open office Calc. After finishing the list he realized that a student name was missing. Give him the steps to insert the missing name in the list. C Ans. Steps to insert a row II Step 1: Select the cell above which you want to add a row and right-click the cell. Step 2: Click the Insert option from the context menu (pop-up menu) that appears. PS Step 3: Select the Entire row option from the dialog box and click the OK button. A row will be inserted above the selected cell. THen Raj can add the missing name. 4. Aditi has created a Calc worksheet. Which cell format in Calc should she use to display the numbers as shown below? i. $80 Ans: Currency ii. 50.00% ICSE/VI/24-25 Page | 4 Ans: Percent 5. Write down one difference between Function Wizard and Sum Ans 5. Function Wizard is used to open a dialog box that allows you to search through a list of available functions. Sum- The sum option is used to insert a formula into the current cell that adds the numbers in the cells. L 6.Write Down the different Horizontal and Vertical Alignments used in Spreadsheet U ER a) Horizontal Alignment Ans. Left, Center, Right, Justify N b) Vertical Alignment SE Ans. Top, Middle, Bottom ************** C II PS ICSE/VI/24-25 Page | 5