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

BCIS Vocabulary Lesson 1, Exercises 1-5 (Excel)

AB
WorkbookAn Excel file with one or more worksheets.
WorksheetThe work area for entering and calculating data made up of columns and rows seperated by gridlines (light gray lines). Also called a spreadsheet.
CellA cell is the intersection of a column and a row on a worksheet. You enter data into cells to create a worksheet
Active cellThe active cell contains the cell pointer--a dark outline around the cell.
Formula barAs you enter data in a cell, it simultaneously appears in the Formula bar, which is located above the worksheet frame.
Cell referenceThe location of a cell in a worksheet identified by its column letter and row number. This is also known as the cells address.
scrollA way to view locations on the worksheet without changing the active cell.
Sheet tabsTabs that appear at the bottom of the workbook window, which display the name of each worksheet.
Tab scrolling buttonsButtons that appear just to the left of the sheet tabs, which allow you to scroll hidden tabs into view.
Blank workbookThe Excel default workbook contains three worksheet tabs or sheets.
TemplateA workbook with certain labels, formulas, and formatting present, saving you time in creating commonly used forms, such as invoices or purchase orders.
LabelText in the first row or column of a spreadsheet that identifies the type of data contained there.
DefaultsThe standard settings Excel uses in its software, such as column width or number of pages in a workbook.
UndoThe command used to reverse one or a series of editing actions.
RedoThe command used to redo an action you have done.
AutoCompleteA feature used to complete an entry based on previous entries made in the column containing the active cell.
Pick From ListA shortcut used to insert repeated information.
AutoCorrectA feature used to automate the correction of common typing errors
Spelling CheckerA tool used to assist you in finding and correcting typographical or spelling errors.
ValueA number entered in the worksheet.
Numeric labelA number entered in the worksheet as a label, not a value--such as the year 2002 used as a column label.
Label prefixAn apostrophe (') used to indicate that a number is really a label and not a value.
SeriesA list of sequential numbers, dates, times, or text.
Standard column widthThe default number of characters that display in a column based on the default font.
FormulaAn instruction Excel uses to calculate a number.
Mathematical operatorsSymbols used in mathematical operations: + for addition, - for subtraction, * for multiplication, / for division, and ^ for exponentiation.
Order of mathematical operationsThe order in which Excel performs the calculations specified in a formula


Kingwood High School
TX

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