Deck 29: Excel: Templates, styles, and Macros

Question 1

What is the default file extension for a template?

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

Answer 1

C

Question 2

Where is the Themes gallery located?

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

Answer 2

C

Question 3

Where are the default cell styles located?

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

Answer 3

A

Question 4

Which of the following is a method for creating macros?

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

Question 5

Where is the Template gallery located?

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

Question 6

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 7

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 8

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 9

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

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

Question 10

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 11

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

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

Question 12

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 13

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

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

Question 14

What is the password character limit in Excel?

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

Question 15

Which of the following formats does not support macros?

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

Question 16

Which of the following is not a default cell style?

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

Question 17

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 18

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 19

Where is the Insert Background feature located?

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

Question 20

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 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 are used in VBA to leave notes or instructions regarding the macro?

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

Question 23

Where can a macro be deleted?

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

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

What is the default reference type when recording a macro?

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

Question 26

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

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

Question 27

Which of the following tabs contains Form Controls?

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

Question 28

Where is the Protect Sheet command located in the Ribbon?

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

Question 29

Which of the following is not an Office theme?

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

Question 30

Where are Trust Center options located?

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

Question 31

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 32

Which of the following is not a Trust Center option?

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

Question 33

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

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

Question 34

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 35

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

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

Question 36

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

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

Question 37

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 38

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 39

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

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

Question 40

Comments in VBA appear in what color?

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

Question 41

Custom backgrounds can be applied to Excel worksheets.

Question 42

Custom functions can be created with the macro recorder.

Question 43

Macros are stored in modules.

Question 44

.xlsb files do not support macros.

Question 45

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

Question 46

By default all cells are locked.

Question 47

Good,Bad,and Neutral are predefined cell styles.

Question 48

By default,the macro recorder uses absolute references.

Question 49

A user can create custom cell styles.

Question 50

Templates can be located and downloaded in the templates gallery.

Question 51

Custom cell styles cannot be removed.

Question 52

Custom styles cannot be applied to other workbooks.

Question 53

The macro recorder can append a previously recorded macro.

Question 54

Once lost,a password cannot be retrieved.

Question 55

Once applied custom backgrounds cannot be deleted.

Question 56

The maximum number of characters for a password is 255.

Question 57

Form controls are located on the Developer tab.

Question 58

Comments cannot be viewed in the VBA editor.

Question 59

Font attributes can be controlled with cell styles.

Question 60

All templates should contain instructions.

Question 61

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

Question 62

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

Question 63

Excel passwords can be up to ________ characters.

Question 64

Macro settings cannot be edited in the Trust Center.

Question 65

Once created,macro buttons cannot be deleted.

Question 66

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

Question 67

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 68

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

Question 69

By default all cells in a workbook are ________.

Question 70

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

Question 71

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

Question 72

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

Question 73

Custom cell styles are stored in the ________ workbook.

Question 74

Once created a custom function cannot be edited.

Question 75

New templates can be located and viewed in the ________.

Question 76

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

Question 77

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

Question 78

The Themes gallery is located on the ________ tab.

Question 79

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

Question 80

Locked cells cannot be ________.