EL2 C7 C8 Flashcards by rebecca mhm

By default, the Macro dialog box displays all the macros in

all the open workbooks

How well did you know this?

Not at all

Perfectly

To create a custom view, begin by

applying the desired settings to the active worksheet

How well did you know this?

Not at all

Perfectly

You can create a macro from scratch in Excel or using which of the following?

VBA Editor

How well did you know this?

Not at all

Perfectly

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

How well did you know this?

Not at all

Perfectly

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

How well did you know this?

Not at all

Perfectly

When you make changes to workbook display options, the changes

are saved with the workbook

How well did you know this?

Not at all

Perfectly

By default, AutoRecover automatically saves information every

10 minutes

How well did you know this?

Not at all

Perfectly

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

How well did you know this?

Not at all

Perfectly

Macros in Excel are written and saved in the _____ programming language.

VBA

How well did you know this?

Not at all

Perfectly

By default, Excel saves the macro in

the current workbook

How well did you know this?

Not at all

Perfectly

Which of the following is the final step when using a customized template?

Double-click the template

How well did you know this?

Not at all

Perfectly

Where is the Customize Quick Access Toolbar button?

at the right side of the Quick Access Toolbar

How well did you know this?

Not at all

Perfectly

How do you start creating a macro?

Click the View tab, click the Macros button arrow, and then click Record Macro

How well did you know this?

Not at all

Perfectly

What is the first step in inserting a form control?

Click the Developer tab

How well did you know this?

Not at all

Perfectly

To have your macros available when creating additional workbooks, you should consider

creating a macros workbook

How well did you know this?

Not at all

Perfectly

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

How well did you know this?

Not at all

Perfectly

To customize the ribbon, start by

clicking the File tab and then clicking Options

How well did you know this?

Not at all

Perfectly

What is the keyboard shortcut to minimize the ribbon?

Ctrl + F1

How well did you know this?

Not at all

Perfectly

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

How well did you know this?

Not at all

Perfectly

To run a macro, view the list of macros by clicking the Macros button in the Macros group on the _____ tab.

View

How well did you know this?

Not at all

Perfectly

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

How well did you know this?

Not at all

Perfectly

While a macro is being recorded, the mouse clicks to select ribbon tabs are

not recorded

How well did you know this?

Not at all

Perfectly

Which type of form control includes a drop-down list?

combo box

How well did you know this?

Not at all

Perfectly

To view the Trust Center options,

click the File tab, click Options, and then click Trust Center

How well did you know this?

Not at all

Perfectly

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 in the XML code appears as

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