Deck 12: Templates, styles, and Macros

Question 1

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

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

Answer 1

A

Question 2

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

Answer 2

C

Question 3

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

Answer 3

A

Question 4

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 5

On which tab will you find the Protect Sheet command?

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

Question 6

Where are custom cell styles stored?

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

Question 7

Which of the following are not included in themes?

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

Question 8

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 9

A cell style is a collection of ________.

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

Question 10

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 11

On which tab is the Themes Gallery?

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

Question 12

Where would you find the Template Gallery?

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

Question 13

On which tab is the insert background feature located?

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

Question 14

How many characters can an Excel password have?

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

Question 15

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 16

The cell styles gallery is on the ________ tab.

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

Question 17

What function traps errors in a custom template?

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

Question 18

What file extension do templates use?

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

Question 19

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

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

Question 20

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

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

Question 21

What color are comments in VBA?

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

Question 22

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

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

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

Where do you edit a macro?

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

Question 25

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 26

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 27

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 28

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 29

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 30

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

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

Question 31

Which of the following is false about a VBA object?

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

Question 32

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 33

Where can you delete or run a macro?

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

Question 34

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

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

Question 35

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 36

Where do you find the Trust Center?

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

Question 37

Protected workbooks cannot be ________.

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

Question 38

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 39

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 40

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 41

Use the ________ function to trap errors when creating templates.

Question 42

________ files save with .xltx file extensions.

Question 43

Delete macros in the ________ dialog box.

Question 44

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

Question 45

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

Question 46

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

Question 47

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

Question 48

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

Question 49

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

Question 50

Select ________ in Backstage view to access the Template Gallery.

Question 51

By default,________ are locked.

Question 52

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

Question 53

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

Question 54

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

Question 55

________ is the file extension for Macro-Enabled Workbooks.

Question 56

The Themes Gallery is located on the ________ tab.

Question 57

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

Question 58

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

Question 59

View and edit macros in the ________.

Question 60

A forgotten ________ in Excel is unrecoverable.

Question 61

The IFERROR function traps errors in Excel templates.

Question 62

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

Question 63

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

Question 64

The background of an Excel Worksheet is always white.

Question 65

Excel templates use the .xlsx file extension.

Question 66

All cells are unlocked,by default.

Question 67

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

Question 68

Start a custom function in a new ________.

Question 69

There are many templates available online.

Question 70

Cell Styles are on the Page Layout tab.

Question 71

Good,Bad,and Neutral are predefined cell styles.

Question 72

Functions are edited in the ________.

Question 73

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

Question 74

Theme fonts may not be altered.

Question 75

Formatting is limited in Templates.

Question 76

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

Question 77

Themes alter formulas.

Question 78

Protecting a workbook encrypts it for internet transmission.

Question 79

It is helpful to provide instructions in a template.

Question 80

A user can modify a cell style.