MS Excel Quiz 1-10
MS Excel Quiz 21-30
MS Excel Quiz 31-40
MS Excel Quiz 41-50
MS Excel Quiz 51-60
MS Excel Quiz 61-70
MS Excel Quiz 71-80
MS Excel Quiz 81-90
MS Excel Quiz 91-100
MS Excel Quiz 101-110
Computer Skill Quiz
MS Word Quiz and Answer
MS PowerPoint Quiz and Answer
Adobe Photoshop Quiz and Answer
Adobe Illustrator Quiz and Answer
Logo Design Quiz and Answer
HTML Quiz and Answer
|
Question 11. An array range that includes both rows and columns is known as________?
a. A single-dimensional array
b. All array ranges must have rows and columns.
c. A two-dimensional array.
Answer : c
Question 12. Can macros close currently open worksheets?
a. Yes
b. No
Answer : a
Question 13. What is the correct formula to calculate an average between cells B3 and B6?
a. AVERAGE(B3+B4+B5+B6)/4
b. SUM(B3+B4+B5+B6)/4
c. AVERAGE(B3:B6)
d. AVE(B3+B4+B5+B6)/4
E. AVE(B3:B6)
Answer : C
Question 14. When is an absolute cell reference used?
a. When you want a cell reference to stay fixed on a specific cell.
b. When you want a cell reference to changed when copied and pasted to other
Answer : a
Question 15. How are rows named?
a. Symbolically
b. Alphabetically
c. Metamorphically
d. Numerically
Answer : d
Question 16. The function =VLOOKUP("Widget",D4:E9,2,False) is correct format.
a. True
b. False
Answer : a
Question 17. In an Excel worksheet, the active cell is indicated by:
a. a blinking border
b. a dotted border
c. a thick black border
d. None of these
Answer : c
Question 18. What is the keyboard shortcut for moving the cursor to the first cell in the current worksheet (assuming no frozen panes, this would be cell A1)?
a. Ctrl + Home
b. Ctrl + Shift + Home
c. Ctrl + End
d. Ctrl + shift + End
Answer : a
Question 19. What kind of formatting allows you to create a set of rules to format cells based on a cell value or another cell?
a. Text Formatting
b. Input Formatting
c. Output Formatting
d. Conditional Formatting
e. Table Formatting
Answer : d
Question 20. Which worksheet function estimates standard deviation based on a sample?
a. STDSAMPLE
b. STDEV
c. STANDDEV
d. STANDARD
e. STDEVIATION
Answer : b
|
|