COMP QUIZZES (2300 or 2302?)

You've entered the following expression in a cell formula: G66+22+(H70/5)*7.... Based on the formula precedence rules, order the steps Excel performs to evaluate the formula

-divide the value in cell H70 by 5 -multiply a result by 7 -add the value in cell G66 -add 22

How many arguments does the NOW function have?

0

What is the serial number that corresponds to the time 6:00 am?

6/24= .25

show the syntax of the IF function

=IF(logical_test,Value_if_true,[value_if_false})

Which of the following is an example of an excel FORMULA? A.) =D8+2.35 B.) "AGSC2301" C.) -4785 D.) AVERAGE(6,8,10,D8) E.) SUM(2,4,7)+2.37 F.) NONE OF THESE

A.) =D8+2.35

Which of the following is a relative reference? a.) X$45 B.) $AB$7 C.) neither is a relative reference d.) both are relative references

C.) neither is a relative reference

Which of the following answers is an example of an Excel FUNCTION? A.) =D8+2.35 B.) "AGSC2301" C.) -4785 D.) AVERAGE(6,8,10,D8) E.) SUM(2,4,7)+2.37 F.) NONE OF THESE

D.) AVERAGE(6,8,10,D8)

Select the most appropriate function to search FOR A SPECIFIED ITEM IN A RANGE OR CELLS, AND THEN RETURN THE RELATIVE POSITION OF THAT INTEM IN THE RANG. a.) HLOOKUP B.) VLOOKUP C.) INDEX D.) MATCH E.) SEARCH

D.) MATCH

which of the following is an example of an array formula? a.) =B6'B8/C6'C8 B.) =MAX(B6:B10) C.) =7/AVERAGE(B6:B10) D.) NONE OF THE ABOVE IS AN EXAMPLE OF AN ARRAY FORMULA

D.) NONE OF THE ABOVE IS AN EXAMPLE OF AN ARRAY FORMULA

Which of the following is an example of an excel FUNCTION? A.) =D8+2.35 B.) "AGSC2301" C.) -4785 D.) AVERAGE(6,8,10,D8) E.) SUM(6,8,10,B8) F.) NONE OF THESE

E.) SUM(6,8,10,B8)

show the syntax of the MID function. Describe the task for eh MID function.

MID returns a specific number of characters from a text string, starting at the position you specify, based on the number of characters you specify. MID(text, start_num, num_chars)

The YEAR, MONTH, and DAY functions have similar syntax while each ending in similar but different results. Write a formula entry showing an example of using the MONTH function? Now, write the result (or evaluation) of the formula your wrote.

MONTH(serial_number) I.E: MONTH(A2) 10`

which of the following is an example of an array formula? a.) 3*B6:B10 B.) AVERAGE(B6:B10) C.) 457+MIN(B6:B10) D.) AB40' AB48*AC6'AC8 E.) none of these is an example of array formulas

a.) 3*B6:B10

Which of the following is NOT true of FORMULAS? a.) a formula is the same thing as a function b.) they can refer to a range of cells c.) they may contain a mixture of absolute and relative cell references d.) they can be changed after they have been entered and applied

a.) a formula is the same thing as a function

Given, the entry: =SUM(A3:A11)*7 then A3:A11 in this formula is what? a.) argument b.)function c.) operator d.)constant

a.) argument

In excel, a predefined calculation is what? a.) function b.) operator c.) reference d.)constant

a.) function

which of the following is the best example of a LITERAL VALUE? a.) A3:A11 b.)787 c.)COUNT(5,6) d.) >=

b.)787

To use the returned value of cell G40 as a fixed value in formulas (which you intend to copy and paste into two other cells), you should enter what type of reference? a.) 3-D b.) mixed c.) absolute d.) relative

c.) absolute

You provide the VALUES TO BE OPERATED on in a FUNCTION by inputting_______ a.) the function name b.) operators c.) arguments d.) function elements e) none of the above

c.) arguments

What type is the following formula element: B7:G77? a.) operator b.) constant c.) reference d.) function e.) none

c.) reference

What type is the following formula element? a.) operator b.) constant c.) reference d.) function e.) none

c.) reference

The syntax of the COUNTIF function is: a.) COUNTIF(logical_test, range, criteria) b.) COUNTIF(logical_test, sum, range) c.) COUNTIF(value1, value2, value3,...) d.) COUNTIF(range, criteria) e.) COUNTIF(criteria, sum_argument)

d.) COUNTIF(range, criteria)

You can enter an array formula into a cell by pressing______. a.) Alt+Shift+Enter b.) Alt+Enter c.) Shift+Tab+Enter d.)Ctrl+Shift+Enter e.) Enter+Tab

d.)Ctrl+Shift+Enter

NESTING refers to the practice of using a(n)______ as a function_______. a.) expression;reference b.)operator;reference c.)literal value; name d.)function; argument e.) expression; argument

d.)function; argument

To what does a LOGICAL EXPRESSION evaluate? show an example

evaluates to TRUE or FALSE i.e: =NOT(A2+A3=24)

T/F: the MATCH function returns/evaluates to the returned value of a cell at a given row and column position.

false

each in a single sentence, state the two limitations of the IF function when used in its simplest form. Then directly following each, state how we overcome or fix each limitation.

first limitation: returns one value if a condition you specify evaluates to TRUE - if the value of this argument is the text string "Within budget" and the logical_test argument evaluates to TRUE, the IF function returns the text "Within budget." If logical_test evaluates to TRUE and the value_if_true argument is omitted (that is, there is only a comma following the logical_test argument), the IF function returns 0 (zero). To display the word TRUE, use the logical value TRUE for the value_if_true argument. second limitation: if that condition evaluates to FALSE. - if the value of this argument is the text string "Over budget" and the logical_test argument evaluates to FALSE, the IF function returns the text "Over budget." If logical_test evaluates to FALSE and the value_if_false argument is omitted, (that is, there is no comma following the value_if_true argument), the IF function returns the logical value FALSE. If logical_test evaluates to FALSE and the value of the value_if_false argument is blank (that is, there is only a comma following the value_if_true argument), the IF function returns the value 0 (zero). I.E= For example, the formula =IF(A1>10,"Over 10","10 or less") returns "Over 10" if A1 is greater than 10, and "10 or less" if A1 is less than or equal to 10.

explain the predefined calculation of the OR function- what does it do?

returns TRUE if any of the values is true, returns FALSE if all are false

Briefly describe the LEN function. Include mention of the arguments and the evaluation of the function.

returns the number of characters in a text string. Text- Required. The text whose length you want to find. Spaces count as characters

Why does an Excel worksheet sometimes display a cell returned value containing the #VALUE! error?

the formula references a cell that contains text which is used in an arithmetic expression

T/F: an array formula can occupy cells or reside in a single cell

true

T/F: the INDEX function returns/evaluates to the returned value of a cell at a given row and column position.

true

Explain the term NESTING

when you include a function in an argument of another function