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
To mark a workbook as final, begin by clicking the _____ tab to display the _____.
File; Info backstage area
To turn on worksheet protection, display the Protect Sheet dialog box and then select
(?)
NOT the password to be used
The first step in importing an XML file is to click the _____ button in the _____ group on the Data tab.
Get Data; Get & Transform
Which of the following is one of the workbook properties that Excel adds automatically?
date the workbook was created
How can you provide a workbook to users with an Excel version earlier than Excel 2007?
Save it in Excel 97-2003 format
In an XML schema, the closing tag includes a(n)
forward slash (/)
To unlock cells, click the _____ in the Cells group on the Home tab.
Format
The _____ feature saves versions of your work at a specified time interval.
AutoRecover
When the schema file is added to the workbook, each <Tag> in the XML code appears as</Tag>
an XML element in the XML maps in the workbook list box
At the dialog box that allows you to protect a workbook’s structure, you can also prevent the user from
resizing or changing the positions of the windows
How can you remove protection from a worksheet?
Click the Unprotect Sheet button in the Protect group on the Review tab
To protect the structure of a workbook, use the Protect Workbook button in the _____ group on the _____ tab.
Protect; Review
For a workbook that has been marked as final, all the following statements are true except which one?
The workbook is encrypted
Workbook properties can be viewed and edited at the
Info backstage area
What does XPS stand for?
XML paper specification
To remove worksheet protection, click the Unprotect Sheet button or click the _____ in the Info backstage area.
Unprotect hyperlink
If the Accessibility Checker determines that a workbook will be difficult in some cases for people with accessibility issues to understand, which of the following accessibility issues will result?
Warning
Create an XML _____ by dragging each element from the list box at the XML Source task pane to its respective column header in the worksheet.
data map
If a password was entered when a workbook was protected, clicking the Protect Workbook button will display the _____ dialog box.
Unprotect Workbook
When you publish a worksheet as an HTML web page,
Excel creates files for supplemental data
How can you prevent a user from making changes to the sizes or positions of windows in a workbook?
Click the Protect Workbook button and then click the Windows check box
Which company developed the PDF standard?
Adobe
Where is the Encrypt with Password option?
at the Info backstage area
A password should contain four types of characters. Which of the following is not one of them?
spaces
When publishing a workbook as a web page, specify whether to publish the entire workbook or _____ at the Save as dialog box.
only the active worksheet
How can you tell that a selected cell is locked?
At the Format button drop-down list, the icon next to Lock Cell is highlighted
At the Macro dialog box, you can do all the following except _____ a macro.
copy
How do you add a command to the Quick Access Toolbar from the Excel Options dialog box?
Double-click the command name
A _____ is a workbook with standard text, formulas, and formatting.
template
Before distributing a workbook, use the _____ to determine whether any of the workbook’s features may make it difficult for someone who requires assistive technology to read it.
Accessibility Checker
At the Save As dialog box, click the _____ button to open the Publish as Web Page dialog box.
Publish
The term _____ refers to descriptive information about data.
metadata
Use Excel’s _____ feature to scan a workbook for personal data and hidden information.
Document Inspector
Remove a password from a workbook at the _____ dialog box.
Encrypt Document
The first step in exporting a worksheet as an XML file is to click the _____ button in the XML group on the _____ tab.
Source; Developer
If you forget the password assigned to protect a worksheet, what can you do?
Nothing; the worksheet cannot be unprotected if the password is forgotten
What does PDF stand for?
Portable Document Format
What is the name for the scrambled text Excel uses to encrypt passwords?
cipher text
At the Document Inspector dialog box, remove the check marks from the check boxes next to
items that are not to be scanned or removed from the workbook before distributing it
At the Info backstage area, a description of the protection features applied to the workbook and/or worksheets is provided
next to the Protect Workbook button
To determine in advance what areas of a worksheet might cause problems for users with earlier versions of Excel,
run the Compatibility Checker
By default, when a worksheet is protected, you
cannot delete any content
Which company developed XPS?
Microsoft
How can you prevent people from making additions, deletions, or changes to a workbook you plan to distribute?
Click the File tab, click Info, click the Protect Workbook button, and then click Mark as Final
Which of the following is not one of the workbook properties listed at the Info backstage area?
User
Which of the following is not one of the steps taken to protect a worksheet?
Click Lock Cell
Which of the following is not one of the steps for deleting a macro?
Click the Formulas tab
When you save a worksheet containing macros created in Excel, what will the file extension be?
.xlsm
When you create a new tab for the ribbon, the tab is given which of the following names?
New Tab (Custom)
When you send a worksheet as an XPS document, the recipient must have _____ on his or computer to use the file.
XPS viewer
When you send a worksheet as a PDF document, the recipient must have _____ on his or her computer to use the file.
Adobe Acrobat Reader DC
By default, when a new workbook is created, Excel inserts in the _____ property box the name of the computer user.
Author
Suppose the Document Inspector identifies personal data in a workbook that should remain confidential. To remove this information before distributing the workbook, use tools at the
Info backstage area
After running the Accessibility Checker, refer to the Accessibility Checker task pane on the_____ of the screen for a list of the inspection results.
right side
To delete a macro, _____, select the macro name, and then click the Delete button.
open the Macro dialog box
At the Record Macro dialog box, the letter entered in the Shortcut key section is used in conjunction with the _____ key to run the macro.
CTRL
At the Excel Options dialog box, _____ displays by default in the Customize the Ribbon option box.
Main Tabs
What does XML stand for?
Extensible Markup Language
You can only apply a custom view to the worksheet that
was active when the view was created
When displayed in the Visual Basic for Applications window, the first few lines of a macro are preceded by apostrophes (‘). These lines are
comments