Advertisement Upgrade to remove ads

Excel

A line chart

uses a line to connect data points in order to show trends over a period of time

A data point

is a numeric value that describes a single value on a chart

To put a long text label on two or more lines within a single cell

Insert a line break with the "Alt + Enter" key combination

A formula (as it applies to Excel 2010) is

a combination of cell references, operators, values, and/or functions used to perform calculations.

A bar chart

compares values across categories using horizontal bars

A data label

is the value or name of a data point

Fill Color (as it applies to Excel)

is the background color of a cell

For a basic mathematical expression it is best to use

formulas such as =B4+C4

The value axis

displays incremental values to identify the values of the data series

To adjust the column width and/or row height of many cells at once

Click and drag across the cells to select them and use any sizing method you choose

A worksheet is defined as

a single spreadsheet that often contains formulas, functions, values, text, and visual aids

To reverse the Data Series of a chart

click Switch Row/Column in the Data group

Formula AutoComplete

displays a list of functions and defined names as you enter a function

A column chart

displays data comparisons vertically in columns

A mixed cell reference

contains both an absolute and a relative cell reference

The IF function

evaluates a condition and returns one value if the condition is true and a different value if the condition is false

A clustered column chart

groups or clusters similar data in columns to compare values across categories

The column index number

is the argument in a VLOOKUP function that identifies from which column to return a value

A "Range"

refers to a group of adjacent or contiguous cells

To insert the current date into an active cell use

The Ctrl and semicolon key combination

The data type "Text" (as it applies to Excel)

includes letters, numbers, and spaces not used in calculations

The Name Box (as it applies to Excel 2010)

identifies the address of the current cell

A category label

is text that describes a collection of data points in a chart

An X Y (scatter) chart

shows a relationship between two variables

An Output Area (as it applies to Excel 2010) is defined as

a range of cells containing results based upon manipulation of the variables in the input area

To Freeze Columns and/or rows

use the View Tab, Window Group, and click Freeze Panes

Each column in a table

represents a Field which can contain an individual piece of data for a record

Excel applies basic formatting to PivotTables such as

primary row labels in bold

Filtering

is the process of displaying only records that meet specific conditions

Sorting Dates oldest to newest

displays data in chronological order

The Solver summary report is

created in a new worksheet

To begin a sort in a PivotTable you must first

click in any cell in the column that you wish to sort

A one-variable data table must have at least ______ blank row and ______ blank column between the dataset and the data table

one, one

Each row in an Excel table

represents a record

The first section of a Solver report

displays information about the report

Which tools have the ability to change values in the original dataset?

Goal Seek and Solver

For Subtotals to be useful and accurate, it is important that the data be ______ correctly

sorted

Which of the following is NOT one of the major sections of a Solver report?

Original Value

A two-variable data table returns ______ result(s) for each combination of two variables

one

The initial results of a Goal Seek are

shown in the Goal Seek Status dialog box

If a Slicer obstructs the view of the PivotTable, ______ the slicer to a new location

drag

When creating a range for the substitution values in a one-variable data table, it is best to arrange them in a ______ orientation

vertical

Solver can be used for

complex equation solving

After entering the substitution values and the reference to a formula, the next step to complete a two-variable data table and view the results is to

drag to select the data table boundaries

Using Conditional Formatting to draw attention to cells that are blank

helps locate where data may be missing

To begin a filter based on a particular field, you drag the desired field to which area under Drag fields between areas below?

Report Filter

Which of the following is NOT required for Solver to generate a solution?

Precedent values

Freeze Top Row

keeps only the top row visible as you scroll through a worksheet

A structured reference

is a tag or use of a table element as a reference in a formula

To open a saved Solver model you must first

click Load/Save in the Solver Parameters dialog box

The Table Style Options Group

contains check boxes to select format actions such as First Column which applies a different format to the first column when checked

Which of the following is NOT a concern when adding subcategories to a PivotTable?

It improves the readibility of the PivotTable

The Show Iteration Results option allows you to

see the values of each trial solution prior to reaching a final solution

To view the PivotTable Field LIst, click Field LIst in the Show group on the

PivotTable Tools Options

Which of the following commands cannot be used on a constraint in the Solver Parameters dialog box?

Format

Print order

is the sequence in which pages print

To convert a table back into a range

click within the table, click the Table Tools Design tab, and then select Convert to Range

PivotCharts look best when they use basic charts such as a

column chart

To build a PivotTable and PivotChart at the same time, click the PivotTable arrow and then select

PivotChart

To remove duplicate records (rows)

select any cell in the table, then click Remove Duplicates from the Tools group on the Table Tools Design tab

Data mining techniques such as PivotTables can detect _____ of data

patterns

After a PivotChart has been created, the PivotTable Settings can still be changed by using the

PivotTable Field List

The Goal Seek command is located in the ______ command on the Data tab

What-If Analysis

Which of the following is NOT one of the major sections of a Solver report?

Original Value

When using a Slicer, the available filters appear in a blue fill color while unavailable filters appear in

gray

In a what-if analysis of a car purchase, the original interest rates of 6% and 5%, 5.5%, 6.5% are the ______ values

substitution

To create a table from an existing range of data

click the Insert tab and then click Table in the Tables group

If you delete a PivotChart, what happens to the PivotTable?

Nothing

The last three sections of a Solver reprot

help you analyze the results

Click the ______ to sort or filter the chart representation based on the values

Legend Field arrows

The Scenario Manager dialog box enables you to all the following except

format scenarios

To create an effective outline in Excel, you must

ensure the data has a hierarchial structure

The breakpoint

is the lowest value for a specific category or series in a lookup table

The NOW function

displays the current date and time

A multiple data series chart

compares two or more sets of data in one chart

A sheet tab (as it applies to Excel 2010)

displays the name of a worksheet within a workbook

Vertical Alignment (as it applies to Excel)

refers to the up-down position of contents in a cell

The TODAY function

displays the current date

A range name

is a word or a string of characters that represent one or more cells

A chart title

is a label that describes the chart

A stock chart

can show the open, high, low, and close prices for individual stocks over time.

A lookup table

contains data for the basis of the lookup and the data to be retrieved

The fill handle (as it applies to Excel 2010)

is a small black square at the bottom-right corner of a cell that facilitates fill operations

The lookup value

is a reference to a cell containing a value to look up

You should use cell references in formulas instead of constant values so

you can change the input values without changing the formulas

A spreadsheet PROGRAM is defined as

a software application used to create and modify spreadsheets

The Y-axis

is a vertical line that borders the plot area to provide a frame of reference for measurement

A doughnut chart displays

values as percentages of the whole but may contain more than one data series

A worksheet is defined as

a single spreadsheet that often contains formulas, functions, values, text, and visual aids

The Table Array

is a range containing a lookup table

An absolute cell reference

indicates a cell's specific location and the reference does not change when you copy the formula

A cell (as it applies to Excel 2010)

is the intersection of a column and a row

A chart sheet

contains a single chart and no spreadsheet data

The COUNT function

tallies the number of cells in a range that contain values

The maximum number of scenarios Scenario Manager can handle is

32

The value you want to achieve in Goal Seek needs to be entered in the ______ box in the Goal Seek dialog box

To value

It is wise to create a Pivot Table in a new worksheet because

separating the PivotTable from the original dataset will prevent accidental deletions of the original dataset

The subtotal command is located on the ______ tab

data

Which of the following will NOT remove a field name from a PivotTable?

Click a field name in the Drag fields between areas below section and then press the Delete key

In addition to sorting and filtering cells by content you can sort and/or filter by

conditional formatting

Click the ______ to sort or filter the chart representation based on the values

Legend field arrows

Before using Solver, it is recommended you complete which step first?

Specify the goal

_____ are created to organize and summarize data in PivotTables

Categories

A total row appears as the last row of a table to

display summary statistics, such as a sum

Predefined styles to format a PivotTable are available in the

PivotTable Styles gallery

A record

is a complete set of data for an entity

The Reports list in the Solver Results dialog box displays the

available report types

Which of the following is TRUE about scenario summary reports?

New reports appear on separate worksheets

The Sort by Value dialog box contains the following options EXCEPT

Manual (you can drag items to rearrange them)

Freezing rows and/or columns

keeps them visible as you scroll through a worksheet

Using Conditional Formatting to draw attention to cells containing errors

helps locate errors in cells quickly

Syntax (as it applies to Excel 2010)

is a set of rules that govern the structure and components for a function

A nonadjacent range

contains two or more cells or ranges that are not touching each other

A surface chart

displays trends using two dimensions on a continuous curve

A nested function

contains another function embedded inside one or more of its arguments

Excel displays a green arrow in the top left corner of a cell if it detects a

potential error

An absolute cell reference

indicates a cell's specific location and the reference does not change when you copy the formula

Column width

is adjustable so you can display more or less characters in a column

A 100% stacked column chart

places (stacks) data in one column per category, with each column having the same height of 100%

Which cell becomes active when you press the "Enter" key?

The next cell down

To change the data source of a chart

use the Select Data Source dialog box from the Select Data button

The category axis

displays descriptive group names or labels, such as college names or cities, to identify data

A sparkline is

a miniature chart contained in a single cell

A trendline

is a line used to depict trends and forecast future data

When you select a chart, Excel displays a Chart Tools contextual tab with three specific tabs

Design, Layout, and Format

A chart

is a visual representation of numerical data

The PMT function

calculates the periodic payment for a loan with a fixed interest rate and fixed term

A stacked column chart

places stacks of data in segments on top of each other in one column, with each category in the data series represented by a different color

To modify the PivotTable value settings you must first

select the value in the appropriate field in the PivotTable

Sorting Text A to Z

arranges data in alphabetical order

After creating a scenario summary report, it is recommended that you do all of the following EXCEPT

change the colors of the title row

Where do you go to begin loading the Solver add-in?

Options on the File tab

A Pivot Table Style controls all except

number format

Filtering the Last_Name column (field) to show only records taht begin with the letter S is an application of

a Text Filter

Which of the following has to be loaded onto Excel?

Solver

A field

is an individual piece of data, such as a last name

Highlight Cell Rules

highlight cells meeting specified criteria with a specified color, font, or border

The show group includes all EXCEPT

Calculations

A Table Style controls

the fill color of the header, row, columns, and records in a table

To change the PivotTable name, click on the _____ group and type the name in the PivotTable Name textbox

PivotTable

If you change any of the Solver parameters

you will need to create another Solver report

A data bar

is a horizontal gradient or solid fill indicating the cell's relative value compared to other selected cells

The MEDIAN function

identifies the midpoint value in a set of values

A "Range"

refers to a group of adjacent or contiguous cells

The MIN function

displays the lowest value in a range

Row Height

is the adjustable vertical measurement of a row

The VLOOKUP function

looks up a value and returns a related result from the lookup table

A handle, indicated by faint dots on the outside border of a selected chart

enables you to adjust the size of a selected chart

A legend

is a key that identifies the color, gradient, picture, texture, or pattern fill assigned to each data series in a chart

See More

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions above and try again

Example:

Reload the page to try again!

Reload

Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

Star this term

You can study starred terms together

NEW! Voice Recording

Create Set