EL2 C7 C8 Flashcards

1
Q

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

A

all the open workbooks

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

To create a custom view, begin by

A

applying the desired settings to the active worksheet

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

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

A

VBA Editor

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

If you enter an uppercase X in the Shortcut key option box at the Record Macro dialog box, Excel will define the shortcut as

A

Ctrl + Shift + X

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What happens if you assign an existing Excel keystroke combination, such as Ctrl + p (print), to a macro?

A

Your macro will override Excel’s shortcut

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

When you make changes to workbook display options, the changes

A

are saved with the workbook

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

By default, AutoRecover automatically saves information every

A

10 minutes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

When you create a new tab in the ribbon, where is the new tab placed?

A

after the tab name you have clicked in the Main Tabs lis

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

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

A

VBA

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

By default, Excel saves the macro in

A

the current workbook

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

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

A

Double-click the template

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Where is the Customize Quick Access Toolbar button?

A

at the right side of the Quick Access Toolbar

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

How do you start creating a macro?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What is the first step in inserting a form control?

A

Click the Developer tab

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

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

A

creating a macros workbook

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

To save your current ribbon and Quick Access Toolbar settings, click the File tab,

A

click Options, click Customize Ribbon, and then click the Import/Export button

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

To customize the ribbon, start by

A

clicking the File tab and then clicking Options

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

What is the keyboard shortcut to minimize the ribbon?

A

Ctrl + F1

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

When you click the Reset button in the Excel Options dialog box with Customize Ribbon selected, these two options are displayed.

A

Reset only selected Ribbon tab and Reset all customizations

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

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

A

View

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

Click the Reset button below the Main Tabs list box in the Excel Options dialog box with Customize Ribbon selected to

A

reset the selected ribbon tab

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

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

A

not recorded

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

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

A

combo box

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

To view the Trust Center options,

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

A custom _____ saves the display and print settings for the active worksheet.

A

view

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q

A custom view cannot be created for any worksheet that contains a

A

table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
27
Q

When a workbook that contains a macro is opened, the default macro security setting is

A

Disable all macros with notification

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
28
Q

A macro name _____ space(s) and _____ letter(s).

A

cannot contain; must begin with a

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
29
Q

The Shortcut key section of the Record Macro dialog box holds the keystrokes that will be used to

A

execute the macro

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
30
Q

To use a template you have created, click Personal at the

A

New backstage area

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
31
Q

Which of the following is not one of the options in the Choose commands from option box at the Excel Options dialog box?

A

Visual Basic Commands

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
32
Q

Where is the Ribbon Display Options button?

A

in the upper right corner of the screen

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
33
Q

The Rename dialog box for a group name contains the Display name text box and the_____ list box.

A

Symbol

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
34
Q

What displays when you click the Edit button at the Macro dialog box?

A

a Microsoft Visual Basic for Applications window

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
35
Q

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.

A

right-clicking

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
36
Q

Macros are created using Excel’s

A

macro recorder

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
37
Q

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.

A

All Commands

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
38
Q

When creating an XML schema, you should provide code for at least _____ records.

A

two

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
39
Q

A title added to a web page displays in the ______ of the browser window.

A

Title bar

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
40
Q

For a workbook that has been marked as final, all the following statements are true except which one?

A

The workbook is encrypted

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
41
Q

To mark a workbook as final, begin by clicking the _____ tab to display the _____.

A

File; Info backstage area

42
Q

To turn on worksheet protection, display the Protect Sheet dialog box and then select

A

(?)
NOT the password to be used

43
Q

The first step in importing an XML file is to click the _____ button in the _____ group on the Data tab.

A

Get Data; Get & Transform

44
Q

Which of the following is one of the workbook properties that Excel adds automatically?

A

date the workbook was created

45
Q

How can you provide a workbook to users with an Excel version earlier than Excel 2007?

A

Save it in Excel 97-2003 format

46
Q

In an XML schema, the closing tag includes a(n)

A

forward slash (/)

47
Q

To unlock cells, click the _____ in the Cells group on the Home tab.

A

Format

48
Q

The _____ feature saves versions of your work at a specified time interval.

A

AutoRecover

49
Q

When the schema file is added to the workbook, each <Tag> in the XML code appears as</Tag>

A

an XML element in the XML maps in the workbook list box

50
Q

At the dialog box that allows you to protect a workbook’s structure, you can also prevent the user from

A

resizing or changing the positions of the windows

51
Q

How can you remove protection from a worksheet?

A

Click the Unprotect Sheet button in the Protect group on the Review tab

52
Q

To protect the structure of a workbook, use the Protect Workbook button in the _____ group on the _____ tab.

A

Protect; Review

53
Q

For a workbook that has been marked as final, all the following statements are true except which one?

A

The workbook is encrypted

54
Q

Workbook properties can be viewed and edited at the

A

Info backstage area

55
Q

What does XPS stand for?

A

XML paper specification

56
Q

To remove worksheet protection, click the Unprotect Sheet button or click the _____ in the Info backstage area.

A

Unprotect hyperlink

57
Q

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?

A

Warning

58
Q

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.

A

data map

59
Q

If a password was entered when a workbook was protected, clicking the Protect Workbook button will display the _____ dialog box.

A

Unprotect Workbook

60
Q

When you publish a worksheet as an HTML web page,

A

Excel creates files for supplemental data

61
Q

How can you prevent a user from making changes to the sizes or positions of windows in a workbook?

A

Click the Protect Workbook button and then click the Windows check box

62
Q

Which company developed the PDF standard?

A

Adobe

63
Q

Where is the Encrypt with Password option?

A

at the Info backstage area

64
Q

A password should contain four types of characters. Which of the following is not one of them?

A

spaces

65
Q

When publishing a workbook as a web page, specify whether to publish the entire workbook or _____ at the Save as dialog box.

A

only the active worksheet

66
Q

How can you tell that a selected cell is locked?

A

At the Format button drop-down list, the icon next to Lock Cell is highlighted

67
Q

At the Macro dialog box, you can do all the following except _____ a macro.

A

copy

68
Q

How do you add a command to the Quick Access Toolbar from the Excel Options dialog box?

A

Double-click the command name

69
Q

A _____ is a workbook with standard text, formulas, and formatting.

A

template

70
Q

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.

A

Accessibility Checker

71
Q

At the Save As dialog box, click the _____ button to open the Publish as Web Page dialog box.

A

Publish

72
Q

The term _____ refers to descriptive information about data.

A

metadata

73
Q

Use Excel’s _____ feature to scan a workbook for personal data and hidden information.

A

Document Inspector

74
Q

Remove a password from a workbook at the _____ dialog box.

A

Encrypt Document

75
Q

The first step in exporting a worksheet as an XML file is to click the _____ button in the XML group on the _____ tab.

A

Source; Developer

76
Q

If you forget the password assigned to protect a worksheet, what can you do?

A

Nothing; the worksheet cannot be unprotected if the password is forgotten

77
Q

What does PDF stand for?

A

Portable Document Format

78
Q

What is the name for the scrambled text Excel uses to encrypt passwords?

A

cipher text

79
Q

At the Document Inspector dialog box, remove the check marks from the check boxes next to

A

items that are not to be scanned or removed from the workbook before distributing it

80
Q

At the Info backstage area, a description of the protection features applied to the workbook and/or worksheets is provided

A

next to the Protect Workbook button

81
Q

To determine in advance what areas of a worksheet might cause problems for users with earlier versions of Excel,

A

run the Compatibility Checker

82
Q

By default, when a worksheet is protected, you

A

cannot delete any content

83
Q

Which company developed XPS?

A

Microsoft

84
Q

How can you prevent people from making additions, deletions, or changes to a workbook you plan to distribute?

A

Click the File tab, click Info, click the Protect Workbook button, and then click Mark as Final

85
Q

Which of the following is not one of the workbook properties listed at the Info backstage area?

A

User

86
Q

Which of the following is not one of the steps taken to protect a worksheet?

A

Click Lock Cell

87
Q

Which of the following is not one of the steps for deleting a macro?

A

Click the Formulas tab

88
Q

When you save a worksheet containing macros created in Excel, what will the file extension be?

A

.xlsm

89
Q

When you create a new tab for the ribbon, the tab is given which of the following names?

A

New Tab (Custom)

90
Q

When you send a worksheet as an XPS document, the recipient must have _____ on his or computer to use the file.

A

XPS viewer

91
Q

When you send a worksheet as a PDF document, the recipient must have _____ on his or her computer to use the file.

A

Adobe Acrobat Reader DC

92
Q

By default, when a new workbook is created, Excel inserts in the _____ property box the name of the computer user.

A

Author

93
Q

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

A

Info backstage area

94
Q

After running the Accessibility Checker, refer to the Accessibility Checker task pane on the_____ of the screen for a list of the inspection results.

A

right side

95
Q

To delete a macro, _____, select the macro name, and then click the Delete button.

A

open the Macro dialog box

96
Q

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.

A

CTRL

97
Q

At the Excel Options dialog box, _____ displays by default in the Customize the Ribbon option box.

A

Main Tabs

98
Q

What does XML stand for?

A

Extensible Markup Language

99
Q

You can only apply a custom view to the worksheet that

A

was active when the view was created

100
Q

When displayed in the Visual Basic for Applications window, the first few lines of a macro are preceded by apostrophes (‘). These lines are

A

comments