Midterm Flashcards
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
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.
Nonprinting characters
The symbol ¶ that represents the end of a paragraph.
Paragraph Symbol
The term that refers to the current selection or setting that is automatically used by a computer program unless you specify otherwise.
Default
A combination of two or more keyboard keys, used to perform a task that would otherwise require a mouse.
Keyboard shortcut
A small toolbar containing frequently used formatting commands that displays as a result of selecting text or objects.
Mini toolbar
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
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
An Office feature that displays a list of potential results instead of just the command name.
Gallery
Microsoft’s collection of Apps for Office that you can download within an application.
Office Store
A reserved area for text or graphics that displays at the bottom of each page in a document.
Footer
An instruction to a computer program that causes an action to be carried out.
Command
A button that displays when an object is selected and that has commands to choose how the object interacts with surrounding text.
Layout Options
A text box, picture, table, or shape that you can select and then move and resize.
Object
Small squares that indicate a picture or object is selected.
Sizing handles
The action of pressing and releasing the left button on a mouse pointing device one time is called:
click
The action of moving your mouse pointer over something on your screen is called:
point
The process of making changes to text or graphics in an Office file is called:
editing
The action of holding down the left mouse button while moving your mouse is called:
dragging
The action of clicking the right mouse button one time is called
right-click
The action of canceling the selection of an object or block of text by clicking outside of the selection is called:
deselect
The tab in Backstage view that displays information about the current file is the:
info tab
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
A page orientation in which the paper is taller than it is wide is called:
portrait
A set of characters with the same design and shape is a
font
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 a:
serif font
Formatting emphasis such as bold, italic, and underline is referred to as:
font style
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
A set of three dots indicating that a dialog box will display if you click the command is:
an ellipsis
The process of updating computer files that are in two or more locations according to specific rules is called:
syncing
Text added to a picture or object that helps people using a screen reader understand what the object is.
alternative text
A command that identifies a work, section, or place in a document so that you can find it quickly without scrolling.
bookmark
A command that searches your document for features that may not be supported by older versions of Office.
Check Compatibility
Details about a file that describe or identify it, including the title, author name, subject, and keywords that identify the document’s topic or contents.
document properties
A reserved area for text or graphics that displays at the bottom of each page in a document.
footer
A command that searches your document for hidden data or personal information that you might not want to share publicly.
inspect document
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.
quick access toolbar
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
An Office feature in Word, Excel, and PowerPoint that enables you to change normal text into decorative stylized text.
wordart
The action of increasing or decreasing the size of the viewing area on the screen.
zoom
A cell reference that refers to cells by their fixed position in a worksheet.
Absolute cell reference
- A defined set of formatting characteristics, such as font, font size, font color, cell borders, and cell shading.
Cell style
An Excel feature that generates and extends values into adjacent cells based on the values of selected cells.
Auto Fill
- An equation that performs mathematical calculations on values in a worksheet.
Formula
- An element of the Excel window that displays the name of the selected cell, table, chart, or object.
Name Box
- 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
- A specific way in which Excel displays number in a cell.
Number format
- A tiny chart in the background of a cell that gives a visual trend summary alongside your data; makes a pattern more obvious.
Sparkline
- 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
- 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
An Excel file that contains one or more worksheets.
Workbook
Another name for a worksheet.
Spreadsheet
The intersection of a column and a row.
Cell
The labels along the lower border of the Excel window that identify each worksheet.
Sheet tabs
A vertical group of cells in a worksheet.
Column
A horizontal group of cells in a worksheet.
Row
Anything typed into a cell.
Cell content
Text or numbers in a cell.
Data
Numbers, text, dates, or times of day that you type into a cell.
Constant value
An equation that performs mathematical calculations on values in a worksheet.
Formula
Constant values consisting of only numbers.
Number values
Another name for a cell reference.
Cell address
Another name for a constant value.
Value
The small black square in the lower right corner of a selected cell.
Fill handle
The graphic representation of data in a worksheet.
Chart
On startup, Excel displays a new blank
workbook
An element in the Excel window that displays the value or formula contained in the active cell is the
formula bar
An element of the Excel window that displays the name of the selected cell, table, chart, or object is the:
name box
A box in the upper left corner of the worksheet grid that selects all the cells in a worksheet is the:
select all box
A cell surrounded by a black border and ready to receive data is the
active cell
The feature that generates and extends values into adjacent cells based on the values of selected cells is:
Auto Fill
The default format that Excel applies to numbers is the:
general format
The data that displays in the Formula Bar is referred to as the
underlying value
The type of cell reference that refers to cells by their fixed position in a worksheet is:
absolute
Tiny charts embedded in a cell that give a visual trend summary alongside your data are:
sparklines
An Excel feature that adjusts the width of a column to fit the cell content of the widest cell in the column is:
autofit
The symbols with which you can specify the type of calculation you want to perform in an Excel formula are:
operators
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
The area along the bottom of a chart that identifies the categories of data is the:
category axis
A feature that outlines cells in color to indicate which cells are used in a formula is called:
range finder
A predefined formula that performs calculations by using specific values in a particular order or structure.
Function
Excel functions, such as AVERAGE, that are useful to analyze a group of measurements.
Statistical functions
A predefined formula that adds all the numbers in a selected range.
SUM function
An Excel function that adds a group of values and then divides the result by the number of values in the group.
AVERAGE function
An Excel function that finds the middle value that has as many values above it in the group as are below it.
MEDIAN function
An Excel function that determines the smallest value in a range.
MIN function
An Excel function that determines the largest value in a range.
MAX function
A command that enables you to select one or more rows or columns and lock them in place.
Freeze Panes
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
Conditions that you specify in a logical function.
Criteria
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.
COUNTIF function
Any value or expression that can be evaluated as being true or false.
Logical test
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
Symbols that evaluate each value to determine if it is the same (=), greater than (>), less than (
Comparison operator
A format that changes the appearance of a cell based on a condition.
Conditional format
A shaded bar that provides a visual cue about the value of a cell relative to other cells is a
data bar
The function that retrieves and then displays the date and time from your computer is the:
NOW function
The process of moving within a worksheet or workbook:
navigate
A series of rows and columns that contains related data and that is managed independently from other data is an Excel
table
The process of arranging data in a specific order based on the value in each field is called:
sorting
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
The Excel command that enables you to specify rows and columns to repeat on each printed page is:
print titles
The labels along the lower border of the workbook window that identify each worksheet are the:
sheet tabs
A worksheet where totals from other worksheets are displayed and summarized is a:
summary sheet
The worksheets that contain the details of the information summarized on a summary sheet are called:
detail sheets
The action of placing cell contents that have been copied or moved to the Clipboard into another location is called:
paste
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
The values that an Excel function uses to perform calculations or operations are the:
arguments
The target destination for data that has been cut or copied using the Office Clipboard is the:
paste area
The term used to describe an Excel function that is subject to change each time the workbook is opened is called:
volatile
An Excel function that adds a group of values, and then divides the result by the number of values in the group.
average
An Excel function that determines the largest value in a selected range of values.
max
