ITE 140 Exam 2
________ is the process of examining a worksheet for errors in formulas.
Auditing
CHAPTER 10 QUIZ
CHAPTER 10 QUIZ
CHAPTER 6 QUIZ
CHAPTER 6 QUIZ
CHAPTER 7 QUIZ
CHAPTER 7 QUIZ
CHAPTER 9 QUIZ
CHAPTER 9 QUIZ
The ________ function is used to join up to 255 strings of characters.
CONCATENATE
Apply styles to cells, such as Headings and Titles and Data and Model, by using the ________ command in the Styles group.
Cell Styles
A ________ is a graphic representation of data.
Chart
Common uses of ActiveX controls are ________.
Command buttons and lists
________ make(s) data easier to interpret by changing the data's appearance based on a condition.
Conditional formatting
To edit and check VBA code, you would click on 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 numbers in the column of records that match the conditions you specify.
DCOUNT
________ refers to facts about people, events, things, or ideas.
Data
A technique to improve accuracy when entering data in a worksheet by controlling the type of data or the values that can be entered is called ________.
Data validation
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
Each of the following is a rule for defining names except: ________.
Defined names can contain spaces.
When you add ActiveX controls to your worksheet, you are working in which of the following modes?
Design Mode
When you add and modify Active X controls to a worksheet, you activate which of the following?
Design Mode
ActiveX controls are found under which of the following tabs?
Developer
From the ________ ribbon tab, you can change the macro security settings in Excel.
Developer
Which of the following is not an 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 notification
The ________ command checks for common errors that occur when using formulas.
Error Checking
You add a button to the Quick Access Toolbar from the ________ dialog box.
Excel Options
When you open a template from the Custom Office Templates folder, it opens as a(n) ________.
Excel Workbook
Any macro setting changes made in Excel in the Macro Settings category apply to ________.
Excel only
A line chart can have only one line.
False
Both charts and SmartArt graphics depend on underlying data in a worksheet.
False
Comments affect the function of a macro.
False
Data stored in a format of rows and columns is referred to a field.
False
Database functions are identified by the letters DF.
False
Imported data must be free of duplicate data or it will result in an error.
False
In the PMT function, if the Type argument is not specified, it assumes the payment will be made at the beginning of each period.
False
Navigation on the ribbon is included in the recorded steps of a macro.
False
Standardization means designing a workbook so that individuals cannot enter data into cells.
False
Templates can only be used on the computer on which they are created.
False
The CONCATENATE function removes extra blank spaces from a string.
False
The HLOOKUP function looks up values in a table array arranged in vertical columns.
False
To convert a table to a range, you must first select the entire table.
False
To record a macro, a worksheet must be protected.
False
VLOOKUP function looks up values in a table array arranged as horizontal rows.
False
When borrowing money, the interest rate and number of periods is quoted in months.
False
When creating custom headers and footers, you can insert text but not pictures or the date.
False
You cannot type your own text in headers and footers.
False
You should plot both totals and details on the same chart.
False
________ 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
In a cell that contains a function, to copy the VALUE to another to cell—rather than the function—use the ________.
Format Painter command
When you start typing a formula, such as =SUM(B Excel will display the ________, which contains all of Excel's built in functions starting with the letter B.
Formula AutoComplete list
On the ribbon, on the Data tab, use commands in the ________ group to bring data from outside Excel into an Excel worksheet.
Get External Data
A method to find a specific value for a cell by adjusting the value of one other cell is ________.
Goal Seek
The ________ function looks up values in a table array arranged in horizontal rows.
HLOOKUP
________ 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 the beginning of a string of characters.
LEFT
The ________ function changes the case of the characters in a string making all characters lowercase.
LOWER
________ functions look up a value in a defined range of cells located in another part of the workbook to find a corresponding value.
Lookup
The ________ function extracts a series of characters from a text string given the location of the beginning character.
MID
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 Setup
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
________ cells are cells that are referred to by a formula in another cell.
Precedent
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 Excel feature that helps you choose a chart type by previewing suggested charts based on patterns in your data is called ________.
Recommended Charts
Records display in ________.
Rows
If a worksheet is slightly wider and taller than the normal margins, use ________ to keep all the information on one page.
Scale to Fit
In the Data Validation dialog box, you can create a ________ that will display when the cell is selected and that provides instructions to the person entering data.
ScreenTip
All of the following are methods to define a name for a cell or group of cells except: ________.
Select the range, click in the Formula bar, and then type the name.
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.
A ________ is a visual representation of information and ideas.
SmartArt graphic
________ is an arrangement of the arguments in a function.
Syntax
The ________ function removes extra blank spaces from a string of characters.
TRIM
________ are workbooks you use as the basis for other similar workbooks.
Templates
Use the ________ command to locate and resolve an error in a formula.
Trace Error
A command that displays arrows to indicate what cells affect the value of the cell that is selected is the ________.
Trace Precedents command
A SmartArt graphic is a visual representation of information and ideas.
True
A chart is a graphic representation of data.
True
A combination of keys to execute a macro or program is known as a shortcut key.
True
A data series is a group of related data points that are plotted in a chart.
True
A macro is an action or a set of actions with which you can automate tasks by grouping a series of commands into a single command.
True
A macro will record the actions to automate a task.
True
A module can contain several sub procedures.
True
An advantage to naming a range of cells is that you can use the name in a formula in other parts of your workbook.
True
An icon set can make data visually easier to interpret.
True
As you create a chart, you can make choices about what data to include.
True
Auditing is the process of examining a worksheet for errors in formulas.
True
Changing a cell's orientation is useful when you need to create a label in a narrow column.
True
Conditional formatting makes your data easier to interpret by changing the appearance of your data based on a condition.
True
Custom headers and footers can be added to worksheets.
True
Data can be imported from a text file into Excel.
True
Data in a worksheet is not always formatted in a way you can use it.
True
Data in an Access database is organized in a format of horizontal rows and vertical columns.
True
Data refers to facts about people, events, things, or ideas.
True
Data validation improves the accuracy of the person entering data into a worksheet.
True
Excel can format text data.
True
Excel includes a group of Formula Auditing features, which consists of tools and commands that help you to check a worksheet for errors.
True
Excel includes predesigned templates, for example for a budget.
True
Excel includes several tools to help you clean up data automatically.
True
Goal Seek is part of a suite of data tools used for What-If Analysis.
True
Goal Seek is useful to determine how much you can borrow to stay within a budget.
True
If you create a defined name and then decide that you no longer need it, you can delete the name and its associated range reference.
True
If you need to make changes to a template, you must first remove protection.
True
If you want to modify the way your macro performs, you can modify the actual code that was created by the macro.
True
In Excel, you can insert a table beside another table in the same worksheet, and then work with the data in each table separately.
True
In Excel, you can not only track and manage financial and numerical data, but you can also create simple databases.
True
In a Lookup formula, the defined range is referred to as the table array.
True
In an icon set, a green upward pointing arrow icon in a range of cells represents a higher value.
True
In the PMT function, the type argument indicates when the loan payment is due.
True
Microsoft Access is a database program that manages database files.
True
Organizations use standardization and protection when creating templates for commonly used forms.
True
Present value (Pv) represents the amount of the loan before any payments are made.
True
Pyramid is a category of SmartArt graphics that uses a series of pictures to show relationships.
True
Sparklines are tiny charts that fit within a cell and give a visual trend summary alongside your data.
True
The DCOUNT function returns the number of occurrences of a specified condition in a database.
True
The Error Checking command checks for common errors that occur in formulas.
True
The Get & Transform Data group of commands enables you to bring data into Excel from various sources.
True
The PMT function calculates the payment for a loan based on constant payments and at a constant interest rate.
True
The Process SmartArt graphic can show steps in a timeline.
True
The Text Pane is populated with placeholder text that you replace with your information.
True
The Watch Window displays the results of specified cells.
True
The Watch Window is useful to monitor cells in one part of a workbook while working on another part of the workbook.
True
The data in a table array, which can be numbers or text, must be sorted in ascending order.
True
The first step in using a lookup function is to define the range of cells that will serve as the table array.
True
To create sparklines, first select the data you want to plot.
True
To use Flash Fill to place data in a column, the data that you want to alter must be in the adjacent column.
True
Visual Basic for Applications (VBA) is the programming language you use to record a macro.
True
When a template design is complete, you should enable protection.
True
When getting external data into Excel, you can establish connections to the external data so that you can automatically update your Excel workbook from the original data.
True
When selecting a range of cells for a chart, it is sometimes necessary to include an empty cell in the selection.
True
When using Visual Basic for Applications, modules are automatically stored as a macro.
True
When you open a template from the Templates folder in Backstage view, a new copy of the template opens as a workbook.
True
When you select the chart type, the resulting chart will contain elements that you can delete or change.
True
With Goal Seek, you can work backward from the desired outcome to find the number necessary to achieve your goal.
True
You can change the values on the value axis to increase or decrease the variations among the numbers displayed.
True
You can create custom headers and footers to provide useful information about your worksheet.
True
You can record a macro or create a macro by using the Visual Basic Editor.
True
The ________ function changes the case of the characters in a string, making all characters uppercase.
UPPER
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
An Excel function that looks up values in a table array arranged as vertical columns is the ________ function.
VLOOKUP
Column charts present data graphically in ________ columns.
Vertical
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
Using various interest rates to determine the amount of loan payments is an example of using ________.
What-If Analysis
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 form easier to read.
a graphic object
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
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
Functions are predefined formulas that perform calculations by using specific 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
An instruction that enables a macro to perform multiple operations on a single object is called a VBA ________.
construct
A defined name provides a logical reference to ________.
data
A range of cells that shows how changing certain values in your formula affects the results of those formulas and that makes it easy to calculate multiple versions in one operation is a(n) ________.
data table
In Excel, you can create simple ________, which are collections of data related to a particular topic or purpose.
databases
A word or string of characters in Excel that represents a cell, a range of cells, a formula, or a constant value is called a ________.
defined name
A data table is useful for all of the following except for ________.
determining the Future value (Fv)
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 that 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(n) ________ to have the same number of cells in each row.
empty cell
When you convert data to a table, a table style is applied, and the headings display ________ arrows.
filter
An advantage to naming a range of cells is that you can use the name in a ________.
formula
After text is entered and formatted in your template, add ________ to the cells where you want the result of the calculations to display.
formulas
A ________ triangle in the upper left corner of a cell indicates that the formula in the cell is suspect for some reason and could be a potential error.
green
In VBA, comments added to code will display in ________.
green text
To bring data from other sources into Excel you ________ the data.
import
For lookup functions to work properly, the data in the table array must be sorted ________.
in ascending order
With the use of icon sets for conditional formatting, icons that make your data easier to interpret are placed ________ the cells.
inside
The amount charged for the use of borrowed money is called ________.
interest
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 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
A collection of VBA declarations, statements, and procedures stored together as one named unit is known as a ________.
module
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
Cells that are referred to by a formula in another cell are called ________.
precedent cells
The total amount that a series of future payment is worth is called the ________.
principal
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
In the Excel PMT function, the term used to indicate the interest rate for a loan is called ________.
rate
The Error Checking button displays as a ________.
red square
Excel's Formula Auditing features can show ________ between cells and formulas to ensure that formulas are logical and correct and also to resolve error messages.
relationships
An organization chart depicts ________ within an organization.
reporting relationships
The macro recorder records all the steps required to complete the actions you want your macro to perform except for navigation on the ________.
ribbon
The ________ is the range of numbers in the data series and that controls the minimum, maximum, and incremental values on the value axis.
scale
The location within which a defined name is recognized without qualification is referred to as the ________.
scope
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
To delete a box from a SmartArt organization chart, a ________ border must display around the box.
solid line
By having two tables side-by-side in the same worksheet, you can ________ similar sets of data to make comparisons.
sort
If you want all of 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
In a lookup formula, the defined range is referred to as the ________.
table array
To combine or separate data, change case, and apply formatting to a string of characters, use a ________.
text function
Custom headers and footers provide ________ sections where you can type your own text or insert header and footer elements.
three
Sparklines are ________.
tiny charts that fit within a cell and give a visual trend summary alongside your data
When you create a chart, you must first decide if you are going to plot values representing ________.
totals OR details
An indicator that shows the relationship between the active cell and its related cell is called a(n) ________.
tracer arrow
A ________ is a graphic representation of trends in a data series.
trendline
The criteria range for the DAVERAGE function must consist of at least ________ vertical cell(s).
two
To see how different interest rates and different payment periods will affect a monthly payment, use a ________.
two-variable data table
In order for individuals completing your form to type their data into designated cells, the cells must be ________.
unlocked
Defined names can contain ________.
uppercase and lowercase letters
A ________ is a list of values that are acceptable for a range of cells.
validation list
The shape or color of icons in an icon set indicates the ________ in the cells relative to all other adjacent cells formatted using the same condition.
values
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 the Backstage view, it opens as a(n) ________.
workbook
The Future value (Fv) at the end of the time period in an Excel function is usually ________ for loans.
zero
