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