Page 76 - Web Applications (803) Class 12
P. 76
At a Glance
• ICT, or information and communication technology, has become an essential component of our daily lives.
• A spreadsheet is a type of electronic document with rows and columns.
• It is used to store data and perform calculations in a systematic manner.
• A worksheet contains numerous cells arranged in rows and columns.
• A cell is a rectangle-shaped box formed by the intersection of a row and column.
• A row is a horizontal (sleeping) arrangement of cells.
• A column is a vertical (standing) arrangement of cells.
• A spreadsheet with one or more worksheets is referred to as a workbook.
• Formulas can be entered in a cell or typed in the formula bar.
• Each formula must begin with an ‘=’ (equal to) symbol.
• Data stored in a spreadsheet can be used for calculations, graphical representation, and information display.
• A function is a pre-defined formula that performs calculations with specific values in a specific order.
• Calc has various functions to help you with your calculations like SUM, MIN, MAX, AVERAGE.
• Presentation software is widely used to create digital presentations.
• A presentation can be made interesting by including images, videos, animation, and music.
• You can change the layout of the slide through the layout tab.
Exercise
Solved Questions
SECTION A (Objective Type Questions)
uiz
A. Tick ( ) the correct option.
1. In Calc spreadsheet software, are numbered from 1 and are numbered from A
onwards.
a. columns, rows b. columns, spreadsheet
c. rows, columns d. rows, slides
2. What is the value of the following formula:
=SUM(10,20,30,40)
a. 110 b. 100
c. 40 d. Error
3. is a collection of numerous rows and columns.
a. worksheet b. slide
c. workbook d. None of the above
4. What is the keyboard shortcut of Paste?
a. Ctrl + P b. Ctrl + C
c. Ctrl + V d. Ctrl + X
74 Touchpad Web Applications-XII

