ITE 140 Exam 2

Lakukan tugas rumah & ujian kamu dengan baik sekarang menggunakan Quizwiz!

________ 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


Set pelajaran terkait

NET260.30 Linux Administration Chapter 5

View Set

Astronomy final exam review: learning questions and quiz questions

View Set

Small Business Management Chapter 5

View Set

ARE 5.0 - Construction & Evaluation - Questions

View Set

Chapter 12_Manegerial Accounting

View Set

Insurance Department and Commissioner

View Set

Chapter 28 - EMT Training - Face and Neck Injuries

View Set

Examen Informática II Preparatoria

View Set