Deck 12: Collaborating on a Shared Workbook

Question 1

How long does Excel store edits in the tracking log

Answer 1

Use of Properties of Properties Windows
Property is an attribute of object. It defines the name, font, and worksheet name etc. for particular object.Properties Window gives the list of properties in the worksheets of Excel Visual basic Application.
Also, it displays the values which are associated with the each object. That objects are present in the Project Exlporer window.
In the property window, property shows the information about the object. That object shows the all kind of the object.Any kind of information always helpful for the mangaing the information.
Also, user can easily understand which objects have which property. So for managing the information and understand the working of that object properties windows helpful.

Question 2

What is the syntax of the MsgBox function

Answer 2

Syntax of Message Box
The dialog box which is used to display message is called as the message box. In the message box there will buttons, messages, and information for the user. Message box is different from the text box because it does not contain the text boxes.
Following is the syntax of MsgBox in VBA:
MsgBox Prompt, Buttons, Title
In the above syntax prompt is message on the message box. Buttons are for the further action. Title is the message which appears at the section of title of message box.

Question 3

What are the two ways you can review the contents of the tracking log

Answer 3

Types of Procedure
There are three different types of procedure in VBA, which are described as follows:
1. Sub procedure: Basic working of sub procedure is standard sub routing.Sub procedure is mostly used sub routing. Sub procedure uses recorded as well as edited macro.It executes the code line by line.Example of sub procedure is saving file.
2. Function procedure: It is another important procedure in VBA.Function procedure returns an answer. This is different with sub procedure because sub procedure not returning the answer.Example of function procedure is "sum" function it returns the output as value.
3. Property procedure: It is giving the property for the object.Property procedure is only used in the Class modules.Property procedure is reserved for the class modules.

Question 4

What command would you enter to display a message box with the following elements: the text File Status in the title bar, the message File Saved, and an OK button

Question 5

What are some edits that are not included in a tracking log

Question 6

What can you customize to insert macro buttons that can be used from any-where within a workbook

Question 7

Can any two workbooks be merged together Explain why or why not.

Question 8

What is the difference between a sub procedure and a function procedure

Question 9

List two advantages of saving workbooks to a file hosting service.

Question 10

What are document properties

Question 11

How do you add multiple values to a document tag

Question 12

How can you determine whether a workbook contains sensitive or personal information

Question 13

Why should you not use the default Sheet1, Sheet2 worksheet names supplied by Excel

Question 14

What is workbook encryption

Question 15

What happens to a workbook that is edited after it is digitally signed

Question 16

What is the difference between linking and embedding

Question 17

What is a control structure, and why might you need one in a VBA procedure

Question 18

Define the terms comparison operator and logical operator.

Question 19

What is a shared workbook

Question 20

What is the syntax of the If-Then-Else control structure

Question 21

How does Excel resolve two different edits made to the same worksheet cell simultaneously

Question 22

What control structure would you use if you had multiple conditions from which to choose