Write very
short answer of the following questions.
a) Is
Ms-Word spreadsheet software?
Ans: No,
Ms-Word is not spreadsheet software.
b) Which
company released Excel program?
Ans: Excel
program was released by Microsoft Corporation USA.
c) Which
symbol is used to make absolute cell reference?
Ans: $
symbol is used to make absolute cell reference eg: $b$2
d) Which
symbol is used to begin formula in Ms-Excel?
Ans: Is
equal to (=) symbol is used to begin formula in Ms-Excel.
e) How many
types of data sorting are used in Excel?
Ans: There
are two types of sorting data either in ascending order or in descending order.
f) Write
the symbols used as reference operator.
Ans: Colon
(:) symbol is used as reference operator.
g) Write the
use of RANK function in excel.
Ans: RANK
function is used to find rank from the given number list in excel.
h) How many
Row and columns are there in Ms-Excel 2016?
Ans: Each
worksheet of Ms-Excel 2016 contain 1,048,576 rows and 16,384 columns.
i) What is
the extension of Excel worksheet?
Ans: Dot
xls or Dot xlsx (.xls or .xlsx) is the extension of Excel worksheet.
Write short
answer of the following questions
a) What is
spreadsheet? Write two example.
Ans:
Spreadsheet is a software package that accepts data in tabular form in row and
columns. Example: Visi calc, Ms-Excel etc.
b) What is
Ms-Excel? Write two versions of Ms-Excel.
Ans:
Ms-Excel is one of the popular and widely used spreadsheet software developed
by Microsoft Corporation USA. Ms-Excel 2007, Ms-Excel 2016 are the two version
of Ms-Excel.
c) What is
formula? Write the rules of using formula.
Ans:
Formula is a sequence of values, cell references and operators that produces a
new value from existing values.
Rules for
using formula in Excel are given below:
i) The
formula always must begin with an equal sign (=)
ii) After
inserting formula, press Enter key to confirm it.
iii) The
formula are not case sensitive.
iv) The
cell address also can be used in the formula. Eg. (A2+B2)*F5
v) The
references, constants, operators and functions can be used in formula.
d) What is
the fill handle? What is its use?
Ans: Fill
handle is a small black square that appears at the bottom right corner of the
selected cell. It is used auto fill list items, to fill custom list etc.
e) What is
meant by sorting data?
Ans:
Sorting is the process of arranging worksheet data in alphanumeric order. There
are two types of sorting data in the cell either in ascending order or in
descending order.
f) What is
chart? List the common chart types.
Ans: Charts
are graphical presentation of numeric data in the worksheet. Charts are based
on data contained in worksheets and it helps to observe and compare different
data in the worksheet.
The most
commonly used types of charts are Bar chart, Column chart and pie chart.
MS-Excel
is widely regarded as a popular and user-friendly spreadsheet software due to
several key reasons:
1.
Intuitive
Interface: Easy-to-navigate grid layout with
an organized toolbar.
2.
Versatility: Suitable for tasks ranging from simple lists to complex
financial models.
3.
Comprehensive
Features: Offers powerful tools like
formulas, charts, and pivot tables.
4.
Data
Visualization: User-friendly charting and
graphing for clear data insights.
5.
Integration: Seamlessly works with other Microsoft Office apps and
external data sources.
6.
Support: Extensive online resources and a large user community.
7.
Customizability: Macros, custom functions, and add-ins tailor the
experience.
8.
Cross-Platform: Available on Windows, macOS, and mobile devices for
on-the-go access.
Overall, MS-Excel’s combination of
ease of use, powerful features, and flexibility makes it a go-to tool for
individuals and businesses alike. Whether for simple data entry or complex data
analysis, Excel provides the tools necessary to handle a wide array of tasks
efficiently.
b) Types of
Cell References in MS-Excel:
1.
Relative
Reference: Changes when a
formula is copied to another cell.
o Example: If =A1+B1 in cell C1 is copied to C2, it becomes
=A2+B2.
2.
Absolute
Reference: Remains
constant when copied. Indicated by $.
o Example: =$A$1+$B$1 remains the same when copied.
3.
Mixed
Reference: Either the row
or column is fixed.
o Example: =A$1+B$1 will adjust the column but keep the
row constant.
c) Common
Functions in MS-Excel:
1.
SUM(): Adds a range of cells.
o Example: =SUM(A1:A10) adds all values from A1 to A10.
2.
AVERAGE(): Calculates the average of a range.
o Example: =AVERAGE(B1:B10) computes the average of values in B1
to B10.
3.
IF(): Performs a logical test and returns
one value for TRUE and another for FALSE.
o Example: =IF(A1>10,
"Pass", "Fail") returns "Pass" if A1 is greater
than 10, otherwise "Fail".
4. OR(): Checks if any of the given
conditions are true. Returns TRUE if at least one condition is met, otherwise
FALSE.
- Example: =OR(A1 >
10, B1 < 5)
returns TRUE if A1 is greater than 10 or B1 is less than 5.
5. AND():
Checks if all the given conditions are true. Returns TRUE only if all
conditions are met, otherwise FALSE.
- Example: =AND(A1 >
10, B1 < 5)
returns TRUE if both A1 is greater than 10 and B1 is less than 5.
6. MIN():
Finds the smallest number in a range of cells.
- Example: =MIN(A1:A10) returns the
smallest value from A1 to A10.
7. MAX(): Finds the largest number in a
range of cells.
- Example: =MAX(A1:A10) returns the
largest value from A1 to A10.
Write the step to perform the
following task in Ms excel 2016
a)
To
sort data
·
Select
the data range you want to sort.
·
Go
to the “Data” tab.
·
Click
“Sort A to Z” or “sort Z to A” for a quick sort, or click “Sort” for more
option.
b)
To
apply function.
·
Select
the cell where you want the result.
·
Type
= followed by the function name (e.g., =SUM(A1:A10))
·
Press
Enter to apply the function.
c)
To
create chart
·
Selected
the data you want to chart.
·
Go
to the insert tab.
·
Choose
the desired chart type from the charts group.
d)
To
change font of selected cells.
·
Selected
the cell where you want change the font.
·
Go
to the home tab.
·
use
the font dropdown menu to choose your desired font.
0 Comments