BUS 114 Midterm Exam Study Guide

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.

"COUNT IF" function

4. An Excel function that adds a group of values and then divides the result by the number of values in the group.

AVERAGE function

1. A cell reference that refers to cells by their fixed position in a worksheet.

Absolute Cell Reference

6. The feature that generates and extends values into adjacent cells based on the values of selected cells is

Auto Fill

3. An Excel feature that generates and extends values into adjacent cells based on the values of selected cells.

AutoFill

11. An Excel feature that adjusts the width of a column to fit the cell content of the widest cell in the column is

AutoFit

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.

Caparison Operators

3. The intersection of a column and a row.

Cell

12. Another name for a cell reference.

Cell Address

7. Anything typed into a cell.

Cell Content

2. A defined set of formatting characteristics, such as font, font size, font color, cell borders, and cell shading.

Cell Style

15. The graphic representation of data in a worksheet.

Chart

9. The combination of chart elements that can be displayed in a chart such as a title, legend, labels for the columns, and the table of charted cells.

Chart Layout

5. A vertical group of cells in a worksheet.

Columns

12. An instruction to a computer program that causes an action to be carried out.

Command

9. Numbers, text, dates, or times of day that you type into a cell.

Constant Values

10. Conditions that you specify in a logical function.

Criteria

8. Text or numbers in a cell.

Data

4. The term that refers to the current selection or setting that is automatically used by a computer program unless you specify otherwise.

Default

14. The small black square in the lower right corner of a selected cell.

Fill Handle

11. A reserved area for text or graphics that displays at the bottom of each page in a document.

Footer

10. An equation that performs mathematical calculations on values in a worksheet.

Formula

4. An equation that performs mathematical calculations on values in a worksheet.

Formula

8. A command that enables you to select one or more rows or columns and lock them in place.

Freeze Panes

1. A predefined formula that performs calculations by using specific values in a particular order or structure.

Function

9. An Office feature that displays a list of potential results instead of just the command name.

Gallery

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.

IF Function

5. A combination of two or more keyboard keys, used to perform a task that would otherwise require a mouse.

Keyboard Shortcut

13. A button that displays when an object is selected and that has commands to choose how the object interacts with surrounding text.

Layout Options

8. A technology that shows the result of applying an editing or formatting change as you point to possible results—before you actually apply it.

Live Preview

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.

Logical Functions

12. Any value or expression that can be evaluated as being true or false.

Logical Test

7. An Excel function that determines the largest value in a range.

MAX Function

5. An Excel function that finds the middle value that has as many values above it in the group as are below it.

MEDIAN Function

6. An Excel function that determines the smallest value in a range.

MIN Function

6. A small toolbar containing frequently used formatting commands that displays as a result of selecting text or objects.

Mini Toolbar

2. The function that retrieves and then displays the date and time from your computer is the

NOW function

5. An element of the Excel window that displays the name of the selected cell, table, chart, or object.

Name Box

2. Characters that display on the screen, but do not print, indicating where the ENTER key, the SPACEBAR, and the TAB key were pressed; also called formatting marks.

Non-printing characters

7. A specific way in which Excel displays number in a cell.

Number Format

11. Constant values consisting of only numbers.

Number Values

14. A text box, picture, table, or shape that you can select and then move and resize.

Object

10. Microsoft's collection of Apps for Office that you can download within an application.

Office Store

3. The symbol ¶ that represents the end of a paragraph.

Paragraph Symbol

13. In an Office program window, the small row of buttons in the upper left corner of the screen from which you can perform frequently used commands is the

Quick Access Toolbar

6. A tool 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.

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

Quick Analysis tool

15. A feature that outlines cells in color to indicate which cells are used in a formula is called

Range Finder

1. A user interface in Office 2016 and Windows 10 that groups the commands for performing related tasks on tabs across the upper portion of the program window.

Ribbon

6. A horizontal group of cells in a worksheet.

Rows

3. A predefined formula that adds all the numbers in a selected range.

SUM Function

11. A font design that includes small line extensions on the ends of the letters to guide the eye in reading from left to right is

Serif font

4. The labels along the lower border of the Excel window that identify each worksheet.

Sheet Tabs

15. Small squares that indicate a picture or object is selected.

Sizing Handles

2. Another name for a worksheet.

Spreadsheet

2. Excel functions, such as AVERAGE, that are useful to analyze a group of measurements.

Statistical Functions

7. A group of formatting commands, such as font, font size, font color, paragraph alignment, and line spacing that can be applied to a paragraph with one command.

Style

10. A charting command to swap the data over the axis—data being charted on the vertical axis will move to the horizontal axis and vice versa.

Switch Row/Column

15 The process of updating computer files that are in two or more locations according to specific rules is called

Syncing

4. A series of rows and columns that contains related data and that is managed independently from other data is an Excel

Table

13. Another name for a constant value.

Value

1. An Excel file that contains one or more worksheets.

Workbook

12. Formatting emphasis such as bold, italic, and underline is referred to as

a font style

9. The type of cell reference that refers to cells by their fixed position in a worksheet is

absolute

5. A cell surrounded by a black border and ready to receive data is the

active cell

14. A set of three dots indicating that a dialog box will display if you click the command is

an ellipsis

13. The values that an Excel function uses to perform calculations or operations are the

arguments

14. The area along the bottom of a chart that identifies the categories of data is the

category axis

1. The action of pressing and releasing the left button on a mouse pointing device one time is called

click

15. A format that changes the appearance of a cell based on a condition.

conditional format

8. Tabs that are added to the ribbon automatically when a specific object, such as a picture, is selected, and that contain commands relevant to the selected object are

contextual tabs

1. A shaded bar that provides a visual cue about the value of a cell relative to other cells is a

data bar

6. The action of canceling the selection of an object or block of text by clicking outside of the selection is called

deselect

4. The action of holding down the left mouse button while moving your mouse is called

dragging

3. The process of making changes to text or graphics in an Office file is called

editing

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

filtering

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

flash fill

10 A set of characters with the same design and shape is a

font

2. An element in the Excel window that displays the value or formula contained in the active cell is the

formula bar

7. The default format that Excel applies to numbers is the

general format

7. The tab in Backstage view that displays information about the current file is the

info tab

3. An element of the Excel window that displays the name of the selected cell, table, chart, or object is the

name box

3. The process of moving within a worksheet or workbook

navigate

12. The symbols with which you can specify the type of calculation you want to perform in an Excel formula are

operators

11. The action of placing cell contents that have been copied or moved to the Clipboard into another location is called

paste

14. The target destination for data that has been cut or copied using the Office Clipboard is the

paste area

2. The action of moving your mouse pointer over something on your screen is called

point

9. A page orientation in which the paper is taller than it is wide is called

portrait

7. The Excel command that enables you to specify rows and columns to repeat on each printed page is

print titles

5. The action of clicking the right mouse button one time is called

right-click

4. A box in the upper left corner of the worksheet grid that selects all the cells in a worksheet is the

select all box

8. The labels along the lower border of the workbook window that identify each worksheet are the

sheet tabs

5. The process of arranging data in a specific order based on the value in each field is called

sorting

8. A tiny chart in the background of a cell that gives a visual trend summary alongside your data; makes a pattern more obvious.

sparkline

10. Tiny charts embedded in a cell that give a visual trend summary alongside your data are

sparklines

9. A worksheet where totals from other worksheets are displayed and summarized is a

summary sheet

10. The worksheets that contain the details of the information summarized on a summary sheet are called

summary sheets

8. The data that displays in the Formula Bar is referred to as the

underlying value

15. The term used to describe an Excel function that is subject to change each time the workbook is opened is called

volatile

1. On startup, Excel displays a new blank

workbook