Spreadsheet software ( MS-Excel)

-


v  What is spreadsheet? Write two examples.
=Spreadsheet is a software package that accepts data in tabular form in rows and columns. It's  two examples are: Visi Calc and Ms-Excel.

v  What is Ms-Excel? Write two versions of Ms-Excel.
=Microsoft Excel is one of the popular and widely used spreadsheet software developed by Microsoft Corporation USA. It's two versions are : Ms Excel 2003 and Ms Excel 2007 .

v  What are different types of cell references?
=The different types of cell references are:
a.       Relational cell reference
b.      Absolute cell reference
c.       Mixed cell reference

v  What is formula? Write the rules for using formula.
=A formula is a sequence of values, cell references, and operators that produces a new value from existing values.
It's rules are:
a.       The formula always must begin with an equal sign
b.      After inserting formula, press Enter key to conform it.
c.       The formulae are not case sensitive.
d.      The cell address also can be used in the formula.

v  What is the fill handle? What is its use?
= Fill handle is a small black square that appears at the bottom right corner of the selected cell. It is use to automatically copy and fill them with a series without using copy command.

v  What is meant by sorting data?
=Shorting is the process of arranging worksheet data in alphanumeric order.

v  What are operators?  List the logical operators used in Ms-Excel.
=The operators are the mathematical symbols that lie between different operands (Value) to perform tasks.

v  What are functions? List some functions used in excel.
=Functions are the built in formulas or readymade expressions which allows performing any calculation quickly and easily. Functions used in excel are: MIN function, MAX function, PRODUCT function, IF functions etc.

v  What is chart? Write the use of legend and gridlines in chart.
= Chart is the graphical presentation of numeric data in the worksheet.
Legend: It is used to describe each of the data series.
Gridlines:  It is used to display for both axes to help read the value of individual data points.

Comments

Post a Comment

Popular posts from this blog

operating system software

-
Image
Ø   What is an operating system? Write any two examples. =An operating system is the most important type of system software that is responsible for the management of various activities of the computer. For e.g. Linux, Unix . Ø   What are the basic functions of an operating system? List any four of them. =The basic functions of an operating system are: a.        Input/output management b.       File and folder management c.        Memory management d.       Run application programmes e.          Ø   What is single user operating system? Write two examples. =An operating system which is designed to operate by single user at a time is called single user operating system. For example: Dos,   Mac Os . Ø   What are differences between GUI operating system and CUI operating system? GUI ...
Read more

Generation of computer

-
Image
a.       What is meant by computer generation? The classification of computers on the basis of main component, their size, processing speed, system architecture etc. is known as computer generation. b.       List any two advantages of second generation computer over first generation computers. The advantages of second generation computer over first generation computers are as given below: -First generation computer user vacuum tube as a main component but second generation computer use transistor as main component. - First generation computer speed was up to milliseconds but second generation computer speed was up to microsecond. - First generation computer were huge in size but second generation computer were smaller and faster than first generation computer etc. c.        Differentiate between third and fourth generation computers. Third generation computer ...
Read more

History of computer

-
Image
a.       How did early people calculate? In early days, there were no facilities to count and calculate. At that time people used different means to count in informal ways such as using pebbles, drawing lines, scratching on walls etc. b.       Why is Charles Babbage known as father of computer science? Charles Babbage is known as the father of computer science because he gave the basic concept of computer in his Analytical engine. c.        Write the feature of Mark-I. The feature of Mark-I are: -           It used 18000 vacuum tubes. -           It consisted seven Lakh and fifty thousand parts. -           It was 51 feet long, 8 feet height and 3 feet wide. -           It consumed huge amount of electricity...
Read more