Practice Test

Q1) NOW() function returns only the current system time. Show Answer

Q2) WEEKDAY() returns the day of the week such as “Sun”, “Mon”, etc Show Answer

Q3) COUNTA and COUNTBLANK functions applied over a range, will always return the same value. Show Answer

Q4) The 5Th largest number in a range is obtained by using the formula = LARGE” (array, 5). Show Answer

Q5) The largest number in a range of 10 numbers can be obtained by using the formula = SMALL(array, 10) Show Answer

Q6) The _______ function obtains its time and date from the computer’s clock: Show Answer

Q7) The ________ function gives the correlation between two sets of values: Show Answer

Q8) In a range consisting of 10 numbers, which of these formula will return the 5th largest number? Show Answer

Q9) In a range consisting of 10 numbers, which of these formula will return the largest number? Show Answer