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

Question 1

The MACRO tab on the ribbon includes commands used to work with macros.

Answer 1

False

Question 2

A macro's steps and their order should be determined and rehearsed after creating the macro.

Answer 2

False

Question 3

Commands can be added directly to a tab.​

Answer 3

False

Question 4

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.

Question 5

You must enable macros each time you open a workbook containing macros if the macro security setting is 'Disable all macros with notification.'

Question 6

The Applied Steps area displays each manipulation that you performed on the data.​

Question 7

If you make a mistake while recording a macro,press the ESC key and repeat the step in error.

Question 8

Once you start recording a macro,any task you perform in Excel will be part of the macro.

Question 9

You can set a keyboard shortcut key combination for executing a macro with an option in the Record Macro dialog box.

Question 10

Every Excel command and ribbon button has a corresponding Answer Report that the computer executes.

Question 11

The first row of the imported worksheet is the part of the data.​

Question 12

Excel has a command or button for every possible worksheet task.

Question 13

You should select the ending cell before turning on the macro recorder.

Question 14

Due to the advanced nature of the power tools,all of the command display automatically.​

Question 15

The Get & Transform command does not allow you to edit imported data.​

Question 16

Before recording a macro,you should select your ending cell.

Question 17

You can click the Stop / Start Macro button on the status bar to start or stop recording a macro.

Question 18

Macros provide you with an opportunity to make certain tasks much more efficient and accurate.

Question 19

A macro name can contain numbers and letters but not underscores.

Question 20

The Query Editor window has its own ribbon,tabs,and groups and is navigated independently from Excel.​

Question 21

Excel has a narrow range of interlinked power tools to analyze business data.​

Question 22

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

Question 23

Power Pivot is ​not helpful when analyzing large,complex sets of related tables.​

Question 24

Power BI is a business intelligence tool to visualize and share data.​

Question 25

If you want to create more than just a single static map,you must add relationships.​

Question 26

3D Maps can only be accessed from a specific worksheet or window.​

Question 27

A relationship is a field or column that three data sources have in common.​

Question 28

A hyperlink is a computer link or reference to another location.​

Question 29

PivotTables can be made without Power Pivot.​

Question 30

Cube functions are also called 3D cubes.​

Question 31

A data model is any collection of data that can be accessed or reassembled without having to reorganize the tables.​

Question 32

The COUNTIFS function is an easy way to count data using multiple criteria sets.​

Question 33

Excel will italicize a hyperlink.​

Question 34

Data models are unique to Power Pivot.​

Question 35

When users hover over a hyperlink,the pointer will appear as an arrow.​

Question 36

The 3D Maps command opens a window that uses a few of your computer's resources.​

Question 37

You can change the file type of a workbook that contains macros to Excel Macro-Enabled Workbook in the Trust Center dialog box.
_________________________

Question 38

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

Question 39

Once a hyperlink is created,it cannot be edited.​

Question 40

You can set up multiple relationships using Power Pivot.

Question 41

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

Question 42

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

A) table
B) macro
C) report
D) calculation

Question 43

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

Question 44

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

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

Question 45

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

A) (INSERT tab | Links group)
B) (PAGE LAYOUT tab | Links group)
C) (VIEW tab | Links group)
D) (DEVELOPER tab | Links group)

Question 46

You can create hyperlinks to ____.​

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

Question 47

What does OLAP stand for?​

A) ​Online Linear Application Program
B) ​Order Lines Around Pivot
C) ​Online Application Power
D) ​Online Analytical Processing

Question 48

Data analysis commands are required ​

A) ​to be turned on all the time.
B) ​in order to use the power tools.
C) ​before you can use the function key.
D) ​to be included in all Excel workbooks.

Question 49

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

A) Macro Options
B) Trust Center
C) Excel Options
D) Security Center

Question 50

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

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

Question 51

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

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

Question 52

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

A) (FORMULAS tab | Execute Macro group)
B) (DEVELOPER tab | Code group)
C) (MACROS tab | Run Macro group)
D) None of the above

Question 53

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

A) (POWER VIEW tab | Themes group)
B) (DEVELOPER tab | Themes group)
C) (MACROS tab | Themes group)
D) (INSERT tab | Background Image group)

Question 54

A macro name can be up to ____ characters long.

A) 8
B) 32
C) 127
D) 255

Question 55

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

A) Installation Defaults
B) Restore Settings
C) Factory preset
D) Excel Options

Question 56

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

A) ​CTRL+B
B) ​CTRL+H
C) ​CTRL+I
D) ​CTRL+K

Question 57

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.

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

Question 58

Power View uses _____ to group data.​

A) ​tiles
B) ​measures
C) ​formulas
D) ​models

Question 59

Why is it called a foreign column?​

A) ​It is written in a different language.
B) ​It refers to a field in one table that uniquely identifies a row in a different table.
C) ​It does not belong in this table.
D) ​It requires a different formula for analyzing the data.

Question 60

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

A) ​It identifies it as a query table.
B) ​Excel has definite rules about how to name different tables.
C) ​Database structures rarely allow spaces in the names of files or fields
D) ​It prevents the table from being read by other databases.

Question 61

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

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

Question 62

What is a measure?​

A) ​A calculated named field in Power Pivot.
B) ​A special set of functions and commands.
C) ​Fields in pivot field lists.
D) ​Created aggregate formulas that use one or multiple rows from multiple sources.

Question 63

Which of the following are interlinked power tools ​used to analyze business data in Excel?

A) ​Power Pivot
B) ​3D Maps
C) ​Power View
D) ​Power BI

Question 64

When customizing the ribbon,​

A) ​consider adding the command to the Quick Access Toolbar.
B) ​consider creating a new tab.
C) ​choose a tab with plenty of room.
D) ​remember who the audience is.

Question 65

Data catalogs _____.​

A) ​can only be stored on the computer where it was created
B) ​act as data dictionaries
C) ​can be shared with everyone within a business
D) ​do not exist

Question 66

Which of the following are types of hyperlinks?​

A) ​links to places in the workbook
B) ​links to files or webpages
C) ​a link to create a new file
D) ​links to email addresses

Question 67

Data modelling is the process of creating a _____.​

A) ​workbook
B) ​simulation
C) ​model
D) ​representation

Question 68

Which of the following steps must be taken in preparation for working with macros in Excel?

A) A security setting must be modified to enable macros.
B) Developer tab must be displayed.

Question 69

Which of the following are true about macros?

A) They save time
B) They ensure consistency
C) They automate repetitive tasks
D) They reduce formatting conformity

Question 70

In Power BI,a(n)_____ is the file management system where you can upload many different types of files.​

A) ​ftp server
B) ​database
C) ​dashboard
D) ​website