Java Games: Flashcards, matching, concentration, and word search.

Excel Test 2 (Chapter 3) Study Guide

This study guide refers primarily to Chapters 3 & 4. It reviews information on the second test given in Excel.

AB
HyperlinkCommand on the Insert Ribbon that creates a link to a web page, picture, email address, or program in a worksheet
ClearCommand that deletes data in a cell
Format CellsDialog box that contains the commands to format information in a specific style, such as an exact date or time
Fill HandleMost efficient way to copy formulas to adjacent cells simultaneously
Formula BarThe "Insert Function" button lies here, next to its window
Name BoxThe area on the left side of the Formula Bar that shows the cell address of a selected cell
Drag and DropThe process of using the mouse to move or copy cells
Fill SeriesThe default command on the Auto Fill Options Dialog Box (at the end of the series)
AutoFitTool used to change the width of a column so that the widest entry will fit
Fill HandleThe small black square in the lower-right corner of the heavy border of an active cell that repeats the cell's value in adjacent cells
CopyMS Excel's feature that makes an exact replica of the cell data and format while keeping the original cell intact
EntryData keyed into a cell
RowContains all information about one element on a worksheet
LabelItems in a spreadsheet that can't be manipulated with math, such as column or row headings or sheet titles
AutoFillCommand that would allow the user to key large amounts of consecutive information, such as numbers 1-100, easily
CutCommand that removes data from one cell and puts it in another
ValueNumber, formula, or function data in a cell that can be manipulated using mathematics
Cell StylesCommand that quickly formats a cell using predefined information such as font type, color, size, and background. Users can also personalize their cell's look using this.
Merged CellCell combined with one or more other cells; often used for titles
Format PainterCopies the style of a selected cell and puts it into (an)other cell(s)
RangeGroup of cells that together form a rectangle or a square; they are named by the name of the first cell in the upper left corner : last cell in the lower right corner


BusinessTeacher
Highlands School
NC

This activity was created by a Quia Web subscriber.
Learn more about Quia
Create your own activities