COSC1371-02
TEST-2 Review:
Spring 2006
A. Internet Explorer/YAHOO
Shortcut keys:
CTRL+O: Open a website
CTRL+P: Print current page
F5: Refresh
Starting page:
Home page designated (by using “Internet Options…” Command on TOOLS
bar)
or the current page or a
Blank page.
ToolBars: Standard toolbars: Back, Forward, Stop, Refresh, Home, Search,
Favorites, History
The last three
buttons divide the page into two panes (The left one is for
Folders)
Address bar
(where you can enter an URL to open a page)
Links Bar (you
can drag an address icon onto this bar for an easy opening of a
page)
YAHOO: A Search engine that helps us locate sites we
want.
Other functions: E-mail, Home-page building, Instant messenger, Online
Games.
Geocities: Home builder
Two tools: Page Wizards and
Page Builder (More advanced)
The
former lets us set up up to 4 links, specify the Title, or include an
image.
Once built, the page can be updated or deleted by File
Manager.
B. WORD2003
Additional bars: Formatting
toolbar, Selection bar (hidden vertical), Horizontal Ruler.
Those bars can be hidden or moved around.
Formatting toolbar: Style, Font, Font size, Bold, Italic, Underlining,
Alignment, Numbering, Bullets,
Font
Color,
Superscript, Subscript.
Text selection:
Selection Bar: Single-click:
one line, D-click: A paragraph.
Triple-click (or CTRL+A): Whole document
Shortcut keys:
CTRL-A: Select the whole document except Header/Footer
CTRL-S (Save and Not Save As)
CTRL-P (Printing) Options:
Page range: All, Current page or certain pages specified.
Orientation: Portrait, Landscape
Number of copies:Collate
Page order: Front to Back or Back to Front.
CTRL-Z: Undo/cancel Almost any number
of previous actions can be undone at the same time
CTRL-Y (Redo)
Doing canceled actions.
CTRL-X: Cut.
CTRL-C: Copy.
CTRL-V: Paste.
CTRL-O: Open
CTRL-Enter: Manual (or
Hard)page break insertion
Home: Start of current line.
End: The end of current line.
CTRL-Home: Document beginning
CTRL-End: Document
end.
Shift-Home: The prefix of
current line.
Shift-End: The suffix of current line.
PgDn: Move 24 lines down (10
points font size) PgUp:
Move 24 lines up
F1: WORD Help Shift-F1: What’s this
tip.
F7: Spelling/Grammar.
Shift-F7: Thesaurus
INSERT Menu: Break
(Page, Column, Section), Picture
(Clip Art, From File, From Scanner/Camera),
and File
TOOLS Menu: Spelling/Grammar (F7), Language (Thesaurus,
Hyphenation)
FORMAT Menu
Font, Paragraph, Bullets and Numbering, Columns
Paragraph: Indents and Spacing, and Line and Page Breaks (Widow/Orphan
Control, Keep
Lines together (No page break within a paragraph)
Tables: Max size: 63 columns and 32767 rows.
Only rows are sorted using columns as sorting keys (up to 3 of them)
ascending or descending.
AutoFormat lets us choose from many styles and column width automatically
adjusted.
A new row can be created just before or after the one selected, and
likewise for a new column.
Multiple columns (by COLUMNS Button) viewed in Print Layout VIEW but not
in Normal VIEW.
TAB: Next cell of the same row, or
first cell of next row or creates a new row after last row.
CTRL-HOME: Cell
A1
CTRL-END: Last
cell
CTRL->: Last column of the same
row
CTRL <-:
First column of the same row.
2.
WorkSheet Size:
256 columns and 65,536 rows
3.
Data Types: Number, Label, Formula (“=” must
appear in the first position of a cell)
4.
Cell references:
Absolute($E$9): Adjusted only when the cell identification itself
changes
due
to inserion/deletions of other cells/rows/columns
Relative (E9)
Automatically adjusted when copied as well as above
cases
5.
Automatic Range conversion:
A3:F10 (Standard) A10:F3
F3:A10
F10:A3
6.
Function categories on “paste function”
Button
All, Financial,
Statistical, Math &
Trig, Logical, etc
7.
Financial functions:
FV(0.5%, 12, -1000) = $12,335
FV(0.5%, 240, -1000) = $462,040
PMT (rate, nPer, Principal)
SLN (Cost, Salvage, Life): Straight-line depreciation (same depreciation
amount for all
periods)
SYD(Cost, Salvage, Life, Period)
Sum-of-Years Digits Dep (Amount decreases as time goes
on)
DDB(Cost, Salvage, Life, Period) Double-Declining Dep ( Amount decreases
as time goes on)
For the First period (year)
DDB > SYD > SLN
For the last period (year) DDB < SYD < SLN
8.
Other functions.
SUM
IF(Condition, TrueValue, FalseValue)
POWER(4,3) = 4*4*4 =
64
9.
Copying cells containing cell
references
COPY/PASTE
Commands
Fill
Handle (Also useful for Label series like “Monday Tuesday Wednesday
…”