MS Excel Quiz 1-10
MS Excel Quiz 11-20
MS Excel Quiz 21-30
MS Excel Quiz 31-40
MS Excel Quiz 41-50
MS Excel Quiz 51-60
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 61. The Remove Duplicates command:
a. Copies and pastes the list without duplicates in a new worksheet
b. Copies and pastes the list without duplicates in the right-adjoining column
c. Removes duplicates from the range that is highlighted based on selected criteria
d. Opens a dialog box asking to delete the duplicates in the existing range or copy to a new
range
Answer : c
Question 62. Where can you see the contents of an active cell?
a. Page Preview bar
b. Tool bar
c. Screenshot bar
d. Formula bar
e. View bar
Answer : d
Question 63. Spell check can be found in the ________menu
a. Review
b. Insert
c. Formula
d. File
e. Data
Answer : a
Question 64. What would the following formula do? =Sheet1!D9+Sheet1!E9
a. This would select D9 and E9 and create an average from sheet2
b. This would select D9 and E9 and add the two together from sheet1
c. This formula doesn't do anything
d. This would select D9 and E9 and add the two together from sheet2
Answer : b
Question 65. In an alphabetical sort, if two cell contents are identical, Excel sorts by:
a. Placing the item that came first in the original list before the second item
b. Merging the two cells
c. Adding a "~" to the end of the second item to make it unic
d. None of these
Answer : a
Question 66. By using which of the following data can be arranged in ascending or descending
order?
a. Sort command from Data menu
b. Sort command from Tools menu
c. Sort command from Table menu
d. None of these
Answer : a
Question 67. Which worksheet function returns the minimum value in a list of arguments?
a. MINIMUM
b. MINA
c. MINVAL
d. MIN
e. MINV
Answer : d
Question 68. Which of the following you will do to view a cell comment?
a. click the display comment command on the window menu
b. click the comment command in the insert menu
c. position the mouse pointer over the cell
d. click the comment command on the view menu
Answer : c
Question 69. If there are duplicate items in a list, the COUNT function will not include the
duplicates in the total count of items.
a. True
b. False
Answer : b
Question 70. Which function searches for a value in a specified table array?
a. =vlookup()
b. =browse()
c. =search()
d. =searchfile()
Answer : a
|
|