Chapter 1

Formulas in Excel

Descriptive type Questions.

Answer the following Question.

A.What is Circular Referance?Explain with Example

A reference in which a formula refers to its own value is called a
circular reference.
Example:if we enter the formula =A1+A2+A3 in cell A1, every time it
calculates the formula in cell A1, it must be calculated again because
A1 has changed.

B.Write steps to find LCM of three numbers.(long)

• Click Math & Trig and then select LCM
• Enter any values in the Number1 , Number2 and Number3 text
boxes, respectively.
• Click OK. The output will appear in cell selected cell.

C.Write two ways of entering a cell referance in formula by

typing and by pointing
Typing: we select a cell and enter the formula in the cell or in the
Formula Bar and press Enter once we are done entering the formula
Pointing: we select a cell and type `=’ and instead of typing the rest
of the formula we click on the cell to which the reference has to be
made.

D. What will you do to display formula after calculated values?

To see the formula we have to select the cell in which the formula is
entered. The formula is displayed in the Formula Bar when the cell is
selected. Or select show formula option from the tab, it will display
all the formulas in sheet.

E. Name different arithmetic operators in excel.

Multiplication, exponent, subtraction, addition, and division

F.Write down method of calculate the values in excel.

The two ways of creating a sheet using the formula bar or Autosum
feature.In formula Bar The user has to type in the cell numbers to
which the formula applies. By using the Autosum feature, the user
does not have to type in the cell numbers individually instead we can
select a range.
G. Working of Relative, Mixed, and Absolute Cell References in
Excel

There are 3 types of cell references:

1. Relative Reference: This changes when you copy the formula

to another cell.Example: In cell B2: =A1 + 5 If you copy this formula
to cell B3, it changes to =A2 + 5. Excel adjusts the reference
automatically.
2. Absolute Reference This does not change when you copy the
formula.
You use the dollar sign $ to lock the cell. Example: In cell B2:
=$A$1 + 5 If you copy it anywhere, it always uses A1.
3. Mixed Reference : This locks either the row or the column
only.
Example: $A1 → Column A is fixed, row can change A$1 → Row 1 is
fixed, column can change ,This is useful when copying formulas
across a table.
G. Explain the Working of Concatenation

Concatenation means joining two or more text values together.

We use the & symbol Example If A1 has "Hello" and B1 has "World"
Formula: = (A1& " "& B1) gives in C1: Hello World

Application Based Questions page 17

a. i. not have an ‘=’ sign at its beginning.
ii. Yes. According
to values calculation
also change
b. i. 3
ii. =C2+D1 and the
result would be value
7.
iii. Relative
referencing
iv. c. i. 36
ii. C2 = 54, C3 = 27, C4 = 72
iii. $B$1 is absolute referencing and A1 is relative
referencing.
 d. i. C2 = 0.08*B2 D2 = B2-C2 ii. When bottom-right
corner of c2 + sign appears. Then drag and drop.
Chapter 2
Creating charts in Excel 2013

Answer the following Questions.

Question#1:Define charts and write down its types name ?
The pictorial representation of data is called charts.Charts have
different types like
 line chart
 column chart
 donught chart
 scatter chart
 Area chart
 radar chart

Question#2:Write short note on column chart.

It shows the changes in data over period of time it describe
comparison among items.values shows vertically and categories
arranged in horizontally.

Question#3:Write down components of charts.

 Data table
 X-Axis
 Y-Axis
 Chart Title
 Charts area
 Plot area
 Legend

Question#4Difference between line chart and Bar charts

Line chart Bar Chart

 Compare trends in data at  It describe comparison among
equal interval. individual items

 It is useful for depicting  Categories organized vertically

changes in value over period of and values horizontally.
time

Question#5:Draw the shape of pie chart and write its function.

A pie chart is a type of graph representing data in a circular form,
with each slice of the circle representing a fraction or proportionate
part of the whole. All slices of the pie add up to make the whole
equaling 100 percent and 360 degrees.

Question#6:What is a combo chart?How will you create a

combo chart?
.A combination chart is a single chart that consists of a series which
uses different chart types. . For example, you may have a chart that
shows both columns and lines with two value axes.

Question#7:What is a sparkline? How is it different from

charts?
Sparkline is a miniature chart embedded in a single worksheet cell. It
provides a visual representation of data.. For example, line and
column sparklines are compact versions of the standard line and
column charts.

Question#8:How will you delete sparklines?

i. Select the sparklines.
ii. Under SPARKLINES TOOLS, click the
DESIGN tab. iii. In the Group group, click the
arrow next to Clear. iv. Click Clear Selected
Sparklines.

Question#9:What do you understand by quick analysis button?

Write down steps to create bar chart using Quick analysis
button.
The Quick Analysis helps in creating a chart or sparklines. To create a
chart using Quick Analysis tool:
i. Select the range of cells.
ii. Click the Quick Analysis button.
iii. Click the CHARTS tab. iv. Click the Insert Chart button.

Question#10:Evaluate the statement” Charts formatting option

in
Excel 2013 are excessive.”
Agree Disagree
A large number of options Too many options make it difficult
makes it easier to represent to decide what to use
data in creative ways.
We can add important details to Charts should be simple and
charts. adding too many details can be
confusing for the person reading
them.
Application Based Question A. .Recommended charts ii. INSERT -
> Charts group -> Column drop-down menu -> Clustered Column.
b.
i. 13 years ii. Years
8-10 and 17-22.
c.
i. Type group->Change Chart Type -> dialog box ->new chart
type -> OK. ii. Locaton Group ->Move Chart ->dialog box
appears ->New sheet ->type a name
d.
i. Quick Analysis
ii. Quick Analysis->CHARTS tab. ->Insert Chart The Insert Chart -
>Select pie chart ->click OK.
Chapter 3
Computer Viruses

Answer the following Questions.

Question#1:Name the types of viruses that infects data
files. Macro virus viruse infects data files.

Question#2:What is the name given to a database of viruses

that an antivirus software scans for?
Virus definitions is the name given to a database of viruses that an
antivirus software scans for

Question#3:Define a computer virus.how can it harm your

computer.
A computer virus is a software program that has the ability to make
copies of itself, and to attach itself to other programs or files.
Different viruses do different things. A computer virus could be
capable of any of the following:
•It can infect executable program files such as word processors,
spreadsheets, and operating systems

Question#4:Mention any three precaution you should take for

protecting your computer from virus infection.
Restrict access to your system, both offline and online.
•Allow only trustworthy users to use the system.
•Install and use antivirus software and keep it updated.

Question#5:How does a computer viruse spread from one

computer to another?
Computer viruses spread from one computer to another by the
transfer of infected data through emails, pen drives, or other sources.

Question#6:Analyze how boot macro and program viruses

affects working of your computer?

Boot Viruses Macro Viruses Program Viruses

infect the boot are written in the infect program files

records of both hard same language in and become active
disks and floppy disks
which common when the program
they become active
when the computer is programs are written is executed
‘booted’, i.e. turned such as MS Excel or
on MS Word they
become active once
the application is
opened
Application Based
Questions: A.
i. Spam
ii. Spam mails may carry advertisements or serve as a means of
spreading malware like viruses and worms.
iii. Delete spam mails b.
i. computer virus.
ii.change in file size And when computer restarts on
its own. iii. install an antivirus software and keep
it updated. c.
i. Antivirus software
ii. QuickHeal Antivirus and Kaspersky
Antivirus iii. updated regularly. d.
i. Program
virus ii. Macro
virus
iii. Boot viruses
____________End Term 1_________