Final exam review

Ace your homework & exams now with Quizwiz!

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


Related study sets

Study questions (LAB 8) measurement of arterial blood pressure

View Set

24. Probability of committing type I error and how to avoid it...

View Set

AP Bio Cellular respiration and Photosynthesis PT.2

View Set

Unit 12 Basic Electricity and Magnetism

View Set

Introduction to Behavioral Health Nursing

View Set

English 4 Sound and Structure in Poems by Dylan Thomas and W. B. Yeats

View Set

Heart failure - medical management

View Set

Ch3 Attitudes and job Satisfaction

View Set