1. Modules created in vba can neither be deleted nor removed? true or false 2. S

Question

1. Modules created in vba can neither be deleted nor removed? true or false

2. Scatter plots are the only type of plots in excel? true or false

3. input box accepts values from user. true or false

4. user cannot rename the worksheets in excel. true or false

5. a module name cannot be changed. true or false

6. a function program in excel cannot:
    a) use excel built in functions
    b) have multiple inputs
    c) be accessed from a cell on a spreadsheet
    d) have multiple outputs

7. which of the following cannot be store a numeric value:
   a) integer
b) string
c) long
   d) boolean

8. solver add in in excel allows you to:
   a) solve equations
   b) plot charts
    c) format cells
    d) all of the above

Explanation / Answer

1. False. We can extend the editor and write custom procedure to delete/remove modules in vba.

2. True. Scatter plots are the only plot in excel.

3. True. Inputbox function in excel is used to accept input values from a user.

4. False. User can rename the worksheets in excel.

5. False. Modulename can be changed in VBA Project Explorer properties.

6. c> A function program in excel cannot be accessed from a cell on a spreadsheet.

7. d>Boolean store only logical values. It cannot store a numeric value

8. d> Solver allows in solving an equation, decision making, plotting charts and formatting cells

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.