computer application paper solution summer 2012.doc

8/10/2019 Computer Application Paper Solution Summer 2012.doc

1/31

Computer Application Paper Solution Summer 2012

Q.2) How one can insert picture in the document file in Ms-ord. !10 Mar"s)

Ans# MS office word is generally used for writing text. However, you may like to insert picture

as well because it can help in making the document illustrative as well as interesting. This is the

reason we shall provide you with the right steps that can help in inserting pictures in your word

file.

Open the MS office word file in which you want to insert picture.

Move over to the cursor to the part where you want to stick the picture.

lick the !"nsert# tab present in the top row.

$s you can see in the above screenshot, you need to move to the insert tab where you find thedifferent options.

Move to the !picture# option to insert pictures which are located on the disk.

"f you want to insert !clip art#, select the !lip $rt# option from the insert tab.

$fter you click the !%icture#, a dialog box opens.


2/31

%rovided above is the screenshot for the dialog box that pops up after clicking %icture.

"n the dialog box, you can select the right picture to be inserted by moving over to the

right drive in your computer. $fter you have found the right picture, click the picture and then click !insert# which is

present at the bottom right corner.

$s you can see, after the right picture has been spotted, you need to click it and then select insert.

$fter you click !"nsert#, the picture is inserted in the MS office word file.

The image can then be formatted as the picture is provided with tools for rotating and

resi&ing.

$s you can see, the picture can be easily rotated and even resi&ed.

The rotating tool is present right in the center of the picture. 'ou can move it right or left

to turn the picture. $t the corner of the picture, there are arrows provided which can be used for increasing

or decreasing the si&e.


3/31

Thus, using the above steps you can insert a picture and format it to make the documentillustrative.How $o %nsert a Picture $hat %s &ot Present 'n (our is"

(or inserting files that are not present in your hard disk drive, you can use two different options.

(irst of all, you can simply save the picture on to your disk by right clicking on the image

and selecting !Save image#. $fter you have saved the image on to a location in your

computer, you can use the same process as above for inserting the picture. Secondly, you can simply copy the image by right clicking on the image and selecting the

option !opy "mage# or simply use the keyboards shortcut ontrol ) . $fter you havecopied the image, move to the MS office word file and scroll to the part where you wantto insert the image. *ight click on the position where you want to insert and then click!paste# or simply use the keyboard shortcut ontrol ) +.

$fter you have done this, the image gets pasted on the word file and you can format it for youruse with the help of formatting tools like rotating tool or resi&ing tool.Thus, this is the main way you can paste the pictures in the word file. Try and paste randompictures to get a hang of things. sing pictures and incorporating them in your MS office word

file may help in making impressive documents. So, follow these steps to learn the use of some ofthe basic tools of MS office word.


4/31

Q.1) rite short notes on the followin* !10 Mar"s)

a) Para*raph formattin* in MS-'+

$ns-

Para*raph formattin*#

%aragraph formatting changes the position and appearance of paragraphs of text. 'ou can makechanges to alignment, indent paragraphs, or adust line spacing.

%ndentin*

To indent and line up lists of text such as /ualifications on a + press the $a, "eon thekeyboard. 0o not use the Space ,aras this will not line up the text correctly.


5/31


6/31

,) Copin* and Moin* cells in Ms-/cel.

$ns-

Move or copy data to another worksheet or workbook

$lthough moving or copying the actual worksheet is a fast and effective way to transfer data to

another location, you can also move or copy all or part of the data in a worksheet to another

worksheet. This method can be used to transfer data to a worksheet in a workbook that is open in

a separate instance of 1xcel.

2. "n a worksheet, select the data that you want to move or copy.

3OT1 "f the selection includes hidden rows or columns, 1xcel also copies the data in those

hidden rows and columns. 'ou may have to temporarily unhide rows or columns that you do not

want to include, and then select each range of data that you do want to move or copy in separate

operations. (or information, see Hide or display rows and columns.

2. On the Hometab, in the Clip,oardgroup, do one of the following-

To move the selected data, click Cut .

e,oard shortcut'ou can also press T*4)5.
http://office.microsoft.com/en-in/excel-help/redir/HP001217049.aspx?CTT=5&origin=HP001217035http://office.microsoft.com/en-in/excel-help/redir/HP001217049.aspx?CTT=5&origin=HP001217035


7/31

To copy the selected data, click Cop .

e,oard shortcut'ou can also press T*4).

6. 0o one of the following- lick the worksheet where you want to paste the data.

Switch to a workbook that is opened in another instance of 1xcel, and then click the

worksheet where you want to paste the data.

4. Select the upper7left cell of thepaste area.

3OT1 0ata in the paste area will be overwritten. $lso, if the paste area contains hidden rows

or columns, you might have to unhide the paste area to see all the copied cells.

8. On the Hometab, in the Clip,oardgroup, click Paste .

e,oard shortcut'ou can also press T*4)+.

T"% To keep the column width that was originally specified for the data, click the arrow

below Paste , click Paste Special, and then under Paste, click Column widths.

3OT1S

9y default, 1xcel displays the Paste 'ptionsbutton on the worksheet to provide you

with special options when you paste cells, such as eep Source ormattin*and Matchestination ormattin*. "f you do not want 1xcel to display this button every time thatyou paste cells, you can turn this option off.

2. lick the Microsoft 'ffice 3utton , and then click /cel 'ptions.

:. "n the Adancedcategory, under Cut4 Cop4 and Paste, clear the Show Paste 'ptions

,uttonscheck box.

;hen you copy cells, cell referencesare automatically adusted. However, when youmove cells, cell references are not adusted, and the contents of those cells and of anycells that point to them might be displayed as reference errors. "n this case, you will haveto adust the references manually.

c) 5raphics and Charts in Ms-/cel.
http://appendpopup%28this%2C%27283322801_6%27%29/http://appendpopup%28this%2C%27334203780_7%27%29/http://appendpopup%28this%2C%27283322801_6%27%29/http://appendpopup%28this%2C%27334203780_7%27%29/


8/31

Ans#

Chart $pes in Microsoft /cel

Excel allows you to create charts in a variety of types: Bar Charts, Column Charts, Line

Charts, Area Charts, Scatter Charts, Pie Charts, Stock Charts. ou can !efine a chart typewhen creatin" your chart in Step # of theChart $i%ar!, or on an existin" chart usin" the

techni&ue !esci'e! 'elow.

Select a Chart Type

ou can open the Chart (ype !ialo" 'y selectin" the chart or a chart series, an! usin" the

Chart (ype menu comman! from the Chart menu:

or 'y ri"ht clickin" on the chart or a series an! choosin" Chart (ype from the context menuthat pops up:

)ote that if a sin"le series is selecte! when you use the Chart (ype comman!, only theselecte! series will 'e chan"e!* if the entire chart is selecte!, every series will chan"e.
http://peltiertech.com/Excel/ChartsHowTo/Charting101.html#ChtWizhttp://peltiertech.com/Excel/ChartsHowTo/Charting101.html#ChtWiz


9/31

$hen you select the Chart (ype comman!, the Chart (ype !ialo" +shown 'elow sprin"s intoaction. (he Stan!ar! (ypes ta' of the Chart (ype !ialo" shows a list of chart types on the

left si!e, an! several chart su'-types on the ri"ht. (he Custom (ypes ta' has a num'er of'uilt-in custom types of charts, inclu!in" several com'ination charts +these are not the only

possi'ilities: see oll our /wn Com'ination Chartselsewhere on this site. ou can a!!

your favorite custom chart types to the 0ser-1efine! list.

Column Charts

Column charts are amon" the most common chart types you will use +see !ialo" 'ox

a'ove. (he two commonly use! su'-types are the Clustere! Column type +top left optionan! the Stacke! Column type +top mi!!le* the #223 Stacke! Column type +top ri"ht

normali%es each stack so it reaches the top of the chart. 4 avoi! the 51 styles, 'ecause 4fin! it !ifficult to line the column tops up with the tick marks on the axes. Bar charts are

hori%ontally oriente! versions of column charts.

Line Charts

Line charts are also commonly use! in Excel. (he !efault Line-$ith-6arkers is pro'a'lymost common +selecte! in the !ialo" 'ox 'elow* other options inclu!e Stacke! Line an!

#223 Stacke! Line, an! all of these are availa'le with or without markers. A"ain, 4 avoi!the 51 Line type.

(he Cate"ory +7 values in a line chart are treate! as e&ually-space! non-numericcate"ories, unless a time-scale cate"ory axis is selecte! in Step 5-Chart /ptions, an! points

are plotte! in or!er from left to ri"ht.
http://peltiertech.com/Excel/Charts/ComboChart1.htmlhttp://peltiertech.com/Excel/Charts/ComboChart1.html


10/31

For a discussion of X axis types, seeX Axis: Category vs. Value; for a comparison of Linecharts and X !catter charts, see my article, !catter Chart or Line Chart", in

the #ech#rax$e% maga&ine.

XY Scatter Charts

(he 7 +Scatter Chart is the type 4 use most often. 4n a!!ition to the !efault 6arkers-/nlystyle, you can select smoothe! or strai"ht line connectors, with or without markers, as

shown 'elow.4n a Scatter chart, 'oth the 7 an! values are treate! as continuouslyvaria'le numeric values. A lo"arithmic 7 axis can only 'e pro!uce! in an 7 chart.

For a discussion of X axis types, seeX Axis: Category vs. Value; for a comparison of Linecharts and X !catter charts, see my article, !catter Chart or Line Chart", in

the #ech#rax$e% maga&ine.
http://peltiertech.com/Excel/ChartsHowTo/CatVsValueAxis.htmlhttp://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=190http://www.mousetrax.com/techtraxhttp://peltiertech.com/Excel/ChartsHowTo/CatVsValueAxis.htmlhttp://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=190http://www.mousetrax.com/techtraxhttp://peltiertech.com/Excel/ChartsHowTo/CatVsValueAxis.htmlhttp://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=190http://www.mousetrax.com/techtraxhttp://peltiertech.com/Excel/ChartsHowTo/CatVsValueAxis.htmlhttp://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=190http://www.mousetrax.com/techtrax


11/31

Other Chart Types

Excel offers a num'er of other chart types. Area charts are similar to line charts, with theareas un!er the lines fille! in with some color pattern. ou can make several versions of Pie

charts, an! 1ou"hnut charts are similar, 'ut allow multiple series, plotte!

concentrically. Bu''le chartsallow an a!!itional value to 'e plotte! for each point, wherethe !iameter of the circle representin" the point is si%e! accor!in" to the thir!

varia'le. Stock chartslet you plot hi"h, low, an! closin" stock prices, with some optionsallowin" openin" prices an! a!!itional series, representin" volume or a market in!ex.

Cylin!er, Cone, an! Pyrami! charts are 51 Column charts which use other shapes instea! ofrectan"ular columns. ou are encoura"e! to experiment with these chart types outsi!e of

this tutorial, 'ut !iscoura"e! from usin" them to !isplay real !ata. (he false thir! axis an!the o!! shapes can !istort the !ata an! !istract the viewer from the point of the chart.

Combo Charts

ou can mix !ifferent types on a sin"le chart, 'y assi"nin" !ifferent chart types to !ifferent

series on the chart. (hese are Com'ination Charts, an! Excel provi!es a small num'er ofthese on the Custom (ypes ta' of the Chart (ype !ialo" 'ox.
http://peltiertech.com/Excel/ChartsHowTo/HowToBubble.htmlhttp://peltiertech.com/Excel/Charts/stock.htmlhttp://peltiertech.com/Excel/ChartsHowTo/HowToBubble.htmlhttp://peltiertech.com/Excel/Charts/stock.html


12/31

ou can create your own com'ination charts with a wi!er variety of com'inations, 'yapplyin" the Chart (ype menu comman! to selecte! series in your chart, not on the chart as

a whole. (his "ives you much more flexi'ility over the types an! formats you can use inyour charts.

d) Mathematical functions in Ms-/cel.

Ans#


13/31


14/31


15/31

Q.6) How to create ta,le of contents in MS-ord. !10 Mar"s)

How to create a $a,le of Contents

2. $pply the built7in Heading styles to the headings in your text.

:. "n ;ord :


16/31

;ord will add a heading. AThere is further information about content controls below.B The only difference

between the two is the text of the heading AContentsC and CTable of contentsCB.

There is a ,uilt-in :Manual $a,le:. This takes you back to the era of the electric typewriter. "f

you like typing things out for no good reason and your life expectancy is a lot longer than mine, this is for

you.

$t the bottom of the menu, you can choose %nsert ta,le of contents. This displays the Table of

ontents dialog that was also in earlier versions of ;ord. "f you want two or more tables of contents in one

document, you must choose this option for the at least the second and subse/uent tables of contents.;sin* a ta,le of contents content control in ord 2008 or ord 2010

'ou can use the content control to manage your table of contents A(igure 2B.

Figure 1: A table of contents in a content control

"f you attempt to insert another custom or built7in table of contents that will be placed in a content control, then the

new one will over7ride the existing one. "f you want more than one table of contents in a document, use the C"nsert

table of contentsC menu option for all, or at least the second and subse/uent, tables of contents.

How to create a custom ta,le of contents and hae it appear on the $a,le of Contents menu in ord 2008

or ord 2010

'ou can save a custom table of contents and have it appear on the *eferences ? Table of ontents menu.

2. "nsert your table of contents into any document, and adust it to suit your needs.

:. $dd text above andDor below the table of contents as re/uired Afor example, add a heading CTable of

ontentsC, preferably formatted with the built7in TO Heading styleB.

6. Select the text above, the table of contents, and the text below.

E. "nsert ? Fuick %arts? Save Selection to Fuick %art Gallery.

8. "n the reate 3ew 9uilding 9lock dialog-

give your table of contents a name

in the Gallery list, choose Table of ontents


17/31

in the ategory list, choose @reate new category@ and name your new category

click O=.

'ou can now insert your table of contents using *eferences ? Table of ontents. "t will be inserted into a content

control, like the built7in tables of contents.

;ord displays entries in the menu in alphabetical order by category. Sadly, there are few letters in the alphabet

before the C9C for C9uilt7"nC. "f you want your custom tables of contents to appear before the 9uilt7"n category, but

there is no name between C$C and C9uilt7"nC that suits you, then put a space at the beginning of the category name.

(or example, name your category C ShaunaC. $ space is alphabeti&ed before a letter, so C ShaunaC will be displayed

before C9uilt7"nC.

Customi


18/31

How to create a ta,le of contents for seeral documents

To create one table of contents for several documents, you need to do the following.

2. reate a separate document to hold the table of contents Awe@ll call this Cthe To documentCB.

:. (or ease, put all the documents, and your To document, in the one folder.

6. "n your To document, use an *0 A*eference 0ocumentB field for each document that you want to include

in your Table of ontents.

To insert an *0 field, do ctrl7( and, within the brackets that ;ord gives you, type *0

CfilenameC. (or example I *0 Chapter 2.docxC J. 'ou can@t type the curly brackets by hand. 'ou must do

ctrl7(.

"f you can@t put all your files in one folder, you must use double backslashes and double /uotes.

(or example, I *0 C-KKMy folderKKhapter 2.docxC J.

"n theory, you can use relative path names. 9ut it never seems to work properlyLg?.

E. $dd an *0 field for each document that you want to reference, in order.

8. reate the Table of ontents in this To document in the usual way.

. *emember the page number rule- CThe Table of ontents will pick up whatever pagination appears in your

documentC. "t applies when using *0 fields to create a To for many documents. 'ou may have to set the

starting page number manually in each document if you want pagination to run consecutively through your

proect.

'ther tips a,out $a,les of Contents

"f you have ;ord :to

update it. Or ctrl-a >to update all fields in the document. "n ;ord :


19/31

Figure 2: Whenever you see this box, alwayschoose the second option and update the entire table.

To ensure that ;ord always updates the Table of ontents when you print your document,

do $ools 7 'ptions 7 Print. Tick the ;pdate ieldsbox.

The Table of ontents will pick up whatever pagination appears in your document. To control page

numbers, seeHow to control the page numbering in a ;ord documentat the ;ord M+% ($F site

"f the tabs in your Table of ontents seem to have gone cra&y, see;henever " update my Table of ontents

it ac/uires unwanted tabs, and " have to press trl)F to get rid of themat the ;ord M+% ($F site To make changes to your Table of ontents, click within the To, or use the arrow keys to get within it.

Then re7doStep :.This will edit your existing Table of ontents, rather than creating a new one.

9y default, all versions of ;ord make the page number in a Table of ontents a hyperlink to the heading

within the document. 9ut recent versions, by default, make each entry in the To a hyperlink. This can easily

drive you cra&y.

To solve the problem, select the whole of the Table of ontents Aselecting a few paragraphs either side is O=B.

0o Shift7(. 'ou@ll see the field codes exposed, and they@ll look something like I TO Ko C276C Kh K& J.

1dit these codes to remove the Kh. %ress ( again to re7generate the To and hide the field codes.

A9y the way, you can@t type the curly brackets yourself. "f won@t work. "f you want to type out the field codes

manually, use ctrl7( to create the curly brackets.B

(or advanced techni/ues for selecting the content to appear in a table of contents, and how to format it,

see TO Tips and Tricks.

Note: t is also possible to create a !able of "ontents by mar#ing each individual paragraph that you $ant to

appear in the !o". !hen, you tell Word to use your mar#ed paragraphs to create the !o". %ou do this using & !" '

fields. t seems to me that the chance of human error in accidentally omitting to mar# a heading is large. $ouldn(t

ris# it. )ut if you(re interested, loo# at Word(s help under !".

Q.?) hat is formula@ /plain with suita,le eample in MS /cel. !10 Mar"s)

Ans#

(ormulas in excel are a very important feature. They are used to calculate values based on whatis in cells, perform operations on a cell content, fetch values based on your search criteria andmuch more. $s a matter of fact, learning excel formulas is very critical for the successful use ofspreadsheet software. 1xcel formulas let you do so much more once you master them.
http://www.word.mvps.org/FAQs/Numbering/PageNumbering.htmhttp://www.word.mvps.org/FAQs/Numbering/PageNumbering.htmhttp://www.word.mvps.org/FAQs/Formatting/TOCJasonTabs.htmhttp://www.word.mvps.org/FAQs/Formatting/TOCJasonTabs.htmhttp://shaunakelly.com/word/numbering/tableofcontents.html#Step2http://shaunakelly.com/word/numbering/tableofcontents.html#Step2http://shaunakelly.com/word/numbering/tableofcontents.html#Step2http://sbarnhill.mvps.org/WordFAQs/TOCTips.htmhttp://www.word.mvps.org/FAQs/Numbering/PageNumbering.htmhttp://www.word.mvps.org/FAQs/Formatting/TOCJasonTabs.htmhttp://www.word.mvps.org/FAQs/Formatting/TOCJasonTabs.htmhttp://shaunakelly.com/word/numbering/tableofcontents.html#Step2http://sbarnhill.mvps.org/WordFAQs/TOCTips.htm


20/31

1. S;M

(ormula- SMA8, 8B or SMA$2, 92B or SMA$2-98B

The SM formula does exactly what you would expect. "t allows you to add : or more

numbers together. 'ou can use cell references as well in this formula.

The above shows you different examples. 'ou can have numbers in there separated by commas

and it will add them together for you, you can have cell references and as long as there are

numbers in those cells it will add them together for you, or you can have a range of cells with a

colon in between the : cells, and it will add the numbers in all the cells in the range.

2. C';&$

(ormula- O3TA$2-$2


21/31

"t only counts the cells where there are numbers.

6. C';&$A

(ormula- O3T$A$2-$2


22/31

B. $+%M

(ormula- T*"MA$2B

Gets rid of any space in a cell, except for single spaces between words. "Qve found this formula

to be extremely useful because "Qve often run into situations where you pull data from a

database and for some reason extra spaces are put in behind or in front of legitimate data. This

can wreak havoc if you are trying to compare using "( statements or +4OO=%Qs.

" added in an extra space behind !" 4ove 1xcel#. The T*"M formula removes that extra space.

heck out the character count difference with and without the T*"M formula.

6. RIGHT, LEFT, MID

(ormulas- *"GHTAtext, number of charactersB, 41(TAtext, number of charactersB,

M"0Atext, start number, number of charactersB.

A3ote- "n all of these formulas, wherever it says !text# you can use a cell reference as wellB

These formulas return the specified number of characters from a text string. *"GHT gives you

the number of characters from the right of the text string, 41(T gives you the number of

characters from the left, and M"0 gives you the specified number of characters from the

middle of the word. 'ou tell the M"0 formula where to start with the startRnumber and then it

grabs the specified number of characters to the right of the startRnumber.
https://www.udemy.com/microsoft-excel-vba-video-tutorial/?couponCode=learn-excel-formulas&tc=blog.excel.1.pic&utm_source=blog&utm_medium=udemyads&utm_content=post6539&utm_campaign=content-marketing-blog&xref=bloghttps://www.udemy.com/microsoft-excel-vba-video-tutorial/?couponCode=learn-excel-formulas&tc=blog.excel.1.pic&utm_source=blog&utm_medium=udemyads&utm_content=post6539&utm_campaign=content-marketing-blog&xref=blog


23/31

" used the 41(T formula to get the first word. " had it look in cell $2 and grab only the 2st

character from the left. This gave us the word !"# from !" love 1xcel#

" used the M"0 formula to get the middle word. " had it look in cell $2, start at character 6, and

grab 8 characters after that. This gives us ust the word !love# from !" love 1xcel#

" used the *"GHT formula to get the last word. " had it look at cell $2 and grab the first

characters from the right. This gives us !1xcel# from !" love 1xcel#

8. ='';P

(ormula- +4OO=%AlookupRvalue, tableRarray, colRindexRnum, rangeRlookupB

9y far my most used formula. The official description of what it does- !4ooks for a value in

the leftmost column of a table, and then returns a value in the same row from a column you

specify#. ASee the full eplanation of ='';PB 9asically, you define a value Athe

lookupRvalueB for the formula to look for. "t looks for this value in the leftmost column of a

table Athe tableRarrayB.

3ote- "f at all possible use a number for the lookupRvalue. This makes it a lot easier to make

sure the data you are getting back is a correct match.

"f it finds a match of the !lookupRvalue# in the left column of the !tableRarray# it will return

the value in the column you specify using the !indexRnum#. The !indexRnum# is relative tothe left mostcolumn. So, if you have the tableRindex look in column $ and you want what is

returned to be whatQs in column 9 the !indexRnum# would be : because the leftmost column,

column $ in this case, is the 2st column in the table array and column 9 is the :nd column

Ahence the : for the index numberB. "f you want what is in column to be returned youQd put 6

for the indexRnum. The !rangeRlookup# is a T*1 or ($4S1 value. "f you put T*1 it will

give you the closest match. "f you put ($4S1 it will only give you an exact match. " only use

($4S1 when using the +4OO=% formula.

1xample-

'ou have : lists- 2 with a sales personQs "0 and the sales revenue for the /uarter. $nother with

the sales personQs "0 and the sales personQs name. 'ou want to match up the sales personQs

name to the sales personQs revenue numbers for the /uarter. They are all umbled around so to
http://office.microsoft.com/en-us/excel-help/vlookup-HP005209335.aspxhttp://office.microsoft.com/en-us/excel-help/vlookup-HP005209335.aspx


24/31

manually match this, even for a small number of salesmen would leave room for a high margin

of error and take a lot of time.

The first list goes from $2 to 926. The :nd list goes from 02 to 1:8.

"n cell 2 " would put the formula +4OO=%A92, U$U2-U9U26, :, ($4S1B

92 the lookupRvalue Athe sales personQs "0. This is a number that appears on both lists.B

U$U2-U9U26 the !tableRarray#. This is the area " want the formula to search the leftmost

column Acolumn 1 in this caseB for the !lookupRvalue#. " went to ( because if it finds match in

column 1, " want it to return whatQs in column (. AThe money signs are there so that the

tableRarray will stay the same no matter where the formula is moved or copied to. This is

called an absolute reference.B

: the indexRnum. This tells the formula the number of columns away from the left

most column to return in case of match. So, if you find a match between the lookupRvalue and

the leftmost column of the table array, return whatQs in the same row in the :nd column of the

table Athe 2st column is always the leftmost column. "t starts at 2, not


25/31

"n order to get a nice neat list of Sales %erson "0, Sales %erson 3ame, and Sales %erson

*evenue all next to each other " used the +4OO=% formula to compare 2 list to another.

This is a complicated formula, but an extremely useful one. heck out some other

examples- =loo"up /ample, Microsofts 'fficial /ample.

D. % Statements

(ormula- "(AlogicalRstatement, return this if logical statement is true, return this if logical

statement is falseB

;hen youQre doing an analysis of a lot of data in 1xcel there are a lot of scenarios you could

be trying to discover and the data has to react differently based on a different situation.
http://www.excelintern.com/microsoft-excel/the-vlookup-formula/http://office.microsoft.com/en-us/excel-help/vlookup-HP005209335.aspxhttps://www.udemy.com/microsoft-excel-vba-video-tutorial/?couponCode=learn-excel-formulas&tc=blog.excel.1.pic&utm_source=blog&utm_medium=udemyads&utm_content=post6539&utm_campaign=content-marketing-blog&xref=bloghttp://www.excelintern.com/microsoft-excel/the-vlookup-formula/http://office.microsoft.com/en-us/excel-help/vlookup-HP005209335.aspx


26/31

ontinuing with the sales example- 4etQs say a salesperson has a /uota to meet. 'ou used

+4OO=% to put the revenue next to the name. 3ow you can use an "( statement that says-

!"( the salesperson met their /uota, say !Met /uota#, if not say !0id not meet /uota# ATip-

saying it in a statement like this can make it a lot easier to create the formula, especially when

you get to more complicated things like 3ested "( Statements in 1xcelB.

"t would look like this-

"n the example with the +4OO=% we had the revenue in column 9 and the personQs name in

column Abrought in with the +4OO=%B. ;e could put their /uota in column 0 and then

weQd put the following formula in cell 12-

"(A6?06, !Met Fuota#, !0id 3ot Meet Fuota#B

This "( statement will tell us if the first salesperson met their /uota or not. ;e would then copy

and paste this formula along all the entries in the list. "t would change for each sales person.

Having the result right there from the "( statement is a lot easier than manually figuring this

out.
https://www.udemy.com/microsoft-excel-vba-video-tutorial/?couponCode=learn-excel-formulas&tc=blog.excel.1.pic&utm_source=blog&utm_medium=udemyads&utm_content=post6539&utm_campaign=content-marketing-blog&xref=blog


27/31

>. S;M%4 C';&$%4 A=/+A5/%

(ormulas- SM"(Arange, criteria, sumRrangeB, O3T"(Arange, criteriaB,

$+1*$G1"(Arange, criteria, averageRrangeB

These formulas all do their respective functions ASM, O3T, $+1*$G1B "( the criteria are

met. There are also the formulas- SM"(S, O3T"(S, $+1*$G1"(S where they will do

their respective functions based on multiple criteria you give the formula.

" use these formulas in our example to see the average revenue A$+1*$G1"(B if a person met

their /uota, Total revenue ASM"(B for the ust the sales people who met their /uota, and the

count of sales people who met their /uota AO3T"(B

10. C'&CA$/&A$/

$ fancy word for combining data in : Aor moreB different cells into one cell. This can be done

with the oncatenate excel formula or it can be done by simply putting the V symbol in

between the two cells. "f " have !Steve# in cell $2 and !Fuatrani# in cell 92 " could put this

formula- $2V# !V92 and it would give me !Steve Fuatrani#. AThe ! ! puts a space in


28/31

between what you are combining with the VB. " can use concatenateA$2, ! !, 92B and it will

give me the same thing- !Steve Fuatrani#

(inding The *ight 1xcel (ormulas (or The Wob

There are 62 built in functions in 1xcel. 'ouQre not going to sit there and memori&e what all

of them do Aor at least " hope notPB. 4uckily 1xcel has a built in wi&ard that helps you find the

correct formula for what youQre looking to do Aif there is oneB.

lick the !fx# next to the formula bar in 1xcel

This brings up a menu and in there you can type in a description of what you are trying to do

and it will bring up the correct excel formula-
https://www.udemy.com/microsoft-excel-vba-video-tutorial/?couponCode=learn-excel-formulas&tc=blog.excel.1.pic&utm_source=blog&utm_medium=udemyads&utm_content=post6539&utm_campaign=content-marketing-blog&xref=bloghttps://www.udemy.com/microsoft-excel-vba-video-tutorial/?couponCode=learn-excel-formulas&tc=blog.excel.1.pic&utm_source=blog&utm_medium=udemyads&utm_content=post6539&utm_campaign=content-marketing-blog&xref=blog


29/31

" typed in !remove extra spaces# and it returned the T*"M formula that we went over earlier.

More /cel ormulas

There is so much more that " use on a regular basis such as Time formulas A3O;, TO0$',

MO3TH, '1$*, 0$', etc.B, other formulas like $30 and O*, along with many others.

The real power comes in combining these functions into complicated excel formulas.


30/31

Q.B) rite short note on the followin*#

a) elete +ows and Columns in Ms-/cel

Ans#

Addin* a row#

2. Move to a cellwhere you want to add a row. (or example, if you wanted to create arow on the @6@ row you would move to $6 or anywhere else on row 6.

:. Once positioned click "nsert and select *ows. This option will not be available ifyou@re highlighting columns and not rows.

$ip#"f you want to insert multiple rows at once highlightmore than one row and then

click "nsert and select *ows. (or example, if you wanted to insert four rows on row 6 you

highlight row 6 and the three rows below it by clicking and dragging your mouse on the

number 6, E, 8, and and then click "nsert and select *ows.

+emoin* a row#

2. Highlight the row or rows you want to delete.:. lick 1dit and select delete.

sing the above steps will delete the row or rows and move the rows beneath up. "f you

ust want to delete the contents of the rows press the delete key on the keyboard.

Addin* a column#

2. Move to a cellwhere you want to add a column. (or example, if you wanted to createa column on the @@ column you would move to 2 or anywhere else on column .

:. Once positioned click "nsert and select olumns. This option will not be available if

you@re highlighting rows and not columns.

$ip#"f you want to insert multiple columns at once highlightmore than one column and

then click "nsert and select olumns. (or example, if you wanted to insert four rows on

olumn you highlight column and the three columns to the right of it by clicking and

dragging your mouse on the letters , 0, 1, and ( and then click "nsert and select olumn.

+emoin* a column#

2. Highlight the column or columns you want to delete.:. lick 1dit and select delete.

sing the above steps will delete the column or columns and move the columns to the

right over. "f you ust want to delete the contents of the columns press the delete key on the

keyboard.
http://www.computerhope.com/jargon/c/cell.htmhttp://www.computerhope.com/jargon/h/highligh.htmhttp://www.computerhope.com/jargon/c/cell.htmhttp://www.computerhope.com/jargon/h/highligh.htmhttp://www.computerhope.com/jargon/c/cell.htmhttp://www.computerhope.com/jargon/h/highligh.htmhttp://www.computerhope.com/jargon/c/cell.htmhttp://www.computerhope.com/jargon/h/highligh.htm


31/31

,) Slide show option for PP$

Ans#

"f you would like to have some slides show for longer periods of time to give the viewers achance to read text or to examine a complicated diagram, then you will need to set the timing foreach slide separately. "t is best to do this when you are in the slide sorter view where you can see

thumbnails AminiaturesB of each slide.

2. (rom slide sorter view.o To set the timing for one or more selected slides, select the slide Aor slides 77?

hold the shift key so you can select more than one slide at a timeB 77? then clickon the slide transition icon next to where it says no transitionor where it says thename of the transition you selected Ae.g. box inB above the row of slides 77? thiscauses the Slide $ransitiondialog box appears and you can enter in the numberof seconds you want the slideAsB to appear on the screen Aas you did aboveB or youcan use the *ehearse Timings option Asee belowB.

:. *ehearse timings. This allows you to set the timings for each individual slide.o (rom the Slide Showmenu bar 77? select +ehearse $imin*s

o $s soon as you select rehearse timings first slide will appear along with a timer

counting seconds Ain the bottom right corner of the screenB. The counter willcontinue to count until you click the right arrow, space bar, or mouse. Once youclick, it moves to the next slide and starts the counter for the next slide.

o ;hen you finish creating the settings for each slide, a box pops up and lets you

choose to accept the timings or start again.

A3OT1- "f you want to change the timing for only one or a few slides Aand keepall the rest the sameB, you need not go through the whole rehearsal of timingsagain. "nstead, view the slides the slide sorter. The time you have set for eachappears below and to the left of each slide. To change the time, click on the slidetransition icon, and in the dialog box manually change the number of secondsB.

6. *ecord narration- This allows you to set the timings for each slide and at the same timerecord any comments you want to make to go along with the slide Abe sure to check thatyou microphone is working and that it is selected in the ontrol %anel under Csound.CB.

computer application paper solution summer 2012.doc

Documents