Deck 12: Templates, Styles, and Macros

Question 1

What function traps errors in a custom template?

A)ERRORTRAP
B)IF(#ErrorValue)
C)IFERROR
D)FINDERROR

Answer 1

C

Question 2

Which of the following are not included in themes?

A)Fonts
B)Colors
C)Formulas
D)Effects

Answer 2

C

Question 3

What file extension do templates use?

A).xlsx
B).xlsm
C).xltx
D).xlsb

Answer 3

C

Question 4

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

A)Good, Bad and Neutral
B)Titles and Headings
C)Data and Model
D)Analysis

Question 5

A cell style is a collection of ________.

A)themes
B)format settings
C)fonts
D)colors

Question 6

Use these instead of numbers in formulas in templates whenever possible.

A)Cell references
B)Functions
C)Styles
D)Text

Question 7

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

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

Question 8

To modify a style, right-click the style and then select ________.

A)New font
B)Change
C)Styles
D)Modify

Question 9

How many characters can an Excel password have?

A)12
B)48
C)156
D)255

Question 10

The cell styles gallery is on the ________ tab.

A)Page Layout
B)Data
C)Insert
D)Home

Question 11

Where are custom cell styles stored?

A)Template gallery
B)Themes gallery
C)Current workbook
D)They are not stored.

Question 12

Which of the following is not a good guideline for creating a template?

A)Include instructions
B)Enter all possible data.
C)Use consistent and appropriate formatting
D)Provide meaningful names to worksheets

Question 13

On which tab is the insert background feature located?

A)Page Layout
B)Formulas
C)Data
D)Home

Question 14

In Windows 10, Workbook templates save in this location by default.

A)C : \Users\username\Documents\Temp
B)C : \Users\username\Documents\Templates
C)C : \Users\username\Documents\Documents\Custom Office Templates
D)C : \Users\username\Documents\Custom

Question 15

A Background in a Worksheet looks like a ________.

A)graphic inserted in the top left corner
B)webpage with a graphic behind the data
C)graphic instead of the data on the worksheet
D)graphic display on top of the data

Question 16

On which tab will you find the Protect Sheet command?

A)Insert
B)Home
C)Review
D)Page Layout

Question 17

Which of the following is a partially completed workbook to be used as a model for a fully completed document?

A)Theme
B)Sub Procedure
C)Macro
D)Template

Question 18

Where is the New Cell Style command?

A)On the Styles Gallery
B)On the Themes gallery
C)On the Page Layout tab
D)On the Insert tab

Question 19

Where would you find the Template Gallery?

A)Insert tab
B)Page Layout tab
C)View tab
D)Backstage view

Question 20

On which tab is the Themes Gallery?

A)File
B)Insert
C)Page Layout
D)View

Question 21

Protected workbooks cannot be ________.

A)saved
B)printed
C)shared
D)edited

Question 22

What tool is best for automating the completion of repetitive tasks in Excel?

A)Macro
B)Template
C)Styles
D)Themes

Question 23

What do Miles and Rate represent in the following line of code? Function Mileage (Miles, Rate)

A)Comments
B)Function arguments.
C)Sub procedures
D)Keywords

Question 24

What would be the first line of the module for a function named Mileage with parameters Miles and Rate?

A)Function Mileage (Miles, Rate)
B)Sub Mileage (Miles, Rate)
C)Mileage (Miles, Rate)
D)End Function

Question 25

How do you insert a button to run a macro in a worksheet?

A)Add a Form Control button that runs the macro
B)Use the Button Builder on the Code group
C)The button has to be inserted on the Quick Access Toolbar.
D)You must use VBA code to do this.

Question 26

Where would you store macros that you'd like to use in any workbook?

A)A template
B)The Normal Document
C)The current workbook
D)The Personal Macro Workbook

Question 27

What is the file extension for a Macro-Enabled Workbook?

A).xlsb
B).xlsm
C).xltm
D).xlm

Question 28

What color are comments in VBA?

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

Question 29

What does the following line of code do to the selected cell? Selection.Font.Bold = False

A)Turns on bold formatting in the selected cell.
B)Replaces the contents of the selected cell with "False"
C)Turns off bold formatting in the selected cell.
D)Nothing, it contains a syntax error.

Question 30

What line of code do you to add at the beginning of a procedure if your worksheet (Sheet 2)is protected and your procedure alters the locked cell H4, if your password is ExcelIsFun?

A)Sheet 2.Password:= "ExcelIsFun"
B)Sheet 2.Unprotect Password:= "ExcelIsFun"
C)Sheet 1.Protect Password:= "ExcelIsFun"
D)Sheet 2.Unprotect Password:= ExcelIsFun

Question 31

Which of the following is not an option in the Trust Center?

A)Trusted Publishers
B)Trusted Locations
C)Trusted App Catalogs
D)Trusted Websites

Question 32

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

Question 33

How would you use a relative cell reference in a macro?

A)Click Use Relative References before you perform the commands.
B)Press F4 when selecting the range.
C)You must edit the macro in the VBA editor to change the reference type.
D)Hold the Shift key down while recording the macro.

Question 34

Where do you edit a macro?

A)Macro editor
B)Macros must be created from scratch.
C)VBA Editor
D)Notepad

Question 35

Where can you delete or run a macro?

A)VBA Editor
B)Macro dialog box
C)Insert tab
D)Backstage view

Question 36

The Macro Recorder is on which two tabs?

A)Developer and Formulas
B)View and Insert
C)View and Developer
D)Developer and Insert

Question 37

Which of the following is false about a VBA object?

A)Contains data
B)Contains code
C)Starts with '
D)Represents a Range

Question 38

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

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

Question 39

Which of the following is false about recording a macro?

A)Cell selections can be recorded as absolute references.
B)There is a pause button which allows you to remove mistakes as you record.
C)The recorder records everything you do.
D)It is a good idea to plan your steps and practice them before recording.

Question 40

Where do you find the Trust Center?

A)Developer tab
B)Excel Options
C)Insert tab
D)View tab

Question 41

A(n)________ is one that prevents users from editing the contents or formatting.

Question 42

By default the ________ uses absolute cell references when storing a macro.

Question 43

A(n)________ is macro code embedded in a worksheet which does something malicious.

Question 44

The ________ directs Excel to trust files in particular folders or created by certain users.

Question 45

If you want to place Confidential behind the data in a worksheet, you use a custom ________.

Question 46

Data and Model, Titles and Headings, and Good, Bad, and Neutral are examples of predefined Cell ________.

Question 47

View and edit macros in the ________.

Question 48

Select ________ in Backstage view to access the Template Gallery.

Question 49

Macro Buttons in worksheets are ________ buttons available on the Developer tab.

Question 50

A(n)________ is a set of instructions that execute a sequence of commands to automate repetitive tasks.

Question 51

The Themes Gallery is located on the ________ tab.

Question 52

________ is the file extension for Macro-Enabled Workbooks.

Question 53

A forgotten ________ in Excel is unrecoverable.

Question 54

Delete macros in the ________ dialog box.

Question 55

A(n)________ is a container in which VBA code is stored.

Question 56

________ files save with .xltx file extensions.

Question 57

Use the ________ function to trap errors when creating templates.

Question 58

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

Question 59

By default, ________ are locked.

Question 60

A password on a protected workbook can be ________ characters long.

Question 61

Start a custom function in a new ________.

Question 62

There are many templates available online.

Question 63

Formatting is limited in Templates.

Question 64

To make a comment line in VBA, start the line with ________.

Question 65

Good, Bad, and Neutral are predefined cell styles.

Question 66

Theme fonts may not be altered.

Question 67

Excel templates use the .xlsx file extension.

Question 68

All cells are unlocked, by default.

Question 69

If you forget your Excel password, you can recover it with your Microsoft account password.

Question 70

Cell Styles are on the Page Layout tab.

Question 71

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

Question 72

The background of an Excel Worksheet is always white.

Question 73

It is helpful to provide instructions in a template.

Question 74

Excel templates are downloadable from the Template Gallery on the Insert tab.

Question 75

A user can modify a cell style.

Question 76

Functions are edited in the ________.

Question 77

Protecting a workbook encrypts it for internet transmission.

Question 78

Themes alter formulas.

Question 79

A(n)________ performs actions on a workbook but doesn't necessarily return a specific value.

Question 80

The IFERROR function traps errors in Excel templates.