What is the value when Excel calculate the average of three cells with values of 10, blank, and 8?

A. 6
B. 9
C. 10
D. none; Excel cannot calculate an average in a range that includes a blank cell


Answer: B

Computer Science & Information Technology

You might also like to view...

If you want to pass an array element into a method by reference, what will you need to do?

a) It always passes the element as a reference automatically. b) Use the keyword ByRef c) Each of the above. d) None of the above, passing in by reference of an array element is only possible if the array type is a reference type.

Computer Science & Information Technology

For a computer to produce correct information, the data that is input into a database must have integrity.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology

____ are executable statements that inform the user what to do.

A. Variables B. Prompt lines C. Named constants D. Expressions

Computer Science & Information Technology

When you add an item to a group on the Navigation Pane, you really create a link to the object.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology