Excel
The _______ is the cell into which you are entering data
active cell
____________ are cell values that you can change to determine new values for formulas
assumptions
The __________ is an area on the excel status bar where you can view a total, an average, or other info about a selected range
autocalculate area
________ is a feature that automatically detects and corrects typing error and misspelled words
autocorrect
__________ are file system or document properties, such as the date you create or change a file, and statistics, such as the file size
automatically updated properties
The ________ is an excel function that calculates the average value of a collection of numbers
average function
________ is an excel feature that automatically increases or decreases the width of a column so that the widest entry will fit
best fit
A _________ is the box, formed by the intersection of a column and a row, where you enter data
cell
The _______ is the column letter and row number location that identifies a cell within a worksheet, such as A1
cell reference
A ________ is a predesigned combination of font, font size, and font color that you can apply to a cell
cell style
A ___________ is defined as a letter, number, symbol or punctuation mark
character
A __________ is a graphic element that illustrates data
chart
A______ is a separate sheet in a workbook that contains only a chart, which is linked to the workbook data
chart sheet
A _________ is an error that occurs when one of the defining values in a cell is itself
circular reference
Each ________ on a menu performs a specific action, such as saving a file or obtaining help
command
________ is special formatting: the font, font color, background fill, and other options-that is applied if cell values meet specified criteria
conditional formatting
A _______ is a column or row in a data sheet and also the set of values represented in a chart
data series
________ is the process of finding and correcting errors in the worksheet
debugging
The range of cells to which you are pasting is called the ________
destination area
The _______ is the range being used as a destination in a data exchange
destination range
A ________ displays a dialog box or a pane with more options for the group when clicked on
dialog box
A __________ occurs when a formula refers to the same cell in which it is entered
direct circular reference
_______ are details about a file such as the project author, title, and subject
document properties
Using the mouse to move or copy cells is called _____________
drag and drop
_________ is the mode in which you can make changes to a cell's content directly in the cell
edit mode
A ______ is the name assigned to a file when you save it
file name
The ________ is a black square that appears in the lower right corner of a selected cell or range
fill handle
_________ is an excel feature that looks for patterns in the data and automatically fills or formats data in remaining cells based on those patterns
flash fill
A _________ is an electronic container that helps you organize your computer files, like a cardboard folder on your desk
folder
The ________ defines the appearance and shape of letters, numbers and special characters
font
__________ refers to the color of the characters in a spreadsheet
font color
The __________ refers to the size of characters, measured in units called points
font size
A ________ is a format that indicates how characters are emphasized, such as bold, underline, and italic
font style
A __________ is text and graphics that print at the bottom of each page
footer
You _________ a worksheet to enhance the appearance of information by changing its font, size, color or alignment
format
___________ assign a format to numbers as the are entered
format symbols
A ___________ is a mathematical statement in a spreadsheet or table cell that calculates a value using cell references, number, and arithmetic operators
formula
The _________ is the area above the worksheet grid where you enter or edit data in the active cell
formula bar
A _______ is a special, predefined formula that provides a shortcut for a commonly used calculation such as sum or count
function
A _______ is a collection of choices, arranged in a grid or list, that you can browse through before making a selection of items such as fonts
gallery
________ involves reducing the electricity consumed and environmental waste generated when using computers, mobile devices, and related technologies
green computing
The evenly spaced horizontal and/or vertical lines used in a worksheet or chart are called __________
gridlines
Each _______ is a tab element on the ribbon that contains related commands
group
A _________ is information that exists on paper
hard copy
A __________ is text and graphics that print at the top of each page
header
_________ involves editing the contents of a cell directly into the cell
in-cell editing
An ______ occurs when a formula in a cell refers to another cell or cells that include a formula that refers back to the original cell
indirect circular reference
__________ is the default excel mode that inserts a character and moves all characters to the right of the typed character one position to the right
insert mode
__________ are labels that appear over each tab and command on the ribbon when the ALT key is pressed
keytips
__________ describes the page orientation in which the page is wide than it is tall
landscape orientation
_________ is an office feature that shows the results that would occur in your file, such as the effects of formatting options on a document's appearance
live preview
__________ are the space between the page content and the edges of the page
margins
A _________ is a list of related items, including folders, programs, and commands
menu
When you _________ cells, you combine multiple adjacent cells into one larger cell
merge
The ______ is an area on the right side of the title bar that contains the sign in link you can use to sign in to your microsoft account
microsoft account area
The __________ determines the lowest number in the range
min function
The _______ is a small toolbar that appears automatically next to selected text and that contains the most frequently used text formatting commands, such as bold, italic, font color, and font size
mini toolbar
The __________ is a box to the left of the formula bar that shows the cell reference or name of the active cell
name box
The _________ returns a number that corresponds to the system date and time beginning with december 31, 1899
now function
A ______ is an amount or value using any of the following characters: 123456789+-(),/.$Ee, as well as blank space
number
The __________ is a temporary storage area in the computer's memory that allows you to collect text and graphics from any office document and then paste them into almost an other type of document
office clipboard
The ___________ is the sequence in which operators are applied in a calculation
order of operations
In _________ mode, excel replaces, or overtypes, the character to the right of the insertion point
overtype mode
____________ view provides an accurate view of how a worksheet will look when printed, including headers and footers
page layout view
A ________ is a section of a window that can remain open and visible while you work in the document
pane
A _________ is an onscreen view of your document prior to printing, to see exactly how the printed document will look
preview
The ____ is a customizable toolbar at the left edge of the title bar that contains buttons you can click to perform frequently used commands
quick access toolbar
A ________ is a series of two or more adjacent cells in a column, row or rectangular group of cells, notated using the cell address of its upper left and lower right corners
range
__________ checks which cells are referenced in the formula assigned to the active cell
range finder
A __________ is a cell address that automatically changes to reflect the new location when the formula is copied or moved
relative reference
Cells that automatically change to reflex the new location when the formulas area copied or moved
relative references
The _______ is a horizontal strip near the top of the window that contains tabs of grouped command buttons that you click to interact with the app
ribbon
The _________ is the box containing the row number to the left of a worksheet row
row heading
__________ determines how the worksheet fits on the page
scaling
A _______ is a label that appears when you point to a button or object, which may include the name, purpose, or keyboard shortcut for the object
screentip
________ on the right edge and bottom edge of a document window let you view a document that is too large to fit on the screen at once
scroll bars
To _________ a cell is to make it active by clicking or tapping it
select
A ________ is an indicator at the bottom of the window that identifies a worksheet
sheet tab
A range of cells you are cutting or copying is called the ________
source area
The ________ is a range being used as a source
source range
________ is a command that checks for spelling errors by comparing words on the worksheet against words contained in its standard dictionary
spelling checker
_________ are document properties associated with all microsoft office files and include author, title and subject
standard properties
The _________ is a clickable button in the lower left corner of the windows 10 start screen that you click to open the start menu
start button
The ________ provides access to all programs, documents, and settings on the computer
start menu
The _______ is the gray bar at the bottom of the excel window that shows status information about the currently open worksheet, as well as view buttons and zoom controls
status bar
Each ________ in the ribbon contains a group of related commands and settigns
tab
A _________ is a single sheet in a workbook file that lets youbenter and manipulates data, perform calculations with data, and analyze data
worksheet
A column letter in a box above the grid is called the _________
column heading
A saved workbook is called a __________
file
__________ displays the highest value in a range
max function
A ___________, which is short for picture element, is an individual point of color on a display screen or printout
pixel
A ________ is a unit of measure used for font size and is equal to 1/72 of an inch
point
_______ allows you to select cells for use in a formula by using the pointer or a screen tap
point mode
_________ is the measurement used to determine size of font
point size
_______ describes a printer copy with a short edge at the top of the printout
portrait orientation
The ________ adds all the numbers in a range of cells
sum function
The ________ is a textbox to the right of the ribbon tabs that is used to find a command or to access the office help system
tell me box
________ is any set of characters containing a letter, hyphen, or a space
text
A ________ formats a worksheet by applying a collection of fonts, font styles, colors, and effects to give it a consistent appearance
theme
________ are tabs that appear when you perform certain tasks or work with objects, such as pictures or tables
tool tabs