Question 1

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

Accepted Answer

This statement is false. When typing into a cell, the text will appear in front of any existing graphics or formatting in the cell.

Question 2

A ____ is created by performing a set of steps and recording the steps as they are performed.

Accepted Answer

The description best fits a macro, which is a set of programmed instructions that automates repetitive tasks in software. The other options, table, report, and calculation, do not involve recording a set of steps.

Question 3

You know there is a hyperlink,if Excel underlines the text.​

Accepted Answer

In Excel, if the text is underlined, it indicates that there is a hyperlink attached to it.

Question 4

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

Accepted Answer

The shortcut key for creating a hyperlink is CTRL+K. This allows the user to quickly insert a hyperlink to a webpage, email address, or file within a document or presentation. F12 is a shortcut key for saving a document. SHIFT+D and ALT+CTRL+H do not have any functions related to creating hyperlinks.

Question 5

Which of the following is the path to the 'Add a Hyperlink' button?

Accepted Answer

The 'Add a Hyperlink' button can be found in the 'Links' group under the 'INSERT' tab.

Question 6

You can create hyperlinks to ____.​

Accepted Answer

The answer of You can create hyperlinks to ____.​
...

Question 7

What does OLAP stand for?​

Accepted Answer

OLAP stands for Online Analytical Processing, which is a technology used for multidimensional analysis of large data sets. It allows users to rapidly access and analyze large amounts of data from various perspectives and dimensions.

Question 8

Data analysis commands are required ​

Accepted Answer

Data analysis commands are not necessarily required to be turned on all the time or included in all Excel workbooks. They are only necessary if the user wants to use power tools such as regression analysis, Fourier analysis, or moving average. The function key can also be used without data analysis commands. Therefore, the best choice is B as it accurately describes the purpose of data analysis commands.

Question 9

You can enable or disable macros with options in the ____ dialog box.

Accepted Answer

The Trust Center in Microsoft Excel contains options for enabling or disabling macros, as well as other security settings.

Question 10

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

Accepted Answer

The Macro Security button is located in the DEVELOPER tab, within the Code group. None of the other tabs or groups mentioned have the Macro Security button.

Question 11

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

Accepted Answer

The answer of Use macros to ensure consistency in all...

Question 12

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

Accepted Answer

The Record Macro button can be found on the DEVELOPER tab, which is not visible by default. If the DEVELOPER tab is not visible, it can be activated by going to File > Options > Customize Ribbon and checking the box next to DEVELOPER in the list of Main Tabs. The Record Macro button is located in the Code group on the DEVELOPER tab. The other options listed are not correct paths to the Record Macro button.

Question 13

Which of the following is the path to the Background button?

Accepted Answer

The Background button is located in the POWER VIEW tab within the Themes group.

Question 14

A macro name can be up to ____ characters long.

Accepted Answer

A macro name can be up to 255 characters long.

Question 15

You can reset the ribbon to its installation default by clicking the Reset button in the Customize the Ribbon options in the ____ dialog box.

Accepted Answer

The option to reset the ribbon to its installation default is located in the Excel Options dialog box under the Customize Ribbon section. This makes D the correct choice. A, B, and C are not accurate options for accessing this feature.

Question 16

You can press _____ to display the Hyperlink dialog box.​

Accepted Answer

Pressing CTRL+K will display the Hyperlink dialog box where you can insert or modify hyperlinks in Microsoft Office programs.

Question 17

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

When using keyboard navigation, we want to make sure that the macro records the relative reference of the keystrokes instead of the absolute reference of the cell or range. This will ensure that the macro works properly regardless of where the active cell is located. Therefore, we should select the "Use Relative Reference" button in the Code group on the DEVELOPER tab.

Question 18

Power View uses _____ to group data.​

Accepted Answer

Power View uses tiles to group data.

Question 19

Why is it called a foreign column?​

Accepted Answer

A foreign column refers to a field in one table that uniquely identifies a row in a different table. This is because it is used as a reference to connect data from one table to another.

Question 20

Why do the query tables use an underscore in their names?

Accepted Answer

It is common in database structures to avoid spaces in file and field names, so underscores are typically used instead. This convention is carried over to query tables in Excel.

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

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

A ____ is created by performing a set of steps and recording the steps as they are performed.

You know there is a hyperlink,if Excel underlines the text.

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

Which of the following is the path to the 'Add a Hyperlink' button?

You can create hyperlinks to ____.

What does OLAP stand for?

Data analysis commands are required

You can enable or disable macros with options in the ____ dialog box.

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

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

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

Which of the following is the path to the Background button?

A macro name can be up to ____ characters long.

You can reset the ribbon to its installation default by clicking the Reset button in the Customize the Ribbon options in the ____ dialog box.

You can press _____ to display the Hyperlink dialog box.

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.

Power View uses _____ to group data.

Why is it called a foreign column?

Why do the query tables use an underscore in their names?

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

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

A ____ is created by performing a set of steps and recording the steps as they are performed.

You know there is a hyperlink,if Excel underlines the text.​

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

Which of the following is the path to the 'Add a Hyperlink' button?

You can create hyperlinks to ____.​

What does OLAP stand for?​

Data analysis commands are required ​

You can enable or disable macros with options in the ____ dialog box.

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

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

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

Which of the following is the path to the Background button?

A macro name can be up to ____ characters long.

You can reset the ribbon to its installation default by clicking the Reset button in the Customize the Ribbon options in the ____ dialog box.

You can press _____ to display the Hyperlink dialog box.​

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.

Power View uses _____ to group data.​

Why is it called a foreign column?​

Why do the query tables use an underscore in their names?

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

You know there is a hyperlink,if Excel underlines the text.

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

You can create hyperlinks to ____.

What does OLAP stand for?

Data analysis commands are required

You can press _____ to display the Hyperlink dialog box.

Power View uses _____ to group data.

Why is it called a foreign column?