Data Management Test One
a named operation that returns a value
function
T/F: Background images do not print in Excel.
true
T/F: The AutoComplete feature automatically completes an entry based on previous entries in a column.
true
another word for text that is hidden from view by overflowing into another cell
truncated
reverses a merge, returning the merged cell back into a range of individual cells
unmerge cells
Excel is an electronic version of a(n) ____. a. spreadsheet b. database c. expression d. formula
A. Spreadsheet
By default, Excel starts with a ____ maximized to fill the Excel window. A. blank workbook B. sample worksheet with formulas C. sample worksheet with calculations D.sample workbook with text, formulas, and calculations
A. blank workbook
how to separate lines within the same cell
Alt+Enter
Excel's way of trying to anticipate the remaining characters by displaying text with the same letters as a previous entry in the same column
AutoComplete
merges each of the rows in the selected range across the columns in the range
Merge Across
What is the difference between clearing data from a worksheet and deleting data from a worksheet?
When you clear data from a worksheet, you leave blank cells where the data had been. When you delete data from a worksheet, you remove both the data and the cells
(in the format cells dialog box) provides options for how data is aligned within a cell
alignment
the most commonly used operators that perform addition, subtraction, multiplication, division and exponentation
arithmetic operators
eliminates empty space by matching the row height or column width to its tallest or longest cell entry
autofitting
a column chart that is turned on its side so that the length of each bar is based on its value
bar chart
(in the format cells dialog box) provides options for adding and removing cell borders as well as selecting a line style and color
border
a way to identify a cell that indicates its column and row location
cell reference
contains an excel chart that provides a visual representation of worksheet data
chart sheet
type of chart that displays values in different categories as columns; the height of each column is based on its value
column chart
a symbol that indicates the relationship between two values
comparison operator
type of interest where the interest is applied not only to the principal but also to any accrued interest
compound interest
technique that includes dragging the range and dropping it into a new location
drag and drop
T/F: A spreadsheet is a collection of numbers, not text.
false
T/F: After you merge a range into a single cell, you cannot realign its content.
false
T/F: By default, embedded charts display the chart and any text or figures on separate pages.
false
T/F: Functions are organized in the Function Library group in the Function tab on the Ribbon
false
T/F: If you revise a style in Excel, the appearance of any cell formatted with that style must be updated manually.
false
T/F: In Excel, charts do not remain linked or connected to their data sources if they appear in different worksheets.
false
T/F: In pie charts with legends, it's best to make the slice colors as similar as possible.
false
T/F: Modifying the number format affects the value stored in the workbook.
false
T/F: The Rand( ) function falls under the Statistical category.
false
T/F: The name of the active workbook appears in the status bar of the Excel window.
false
T/F: To enter a mixed reference, type $ after either the row or column reference.
false
T/F: When a worksheet is printed, the gridlines that surround the cells are printed by default.
false
T/F: When selecting a data source for a pie chart, select all rows and columns, including total rows and columns.
false
T/F: You can rotate a 3-D chart along the x-axis, y-axis, and z-axis.
false
T/F: You can use the Go To dialog box to navigate to a specific worksheet.
false
(in the format cells dialog box) provides options for creating and applying background colors and patterns to cells
fill
(in the format cells dialog box) provides options for selecting font types, sizes, styles, and other formatting attributes such as underlining and font colors
font
the process of changing a workbook's appearance by defining the fonts, colors, and decorative features
formatting
a view of the worksheet contents that displays formulas instead of the resulting values
formula view
the amount added to the principal by the lender
interest
in this orientation view, the page is wider than it is tall
landscape orientation
lines that connect each data label to its corresponding data marker
leader lines
a key that shows each color used in the worksheet and what it means, so others know why certain cells are highlighted
legend
merges the range into one cell and horizontally centers the content
merge & center
merges the range into a single cell, but does not horizontally center the cell content
merge cells
when functions can be placed inside of another function they are being ___________.
nested
(in the format cells dialog box) provides options for formatting the appearance of numbers, including dates and numbers treated as text
number
any numerical value that can be used in a mathematical calculation
number data
a formula is written using this that combine different values, resulting in a single value that is then displayed within the cell
operators
a set of predefined rules used to determine the sequence in which operators are applied in a calculation
order of precendence
displays the location of the different page breaks within the worksheet
page break preview
shows how the worksheet will appear when printed
page layout view
a chart in the shape of a circle that shows data values as a percentage of the whole
pie chart
a single point on a computer monitor or printout
pixel
approximately 1/72 of an inch
point
in this orientation view, the page is taller than it is wide
portrait orientation
the amount of money being loaned
principal
(in the format cells dialog box) provides options for locking or hiding cells to prevent other users from modifying their contents
protection
indicates the location and size of a cell range
range reference
the range of values
scale
reduces the width and the height of a printout to fit the number of pages you specify by shrinking the text size as needed
scaling
a box surrounding the chart object that is used to move or re-size the object
selection box
type of interest where the interest is equal to a percentage of principal for each period that the money has been lent
simple interest
a square or dot in the selection box that is used to change the object's width and height
sizing handle
a collection of text and numbers laid out in a rectangular grid
spreadsheet
any combination of letters, numbers, and symbols that form words and sentences
text data
a collection of formats for text, colors, images, and graphical effects applied throughout a workbook
theme
the 12 colors that belong to the workbook's theme
theme colors
associated with a particular theme and used for headings and body text in the workbook
theme font
T/F: A chart style is similar to a cell style or a table style in that it formats several chart elements at one time.
true
T/F: A mixed reference "locks" one part of the cell reference while the other part can change.
true
T/F: Although 3-D charts are visually attractive, they can obscure the relationship between the values in the chart by making it difficult to see which slice is larger.
true
T/F: By default, text is black and cells have no background fill color.
true
T/F: COUNT is a Statistical function.
true
T/F: Charts include individual elements that can be formatted, including the chart area, the chart title, the plot area, data markers, and a legend.
true
T/F: Every chart must have a data source.
true
T/F: Excel workbooks can contain two kinds of sheets.
true
T/F: Formatting changes only the appearance of data - it does not affect the data itself.
true
T/F: Functions can be incorporated as part of larger formulas.
true
T/F: Microsoft Excel 2010 stores spreadsheets in files called workbooks.
true
T/F: Not all functions have arguments.
true
T/F: One challenge of nesting functions is to make sure that you include all of the parentheses.
true
T/F: Optional arguments are always placed last in the argument list.
true
T/F: Red-green color blindness is the most common, so avoid using red text on a green background or green text on a red background.
true
T/F: Scrolling through sheet tabs does not change the active sheet in the workbook window.
true
T/F: The formula bar displays the value or formula of the active cell
true
T/F: To change a border color on a chart, click the Color button to open the color palette.
true
T/F: When you enter a formula into a cell, Excel interprets cell references in the formula in relation to the cell's location.
true
T/F: You can rotate cell contents in Excel so that they appear at any angle or orientation.
true
T/F: You can use a picture or image as the background for all the cells in a worksheet.
true
allows you to change one or more values in a spreadsheet and then assess the effect those changes have on the calculated values
what if analysis
contains a grid of rows and columns into which the user enters data values and formulas
worksheet
This axis represents the length of an object
x axis
This axis represents that height of an object
y axis
This axis represents the object's depth
z axis