Management Information Systems

Business

Quiz 22 :
Programming in Excel With VBA

Quiz 22 :
Programming in Excel With VBA

Showing 1 - 20 of 125
Next Quiz
arrow
VBA is:
Free
Multiple Choice
Answer:

Answer:

A
Explanation: VBA,which stands for Visual Basic for Applications,is a programming language developed by Microsoft.Excel,along with the other members of Microsoft Office,includes the VBA language.VBA extends and customizes Excel,allowing you to do things that Excel itself is not able to do,such as calculating values in cells based on user input values.

arrow
Which of the following Excel tools allows you to automate the building and running of complex calculations that are not included in the standard set of Excel functions?
Free
Multiple Choice
Answer:

Answer:

D
Explanation: VBA extends and customizes Excel,allowing you to do things that Excel itself is not able to do,such as calculating values in cells based on user input values.

arrow
Units of VBA code are often referred to as ____.
Free
Multiple Choice
Answer:

Answer:

C
Explanation: Units of VBA code are often referred to as macros.

arrow
Which of the following Excel tools allows you to record a sequence of commands in Excel and save them?
Multiple Choice
Answer:
arrow
Which of the following is a programming language that includes build-in commands that mimic the functionality available from menus and dialog boxes within an application?
Multiple Choice
Answer:
arrow
Which of the following is a set of Excel actions recorded or written by a user?
Multiple Choice
Answer:
arrow
Mr.Joseph is the CEO of a leading manufacturing concern.He wanted his name and designation to appear in italics on all the spreadsheets of the company's annual report.Which of the following Excel action should he use to achieve this?
Multiple Choice
Answer:
arrow
Dan was making a science project.He wanted to automate the two steps of adding a background theme to the cells and then printing the worksheet.Which of the following Excel actions can help Dan achieve this?
Multiple Choice
Answer:
arrow
Which of the following statements is true about a macro in Excel?
Multiple Choice
Answer:
arrow
Which of the following is a built-in function in Excel and does not require a macro?
Multiple Choice
Answer:
arrow
Which of the following tools enables users to view and edit a VBA macro?
Multiple Choice
Answer:
arrow
Which of the following is a component of a macro that performs some action on or with objects?
Multiple Choice
Answer:
arrow
Which of the following is a VBA macro that returns a single value?
Multiple Choice
Answer:
arrow
Which of the following is true about Function procedures?
Multiple Choice
Answer:
arrow
Which of the following VBA macros can be used in a worksheet formula?
Multiple Choice
Answer:
arrow
Which of the following does a VBA macro manipulate?
Multiple Choice
Answer:
arrow
A(n)_____ in VBA is an item available for you to control in your code.
Multiple Choice
Answer:
arrow
Which of the following refers to a place used to store a piece of information in Excel?
Multiple Choice
Answer:
arrow
Which of the following keys will you press to activate the VBE when Excel is active?
Multiple Choice
Answer:
arrow
When working on a worksheet,Ben was editing his macros using the Visual Basic Editor (VBE).After a while he wanted to go back to the Excel application interface.Which of the following key(s)should Ben use to toggle between the Excel application interface and the VBE?
Multiple Choice
Answer:
Showing 1 - 20 of 125
Next Quiz