Advance Excel Quiz

What will be the result of =ROUND(14.567,1)?

• 14.6

• 14.4

• 14.56

• 15

Which function is used to find the remainder of a division operation in Excel?

• MOD

• QUOTIENT

• REMAINDER

• INT

If A1=10, A2=3, what will =POWER(A1,A2) return?

• 100

• 1000

• 30

• 1

Which function calculates the average while ignoring blank cells?

• AVERAGE

• AVERAGEIF

• AVERAGEA

• AVERAGEX

What will be the output of =IF(A1>10, "High", "Low") if A1=5?

• High

• Low

• Error

• True

What does =AND(A1>10, A2<5) return if A1=12 and A2=6?

• TRUE

• FALSE

• #VALUE

Which function returns TRUE if at least one condition is TRUE?

• AND

• OR

• NOT

• XOR

What will =NOT(TRUE) return?

• TRUE

• FALSE

• #ERROR

• 0

What does =LEN("Excel Quiz") return?

• 10

• 11

• 9

• 12

Which function extracts a specific number of characters from the start of a text string?

• MID

• LEFT

• RIGHT

• FIND