Information Technology Functions

f the cell B2 is 68, what will this IF function give you as a result? =IF (B2>60, ''pass'', ''fail'') pass fail 60 none of these all of these

pass

What do you need to include when you are entering text into your formula? A. quotes B. parentheses C. apostrophes D. none of these E. all of these

quotes/quotations

. Returns the number of cells in a range that contains numbers

Count

Returns the number of cells that meet a condition set forth in a formula

CountIF

What functions are used to calculate a period of time.

Date Function

The function that lets you add up a range of cells or values

SUM

The IF Statement takes a logical test and determines a result that is either True or False.

True

SUM, AVERAGE, IF, MIN and MAX are examples of _______.

predefined functions

Which of the following is the correct formula for the IF function in Excel? IF (logical_test, value_if_true, value_if_false) =IF (logical_test, value_if_true, value_if_false) =(logical_test, value_if_true, value_if_false) all of these none of these

=IF (logical_test, value_if_true, value_if_false)

In computing for the % equivalent of Q1 and Q2 the following operators were used ________.

Division and multiplication

What function was used to find the highest grade?

MAX