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