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: