Excel

which of the following is the correct formula to find the lowest value in the cells between A1 and A5?

• =min(A1:A5)

• =max(A1:A5)

• =average(A1:A5)

• =sum(A1:A5)

which of the following is the correct formula to display "Pass" if the student gets higher than 50 marks and "Fail" otherwise?

• =if(A1>50)

• =if(A1>50, Pass, Fail)

• =if(A1>50, "Pass , Fail")

• =if(A1>50 "Fail , "Pass")

when do we use IF and AND formulas together?

• when we have only one condition

• when we have 2 conditions

• when we have no conditions

• when the output does not depend on the condition

look at the table below:

Name: Grade: Classification:

Maria 4

Hania 4

Bilal 5

I apply the following formula:

=IF(B2>5,"Senior school","Primary school")

what is the output for Maria?

• Senior school

• Primary school

• IF

• none of the following

look at the table below:

A B

Item Cost

apples $1.50

oranges $0.75

bananas $1.00

TOTAL:

in order to calculate the total cost of all 3 fruits, which Excel formula will i use?

• =SUM(A2:A4)

• =SUM(B2:B4)

• =ADD(B2:B4)

• =ADD(A2:A4)

-------------- will automatically modify a cell's row height so that the text can be displayed in multiple lines

a ________ is a predefined formula that performs calculations in a particular order

______________ allows you to combine cells into one big cell

the ___ function allows you to find the total of numbers in a given cell range

the _______ function calculates the arithmetic mean of the numbers