CSC 1123 MGCCC Final Exam chp 14-18
order of operations
10. The mathematical rules for performing multiple calculations within a formula.
detail sheets
10. The worksheets that contain the details of the information summarized on a summary sheet are called:
sparklines
10. Tiny charts embedded in a cell that give a visual trend summary alongside your data are:
COUNTIF function
11. A statistical function that counts the number of cells within a range that meet the given condition and which has two arguments—the range of cells to check and the criteria
AutoFit
11. An Excel feature that adjusts the width of a column to fit the cell content of the widest cell in the column is:
number values
11. Constant values consisting of only numbers
fomrula autocomplete
11. The Excel feature which, after typing = and the first letter of a function, displays a list of function names.
paste
11. The action of placing cell contents that have been copied or moved to the Clipboard into another location is called:
axis
12. A line that serves as a frame of reference for measurement and that borders the chart plot area.
cell address
12. Another name for a cell reference
logical test
12. Any value or expression that can be evaluated as being true or false
flash fill
12. The Excel command that recognizes a pattern in your data and then automatically fills in the values when you enter examples of the desired output is:
value axis
12. The y-axis is also known as the:
Quick Analysis tool
13. A feature that displays in the lower right corner of a selected range with which you can analyze your data by using Excel tools such as charts, color-coding, and formulas is called:
IF function
13. A function that uses a logical test to check whether a condition is met, and then returns one value if true and another value if false
value
13. Another name for a constant value
color or pattern
13. In a chart, each data point—bar, slice, and so on—has a unique:
category axis
13. The area along the bottom of a chart that identifies the categories of data; also referred to as the x-axis.
arguments
13. The values that an Excel function uses to perform calculations or operations are the:
value axis
14. A numerical scale on the left side of a chart that shows the range of numbers for the data points; also referred to as the y-axis.
comparison operator
14. Symbols that evaluate each value to determine if it is the same (=), greater than (>), less than (<), or in between a range of values as specified by the criteria
fill handle
14. The small black square in the lower right corner of a selected cell
paste area
14. The target destination for data that has been cut or copied using the Office Clipboard is the:
Range finder
15. A feature that outlines cells in color to indicate which cells are used in a formula is called:
value after increase= bas x percent new value
15. The formula for calculating the value after an increase by multiplying the original value—the base—by the percent for new value.
chart
15. The graphic representation of data in a worksheet
volatile
15. The term used to describe an Excel function that is subject to change each time the workbook is opened is called:
conditional format
15.. A format that changes the appearance of a cell based on a condition
absolute
2. A cell reference that refers to a cell by its fixed position in a worksheet is referred to as being:
goal seek
2. A what-if analysis tool that finds the input needed in one cell to arrive at the desired result in another cell.
spreadsheet
2. Another name for a worksheet
statistical functions
2. Excel functions, such as AVERAGE, that are useful to analyze a group of measurements
SUM function
3. A predefined formula that adds all the numbers in a selected range
name box
3. An element of the Excel window that displays the name of the selected cell, table, chart, or object is the:
relative cell reference
3. In a formula, the address of a cell based on the relative position of the cell that contains the formula and the cell referred to.
cell
3. The intersection of a column and a row
select all box
4. A box in the upper left corner of the worksheet grid that selects all the cells in a worksheet is the:
data marker
4. A column, bar, area, dot, pie slice, or other symbol in a chart that represents a single data point.
AVERAGE function
4. An Excel function that adds a group of values and then divides the result by the number of values in the group
series
4. Related data points represented by data markers are referred to as the data:
sheet tabs
4. The labels along the lower border of the Excel window that identify each worksheet
Editing
4. The process of modifying a presentation by adding and deleting slides or by changing the contents of individual slides is referred to as:
column
5. A vertical group of cells in a worksheet
chart sheet
5. A workbook sheet that contains only a chart.
MEDIAN function
5. An Excel function that finds the middle value that has as many values above it in the group as are below it
explode
5. The action of pulling out a pie slice from a pie chart is called:
Layout
5. The arrangement of elements, such as title and subtitle text, lists, pictures, tables, charts, shapes, and movies on a PowerPoint slide is:
filtering
6. The process of displaying only a portion of the data based on matching a specific value to show only the data that meets the criteria that you specify is called:
major unit
6. The value in a chart's value axis that determines the spacing between the gridlines in the plot area is the:
cell content
7. Anything typed into a cell
chart area
7. The entire chart and all of its elements.
Freeze Panes
8. A command that enables you to select one or more rows or columns and lock them in place
data
8. Text or numbers in a cell
underlying value
8. The data that displays in the Formula Bar is referred to as the:
sheet tabs
8. The labels along the lower border of the workbook window that identify each worksheet are the:
what if analysis
8. The process of changing the values in cells to see how those changes affect the outcome of formulas in a worksheet.
Logical functions
9. A group of functions that test for specific conditions, and which typically use conditional tests to determine whether specified conditions are true or false.
Font
9. A set of characters with the same design and shape is a:
constant value
9. Numbers, text, dates, or times of day that you type into a cell
rate= amount of increase/base
9. The mathematical formula to calculate a rate of increase.
absolute
9. The type of cell reference that refers to cells by their fixed position in a worksheet is:
pie chart
1. A chart that shows the relationship of each part to a whole.
Merge & Center
1. A command that joins selected cells in a workbook into one larger cell and centers the contents in the merged cell:
function
1. A predefined formula that performs calculations by using specific values in a particular order or structure
data bar
1. A shaded bar that provides a visual cue about the value of a cell relative to other cells is a:
workbook
1. An Excel file that contains one or more worksheets
Slide pane
1. In Normal view, the pane that displays a large image of the active slide is the:
formula
10. An equation that performs mathematical calculations on values in a worksheet
Criteria
10. Conditions that you specify in a logical function
sorting
5. The process of arranging data in a specific order based on the value in each field is called:
row
6. A horizontal group of cells in a worksheet
bevel
6. A shape effect that uses shading and shadows to make the edges of a shape appear to be curved or angled.
MIN function
6. An Excel function that determines the smallest value in a range
AutoFill
6. The Excel feature that generates and extends values into adjacent cells based on the values of selected cells is:
MAX function
7. An Excel function that determines the largest value in a range
active cell
A cell surrounded by a black border and ready to receive data is the:
line chart
A chart type that displays trends over time is a:
an enterprise fund
A municipal government fund that reports income and expenditures related to municipal services for which a fee is charged in exchange for goods or services is:
a data marker
A pie slice is an example of:
Excel table
A series of rows and columns that contains related data and that is managed independently from other data is an Excel:
point
A value that originates in a worksheet cell and that is represented in a chart by a data marker is a data:
Presenter view
A view that shows the full-screen slide show on one monitor while enabling the presenter to view a preview of the next slide, notes, and a timer on another monitor is:
summary sheet
A worksheet where totals from other worksheets are displayed and summarized is a:
formula bar
An element in the Excel window that displays the value or formula contained in the active cell is the:
Artistic Effects
Formats applied to images that make pictures resemble sketches or paintings are:
Notes pane
In Normal view, the pane that displays below the Slide pane:
Header
Text that prints at the top of a sheet of slide handouts or notes pages is a:
print titles
The Excel command that enables you to specify rows and columns to repeat on each printed page is:
category axis
The area along the bottom of a chart that identifies the categories of data is the:
plot area
The area bounded by the axes of a chart, including all the data series, is the:
View buttons
The buttons in the lower right corner of the PowerPoint window that control the look of the presentation window are the:
general format
The default format that Excel applies to numbers is the:
NOW function
The function that retrieves and then displays the date and time from your computer is the:
increase
The percent by which one number increases over another number is the percentage rate of:
navigate
The process of moving within a worksheet or workbook:
base
The starting point when you divide the amount of increase by it to calculate the rate of increase is the:
operators
The symbols with which you can specify the type of calculation you want to perform in an Excel formula are:
3-D
The term that refers to an image that appears to have all three spatial dimensions is:
Slide Sorter view
The view in which all of the slides in your presentation display in miniature is:
category axis
The x-axis is also known as the: