Font size
WorksheetsExcel 2P-2RVW-Formulas and Functions in Excel
Total questions: 19
Worksheet time: 12mins
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
What is the correct excel formula to calculate the BMI
=D6/C6^2
=D6/C6*C6
=D6/(C6*D6)
Function to calculate the sales average in the 1st semester
=Average ( B4:D4 )
=Average ( B4:C4 )
=AverageIf ( B4:C4 )
=Average ( A4:A4 )
Function to calculate the smallest number of cars sold at a dealership.
=MODE.SNGL( )
=MIN( )
=MAX( )
=COUNT( )
How many employees do we have?
=SUM(D2:D4)
=SUM(B2:B4)
=COUNT(B2:B4)
=COUNTA(B2:B4)
Function to find out the number of employees who earn more than $2000
=COUNT ( D2:D4 )
=SUMIF (D2:D4, ">2000")
=COUNTIF( D2:D4, ">2000" )
=COUNTA( D2:D4, ">2000" )
Find out the total Reached sales in Puebla
=SUM ( C3:C7 )
=COUNTIF ( A3:A7,"Puebla" )
=SUMIF ( A3:A7,"Puebla",C3:C7 )
=SUMIF ( A3:A7,"Puebla",B3:B7 )
Most repeated value at the reached sales range
=AVERAGE ( B3:B7)
=MODE.SNGL ( C3:C7)
=COUNT ( C3:C7)
= LEFT ( C3:C7)
Consider the next value in A1: SONIA LOPEZ
in B1 you need to instert a function that shows SONIA
= PROPER ( A1 )
=LEFT ( A1, 5)
=RIGHT ( A1, 5)
=LEFT ( A1)
The command to show all the formulas in your worksheet is in:
Home tab
Page layout
Data tab
Formulas tab
