Back to Mrs. Horwitz's Excel Web Site
In an Excel Spreadsheet define the terms and the commands from each chapter.
In the spreadsheet, Sheet 1 should be renamed "Terms", and Sheet 2
should be renamed "Commands". Format Column A to 15 and Column B to
40.
Format Column B as follows:
- Format - Cells
- Alignment-Wrap Text
- Horizontal-Left
- Vertical Top
- Change to Landcape (under Page Tab)
- Add a Header and Page # to each spreadsheet
Terms Spreadsheet: Column A (Term) and Column B (Definition)
Commands Spreadsheet: Column A (Command) andColumn B (Definition).
Chapter 1:
Excel 2003
Terms:
- Excel
- Title Bar
- Menu Bar
- Standard Toolbar
- Formatting Toolbar
- Name Box
- Formula Bar
- Worksheet
- Label
- Value
- Row
- Cell
- Column
- Column Headings
- Row Headings
- Active Cell
- Status Bar
- Scroll Bars
- Worksheet Tabs
- Tab Scrolling Buttons
- Workbook
- Worksheet
- Cell Address
- Name Box
- Go To Dialog Box
- Zoom Size
- Clear the Contents of a Cell
- Undo
- Redo
- Print Preview
Commands:
- What is the command to completing the following:
Move to the beginning of the worksheet.
Move to the last-used cell on the worksheet.
Move to the beginning of the current row.
Move up one screen.
Move down one screen.
Move one screen to the left.
Move one screen to the right.
Move one cell up, down, left, or right.
Move to the edge of a group of cells with data.
Open the Go To dialog box.
Move to the cell that is clicked.
Move to the next cell in a left-to-right sequence.
Move to the previous cell in a right-to-left sequence.
Move to the active cell when it has scrolled out of view.
Move to the previous worksheet.
Move to the next worksheet.
Complete the edit and return to Ready mode.
Cancel the edit and restore the existing data.
Move the insertion point to the beginning of the data.
Move the insertion point to the end of the data.
Delete one character to the right of the insertion point.
Delete everything from the insertion point to the end of the line.
Delete one character to the left of the insertion point.
Move the insertion point one character left or right.
Move the insertion point one word left.
Move the insertion point one word right.
To the Top
Chapter 2
Excel 2003
Terms:
- Labels
- Default Font
- font style
- font size
- format painter
- range
- range address
- selection pointer
- extend selection Mode
- autofit
- value
- currency style
- Format Cells Dialog Box or Ctrl 1
- formula
- arithmetic operators
- function
- autosum button
- average function
- max function
- autocalculate
- count function
Commands:
- What is the command to completing the following:
Keyboard shortcut to bold an item
Keyboard shortcut to apply the size italic to an item
Selects from the active cell, moving in the direction of the arrow.
Selects the current column.
Selects the current row.
Starts Extend Selection mode.
Ends Extend Selection mode.
Extends selection from active cell in the direction of the arrow.
Extends selection from active cell up one screen in the same column.
Extends selection from active cell down one screen in the same column
Extends selection from active cell to beginning of data.
Extends selection from active cell to end of data.
Selects every cell on the worksheet.
K eyboard shortcut to open the format cells dialog box
To the Top
Chapter 3
Excel 2003
Terms:
- autocorrect
- trace error options
- spell check
- Find
- Replace
- character string
- wildcard
- series
- interval
- autofill command
- fill handle
- autoformat
- marker
Commands:
What is the method to completing the following:
- keyboard shortcut to start the find command
- keyboard shortuct to start the find and replace command
To the Top
Chapter 4
Excel 2003
Terms:
- autoComplete
- Pick from List
- windows clipboard
- Cut Command
- Copy Command
- Paste Command
- insert a row or column
- freeze and unfreeze rows and columns
- cell alignment
- Horizontal alignment options
- Vertical alignment options
- center across selection
- wrap text option
- merge and center button
- border
- shading
- comma style button
- decrease decimal button
Commands:
What is the method to completing the following:
- keyboard shortcut to insert a new worksheet
- keyboard shortcut to cut
- keyboard shortcut to copy
- keyboard shortcut to paste
- keyboard shortcut to insert a row or column
- keyboard shortcut to delete a row or column
- method to hide a column
To the Top
Chapter 5
Excel 2003
Terms:
- template
- .xlt
- order of precedence and order of operation
- relative reference
- absolute reference
- mixed reference
- page orientation
- portrait
- landscape
- scaling
Commands:
What is the method to completing the following:
- Keyboard shortcut to display/hide formulas
- Keyboard shortuct to increase a decimal
- Keyboard shortcut to open the format cells dialog box
To the Top
Chapter 6
Excel 2003
Terms:
- syntax
- argument
- Insert Function
- TRUNC Function
- SUMIF Function
- Range
- Criteria
- Average Function
- Arithmetic Mean
- Min Function
- Max Function
- Count Function
- Counta Function
- Date & Time Function
- Serial Number
- Today Function
- Group Sheets
- Fill Across Worksheets
- NOW Function
Commands:
What is the method to completing the following:
- Keyboard shortcut that will insert a new workbook
To the Top
Chapter 7
Terms:
- Spell Checker
- Auto Correct
- Find
- Replace
Commands:
What is the method to completing the following:
- The keyboard shortcut to start the spell checker.
- The keyboard shortcut for Find.
- The keyboard shortcut for Replace.
To the Top
Chapter 8
Terms:
- Format
- Full Precision
- Procision as Displayed
- Wrap Text
- Rotate Text
Commands:
What is the method to completing the following:
- The keyboard shortcut for open the Format Cells feature
- The keyboard shortuct to create a line break
- The menu commands to hide rows
- The menu commands to unhide rows
- The menu commands to hide columns
- The menu commands to unhide columns
- The menu command to center information across the columns
- The menu command to surpress zeros in the worksheet.
To the Top
Chapter 9
Excel 2003
Terms:
- Chart
- Object
- Selection handles
- Chart area
- Category axis
- Category title
- Value axis
- Plot area
- Chart title
- Data series
- Data point
- Data marker
- Legend
- Gridline
- Tick Mark
- Data Label
- Wizard
- Gradient
- Texture
- Pattern
- Combination chart
- Secondary scale
Commands:
What is the method to completing the following:
- The keyboard shortcut to create a bar chart
To the Top
Chapter 10
Excel 2003
Terms:
- chart
- embedded chart
- object
- selection handles
- chart area
- category axis
- category title
- value axis
- plot area
- chart title
- data series
- data point
- data marker
- legend
- tickmark
- data label
- wizard
- gradient
- texture
- pattern
- combination chart
- secondary scale
Commands:
What is the method to completing the following:
- Keyboard shortcut to automatically create a column chart
To the Top
Chapter 11
To the Top
Chapter 12
To the Top
Chapter 13
Excel 2003
Terms:
- list
- sorting command
- ascending sort
- descending sort
- named range
- filter
- autofilter
- wildcard
- pirnt area
- live link
- view
- text file
Commands:
What is the method to completing the following:
To the Top
Chapter 14
Terms:
Group Sheets
Arrange Windows
Maximize Button
Minimize Button
Restore Button
Commands:
What is the menu command to arrange the windows?
What is the menu command to cloase all workbooks?
What is the menu command to delete a sheet?
What is the menu command to insert a worksheet?
What is the keyboard shortcut to Maximize a Window?
What is the keyboard shortcut to Minimize a Window?
What is the keyboard shortcut to Restore a Window?
What are the keyboard shortcuts to Switch to the Next Window?
What are the keyboard shortcuts to Switch to the Previous Window?
To the Top
Chapter 15
Excel 2003
Terms:
- range names
- constant
- VLookup
- Table_Array
- HLookup
- circular reference
- reference functions
- hyperlink
- rows function
- array
- index function
- transpose
Commands:
What is the keyboard shortcut to enter the date?
What is the keyboard shortcut to paste names?
To the Top
Chapter 16
To the Top
Chapter 17
Terms:
- Chart
- Chart Types -List them (page 418)
- Define the Chart Types- Area, Bar, Column & Pie
- Chart Objects
- category axis
- value axis
- plot are
- data marker
- legend
- tick mark
- data point
- data series
Commands:
What is the method to completing the following:
- Keyboard shortcut to create a chart.
- Menu steps to create a chart
To the Top
Chapter 18
To the Top
Chapter 19
Terms:
- Database
- List
- Field
- Record
- Field Name
- Data Form
- Criteria
- Ascending Order
- Descending Order
Commands:
What is the method to completing the following:
- Menu command toe enter a data series.
- Menu command to display the data form
- Menu command to stor ascending or descending order.
To the Top
Chapter 20
Terms:
- Filtering
- AutoFilter
- Comparison Operator
Commands:
What is the method to completing the following:
- Menu commands to turn the AutoFilter on.
- Commands to use comparison operators in a filter.
To the Top
Chapter 21
To the Top
