Page 77 - Artificial Intellegence_v2.0_Class_12
P. 77
4. If cell A1 contains 10 and cell B1 contains 50, the formula is given in C1 as A1+B1.
i. he cell does not sho as ans er instead displays A . hat could be the reason
ii. an e give the formula in any other ay
Ans. i. he cell should contain a formula starting ith sign. In cell , enter A .
ii. e can enter in cell sum A ).
5. What is the use of fill handle?
Ans. he alc ill andle tool is used to automatically fill input in series. It fills the ne t cells hen e drag it ith the ne t
pre-defined value. For example, if you want to fill the numbers in sequence of even numbers 2, 4, 6...., or days of the
eek as onday, uesday,.... or months as an, eb,...., e need to enter the first t o values, select them and drag to
the next cells to generate the series.
B. Long answer type questions.
1. What do you understand by presentation? Name few presentation software.
Ans. Presentation is a way of systematic display of information. It includes pictures, text, graphics, audios, videos and
animated ob ects that are organised and presented in a proper sequence. ith the advent of computers and
development of different types of presentation software, ideas or information can be presented in a more effective,
efficient and interesting way.
here are a variety of presentation soft are available
• Microsoft PowerPoint • OpenOffice Impress
• Google Slides • LibreOffice Impress
• Prezi • Sway
. Define the follo ing terms in association ith spreadsheet
i. Formula bar
ii. Name box
iii. Worksheet
Ans. i. Formula bar: Whatever you input, it appears in the formula bar. You can also immediately input or change data
and formulas in the Formula Bar.
ii. Name box: he location of the selected cell is displayed in the name bo . he cell s location is a combination
of column and row. For instance, B5, where B denotes the column name and 5 denotes the row number.
iii. Worksheet: A orksheet is a collection of cells in the shape of a grid a net ork of intersecting lines that form
rectangles). hen you initially open a spreadsheet, you ill see a blank orksheet ith the name heet .
3. What do you understand by function? Name and define the various functions Calc provides.
Ans. A function is a pre-defined formula that performs calculations with specific values in a specific order. One of the
primary advantages of functions is that they can save your time because you do not have to write the formula yourself.
Calc has various functions to help you with your calculations.
i. SUM: To calculate the sum of a given range of numbers
ii. MAX: To find the maximum number from a given range of numbers
iii. MIN: To find the minimum number from a given range of numbers
iv. AVERAGE: To find the average value of a given range of numbers
4. What are the advantages of spreadsheets?
Ans. preadsheet programmes have gro n in popularity due to the follo ing benefits
i. Built-in functions make calculations easier, faster, and more accurate.
ii. Large amounts of data can be handled and manipulated with ease.
iii. Data can be e ported to or imported from other applications.
iv. Data can be easily represented in pictorial form, such as graphs or charts.
v. ormulae are automatically recalculated hen the underlying data values change.
IC T S ki l l s- IV 75

