FINAL

- 1. In an Excel worksheet, what would result from =AVERAGE(A1:A3) if A1=10, A2=20 and A3=30 ?
A) 40 B) 30 C) 20 D) 15 E) 60 - 2. Which of the following arithmetic operations is represented by an asterisk (*) in an Excel workbook?
A) Addition B) Multiplication C) Divition D) Exponentiation E) Subtraction - 3. In an Excel worksheet, what does B3:D15 represent or indicate?
A) A formula B) A division formula C) A cell range D) A function E) A cell format - 4. Which of following Excel formulas is the correct representation of a formula that is to be entered in cell C5?
A) *B6+B15 B) ==B6+B15 C) &B6+B15 D) =B6+B15 E) +B6+B15 - 5. Which of the following cell references is an example of a mixed reference in an Excel worksheet?
A) B1 B) AB1 C) C24 D) $B$1 E) $B1 - 6. Which of the following arithmetic operators will be calculated first if all of them are used in the same Excel formula?
A) > (greater than) B) * (Multiplication) C) < (less than) D) / (division) E) ^ (exponentiation) - 7. Which one of the following relational operators represents "Less than or equal to" in an Excel formula or function?
A) <= B) ==< C) =< D) >= E) => - 8. If an Excel function has more than one argument, what separates the arguments in the formula bar?
A) Colons B) Parenthesis C) Commas D) Periods E) Semicolons - 9. Which of the following objects is not an argument of the IF function in an Excel worksheet?
A) Value_when_false B) Any of them C) Value_if_false D) Value_if_true E) Logical_test - 10. Which of the following Excel formulas would result in TRUE if C4 is less than 10 and D4 is less than 100?
A) =AND(C4<10, D4<100) B) =AND(C4>10, D4<10) C) =AND(C4>10, D4>10) D) =AND(C4>10, C4<100) E) =AND(C4<10, D4<=100) - 11. Charts that display data as slices of a circle and show the relationship of each value in a data series to the series as a whole are called.
A) Line charts B) Bar charts C) Pie charts D) Scatter Charts E) Value charts |

Students who took this test also took :

Created with That Quiz —
the math test generation site with resources for other subject areas.