Font size
WorksheetsExcel Basic Function
Total questions: 34
Worksheet time: 18mins
What does a formula always begin with?
Addition symbol +
Exclamation Symbol !
Equals symbol =
Minus symbol -
Is a zip code (28379) a label or a value?
Label
Value
A ___________ instructs the software to perform a calculation.
Workbook
Active cell
Cell range
Formula
A basic function is a shortcut for a formula.
True
False
Which of the following is the correct way to write a function in a spreadsheet?
=SUM(A1-A5)
=SUM A1+A5
SUM (A1:A5)=
=SUM(A1:A5)
In the following image, we are looking at the use of the COUNT function. What will be the value that should appear in cell E5?
8
3
7
5
In the following image, we are looking at the use of the COUNTA function. What will be the value that should appear in cell B7?
3
7
0
Ninguno
In the following figure using the IF function to place those conditions, which of the following is correct?
=SI(A2 > 18, "Menor de edad", SI(A2 <> 65, "Mayor de edad", "Tercera edad"))
=SI(A2 < 18, "Menor de edad", SI(A2 < 65, "Mayor de edad", "Tercera edad"))
=SI(A2 < 18, "Menor de edad", SI(A2 < 65, "Mayor de edad", "Mayor de 18 años"))
=SI(A2 < 18, "Menor de edad", SIA2 < 65, "Mayor de edad", "Tercera edad")
What is the formula to make a discount of 30% (A2) to a purchase online for 1500 (D2)?
=D2*0.30
D2/0.3
=D2*A2/30
=D2*30%
In the following image they ask me to obtain a difference of the sales of 2019 and 2020. Which of the following formulas is correct?
=C2-B2/2
=(C2-B2)/B2
=B2/%
=(C2*%)/B2
In the following image, we observe the use of the MAX function with a set of numbers of which the one that should appear as a result in cell C7 is:
-3
-1
0
-2
Any formula must start with an (a) sign
If you type "A1+B1" in cell C1, the value of cell C1 would be
A1+B1
3
=A1+B1
C1
If you type =A1/B1 in cell C1, the value of cell C1 would be
2
1
0.5
A1/B1
"=A1+B1" is called a
formula
function
"=SUM(A1:B1)" is a
function
formula
both
if you type "=A1*B1" in cell C1
the value of cell C1 would be
2
3
1
A1*B1
The formula to DIVIDE cell A1 by cell B1 would be
=A1/B1
=B1/A1
=DIV(A1:B1)
-
the FUNCTION to add cell A1 and B1 would be
=A1+B1
=SUM(A1:B1)
=ADD(A1:B1)
=A1*B1
the formula to calculate the DIFFERENCE between A1 and B1 would be
=DIFF(A1:B1)
=A1-B1
=MIN(A1:B1)
"=(A1+B1)/2" is a ___ that will calculate the average value of cells A1 and B1
Formula
Function
=AVERAGE(A1:B1) is a ___ that will calculate the average value of cells A1 and B1
Function
Formula
to find out which cell value is HIGHER, A1 or B1, you would type:
=MAX(A1:B1)
=HIGHER(A1:B1)
=MAXIMUM(A1:B1)
=SUM(A1:B1)
to find out the average value of cells A1 and B1, using a FUNCTION, you would type:
=AVG(A1:B1)
=AVERAGE(A1:B1)
=MAXIMUM(A1:B1)
=SUM(A1:B1)/2
"=SUM(A1:B1)/2"
this formula would calculate the AVERAGE value of cells A1 and B1
TRUE
FALSE
This is not a formula
