Final exam review
To add a shape to a lower level of an organization chart, right-click the shape, click Add Shape, and then click _________.
Add Shape Below
The action that causes a macro to run, which may include a combination of keystrokes and the click of a button on the Quick Access Toolbar is called _________.
An event
You add a button to the Quick Access Toolbar from the ______ dialog box.
Backstage view
An area to position fields that you want to display as columns in the PivotTable is called _________.
COLUMNS area
The ______ function is used to join uptimes to 255 strings of characters.
CONCATENATE
A ______ is a graphic representation of data.
Chart
Common uses of Active controls are __________.
Command buttons, lists, and dialog boxes
_________ makes data easier to interpret by changing the data's appearance based on a condition.
Conditionally formatting
To edit and check VBA code, you would click on the View Code from the ________.
Controls group
When you click the _______ button, the filtering arrows are removed from the cells, but the color and formatting of the table style remain.
Convert to Range
The __________ function counts the cells containing number in the column of records that match the conditions you specify.
DCOUNT
A method of incorporating data from multiple, related tables into an Excel worksheet is called a ______.
Data Model
A _______ can import data from and Excel workbook, from a Microsoft Access database, or from an external source such as a corporate database, a public feed, or an analysis service.
Data model
In Excel, you can create simple _______, which are collections of data related to a particular topic or purpose.
Databases
When you add ActiveX controls to your worksheet, you are working in which of the following modes?
Design Mode
When you add and modify ActiveX controls to a worksheet, you activate which of the following?
Design Mode
ActiveX controls are found under which of the following tabs?
Developer
Which of the following is NOT and argument in the majority of database functions?
Dialog
To approve or block files containing macros, your macro security level should be set to ________.
Disable all macros with notifications
When you open a template from the Custom Office Templates folder, it opens as a __________.
Excel Workbook
Any macro setting changes made in Excel in the Macro Settings category apply to _________.
Excel only
The _______ is an area where you can position fields to use for filtering the PivotTable and thereby enabling you to display a subset of the data in the PivotTable report.
FILTERS area
Which of the following is a button on a PivotChart with an arrow to choose a filter, and thus change the data that is displayed in the chart?
Field button
__________ are arrows that display in the column titles of Excel data and that enable you to sort and filter the data when it is converted to a table.
Filtering controls
To make sorting and filtering easier, you can separate data into separate fields by using _______.
Flash Fill
On the ribbon, on the data tab, use command in the ______ group to bring data from outside Excel into an Excel worksheet.
Get External Data
________ are sets of three, four, or five small graphic images that make your data visually easier to interpret.
Icon sets
The _______ function returns the specified number of characters from beginning of a string of characters.
LEFT
The ________ function changes the case of the characters in a string making all characters lowercase.
LOWER
The ______ function extracts a series of characters from a text string given the location of the beginning character.
MID
When getting external data from Microsoft Access, in the Select Table dialog box, select the "enable selection of multiple tables" check box, and then click the ________ to select all of the tables in the database.
Name
When referring to an object in a program, use the ________ field.
Name
The _________ function will capitalize the first letter of each word.
PROPER
To center a page horizontally, use the Margins tab in the __________ dialog box.
Page Set up
A location where you can store macros that you want to be able to use in other workbooks is the ________
Personal Macro Workbook
You would choose which of the following workbooks to save a macro that is used in other workbooks?
Personal Macro Workbook
A chart that illustrates the relationship of each part to a whole is called a _________.
Pie chart
When you import data from Microsoft Access to a PivotTable report, the _______ placeholder displays on the left side of the worksheet and PivotTable fields pane displays on the right.
PivotTable
Which of the following is an interactive report that summarizes and helps analyze large amounts of data?
PivotTable
The ______ is a window that lists all the fields from the source data for us in a PivotTable and provides an areas in which you can rearrange the fields in the PivotTable.
PivotTable Fields pane
When you import data from Microsoft Access to a PivotTable report, the _____ displays to the right of the worksheet.
PivotTable Fields pane
Which of the following is a report that is useful when you want to analyze totals, such as when you have a long list of numbers to sum and you want to compare several facts about each total?
PivotTable Report
You can apply a _______ to the entire PivotTable report.
PivotTable style
Which of the following SmartArt graphic categories would be best to show a timeline?
Process
________ prevents anyone from changing a workbook.
Protection
The ______ function returns the specified number of characters from the end of a string of characters.
RIGHT
An area to position fields that you want to display as rows in the PivotTable reports is called the _______.
ROWS area
By default, when a non-numeric field is added to a PivotTable, it is placed in the ______ area.
ROWS area
In the PivotTable field section, you can arrange existing fields by using which of the following areas in the layout section?
ROWS area
An excel feature that helps you choose a chart type by previewing suggested charts based on patterns in your data is called ____________.
Recommended charts
If a worksheet is slightly wider and taller than the normal margins, use ______ to keep all the information on one page.
Scale to Fit
Which of the following statements is NOT true about side-by-side tables?
Side-by-Side tables must have the same number of rows and columns.
______ are filtering controls with buttons that enable you to drill down through large amounts of data.
Slicers
A _____ is visual representation of information and ideas.
SmartArt Graphic
To delete a box from a SmartArt organization chart, a _______ border must display around the box.
Solid line
The ______ function removes extra blank spaces from a string of characters.
TRIM
__________ are workbooks you use as the basis for other similar workbooks.
Templates
To combine or separate data, change case, and apply formatting to a string of characters, use a ________.
Text function
When you create a chart, you must first decide if you are going to plot values representing ______.
Totals OR Details
The ________ function changes the case of the characters in a string, making all characters uppercase.
UPPER
An area to position fields that contain data that is summarized in a PivotTable or PivotChart is called the _______.
VALUES area
When a numeric field is added to a PivotTable, it is placed in the _______ area of the PivotTable field list.
VALUES area
Which of the following areas of a PivotTable field list enables you to display average values?
VALUES area
A _____ is an instruction that enables the macro to perform multiple operations on a single object.
VBA construct
The word "with" denotes the beginning of a ____, an instruction that enables the macro to perform multiple operations on a single object.
VBA construct
The window where you can view and edit the module containing the Visual Basic Code is the _______ Window.
Visual Basic Editor
Macros are recorded in the ________ programming language, which you can use to write computer programs within the Microsoft Windows environment.
Visual Basic for Applications
A field that is being removed from the PivotTable report is indicated by a(n) attached to the pointer as you drag ___________.
X
In a database, _______ is a vertical column that stores information that describes a record.
a field
A worksheet or Excel object containing fields and controls that enable you to easily enter or edit data is __________.
a form
An ActiveX control is _______, such as a check box or button that is placed on a form to display or enter data, perform an action, or make a from easier to read.
a graphic object
When naming a macro, the first character of the macro name must be _________.
a letter
A named sequence of statements that performs a task is called _________.
a procedure
A unit of computer code that performs an action is called _______.
a procedure
A set of instructions that accomplish a specific task is called _________.
a sub procedure
Information stored in rows and columns is referred to as _______.
a table
Before working with a macro, you must first ________.
add the developer tab to the ribbon
By using a digital signature, you confirm that the document or macro originated from the signer and has not been ______.
altered
Within VBA, you can write a procedure into your form that will insert __________.
an ActiveX control
When coding in VBA, comments are preceded by ________.
an apostrophe
Functions are predefined formulas that perform calculations by using values, called _______.
arguments
When you assign a shortcut key to a macro, it will take precedence over the shortcut keys that are _________.
built into Excel
the entire chart with all of its elements is called the _________.
chart area
Objects that make up a chart are called __________.
chart elements
Charts can be placed on a separate sheet called a ______.
chart sheet
To make comparisons among related data, use a _______ chart.
column
A PivotTable report _______ large amounts of data so you can analyze related totals.
combines and compares
An instruction that enables a macro to perform multiple operations on a single object is called a VBA ________.
construct
________ refers to facts about people, events, things, or ideas.
data
The letter D at the beginning of a function identifies to Excel that a _______ range will be used in the formula.
database
If you make an error when entering code and need to correct the error, you can click the ________.
debug button
From the ____ ribbon tab, you can change the macro security settings in Excel.
developer
An electronic, encryption-based, secure stamp of authentication on a macro or document is called a ______.
digital signature
If you share macros with others, you can certify them with a _________.
digital signature
A chart is inserted into the same worksheet that contains the data used to create the chart is called ________.
embedded.
When selecting the range for a line chart, you may need to include a _______ to have the same number of cells in each row.
empty cell
In Microsoft Access, each column is called a _________.
field
In a PivotTable, a single piece of information for every record is called a ________.
field
A PivotChart displays _________ that you can click to choose a filter and change the data displayed in the chart.
field buttons
Excel uses the column titles as the ________ for the categories of data.
field names
To limit the display of data to only a specific information is called ______.
filter
When you convert data to a table, a table style is applied, and the headings display ________ arrows.
filter
You can limit the display of data to specific information by using _______.
filtering
After text is entered and formatted in your template, add ______ to the cells where you want the result of the calculations to display.
formulas
Templates can have built-in _______ display the results of calculations based on the data that is entered into the template.
formulas
In VBA, comments added to code will display in _______.
green text
To print all the worksheets in a workbook at the same time, you can either _________ the worksheets, or under Print Settings, select Print Entire Workbook.
group
To bring data from other sources into Excel you ______ the data.
import
With the use of icon sets for conditionally formatting, icons that make your data easier to interpret are placed _______ the cells.
inside
Column and row titles that describe the values in the column or row are known as ________.
labels
When creating a column chart, selecting ________ for the data helps the reader understand the chart.
labels
The area to rearrange and reposition fields in the PivotTable is called the __________.
layout section
The text pane displays to the _______ of the SmartArt diagram
left
The key that defines the colors assigned to categories in a chart is called a(n) _________.
legend
To display trends over time, use a _____ chart.
line
On the categorized tab, the same properties are listed, but they are organized by __________ groups.
logical
Unauthorized macro code is called a ________.
macro virus
A collection of VBA declarations, statements, and procedures stored together as one named unit is known as a _______.
module
By using a PivotTable, you can show that same data in a table in ______.
more than one arrangement
When you protect a worksheet, you can add an optional ______ to prevent someone from disabling a worksheet's protection.
password
The text pane includes _____ in which you can type text into a SmartArt graphic.
placeholders
The area bounded by the axes, including all the data series is called __________.
plot area
In Microsoft Access, the field used to uniquely identify a record is called a __________.
primary key
A module consists of _________, which are units of computer code that perform some type of action.
procedures
If you need to make changes to a template after it is protected, you must first remove the __________.
protection
To prevent others from altering the formulas or changing other template components, you should use ______.
protection
If you try to enter data in a protected cell, a message displays informing you that the cel is protected and therefore ________.
read-only
In Microsoft Access, each row is called a __________.
record
If you change the underlying data on which a PivotTable report is based, you must also ________ or update the PivotTable to reflect the new data.
refresh
When you import data from Microsoft Access to Excel, the resulting association between tables of data that share a common field is called a ________.
relationship
An organization chart depicts ______ within an organization.
reporting relationships
The macro recorder records all the steps requires to complete the actions you want your macro to perform except for navigation on the ________.
ribbon
Records display in ________.
rows
The ______ is the range of numbers in the data series and that controls the minimum, maximum, and incremental values on the value axis.
scale
A _______ is an XML file that contains the rules for what can and cannot reside in an XML data file.
schema
A group of related data plotted in a chart is called a data ________.
series
A function key or key combination, such as F5 or Ctrl + R, that carries out a menu command is called a ______.
shortcut key
A slicer includes a _________ that indicated the category of the slicer items.
slicer header
By having two tables side-by-side in the same worksheet, you can _______ similar sets of data to make comparisons.
sort
The data for a PivotTable formatted in columns and rows is called _______.
source data
if you want all the forms within an organization to have a uniform appearance and have the data organized in the same manner, you should use ____________.
standardization
The two main reasons for creating templates for commonly used forms in an organization are ________.
standardization and protection
The default calculation in a PivotTable Report is to ________ the numeric data.
sum
________ is an arrangement of the arguments in a function.
syntax
Custom headers and footers provide __________ sections where you can type your own text or insert header and footer elements.
three
Sparklines are. ________.
tiny charts the fit within a cell and give a visual trend summary alongside your data.
A ____ is a graphic representation of trends in a data series.
trendline
The criteria range fro the DAVERAGE function must consist of at least _______ vertical cell(s).
two
In order for individuals completing your form to type their data into designated cells, the cells must be ____________.
unlocked
The shape or color of icons in an Icon Set indicated the _________ in the cells relative to all other adjacent cells formatted using the same condition.
values
Column charts present data graphically in _________ columns.
vertical
The select locked cells option enables you to click the locked cell and _______ the formulas.
view
Macros can be performed with a single mouse click, a keyboard, shortcut, or __________.
when a workbook is opened.
When you open a template from the New tab in Backstage View, it opens as a ________.
workbook
