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