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
|
|