quiz of session 6 : numerical functions (part 1)

addition operation in excel can be performed

• function called sum and code

• function called sum and simple formula with dot "."

• function called sum and simple formula with plus sign "+"

• non

if i want to sum all of these values using sum function i will type in formula bar

• sum(A1:F8)

• =sum(A1:F8)

• =sum(B3:N9)

• =add(A1:f8)

Answer explanation

subtraction process in excel can be performed by

• standard or direct function

• programming code of a specific programming language

• none

• simple formula

  sum function with minus sign

  or imsub function

multiplying operation can be performed in excel by

• formula with *

  or product function

• formula with ^

  or product function

• formula with &

  or product function

• none

multiplying in excel can be performed by

• /

  and

  divide

• /

  and

  quotient

• '

  and

  quotient

• none

the difference between quotient and the normal division

• no difference

• quotient and normal division don't related to each other

• quotient prints only the integer of division operation

• none