EL2 C7 C8 Flashcards
By default, the Macro dialog box displays all the macros in
all the open workbooks
To create a custom view, begin by
applying the desired settings to the active worksheet
You can create a macro from scratch in Excel or using which of the following?
VBA Editor
If you enter an uppercase X in the Shortcut key option box at the Record Macro dialog box, Excel will define the shortcut as
Ctrl + Shift + X
What happens if you assign an existing Excel keystroke combination, such as Ctrl + p (print), to a macro?
Your macro will override Excel’s shortcut
When you make changes to workbook display options, the changes
are saved with the workbook
By default, AutoRecover automatically saves information every
10 minutes
When you create a new tab in the ribbon, where is the new tab placed?
after the tab name you have clicked in the Main Tabs lis
Macros in Excel are written and saved in the _____ programming language.
VBA
By default, Excel saves the macro in
the current workbook
Which of the following is the final step when using a customized template?
Double-click the template
Where is the Customize Quick Access Toolbar button?
at the right side of the Quick Access Toolbar
How do you start creating a macro?
Click the View tab, click the Macros button arrow, and then click Record Macro
What is the first step in inserting a form control?
Click the Developer tab
To have your macros available when creating additional workbooks, you should consider
creating a macros workbook
To save your current ribbon and Quick Access Toolbar settings, click the File tab,
click Options, click Customize Ribbon, and then click the Import/Export button
To customize the ribbon, start by
clicking the File tab and then clicking Options
What is the keyboard shortcut to minimize the ribbon?
Ctrl + F1
When you click the Reset button in the Excel Options dialog box with Customize Ribbon selected, these two options are displayed.
Reset only selected Ribbon tab and Reset all customizations
To run a macro, view the list of macros by clicking the Macros button in the Macros group on the _____ tab.
View
Click the Reset button below the Main Tabs list box in the Excel Options dialog box with Customize Ribbon selected to
reset the selected ribbon tab
While a macro is being recorded, the mouse clicks to select ribbon tabs are
not recorded
Which type of form control includes a drop-down list?
combo box
To view the Trust Center options,
click the File tab, click Options, and then click Trust Center
A custom _____ saves the display and print settings for the active worksheet.
view
A custom view cannot be created for any worksheet that contains a
table
When a workbook that contains a macro is opened, the default macro security setting is
Disable all macros with notification
A macro name _____ space(s) and _____ letter(s).
cannot contain; must begin with a
The Shortcut key section of the Record Macro dialog box holds the keystrokes that will be used to
execute the macro
To use a template you have created, click Personal at the
New backstage area
Which of the following is not one of the options in the Choose commands from option box at the Excel Options dialog box?
Visual Basic Commands
Where is the Ribbon Display Options button?
in the upper right corner of the screen
The Rename dialog box for a group name contains the Display name text box and the_____ list box.
Symbol
What displays when you click the Edit button at the Macro dialog box?
a Microsoft Visual Basic for Applications window
You can rename a tab by _____ the tab name, clicking Rename at the shortcut menu, and then typing a new name at the Rename dialog box.
right-clicking
Macros are created using Excel’s
macro recorder
If a feature is not available in any tab on the ribbon, search for it in the ____ list box at the Excel Options dialog box.
All Commands
When creating an XML schema, you should provide code for at least _____ records.
two
A title added to a web page displays in the ______ of the browser window.
Title bar
For a workbook that has been marked as final, all the following statements are true except which one?
The workbook is encrypted