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 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 51. Applying a $ to a cell reference in a formula:
a. Applies currency formatting to the result of the formula.
b. Converts the result of the formula to text.
c. Turns to wrap text in that cell.
d. Keeps the reference component unchanged as you copy this formula to other locations.
Answer : d
Question 52. What is a function of data markers?
a. You can automatically apply formatting to a data series
b. You can change a data print value and automatically turn it into a chart
c. You can change the position of a data marker and automatically change the data point value
in the worksheet
Answer : c
Question 53. What character is used in a formula cell reference so that it can be copied elsewhere
but still refer to the same cell or cells?
a. &
b. *
c. $
d. /
Answer : c
Question 54. Which language is used to create macros in Excel?
a. C#
b. Visual Basic for Applications
c. Java
d. C
Answer : b
Question 55. Which is not a function?
a. MAX
b. SUM
c. DMV
d. PMT
Answer : c
Question 56. If you see a small red triangle in the top right corner of a cell, it means there is
something 'attached' to the cell. What is it?
a. A comment
b. A macro
c. A formula
d. A hyperlink
Answer : a
Question 57. The speed up the calculations of a data table on a worksheet,
a. You can change the calculation options to automatically recalculate the worksheet.
b. You can create a running balance formula in Tools menu Formula auditing Mode
c. Automatic option is not available
Answer : a
Question 58. Under which tab would you access Visual Basic?
a. Home
b. Insert
c. Data
d. Formulas
e. Developer
Answer : e
Question 59. What is the correct syntax for typing a function into a cell?
a. Function name, equal sign, arguments
b. Function name, arguments, equal sign
c. Equal sign, Function name, arguments
d. Equal sign, Function name, result
Answer : c
Question 60. Does conditional formatting override the formatting set inn a cell?
a. No-unless a MACRO is used.
b. No-the manually set format will override the conditional formatting
c. Yes-if the condition(s) are met
d. Depends onn the user setting
Answer : c
|
|