How can we help?

You can also find more resources in our Help Center.

166 terms

CS 110 Exam 2

Excel
STUDY
PLAY
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
To simplify entering ranges in formulas you can use
range names
To ensure a PivotTable is up to date when the workbook opens
select Refresh data when opening the file in the PivotTable options dialog box on the data tab
Which What-If Analysis tool would be best at comparing the combined effects of various interest rates and down payments?
Two-variable data table
When you see Sum of Total... in the Values area box, position the pointer over the _____ in the Values area to see a ScreenTip with the full name
field name
Where is Solver located if it is already loaded onto Excel?
Analysis group on the data tab
Which of the following is NOT true about the Subtotal command?
the subtotal dialog box can be used with tables
The strength of a pivot table lies in its
ability to easily and quickly rearrange data
Which of the following is FALSE about PivotTables?
Each row in the source data becomes a PivotTable field
The _____ dialog box contains the Row and Column input cell boxes
data table
A page break
indicates where data starts on a new printed page
After creating a chart you can change the chart type by using
design tab/ change chart type button
Wrap Text
enables data to appear on two or more lines within a cell
The x axis
is a horizontal line that borders the plot area to provide a frame of reference for measurement
A gridline
is a horizontal or vertical line that extends form the horizontal or vertical axis through the plot area
A data series
is a group of related data points
Horizontal alignment
refers to the left-right position of contents in a cell
The RATE
is the periodic interest rate, such as a monthly interest rate