Deck 43: Templates styles and Macros

Question 1

Which of the following is not a default cell style?

A)Standard
B)Bad
C)Good
D)Neutral

Answer 1

A

Question 2

Which of the following is not prevented when a worksheet is protected?

A)Inserting
B)Printing
C)Deleting
D)Copying

Answer 2

B

Question 3

What is the default file extension for a template?

A))xls
B))xlsx
C))xltx
D))xlm

Answer 3

C

Question 4

Where are the default cell styles located?

A)Styles group
B)Editing group
C)Format group
D)Cells group

Question 5

Which of the following is not a predefined cell style category?

A)Data and Model
B)Number Format
C)Titles and Headings
D)Analysis

Question 6

Where is the Themes gallery located?

A)Backstage
B)Data tab
C)Page Layout tab
D)Insert tab

Question 7

What is the default save location for templates?

A)c :/Users\username\Documents\CustomOfficeTemplates
B)c : /Users\MyDocuments
C)c :/templates
D)c :/Users\templates

Question 8

Which of the following formats does not support macros?

A))xlsm
B))xlsb
C))xltm
D))xlsx

Question 9

Which of the following is not a tool to help provided a unified look and feel within a workbook?

A)Themes
B)Custom functions
C)Backgrounds
D)Styles

Question 10

Which of the following is not a tool to improve efficiency in a common workbook that is used by numerous employees in a business?

A)Template
B)Macros
C)Themes
D)Print settings

Question 11

Which of the following is true about a protected worksheet?

A)It cannot be saved
B)It cannot be printed
C)It cannot be edited
D)It cannot be shared on SkyDrive

Question 12

Where is the Insert Background feature located?

A)Backstage
B)Page Layout tab
C)Formulas tab
D)Insert tab

Question 13

Which of the following formats is supported as a background in Excel?

A)jpeg
B)mp3
C))xls
D))mpeg4

Question 14

Which of the following is not controlled with cell style formats?

A)Font attributes
B)Print settings
C)Cell-protection settings
D)Border and fill styles

Question 15

Which of the following is a method for creating macros?

A)Macro recorder
B)Formula builder
C)Insert function button
D)Developer tools

Question 16

What is the password character limit in Excel?

A)325
B)255
C)355
D)100

Question 17

Which of the following tools is best suited to complete repetitive tasks in Excel?

A)Macros
B)Templates
C)Styles
D)Themes

Question 18

Which of the following is not a good practice when creating a template?

A)Using descriptive labels
B)Using cell references in formulas
C)Locking view settings
D)Including instructions

Question 19

Which of the following is not true about locked cells?

A)Locked cells can be edited
B)All cells are locked by default
C)A password is required to unlock the cells
D)A locked cell is indicated by a padlock icon in the Format menu

Question 20

Where is the Template gallery located?

A)Insert tab
B)Backstage
C)Data tab
D)Formulas tab

Question 21

Which of the following is the proper beginning for a sub procedure named "Test"?

A)Sub ()
B)Sub (Test)
C)(Test)
D)Sub Test()

Question 22

Which of the following tabs contains Form Controls?

A)Insert
B)Data
C)Developer
D)Formulas

Question 23

What is the default reference type when recording a macro?

A)Absolute
B)Relative
C)Mixed
D)Normalitive

Question 24

Which of the following items is not stored inside VBA modules?

A)Sub procedures
B)Keywords
C)Comments
D)Index documents

Question 25

Where can a macro be deleted?

A)Backstage
B)Macro dialog box
C)Developer tab
D)Insert tab

Question 26

Where are custom cell styles saved?

A)The workbook in which you created the style
B)A personal styles workbook
C)My Documents
D)A personal macro workbook

Question 27

Which function should be used to mask zero values in templates?

A)IF
B)IFERROR
C)VLOOKUP
D)INDEX

Question 28

Which of the following is not a best practice when creating a macro?

A)Practice the steps before starting
B)Determine whether absolute or relative references should be used
C)Start and stop the recording as needed
D)Ensure the macros are broad enough to apply to multiple situations

Question 29

Which of the following is not an Office theme?

A)Office
B)Integral
C)Helvetica
D)Frame

Question 30

Where is the Protect Sheet command located in the Ribbon?

A)Backstage
B)Formulas tab
C)Review tab
D)Data tab

Question 31

Which of the following cannot be modified in a custom cell style?

A)Number
B)Alignment
C)Print area
D)Fill

Question 32

Where are macros recorded with the macro recorder stored?

A)The current workbook
B)The Templates folder
C)The templates gallery
D)My Documents

Question 33

Comments in VBA appear in what color?

A)Red
B)Green
C)Blue
D)Black

Question 34

Which of the following is not a Trust Center option?

A)Trusted App Catalogs
B)Trusted Publishers
C)Trusted Calculations
D)Message Bar

Question 35

Where are Trust Center options located?

A)Data tab
B)Backstage
C)Insert tab
D)Formulas tab

Question 36

What is the default folder for Personal Macro Workbooks in Windows 8?

A)c : /Users\Username\documents
B)c : /Users\Username\AppData\Roaming\Microsoft\Excel\XLStart
C)c : /Users\Username\AppData\Roaming\XLStart
D)c :/Users\Username\Excel

Question 37

Which of the formats below will not support sub procedures using VBA?

A))xlsm
B))xlsx
C))xlsb
D))xltm

Question 38

Which of the following are used in VBA to leave notes or instructions regarding the macro?

A)Comments
B)Keywords
C)Indicators
D)Index notes

Question 39

Which of the following is the file extension for a Personal Macro Workbook?

A))xls
B))xlxs
C))xltm
D))xlsb

Question 40

Which of the following objects can be used to launch a macro?

A)Chart
B)Function
C)Image
D)Hyperlink

Question 41

Custom cell styles cannot be removed.

Question 42

Form controls are located on the Developer tab.

Question 43

Comments cannot be viewed in the VBA editor.

Question 44

Once applied custom backgrounds cannot be deleted.

Question 45

.xlsb files do not support macros.

Question 46

Templates can be located and downloaded in the templates gallery.

Question 47

A user can create custom cell styles.

Question 48

The macro recorder can append a previously recorded macro.

Question 49

Once lost,a password cannot be retrieved.

Question 50

The maximum number of characters for a password is 255.

Question 51

Custom styles cannot be applied to other workbooks.

Question 52

Good,Bad,and Neutral are predefined cell styles.

Question 53

Font attributes can be controlled with cell styles.

Question 54

Custom functions can be created with the macro recorder.

Question 55

By default,the macro recorder uses absolute references.

Question 56

When creating templates,IFERROR should be used to mask zero values.

Question 57

Macros are stored in modules.

Question 58

All templates should contain instructions.

Question 59

Custom backgrounds can be applied to Excel worksheets.

Question 60

By default all cells are locked.

Question 61

The ________ function should be used to trap errors when creating templates.

Question 62

Once created a custom function cannot be edited.

Question 63

A(n)________ is a collection of format settings based on the currently selected theme to provide a consistent appearance within a worksheet and among similar workbooks.

Question 64

A ________ is a collection of formats that include coordinating colors,fonts,and special effects to provide a stylish appearance.

Question 65

Macro settings cannot be edited in the Trust Center.

Question 66

Custom cell styles are stored in the ________ workbook.

Question 67

Once created,macro buttons cannot be deleted.

Question 68

Locked cells cannot be ________.

Question 69

The Themes gallery is located on the ________ tab.

Question 70

A run time error will occur if a sub procedure is run on a protected workbook.

Question 71

New templates can be located and viewed in the ________.

Question 72

Data and Model,Titles and Headings,and Number Format are all examples of predefined ________.

Question 73

A ________ is a set of instructions that execute a sequence of commands to automate repetitive or routine tasks.

Question 74

By default all cells in a workbook are ________.

Question 75

Excel passwords can be up to ________ characters.

Question 76

A ________ is a partially completed document that you use as a model to create other documents
that have the same structure and purpose.

Question 77

Cells can be locked from the ________ group on the Home tab.

Question 78

The VBA editor can be opened with the key stroke Alt+F11.

Question 79

An image used to classify a document as confidential can be placed as a custom ________ in a workbook.

Question 80

The file extension for an Excel Macro-Enabled Workbook is ________.