MS Excel Quiz 1-10
MS Excel Quiz 11-20
MS Excel Quiz 21-30
MS Excel Quiz 31-40
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 41. Attaining data from a cell located in a different sheet is called what?
a. updating
b. referencing
c. traveling
d. functioning
e. location
Answer : b
Question 42. How can you set 0.5 inch left indentation for a cell in Excel?
a. You can specify indentation only if you turn the rules on.
b. The indentation can be specified only when printing.
c. Indentation can be set from Format Cells box.
d. This is possible, but the answer is not listed here.
e. This is impossible.
Answer : c
Question 43. The difference between centering text in a cell and centering a number is:
a. There is no difference
b. A number must always be right justified and cannot be centered
c. The text center command is part of the font selection
d. A number must be centered with the "Accounting" format option
Answer : a
Question 44. A function inside another function is called a __________function.
a. Sum
b. Round
c. Nested
d. Text
e. Round
Answer : c
Question 45. The formula =4>6 returns:
a. 2
b. -2
c. False
d. True
Answer : c
Question 46. When a list is filtered (showing only rows that meet the criteria) and highlighted,
the copy command will result in:
a. A dialogue box asking which rows to copy
b. Only the highlighted cells being copied
c. Both visible and hidden rows being copied
d. No option, Excel will not allow copying of filtered rows
Answer : b
Question 47. What does the "V" in "VLOOKUP" stand for?
a. Valkyrie
b. Verified
c. Vitric
d. Vertical
e. Validated
Answer : d
Question 48. Which worksheet function returns covariance, the average of the products of paired
deviations?
a. COUNT
b. COVER
c. CHITEST
d. DEVSQ
e. FREQUENCY
Answer : b
Question 49. How do you translate a time into a decimal value?
a. =TIMEVALUE
b. =TIME
c. Look into the date and time function
d. Ctrl T
Answer : a
Question 50. What does H stands for in HLOOKUP formula?
a. However
b. Header value
c. Horizontal
d. Height
Answer : c
|
|