Data Management Test One

Ace your homework & exams now with Quizwiz!

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


Related study sets

Chapter 22: PrepU - Nursing Management: Patients With Oral and Esophageal Disorders and Patients Receiving Gastrointestinal Intubation, Enteral, and Parenteral Nutrition

View Set

Nursing Care of the Child With an Alteration in Urinary Elimination/Genitourinary Disorder

View Set

Principles of Management: Final Exam

View Set

LC13: LearningCurve - Ch. 13: Fiscal Policy

View Set

Christian Worldview Topic 2 Quiz

View Set

Cybersecurity Essentials Chapter 3 Malware and Malicious Code

View Set