Excel Cells
Features of Word and Excel
Common Features Terms
More Excel Functions
MISC
100
The intersection of a column and a row
What is a cell
100
Graphics including pictures, ClipArt, charts, shapes, diagrams, lines and so on
What are drawing object
100
A folder within a folder
What is a subfolder
100
Predefined formula that adds all the numbers in a selected range of cells
What is SUM function
100
Tiny charts embedded in a cell that give a visual trend summary alongside your data
What are sparklines
200
Anything typed into a cell
What is cell content
200
Formats that make pictures look like sketches or paintings
What are artistic effects
200
The user interface that groups commands on tabs at the top of a program window
What is the Ribbon
200
A group of functions that tests for specific conditions and which typically use conditional tests to determine whether specific conditions are true or false
What are logical functions
200
The Excel feature that generates and extends values into adjacent cells based on the values of selected cells
What is Auto Fill
300
A vertical group of cells in a worksheet
What is a column
300
Changes the appearance of a cell based on a criteria
What is conditional formatting
300
Small pictures that represent a program, a file, a folder, or an object
What are Icons
300
Uses a logical test to check whether a condition is met and then returns one value if true and another value if false
What is the IF function
300
A predesigned set of colors, fonts, lines, and fill effects that look good together and that can be applied to your entire document or specific items
What is Theme
400
A horizontal group of cells in a worksheet
What is a row
400
The manner in which text displays around an object
What is text wrapping
400
One or more keys pressed to perform a task that would otherwise require a mouse
What are keyboard shortcuts
400
The values that Excel uses to perform calculations or operations
What are arguments
400
The small black square in the lower, right corner of an active Excel cell that allows you to copy formulas
What is the fill handle
500
The box in the upper left corner of the worksheet grid that selects all cells in a worksheet
What is the select all box
500
The values in parentheses in Excel
What are arguments
500
The program that displays the files and folders on your computer
What is Windows Explorer
500
A statistical function that counts the number of cells within a range that meets the given conditions or criteria that you provide
What is COUNTIF
500
An area of the start menu that displays all the available programs on your computer system
What is All Programs
M
e
n
u