MS Excel Quiz 91-100


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 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 91. Excel's data validation feature enables you to...

a. only except data with a citation
b. limit what kinds of graphs a user can create
c. request that all edits be sent to you for approval
d. set up certain rules that dictate what can be entered into a cell

Answer : d

Question 92. How do you make sure that a MACRO won't automatically run on a spreadsheet you've downloaded?

a. Impossible to block unless you open the spreadsheet and delete/modify the MACROs
b. Ctrl-Alt-Delete
c. Set your Security settings so that Excellwill ask permission first.
d. Don't download spreadsheet ffrom the Internet

Answer : c

Question 93. How can you delete an emvedded object?

a. Select it, press Delete
b. Press Shift + Delete
c. Press Alt + Delete
d. Double click it

Answer : a

Question 94. How are columns named?

a. Alphabetically
b. Metamorphically
c. Symbolically
d. Numerically

Answer : a

Question 95. Which worksheet function returns the individual term binomial distribution probability?

a. BETADIST
b. AVERAGEA
c. BETAINV
d. BINOMDIST
e. AVEDEV

Answer : d

Question 96. The cell reference of a range of cells that starts in cell B1 and goes over to column G and down to row 10 is...

a. B1;G10
b. B1:G10
c. B1-G10
d. B1*G10

Answer : b

Question 97. Foratting a cell in Currency, you can specify...

a. decimal places
b. currency symbol
c. both decimal places and currency symbol
d. none of the above

Answer : c

Question 98. How do you create a remainder to follow up on a document?

a. Insert/New Comment
b. Data/Validation/Input Message
c. Tools/Scenarios/Add/Merge
d. Tools/Flag for Follow Up/Enter Date & Time

Answer : d

Question 99. Which solver method will change variable cells to meet an objective cell?

a. Cannot be done in Solver
b. LP Simplex
c. Evolutionary
d. GRG Nonlinear
e. All Solver method

Answer : e

Question 100. In Sheet1, column A is January's sales numbers. In Sheet2, column A is February's sale numbers. Which equation on Sheet 3 totals both columns, in row 5?

a. =Sheet1!A5+A5
b. =A5+A5
c. =Sheet1!A5+Sheet2!A5
d. =Sheet1+Sheet2

Answer : c


Previous<------------>Next