Excel Chapter 6: Exam, ITSW 1304 Excel Spreadsheet Ch. 5, ITSW 1304 Excel Spreadsheet Ch. 4, ITSW 1304 Excel Spreadsheet Ch. 3, ITSW 1304 Excel Spreadsheet Ch. 2, ITSW 1304 Excel Spreadsheet Ch. 1

If a cell"s width is too narrow to properly display the numeric contents of the cell, Excel displays a series of _______ symbols.

#

Absolute cell references are indicated by using what symbol in the cell address?

$

Which is the Excel operator for multiplication?

*

You can save an Excel file as a text file with which of the following file extensions?

.txt

By default, Excel 2013 files are saved in the native Microsoft Excel Workbook file format with the following file extension:

.xlsx

Which is the Excel operator for division?

/

Freeze Panes

A command to set column and row headings so that they remain on the screen while scrolling to other parts of the worksheet

To add a shape to a lower level of an organization chart, click Add Shape, and then click:

Add Shape Below.

Record

All of the categories of data pertaining to a person, place, thing, event, or idea

Scaling adjusts the width of a column to fit the widest cell contents found in the column.

False

The only kinds os values that can be entered into a cell are text values and number values.

False

When the Accounting Number Format is applied, a negative number displays with a negative sign, such a s-5 or -6.

False

You must delete the current value in a cell before you can begin entering a new value.

False

CSV file (comma separated values)

Files type in Excel that saves the file with a comma between each cell

________ displays only the rows that meet the criteria or conditions you specify to limit which records are included in the results.

Filtering

The PMT function belongs in the ________ functions category. Statistical Engineering Financial Logical

Financial

Using ____________ searches the spreadsheet for one value and replaces it with another.

Find and replace

Use _________ to split data from two or more cells or to combine data from two cells.

Flash Fill

To quickly locate specific text, formatting, or type of information within a workbook, use the Find command.

T

Using the Advanced command disables the AutoFilter command and removes the AutoFilter arrow from the column headings.

T

When using compound criteria on the same row, all the conditions must be met for the records to be included in the results.

T

When you create a custom list, the list remains available for all workbooks that you use in Excel.

T

You can create your own themes, cell styles, and table styles in Excel.

T

You can customize your table by creating and applying a custom table style of your own design.

T

You would use a wildcard character to search a field when you are uncertain of the exact value for which you are searching.

T

Query

Term that refers to asking a question about the data in a database

Hyperlinks can be attached to which of the following items?

Text and graphics

All Excel formulas begin with the equal sign (=).

True

An Excel function that looks up values in a table array arranged as vertical columns is the ________ function. SUM PMT HLOOKUP VLOOKUP

VLOOKUP

A __________ is formatted as a pattern of uniformly spaced horizontal rows and vertical columns.

Worksheet

The individual pages of an Excel document are called

Worksheets

Which is the Excel operator for exponentiation?

^

The use of two or more criteria on the same row, it is known as a(n):

compound criteria.

Using ____________ allows a cell to change appearance based on criteria.

conditional formatting

To apply complex criteria to a single column, use a(n):

custom filter.

A __________ provides a visual cue about the value of a cell relative to other cells.

data bar

Each pie slice displayed on a pie chart is an example of a:

data marker

A ___________ is a value that originates in a worksheet cell and is represented in a chart.

data point

A data marker, such as a column, dot, or pie slice on a chart, represents a single:

data point

Charted values that originate in a worksheet are called:

data points

A group of related data plotted in a chart is called a:

data series

In an Excel chart, a ___________ is made up of related data points.

data series

On a pie chart, the _______________ determines the size of each pie slice.

data series

A(n) ________ is a range of cells that shows how changing certain values in your formula affects the results of the formulas. row array column data table

data table

An organized collection of facts related to a specific topic is known as a:

database

A defined name provides a logical reference to: date. functions. tables. formulas.

date.

Exploding a slice of a pie chart causes it to completely disappear from the chart.

false

Goal Seek is a method to find a specific value for a cell by adjusting the value of one other cells.

false

If you click Ignore Error, the error is NOT marked to be ignored for each consecutive check.

false

If you need to make changes to a template, it is not necessary to remove protection.

false

In Excel, you can move from one worksheet to another by clicking the data bar.

false

In the Error Checking rules options, all but the next to last rule are selected by default.

false

Line charts MUST consist of only one line.

false

New data cannot be inserted into a named range.

false

New shapes cannot be added to a SmartArt graphic.

false

Once you have created a chart, it is not possible to change the range of data that is displayed.

false

Resetting ignored errors will not reset all errors in all worksheets in the active workbook.

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 COUNTIF function takes three arguments.

false

The Goal Seek command can be found on the Data tab, in the Get External Data group.

false

The MEDIAN function adds a group of values and then divides the sum by the number of items in the group.

false

The cell reference M$10 can be used as a defined name.

false

The data in an Excel table can only be sorted into ascending order.

false

The order of operations used in Excel says that consecutive operators with the same level of precedence are done from right to left.

false

Time is displayed along the y-axis on a line chart.

false

To identify which slice of pie corresponds to which set of data points, look at the value axis.

false

To select all the columns that represent a data series in a column chart, you must click on each column individually.

false

To stay within your budget, an alternative to borrowing less money would be to decrease the number of years of payment.

false

When borrowing money, the interest rate is usually quoted per month.

false

When writing a formula in Excel, use quotation marks to specify the order in which the operations should occur.

false

Worksheets must be formatted one at a time.

false

You cannot change a defined name.

false

You cannot explode all the pie slices in a pie chart.

false

You cannot use a picture as the fill for the chart area of a line chart.

false

You should plot both totals and details on the same chart.

false

A ________ is a single piece of information that is stored in every record within each table column.

field

The first step in adding subtotals to a group or list is to sort the data by the ________ for which you want to create a subtotal.

field

The small black square in the lower right corner of a selected cell is called the:

fill handle

You would ____________ a table if you wanted to display only data that matches specific criteria.

filter

The process of specifying the appearance of cells and the overall layout of a worksheet is ca;;ed:

formatting

The result of a formula displays in the active cell, and the ____________ itself displays in the Formula Bar.

formula

An advantage to naming a range of cells is that you can use the name in a: table array. data table. formula. lookup table.

formula.

Templates can have built-in ________ for performing calculations based on the data you enter.

formulas

A prewritten formula known as a (n) _________ looks at one or more values, performs an operation, and returns a value.

function

A ________ triangle in the upper left corner of a cell indicates that the formula in the cell is suspect for some reason. red green blue orange

green

The ________ refers to the location where the name is recognized without qualification. scope of a name cell range formula table array

scope of a name

The COUNTIF function takes two arguments:

the range of cells to check and the criteria

A predesigned set of colors, fonts, lines, and fill effects that look good together and which can be applied across all Office 2013 applications is called a:

theme.

Sparklines are:

tiny charts that fit within a cell.

When you create a chart, you must first decide if you are going to plot values representing:

totals OR details.

A 3D image appears to have length, width and depth.

true

A SmartArt graphic is a visual representation of information and ideas.

true

A data series is a group of related data.

true

A function is a predefined formula.

true

A pie chart can only be based on one data series.

true

A pie chart must be limited to no more than seven categories.

true

A value or expression that can be evaluated as true or false is called a logical test.

true

Absolute cell references are indicated by placing the dollar sign ($) in front of the row and column indicators.

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 organization chart depicts reporting relationships within an organization.

true

As you type in the Text Pane, the text appears simultaneously in the SmartArt graphic.

true

Changing values in cells to see how those changes affect values calculated by formulas in other cells is called doing a what-if analysis.

true

Charts and diagrams communicate data visually.

true

Data tables are used to view and compare the results of different operations.

true

Data tables make it easy to calculate multiple versions in one operation.

true

Data validation improves accuracy.

true

Dependent tracer arrows are red when showing a cell that contains an error.

true

Excel assigns a serial number to each date entered, which enables dates to be treated the same as other numbers in the worksheet.

true

Excel enables you to delete the formatting of a cell without deleting the contents of the cell.

true

Excel enables you to put the category names directly on the pie slices, eliminating the need for a legend.

true

Excel includes predesigned templates.

true

Excel's NOW function returns the date and time, which it retrieves from the computer's clock and calendar.

true

Excel's Print Tiles command enables you to specify rows and columns that will repeat on each printed page.

true

Excel's Shrink to Fit command enables you to stretch or shrink the width and/or height of printed output I order to fit the output on a specific number of pages.

true

Formula AutoComplete displays the names of functions that begin with the letter or letters you have typed in after the equal sign (=).

true

Goal Seek can be used to determine how much you can borrow to stay within your budget.

true

Goal Seek is a data tool used for What-If Analysis.

true

Goal Seek is an example of a what-of analysis tool.

true

High Point, Low Point, and Last Point markers can be used to further emphasize the visual story that sparklines depict.

true

If a value is changed in a cell, Excel recalculates all formulas that reference that cell.

true

If the copied data contains a formula, this formula overwrites the data in the calculated column.

true

In Excel, data can be moved from one area to another using the mouse and a technique called drag and drop.

true

In a Lookup function, the formula refers to the defined range as the table array.

true

In the PMT function, a minus sign is placed before the amount of the principal so that payments are shown as a positive value.

true

Like a spelling checker that checks for errors in data that you enter in cells, you can implement certain rules to check for errors in formulas.

true

Logical functions are used to test for specific conditions.

true

MIN and MAX are examples of statistical functions.

true

Naming cells has no effect on the displayed or underlying values.

true

Organizations use standardization and protection when creating templates for commonly used forms.

true

Payments on a loan are usually made monthly.

true

Preformatted SmartArt styles can be applied from the DESIGN tab.

true

Present value (Pv) represents the amount of the loan before any payments are made.

true

Sparklines give a visual trend summary alongside your data.

true

Text within a cell can be rotated to draw attention to the data.

true

The AutoFill feature will continue a series based on the values placed in two or more consecutive cells.

true

The AutoFill feature will duplicate a pattern of values that you set in the beginning cells.

true

The Error Checking command checks for common errors that occur in formulas.

true

The Excel comparison operator for "not equal to" is < >

true

The IF function returns one value if a logical test is false and a different value if the logical test is true.

true

The MEDIAN function finds the middle value from a group of values.

true

The PMT function calculates the payment for a loan based on constant payments and at a constant interest rate.

true

The data in an Excel table is managed independently from the other data in the worksheet.

true

The first step in using a lookup function is to define the range of cells that will serve as the table array.

true

The plot area and the chart area are the two background elements of an Excel chart.

true

The sizes of pie slices are automatically adjusted when the underlying data values are changed.

true

The target destination for data that has been cut or copied using the Clipboard is called the paste area

true

To apply an effect to shapes in an organization chart, you must hold Ctrl and click on all shapes individually to select them.

true

Under Paste Options you have the choice to paste the calculated values instead of the formulas.

true

Using conditional formatting enables you to have a cell formatted in different ways depending on the value stored in that cell.

true

When a new row is inserted in a named range, Excel adjusts formulas accordingly.

true

When a template design is complete, you should enable protection.

true

When creating a data table, the PMT function must be entered in the upper left corner of the range of data.true

true

When selecting a range of cells for a chart, it is sometimes necessary to include an empty cell in the selection.

true

When you open a template from the Templates folder in Backstage view, a new copy of the template opens as a workbook.

true

You can change the values on the value axis to increase or decrease the variations among the numbers displayed.

true

You can only have one watch per cell.

true

To determine a monthly interest rate, you must divide the annual interest rate by: four. twelve. two. six.

twelve

To determine the number of months to repay a loan, you must multiply the number of years by: six. four. two. twelve.

twelve

The defined range for a lookup formula must have at least ________ rows or columns. three two four one

two

The Formula Bar displays the data known as the:

underlying value

To create a form for others to complete, you should first ________ the cells that will need to be filled in and then protect the workbook.

unlock

When creating a data table, you enter the PMT function in the ________ of your range of data. lower right corner upper right corner lower left corner upper left corner

upper left corner

When pasting a range of cells you only need to click or select the ______________ of the paste area.

upper left corner

A ________ is a list of values that are acceptable for a range of cells. data table validation list cell range table array

validation list

On a line chart, the y-axis is also known as the:

value axis

Column charts present data graphically in ________ columns.

vertical

If the Select locked cells option is selected in the Protect Sheet dialog box, the user can click the locked cells and ________ the formulas.

view

A function such as NOW that is updated each time a workbook is opened is said to be:

volatile

Goal seek is an example of a ____ tool.

what-if-analysis

Performing a ____ involves changing the value in a cell to see what effect it has on values in other cells that are calculated using that value.

what-if-analysis

When a template is opened from the New tab in the Backstage view, it is opened as a(n):

workbook

On a line chart, the area that identifies the categories of data is called the:

x-axis

On a line chart, the range of numbers for the data points are displayed on the:

y-axis

Loans are typically made for a period of: days. months. years. quarters.

years

The Future value (Fv) at the end of the time period is usually ________ for loans. zero half the principal twice the principal the same as the principal

zero

An Excel document is called a

Workbook

An ascending sort refers to text that is sorted alphabetically from:

A to Z.

Criteria and List ranges are a(n) ________ reference when defining a database area in a spreadsheet.

Absolute

The ___________ inserts a thousand comma separator when appropriate, inserts a fixed U.S. dollar sign aligned at the left edge of the cell, applies two decimal places, and provides space for negative numbers to be displayed inside of parentheses.,

Accounting number Format

By default, test values entered into a cell are right-justified.

False

COUNTIF is an example of a logical function.

False

Data that is displayed in a cell is called the underlying value.

False

Deleting the contents of a cell also removes the format that has been applied to the cell.

False

Each data point is represented in chart by a legend.

False

Excel does not provide a method to check the spelling in a worksheet.

False

Excel's Name Box identifies the worksheets in a workbook.

False

IF is an example of a statistical function.

False

In Excel, column headings are made up of a letter and a digit, such A2.

False

In Excel, numbers are used as column headings.

False

The use of two or more criteria on the same row is known as a:

compound criteria.

Match the following terms to their meanings: 1. Fund 2. Goal seek 3. Order of operations 4. What-if analysis 5. Major unit

1. A sum of money set aside for a specific purpose 2. finds the input needed in one cell to arrive at the desired result in another cell 3. mathematical rules that indicate in what order calculations are done 4. changing a value in one cell to see what affect it has on other cells 5. determines the spacing between the gridlines

Match the following terms to their meanings: 1. 3-D 2. Explode 3. Bevel 4. Enterprise fund 5. Formula AutoComplete

1. an image that appears to have length, width, and height 2. pulls a pie slice away from the other pie slices 3. shape effect to make edges of a shape appear curved or angled 4. municipal government fund that reports income and expenditures for services that charge a fee 5. list of functions that display after typing = and the beginning letter of a function name

Match the following terms to their meanings: 1. Value after increase 2. Percent for new value 3. percentage of rate increase 4. Rate 5. Base

1. base * percent for new value 2. base percent + percent of increase 3. percent by which one number increases over another number 4. Amount of increase/base 5. data starting point

Match the following terms to their meanings: 1. Data Marker 2. Data point 3. Data series 4. Chart sheet 5. Chart area

1. pie slice 2. a value that appears in the spreadsheet and is represented on the chart. 3. determine the size of each pie slice. 4. contains only a chart 5. The chart and all of its elements.

Match the following terms to their meanings: 1. Pie chart 2. Line chart 3. Category axis 4. Value axis 5. 3-D

1. shows the relationship of each part to a whole. 2. displays trends over time 3. x-axis on a line chart 4. y-axis on a line chart 5. three dimensional

An image that appears to have length, width, and depth is said to be:

3-D

The Excel operator for "less than" is:

<

The Excel operator for "not equal to" is:

< >

All Excel formulas begin with which symbol?

=

The Excel operator for "greater than or equal to" is:

>=

Cell Styles

A set of formatting characteristics you can apply to a cell

Field

A single piece of information that is stored with every record in a spreadsheet

Wildcard

A special character, such as the asterisk (*) used when searching for files or fields when you are uncertain of the exact value or to widen the search results

If you want every one of the comparison criteria that you specify to be true, you would use the:

And operator.

AutoComplete generates and extends a series of values based on the values of other cells.

False

The values that an Excel function uses to perform operations are called:

Arguments

To tile multiple worksheets on the screen use the ________ command.

Arrange All

________ is the process of examining a worksheet for errors in formulas. Tracing Auditing Segmenting Defining

Auditing

___________ generates and extends a series of values into adjacent cells based on the values of other cells.

Auto Fill

The ___________ feature fills in the remaining characters of a word if what is typed matches an existing entry in the column.

AutoComplete

To widen a column to fit the cell content of the widest cell in the column, use:

AutoFit

Excel"s __________ function adds all of its arguments then divides the sum by the number of arguments.

Average

If a column of data holds the letter grades for a class, the ________ function could be used to determine how many students had a grade of "A".

COUNTIF

The _________ function counts the number of cells within a range that meet a certain criteria.

COUNTIF

Which of the following file formats is commonly used to import data into a database program?

CSV

Which of the following types of files can be readily exchanged with various database programs?

CSV or comma separated values

Labels that display along the bottom of a chart to identify the category of the data are called: :

Category labels

A ___________ is created when a row and a column intersect.

Cell

Various styles, such as Headings and Titles, can be applied by using ________ in the Styles group. Conditional Formatting Merge Styles Format as Table Cell Styles

Cell Styles

_____________ are defined as sets of formatting characteristics, such as font size, font color, cell borders, and cell shading.

Cell styles

Hyperlink

Colored and underlined text that, when clicked, takes you to another location, such as the Web or an intranet

Values are evaluated using ____________ operators.

Comparison

Use a(n) ________ to apply complex criteria to a single column.

Custom filter

Which of the following is an example of a logical test?

D5>45

________ improves accuracy because it limits and controls the type of data an individual can enter into a form. Goal Seek Data protection Data validation What-If Analysis

Data validation

An Excel worksheet is made up of one or more workbooks.

False

Which of the following rules is NOT acceptable for defining names? The first character of the defined name must be a letter, an underscore, or a backslash. A defined name can be no longer than 255 characters. Defined names can be the same as a cell reference. Defined names can contain uppercase and lowercase letters.

Defined names can be the same as a cell reference.

The ________ command checks for common errors that occur in formulas. Hide Error Error Checking Trace Error Audit

Error Checking

Which of the following are some frequently and commonly used file formats for Excel?

Excel Template, Excel 97-2003 Workbook, CSV or tab delimited

When a template is opened from Windows File Explorer, it is opened as a(n):

Excel Workbook (*.xlsx)

A file developed by Microsoft that provides a visual image of a spreadsheet is a portable document format file.

F

A question mark (?) in a search criteria will allow you to search for multiple characters in the field.

F

Detail data does not refer to the subtotaled rows that are totaled and summarized.

F

When filtering by format and value using AutoFilter in Excel, each of the filter types are not mutually exclusive for the column, where you can use one filter at a time.

F

You can reduce the horizontal and vertical size of the printed data by changing the arrangement of the number of pages in a workbook.

F

Effects can be added to SmartArt diagrams from the ________ tab.

FORMAT

A line chart emphasizes the distinct values of each data point.

False

A relative cell reference refers to a cell by its fixed position within the worksheet and is not adjusted when the formula is copied.

False

AutoFit centers the worksheet on the page.

False

You can create a custom table style by clicking:

Format as Table.

Which of the following are the three types of filters you can create with AutoFilter?

Format, values, and criteria

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. table array Formula AutoComplete list defined name AutoFill

Formula AutoComplete list

In the ____________ you can enter a value or a formula or edit a value or formula in the active cell.

Formula Bar

To set column and row titles on the screen while you scroll, which of the following command(s) would you use?

Freeze Panes

Using _____________ enables you to select one or more rows or columns and lock them into place.

Freeze panes

A predefined formula is called a:

Function

When using the PMT function to calculate payments, which of the following is NOT a required argument? Future value (Fv) principal rate Nper

Future value (Fv

To move to a specific cell or range of cells in a large worksheet use the ________ command.

Go To

Which command would you use to move to cells that have special characteristics, are blank, or contain constants?

Go To Special

A method to find a specific value for a cell by adjusting the value of one other cell is: validation. protection. Goal Seek. lookup.

Goal Seek.

Excel's ____ finds the input needed in one cell for another cell to have a desired value.

Goal seek

The SmartArt organization chart is in the ________ category.

Hierarchy

The __________ function returns one value if a condition is met, and a different value if it not.

IF

When you borrow money, the amount charged to you is called: interest. principal. capital. Present value (Pv).

Interest

A series of rows that contain related data is known as a:

List

The defined table range will automatically display as the ________ range in the Advanced Filter dialog box.

List

________ functions look up a value in a defined range of cells located in another part of the workbook to find a corresponding value. Lookup Statistical Financial Logical

Lookup

Excel"s __________ function finds the largest value in a selected range of cells.

Max

Excel"s _____________ function finds the middle value in a range.

Median

Which Excel function would be used to find the middle value of a list of test scores?

Median

Excel"s _________ command creates one cell from the selected cells and centers the contents within the new cell.

Merge & Center

The Excel function __________ would be used to find the lowest score on a series of student test scores.

Min

If the file to which a hyperlink refers to is moved or renamed, or a webpage to which a hyperlink refers has a new address, which of the following do you need to do to the hyperlink to make it work correctly?

Modify the hyperlink to reflect the change

When you save a template on your own computer to the template folder, it will be available for future use from:

My templates.

Excel's __________ function retrieves the date and time from the computer's calendar and clock.

NOW

The ___________ displays the name of the selected cell, table, chart, or object.

Name Box

For the ________, only one of the two comparison criteria that you specify must be true.

Or comparison operator

Database

Organized collection of facts related to a specific topic

Themes can be found on the ________ tab in the themes group.

Page Layout

To center worksheet data horizontally and vertically on a page, use the ________________ dialog box.

Page Setup

If you want to copy only the value in a cell and not the formula, use: Paste Special. Paste. Paste Link. Format Painter.

Paste Special.

________ are cells that are referred to by a formula in another cell. Trace cells Dependent cells Related cells Precedent cells

Precedent cells

Which of the following SmartArt graphic categories would be used to show a timeline?

Process

________ prevents anyone from changing a workbook.

Protection

Using the ________ command, you can choose to save an Excel file in another file format.

Save As

Using _________ enables you to stretch or shrink the width, height, or both of printed output.

Scale to fit

____________ shrinks the width and height of the printed worksheet to fit a maximum number of pages.

Scaling

In the Data Validation dialog box, you can create a ________ that provides the user with instructions about what to do. defined name Screen Tip cell reference table array

Screen Tip

Which of the following is NOT a way to define a name for a cell or group of cells? Select the range, click in the Name box, and then type the name. Select the range, click in the Formula Bar, and then type the name. Select the range, click the Define Name button, and then type the name. Select the range, open Name Manager, click New, and then type the name.

Select the range, click in the Formula Bar, and then type the name.

A ________ is a visual representation of information and ideas that you can create by choosing from among many different layouts to communicate your message easily and effectively.

SmartArt graphic

To sort data on several criteria at once, use the ________, which enables you to sort by more than one column or row.

Sort dialog box

Which of the following is NOT a rule for defining names? Defined name can be no longer than 255 characters. First letter must be a letter, underscore, or backslash. Spaces are valid. The letters C or R cannot be defined as a name.

Spaces are valid.

The functions AVERAGE and MEDIAN are examples of ________ functions, which are useful when the user needs to analyze a group of measurements.

Statistical

The _________ function adds all of the numbers in a range of cells.

Sum

Which Excel function would be used to calculate the total points a student earned on a series of tests?

Sum

Defining data as a table prior to sorting the data is optional.

T

Excel worksheets and workbooks can be saved as Web pages, no matter how large or how many worksheets there are in a file.

T

If data within an Excel spreadsheet is not organized so that Excel can outline it automatically, you can create an outline manually.

T

If your worksheet is wider than one page, you will also want to repeat the row titles on each page when you print or view the spreadsheet.

T

It is not required to format the selected range in a spreadsheet as a table, it can be a table or a database.

T

The criteria range indicates how the displayed records in a spreadsheet are filtered.

T

The criteria range must have a row for the column headings and at least one row for the criteria.

T

Arrange All

Tiles all open worksheets on the screen

Why would you explode a slice on a pie chart?

To emphasize the slice to the person viewing the chart

In addition to the indicator in the upper left corner of the cell, you can use the ________ command to locate an error in a formula. Trace Error Fix Error Find Error Locate Error

Trace Error

Which of the following is NOT a type of sparkline?

Trend

A button that displays options related to the current task is referred to as being context sensitive.

True

A group of cells that Excel treats as a single unit is called a range.

True

A range can be made up of two or more nonadjacent areas on a worksheet.

True

Application-level buttons enable you to minimize, close, or restore the displayed workbook to its previous size.

True

Cell contents are either values or formulas.

True

Excel"s Formula Bar displays the underlying value of the active cell.

True

Number values are often called tablets.

True

Recommended Charts is a feature that displays a customized set of charts that, according to Excel"s calculations, will best fit your data based on the range of data that you select.

True

Scaling enables you to indicate the maximum number of pages to be used when printing a worksheet.

True

Text values usually are used to provide information about the numbers displayed in worksheet cells.

True

The box formed at the intersection of a row and a column is called a cell.

True

The cell of the worksheet that is ready to accept data is known as the active cell.

True

The first step in entering data by range is to select the desired range.

True

The point and click method is one way to enter a formula.

True

The result of a formula is displayed in a cell, and the underlying formula is displayed in the Formula Bar.

True

The terms worksheet and spreadsheet are interchangeable.

True

The word pixel is short for picture element.

True

To perform basic mathematical operations in Excel, use Arithmetic operators.

True

When Comma Style is applied, negative numbers display inside parentheses.

True

When printing a worksheet, you can change the orientation either on the Page Layout tab or in Pint Preview.

True

When you add or delete rows or columns in a worksheet, Excel automatically adjust all of the formulas, unless it has an absolute reference.

True

When you change a value in a cell, Excel automatically recalculates.

True

When you insert a new row, by default the new row uses the formatting of the row above.

True

You can select an element of a chart to format by using the Chart Elements button to the right of a selected chart.

True

If you have defined a two-column range of cells containing names and phone numbers, you would use the ________ function to match a name with a number. VLOOKUP HLOOKUP LOOKUP MATCH

VLOOKUP

Data table are NOT used to: view and compare results. calculate possible values for each argument. calculate multiple versions in one operation. determine the Future value (Fv).

View and compare results

The process of changing the values in cells to see how those changes affect the outcome of formulas on a worksheet is called: Validation. What-If Analysis. Lookup. Goal Seek.

What-If Analysis.

Using various interest rates to determine the amount of loan payments is called: What-If Analysis. Lookup. Validation. Protection.

What-If Analysis.

A group of items that come one aftet another in succession is called:

a series

A (n) ___________ refers to a cell by its fixed position in the worksheet.

absolute cell reference

The ________ area of a worksheet contains data or has contained data and does not include any empty cells.

active

Tracer arrows show the relationship between ________ cells. active and related active and reticent active and precedent active and dependent

active and related

The _________, when outlined in black, indicates it is ready to accept data.

active cell

Filtering actions are ________, each additional filter that you apply is based on the current filter.

additive

In the Name Manager dialog box, defined names are listed by: the order in which they were named. alphabetical order. reverse order in which they were named. length of the name with shortest first.

alphabetical order.

The percentage rate of increase is calculated by using this formula:

amount of increase/base

A red triangle in the upper right corner of a cell indicates that there is a(n): value. error. option. comment.

comment.

A hyperlink in a worksheet may take you to which of the following locations:

another location in the worksheet or the company intranet.

Excel uses _____________ to perform basic mathematical operations.

arithmetic operators

The ________ is used as a wildcard symbol when searching for criteria in an Excel spreadsheet.

asterisk (*)

A(n) ____ is a line that borders the chart plot area and serves as a frame of reference for measurement.

axis

When calculating the amount of increase, the ____ is the starting point for the data.

base

Value after increase is calculated by using this formula:

base * percent for new value

Percent for new value is calculated using this formula:

base + percent of increase

Applying the shape effect ____ causes the edges of a shape to appear to be curved or angled.

bevel

The Page Break Preview window shows where the page breaks by displaying:

blue dashed lines and the page number on the worksheet.

If you calculate payments that are too high for your budget, you might consider: borrowing less money. increasing the interest rate. decreasing the time period to repay the loan. borrowing more money.

borrowing less money.

On a line chart, the x-axis is also know as the:

category axis

Anything you type into a cell is referred to as:

cell content

A defined set of formatting characteristics, such as fonts, font sizes, number formats, cell borders, and cell shading is known as a(n):

cell style.

To make data easier to understand, use a __________________ instead of a table of numbers.

chart

In Excel, the ____ is made up of the chart and all its elements.

chart area

The entire chart with all of its elements is called the:

chart area.

Use the ____ button to add, remove, or change chart elements such as the chart title, the legend, and the data labels.

chart elements

When a chart is selected, three buttons display to the right, the first of which is the ____ button.

chart elements

Objects that make up a chart are called:

chart elements.

A workbook sheet that contains only a chart is called a(n):

chart sheet

Charts can be placed on a separate sheet called a:

chart sheet.

To make comparisons among related data, use a ________ chart.

column

Saving an Excel worksheet as a CSV file separates the cells of each row with:

commas.

A ________ is a word or string of characters in Excel that represents a cell, a range of cells, a formula, or a constant value. defined name cell range table array validation list

defined name

Subtotal rows that are totaled and summarized are referred to as ________ data.

detail

Changes made to the ___________ affect the overall totals on the Summary worksheet.

detail sheets

The data you see in a cell is called the:

displayed value

By default, Excel displays a chart as a(n) ________ object within the worksheet.

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

To ____ one or more slices on a pie chart means to pull the slice(s) away from the rest of the chart.

explode

If you calculate payments that are high for your budget, you might consider: decreasing the time period to repay the loan. borrowing more money. increasing the interest rate. extending the time period to repay the loan.

extending the time period to repay the loan.

Multiple sets of data can be pulled out or ________ from a filtered list and placed below the table of data.

extracted

An advanced filter that is used for copying selected rows to another part of the worksheet is called:

extracting.

You can copy the results of a filter to another area of your worksheet for comparison purposes: this action is known as:

extracting.

A one-variable data table will allow you to see how different interest rates and different payment periods will affect a monthly payment.

false

A pie chart must have a legend.

false

A relative cell reference refers to a cell by its fixed position in the worksheet.

false

A summary sheet provides a visual cue about the value of a cell in relationship to other cells.

false

A to Z indicates that a list will be sorted in descending order.

false

AVERAGE, SUM, and MEDIAN are examples of logical functions.

false

According to Excel's order of operations, addition and subtraction are done before exponentiation.

false

After a pie chart is created, it cannot be rotated.

false

All shapes in an organization chart must be the same color.

false

An error is indicated in a cell by a triangle that appears in the top right corner of the cell when an error is found.

false

An error value is the result of a formula that Excel can evaluate correctly.

false

By default, the plot area and the chart area are filled with different colors.

false

By using the Watch Window, you will need to repeatedly scroll or go to different parts of your work to inspect, audit, or confirm formula calculations and results in a large worksheet.

false

Charts and SmartArt graphics depend on underlying data in a worksheet.

false

Detail sheets display and summarize totals from other worksheets.

false

Each worksheet in a wordbook must have the same headers and footers.

false

Entering the year portion of a date as 40 will be interpreted as the ear 2040

false

Excel provides only one technique of changing the name of a worksheet

false

Excel's Paste Options gallery does not include Live Preview.

false

The Trace Error button will appear next to a cell where a formula error occurs and is identified by a ________. purple triangle green triangle red triangle blue triangle

green triangle

By including worksheets in a ___________ you can enter or edit data on them simultaneously.

group

Scaling reduces the ________ size of the printed data by a percentage or by the number of pages you specify.

horizontal and vertical

Clicking a ________ will take you to another location in the worksheet, another file location, a webpage on the intranet, or to your organization's Internet.

hyperlink

A text value is also referred to as a:

label

To create a column chart, you must first select the ________ data to be plotted.

labels

When you create a chart, Excel uses the column and row headings that describe the values as ________ for the data.

labels

The Text Pane displays to the ________ of the SmartArt diagram.

left

If there is only one line in a line chart, you should delete the:

legend

On an Excel chart, the ________ identifies the patterns or colors that are assigned to all the categories in the chart.

legend

One way to determine which slice of pie on a pie chart goes with which set of data is to look at the:

legend

The ___________ identifies patterns and colors assigned to categories in the chart.

legend

The key that defines the colors assigned to categories in a chart is called a(n):

legend

If you want to chart trends over time, you should use a ____ chart.

line

To display trends over time, use a ________ chart.

line

Functions that test for a specific condition are called _________ functions.

logical

IF is an example of a __________ function.

logical

A value or expression that can be evaluated as true or false is called a:

logical test

The first sort level is sometimes referred to as the:

major sort.

Fonts are associated with different themes and can be customized by:

mixing Colors and Fonts from any of the supplied themes.

If you want to see how different interest rates affect a monthly payment, you would use a: two-variable data table. table array. defined name. one-variable data table.

one-variable data table.

Cells that have external references to other workbooks are displayed in the Watch Window toolbar only when the other workbooks are: listed. closed. open. found.

open.

Before printing or distributing a large worksheet, the Preview option will allow you to see:

orientation and page breaks.

A ___________ is a portion of a worksheet window bound by, and separated from, other portions by vertical or horizontal bars.

pane

Excel displays various ____ on the right to enable you to format different chart elements.

panes

The portions of a worksheet bounded by and separated from other parts of the worksheet by horizontal and vertical lines are called:

panes

When you protect a worksheet, you may add an optional ________ to prevent someone from disabling the worksheet protection.

password

The action of placing cell contents that have been copied to the Clipboard is:

pasting

The ____ is the percent by which one number increases over another during a specified time frame.

percentage of rate increase

A _________ shows the relationship of each part of the data to the whole.

pie chart

Which type of chart would be the best to chart the number of votes each candidate received compared to the total number of votes cast?

pie chart

The Text Pane includes ________ in which text can be typed.

placeholders

The two background elements of an Excel chart are:

plot area and chart area

Cells referred to by a formula in another cell are called: dependent cells. Trace dependents. precedent cells. Trace precedents.

precedent cells

The initial amount of a loan also is called the: percentage. principal. rate. interest.

principal

You can share worksheets or workbooks with others by:

printing paper copies, sending the file electronically, or posting the file to the Web or a shared workspace.

All cells are locked by default, but the locking feature is only enabled when ________ is applied.

protection

To prevent others from changing the formulas and formatting of a worksheet, you should use:

protection

Two or more cells that Excel treats as a single unit called a:

range

In a cell that contains a formula, the __________________ visually indicates which workbook cells are included in a formula calculation.

range finder

In Excel, the interest percentage on a loan is called the: Future value (Fv). payment period. Present value (Pv). rate.

rate

If you try to enter data in a protected cell, a message appears informing you that the cell is protected and therefore:

read-only.

Which of the following describes all of the categories of data pertaining to one person, place, thing, event, or idea within a table row?

record

Within Excel, there are groups of Formula Auditing features that are useful in showing ________ in complex worksheets. precedents tracings dependents relationships

relationships

A cell address used in a formula using a(n) ___________ will be adjusted appropriately when the formula is copied to another cell.

relative cell reference

To gain a different view of a pie chart, you can ____ the chart within the 360 degrees of the circle.

rotate

The ________ is the range of numbers in the data series that controls the minimum, maximum, and incremental values on the value axis.

scale

By applying ________ to a worksheet, the data will be forced into a selected number of pages.

scaling

Dates can be treated as other numbers because Excel assigns a ___________ value to the date as it is entered.

serial

A ___________ identifies a worksheet in a workbook.

sheet tab

You can move from one worksheet to another by clicking the:

sheet tabs

The outline bar along the left side of a worksheet enables you to ________ levels of detail with a single mouse click.

show and hide

To delete a box from a SmartArt organization chart, you must display a ________ border.

solid line

To __________ a table means to arrange all of the data in a specific order.

sort

Tiny charts embedded in cells that show a visual trend alongside the data are called:

sparklines

If you want all of the forms within an organization to have a uniform appearance and the data organized in the same way, you should use:

standardization

Templates are commonly used to provide ________ of data.

standardization and protection

The current cell mode, the page number, and the view and zoom button display on the:

status bar

To enhance the appearance of sparklines, use:

styles

To help choose the best type of chart for your data, use:

styles

A ______________ displays and summarizes totals from other worksheets.

summary sheets

A range of cells can be converted into an Excel ___________ so that the data can be analyzed.

table

an Excel _____________ is a series of rows and columns that contain related data and is managed independently from other data in the worksheet.

table

In a lookup formula, the defined range is referred to as the: defined name. table array. validation list. named range.

table array

A theme combines font sets for:

text and headings.

Saving an Excel worksheet as a ________ separates the cells of each row with tab characters.

text file