Question 1

You can create hyperlinks to ____.​

Accepted Answer

A)  ​open the user's default email handler 
B)  ​open the user's browser 
C)  ​share desktops 
D)  ​share private information

Question 2

Use macros to ensure consistency in all of the following EXCEPT ____.

Accepted Answer

A)  calculations 
B)  formatting 
C)  manipulation of nonnumeric data 
D)  variables

Question 3

When the number of rows are different,the relationship is said to be one-to-many.​

Accepted Answer

A) True 
 B)False

Question 4

The Get & Transform commands allow you to ​_____ large amounts of data into an accessible Excel table.

Accepted Answer

A)  ​extract 
B)  ​clean 
C)  ​connect 
D)  ​transform

Question 5

Which of the following is the path to the Macro Security button?

Accepted Answer

A)  (FORMULAS tab | Security group) 
B)  (REVIEW tab | Macros group) 
C)  (DEVELOPER tab | Code group) 
D)  (DATA tab | Macros group)

Question 6

A screen capture is a picture that can be used in other places in the workbook.​

Accepted Answer

A) True 
 B)False

Question 7

If you have enabled macros in a worksheet,Excel will not ask you about enabling them the next time you open the worksheet,but will open the worksheet with macros enabled.

Accepted Answer

A) True 
 B)False

Question 8

Which of the following is the shortcut key for creating a hyperlink​?

Accepted Answer

A)  ​F12 
B)  ​CTRL+K 
C)  ​SHIFT+D 
D)  ​ALT+CTRL+H

Question 9

If you will be using keyboard navigation when creating a macro,you must ensure that the '____' button in the Code group on the DEVELOPER tab is selected so that the macro works properly.

Accepted Answer

A)  Use Relative Reference 
B)  Use Absolute Reference 
C)  Use Mixed Reference 
D)  Use All References

Question 10

If you try to type in a cell,the text will appear behind the graphic.​

Accepted Answer

A) True 
 B)False

Exam 10: Using Macros and Visual Basic for Applications Vba With Excel

You can create hyperlinks to ____.

Use macros to ensure consistency in all of the following EXCEPT ____.

When the number of rows are different,the relationship is said to be one-to-many.

The Get & Transform commands allow you to _____ large amounts of data into an accessible Excel table.

Which of the following is the path to the Macro Security button?

A screen capture is a picture that can be used in other places in the workbook.

If you have enabled macros in a worksheet,Excel will not ask you about enabling them the next time you open the worksheet,but will open the worksheet with macros enabled.

Which of the following is the shortcut key for creating a hyperlink?

If you will be using keyboard navigation when creating a macro,you must ensure that the '____' button in the Code group on the DEVELOPER tab is selected so that the macro works properly.

If you try to type in a cell,the text will appear behind the graphic.

Exam 10: Using Macros and Visual Basic for Applications Vba With Excel

You can create hyperlinks to ____.​

Use macros to ensure consistency in all of the following EXCEPT ____.

When the number of rows are different,the relationship is said to be one-to-many.​

The Get & Transform commands allow you to ​_____ large amounts of data into an accessible Excel table.

Which of the following is the path to the Macro Security button?

A screen capture is a picture that can be used in other places in the workbook.​

If you have enabled macros in a worksheet,Excel will not ask you about enabling them the next time you open the worksheet,but will open the worksheet with macros enabled.

Which of the following is the shortcut key for creating a hyperlink​?

If you will be using keyboard navigation when creating a macro,you must ensure that the '____' button in the Code group on the DEVELOPER tab is selected so that the macro works properly.

If you try to type in a cell,the text will appear behind the graphic.​

You can create hyperlinks to ____.

When the number of rows are different,the relationship is said to be one-to-many.

The Get & Transform commands allow you to _____ large amounts of data into an accessible Excel table.

A screen capture is a picture that can be used in other places in the workbook.

Which of the following is the shortcut key for creating a hyperlink?

If you try to type in a cell,the text will appear behind the graphic.