a feature that includes pre-made documents that allow the user to fill-in-the blanks to create new documents, such as calendars, invoices, reports, resumes, etc.; enhances user's efficiency and creativity
What is a Template
100
the space formed by the intersection of a row and a column; the basic unit of a worksheet
What is Cell
100
a chart that uses bars of varying height to illustrate values in a worksheet
What is Column chart
100
a feature that allows text to be included with pictures, shapes, or tables without covering or hiding under the image, giving the user control over how the text is position
What is Wrap Text
100
an equation that calculates a new value using values currently on a worksheet
What is Formula
200
cell reference that does not adjust to the new cell location when copied or moved
What is Absolute cell reference
200
returns the average (arithmetic means) of its arguments
What is AVERAGE
200
a vertical group of cells in a worksheet identified by letters
What is Column
200
text created as a graphic image
What is Word/Text art
200
keeps selected rows or columns visible on the screen as the rest of the worksheet scrolls
What is Freeze
300
the use of software application to create, edit, format, print and save text-based documents, such as letters, reports, and memos
What is Word processing
300
also called a soft return; a feature that automatically moves text to the next line when the previous line is full without the user pressing the enter key
What is Word Wrap
300
a graphic representation of values and their relationships: pie, line, column, bar, scattered
What is Chart/graph
300
a feature that allows the user to view synonyms and antonyms, and automatically replace words for enhanced writing
What is Thesaurus
300
a prewritten formula that makes it easy to perform common calculations
What is Function
400
a selected worksheet cell that is ready for data entry
What is Active cell
400
a function that automatically adds the values in the cells directly above or to the left of the active cell
What is Autosum
400
a feature that allows the user to view the current page of a document onscreen in a different ways Example: Normal view, Page Layout, Web Layout, etc.
What is View
400
to copy a cell's contents and/or formatting into an adjacent cell or range
What is Fill
400
alphanumeric text that will not be used in calculations
What is Label
500
the position of data within a cell
What is Alignment
500
value, cell reference, range, or text that acts as an operand in a function formula
What is Argument
500
a unique identifier for a cell which is formed by combining the cell's column letter and row number
What is Cell reference
500
arranging the shape, size, type, and general makeup of a cell or group of cells
What is Format
500
a chart that uses points connected by a line to illustrate values in a worksheet