Filters
Question type
Study Flashcards

The Themes Gallery is located on the ________ tab.

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

Keywords are words or symbols that are reserved for specific actions in VBA.

Correct Answer

verifed

verified

True

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

Correct Answer

verifed

verified

Select ________ in Backstage view to access the Template Gallery.

Correct Answer

verifed

verified

New

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.

Correct Answer

verifed

verified

The IFERROR function traps errors in Excel templates.

Correct Answer

verifed

verified

Match each of the following concepts to its best description:

Premises
Absolute Reference
Personal Macro Workbook
VBA Editor
Macro
Macro Recorder
Responses
Automation for a series of repetitive tasks
Default cell reference type in macros
Stores macros to be used on all workbooks
Tool that stores all actions to create a macro
Tool for modifying a macro

Correct Answer

Absolute Reference
Personal Macro Workbook
VBA Editor
Macro
Macro Recorder

Cell Styles are on the Page Layout tab.

Correct Answer

verifed

verified

Trusted locations are websites where you download templates.

Correct Answer

verifed

verified

Functions are edited in the ________.

Correct Answer

verifed

verified

VBA editor...

View Answer

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

Correct Answer

verifed

verified

A forgotten ________ in Excel is unrecoverable.

Correct Answer

verifed

verified

On which tab will you find the Protect Sheet command?


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

Correct Answer

verifed

verified

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


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

Correct Answer

verifed

verified

Good,Bad,and Neutral are predefined cell styles.

Correct Answer

verifed

verified

The cell styles gallery is on the ________ tab.


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

Correct Answer

verifed

verified

Themes alter formulas.

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

A

Showing 1 - 20 of 97

Related Exams

Exam 1

Introduction to Excel

100 Questions

Exam 2

Formulas and Functions

100 Questions

Exam 3

Charts

100 Questions

Exam 4

Datasets and Tables

100 Questions

Exam 5

Subtotals, Pivot-tables, and Pivot-charts

100 Questions

Exam 6

What-If Analysis

100 Questions

Exam 7

Specialized Functions

100 Questions

Exam 8

Statistical Functions

100 Questions

Exam 9

Multiple-Sheet Workbook Management

98 Questions

Exam 10

Imports, xml, and Power Add-Ins

95 Questions

Exam 11

Collaboration and Workbook Distribution

96 Questions

Exam 13

Office 2016 Common Features

100 Questions

Show Answer