- 1. In an Excel worksheet, what would result from =AVERAGE(A1:A3) if A1=10, A2=20 and A3=30 ?
A) 15
B) 30
C) 20
D) 60
E) 40
- 2. Which of the following arithmetic operations is represented by an asterisk (*) in an Excel workbook?
A) Multiplication
B) Divition
C) Exponentiation
D) Addition
E) Subtraction
- 3. In an Excel worksheet, what does B3:D15 represent or indicate?
A) A formula
B) A function
C) A division formula
D) A cell range
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) AB1
B) B1
C) C24
D) $B1
E) $B$1
- 6. Which of the following arithmetic operators will be calculated first if all of them are used in the same Excel formula?
A) < (less than)
B) > (greater than)
C) ^ (exponentiation)
D) * (Multiplication)
E) / (division)
- 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) Commas
B) Periods
C) Semicolons
D) Parenthesis
E) Colons
- 9. Which of the following objects is not an argument of the IF function in an Excel worksheet?
A) Logical_test
B) Value_when_false
C) Value_if_false
D) Value_if_true
E) Any of them
- 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<10)
B) =AND(C4<10, D4<=100)
C) =AND(C4<10, D4<100)
D) =AND(C4>10, C4<100)
E) =AND(C4>10, D4>10)
- 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) Scatter Charts
B) Value charts
C) Line charts
D) Pie charts
E) Bar charts
|