Excel 2P-2RVW-Formulas and Functions in Excel

What´s the difference between a formula and a function?

• There is no difference

• Functions are more complicated than formulas

• Formulas are designed by the user and functions are predefined in Excel

• They both start with the =

=700/3*3

=700/(3*3)

The result of these two formulas is not the same because of the

o__________ _____________y ^{(HINT: 2 words)}

(a)  

Excel formula to calculate the area of a circle which diameter is 14.

• =Pi()*14^2

• =Pi()*14/2^2

• =Pi()*(14/2)^2

Formula in excel to find out the number of chairs at a party where you have: 50 tables of guests, each table has 12 guests. In addition you want 3% more of extra chairs for the party crashers

• =50*12+ 50*12*3%

• =50*12*.03

• =50*12+3%

What kinds of formats can we apply in Excel when working with money?

• Money and Decimals

• Currency and Accounting

• Accounting and Number

Formula in G2 to calculate the total income. You must able to copy along G for calculating the other products income as well.

• =15.00-9.00

• =F2-E2

• =E2-F2

Which formula would you type in D5 to calculate the salary increase along column D?

• =B2*$C$5

• =$B$2*C5+C5

• =$B$2*C5

Which formula would you type in B3 to calculate the final price along row 3?

• =$A2-B2

• =$A$2-$B$2

• =A2-B2

The Excel formula to calculate: 76 times 180 minus the difference between 345 and 126

• =76+180-345-126

• =180*76-(345-126)

• =76 x 180-(345-126)

You had 320 chocolates stored below your bed, your little sister ate half of them and your aunt gave you 53.

Which excel formula is the correct one?

Is there anyone in 2nd semester who hides their chocolates?

• =(320/2)+53 and No one keeps chocolates below their bed

• =320/2+53 and Some of us keep chocolates below our bed

• =320/2+53 and No one keeps chocolates below their bed

• =(320/2)+53 and Some of us keep chocolates below our bed