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 61-70
MS Excel Quiz 71-80
MS Excel Quiz 81-90
MS Excel Quiz 91-100
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 101. It is possible to upload a SWF file into Excel.
a. True
b. False
Answer : a
Question 102. To unhide a sheet and make viewable with other tabs in the current window:
a. Right click on any tab, select Unhide, choose the tab from the list to unhide
b. Adjust Custom View selection in View menu
c. Press Ctrl-U
d. In the View menu select Unhide
Answer : a
Question 103. In a bar graph the horizontal axix is the:
a. Secondary axis
b. Latitudinal axix
c. Y-axis
d. X-axis
Answer :
Question 104. If a set of numbers has an even number of items, the MEDIAN function will return:
a. The lower of the numbers in the middle of the set
b. The higher of the numbers in the middle of the set
c. The average of the numbers in the middle of the set
d. An error
Answer : c
Question 105. If you would like to count the number of cells within a range that fit a specific criteria, which funtion would use?
a. NUMFITCRITERIA
b. COUNTTHOSEARE
c. IFFIT
d. COUNTONLYFIT
e. COUNTIF()
Answer : e
Question 106. Where do you place a MACRO that is supposed to run automatically after every entry on a worksheet?
a. In a cell, place a hyoerlink to the code on a webpage.
b. Must manually run the Macco after each entry.
c. On the worksheet tab, go to "View Code" and place the Macro there.
d. Must use a Form to do this.
Answer : c
Question 107. What is a column in a worksheet?
a. A lateral group of cells within a worksheet
b. A horizontal group of cells within a worksheet
c. A consecutive group of cells within a worksheet
d. A vertical group of cells within a worksheet
e. A diagonal group of cells within a worksheet
Answer : d
Question 108. What too allows you to summarize and analyze data in various categories?
a. Pie Chart
b. Pivot tables
c. Copy and paste
d. Square root analysis
Answer : b
Question 109. If there is text in a column and you try to sort the entire column:
a. it will keep the text in the same cell and sort the numeric values
b. it will not sort the column
c. an error message will appear
d. sorting function will be disabled
Answer : a
Question 110. Can Excel open two documents with the same file name simultaneously?
a. Yes
b. No
Answer : b
|
|