Operating System

Sunday, April 5, 2015

Excel 2010 Test Questions - 15

Leave a Comment
71. Which option button provides formatting options following the insertion of cells, rows, or columns in a worksheet?

A.    AutoCorrect
B.     Insert
C.     Paste
D.    Auto Fill

Answer: B

72. Which option button provides a list of error-checking options following the assignment of an invalid formula to a cell?

A.    Trace Error
B.     AutoCorrect
C.     Paste
D.    Auto Fill

Answer: A

73. Which of the following is a valid Excel 2010 function?

A.    AVERAGE, MAX, and NUM
B.     MAX, MIN, and WEEK
C.     AVERAGE, MAX, and MIN
D.    WEEKDAY, MAX, and CLOSE

Answer: C

74. When typing a function directly into a worksheet cell, what provides a description of currently selected functions?

A.    Screenshot
B.     Description box
C.     Function box
D.    Screen Tip

Answer: D

75. Which is the valid function for displaying the highest value in a range of values?

A.    Max
B.     High
C.     Upper
D.    Top


Answer: A
If You Enjoyed This, Take 5 Seconds To Share It

0 comments:

Post a Comment