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 
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 
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 
A)  ​extract 
B)  ​clean 
C)  ​connect 
D)  ​transform

Question 5

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

Accepted Answer

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

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.

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

Working With Large Worksheets, Charting, and What-If Analysis

Financial Functions, Data Tables, and Amortization Schedules

Working With Multiple Worksheets and Workbooks

Creating, Sorting, and Querying a Table

Creating Templates, Importing Data, and Working With Smartart, Images, and Screenshots

Working With Trendlines, Pivot Table Reports, Pivotchart Reports, and Slicers

Formula Auditing, Data Validation, and Complex Problem Solving

Collaboration Features for Workbooks

Essential Concepts and Skills

Productivity App: Productivity Apps for School and Work

Filters

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

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

Working With Large Worksheets, Charting, and What-If Analysis

Financial Functions, Data Tables, and Amortization Schedules

Working With Multiple Worksheets and Workbooks

Creating, Sorting, and Querying a Table

Creating Templates, Importing Data, and Working With Smartart, Images, and Screenshots

Working With Trendlines, Pivot Table Reports, Pivotchart Reports, and Slicers

Formula Auditing, Data Validation, and Complex Problem Solving

Collaboration Features for Workbooks

Essential Concepts and Skills

Productivity App: Productivity Apps for School and Work

Filters

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.