Shortcuts

Front 1

It displays the name of the document and the name of the program(application). example - document 1 -Microsoft Word.

Back 1

Title Bar

Front 2

It displays the names of the main menus. They are file, edit, view, format, tools, table, window, help. Main menus can contain arrows which open submenus.

Back 2

Menu Bar

Front 3

It displays buttons for accessing commonly used commands such as saving, opening and printing a file.

Back 3

Standard Toolbar

Front 4

It displays buttons for accessing common features and commands such as bold, italic and centering.

Back 4

Formatting Toolbar

Front 5

It measures the width of the document and displays information such s margins, tab stops and indents.

Back 5

Horizontal Ruler

Front 6

It measures the height of the document page and is only displayed in print layout view.

Back 6

Vertical Ruler

Front 7

It displays the name of the element (icon) on which the mouse pointer is resting or pointing.

Back 7

Screen Tip

Front 8

A blinking vertical line that displays to the right of the space where characters are inserted into the document.

Back 8

Insertion Point

Front 9

It is used with the mouse to shift the on-screen display up and down or left to right

Back 9

Scroll Bars

Front 10

The white area where you type the document.

Back 10

Document Window

Front 11

They are used to change the way a document is displayed. These options are also available on the view menu. They are print layout, web layout, ouline view, and normal.

Back 11

View buttons

Front 12

It displays information such as the currently displayed page, section, how many pages are in the document, where the insertion point is located and which mode buttons are active.

Back 12

Status Bar

Front 13

They are used to change the way word operates to make creating and editing documents easier. OVR is an example of one of these buttons and is actived by pressing the insert key.

Back 13

Mode Buttons

Front 14

It answers questions and offers suggestions about word features. It can look like a paperclip.

Back 14

Office Assistant

Front 15

Ctrl + P

Back 15

Print

Front 16

Ctrl + V

Back 16

Paste

Front 17

Ctrl + N

Back 17

File New

Front 18

Ctrl + C

Back 18

Copy

Front 19

Ctrl + O

Back 19

File Open (folder)

Front 20

Ctrl + S

Back 20

Save

Front 21

Ctrl + A

Back 21

Select All

Front 22

Ctrl + F

Back 22

Find

Front 23

F7

Back 23

Check Spelling

Front 24

Ctrl + X

Back 24

Cut

Front 25

Ctrl + Z

Back 25

Undo

Front 26

Print

Back 26

Ctrl + P

Front 27

Cut

Back 27

Ctrl + X

Front 28

Save

Back 28

Ctrl + S

Front 29

F3

Back 29

Starts up Find from the Desktop

Front 30

F5

Back 30

Refresh Contents

Front 31

Crtl + F4

Back 31

Closes Active Window in Program

Front 32

Alt + Enter

Back 32

Opens Properties Window for selected Icon or Program

Front 33

Shift + F10

Back 33

Simulates right click on selected item.

Front 34

WINKEY + D

Back 34

Minimizes all windows and returns the user to the desktop.

Front 35

WINKEY + M

Back 35

Minimizes all windows.

Front 36

WINKEY + SHIFT + M

Back 36

Undo the minimize.

Front 37

WINKEY + E

Back 37

Opens IE

Front 38

WINKEY + TAB

Back 38

Cycle through open programs through the taskbar.

Front 39

displays the application icon,the name of the file, and the name of the current application

Back 39

Title bar

Front 40

displays a list of menus such as File, Edit, View, and Format. When you click on each menu you get a list of commands

Back 40

Menu bar

Front 41

is a row of icons that gives you quick access to editing commands

Back 41

Standard toolbar

Front 42

is a second row of icons that gives you quick access to various formatting commands

Back 42

Formatting toolbar

Front 43

allows you to add visual effects, shapes, and graphics to a document by using AutoShapes, text boxes, WordArt, lines, and arrows

Back 43

Drawing toolbar

Front 44

allow you to move up and down and from side to side within a document

Back 44

Scroll bars

Front 45

is useful for adjusting the margins of a document and the indentation of paragraphs

Back 45

Ruler

Front 46

a tool that allows you to jump to specific areas within a Word document

Back 46

Select browse object

Front 47

active cell

Back 47

cell ready for data entry

Front 48

alignment

Back 48

When data is entered into a cell, labels will align on the left and values will align on the right.

Front 49

Cell

Back 49

Intersection of a row and a column and identified by a cell reference

Front 50

Cell range

Back 50

A selected group of cells that form a rectangle

Front 51

Cell Reference

Back 51

The column letter and the row number. Example: B12

Front 52

Column

Back 52

Identified by letters that appear at the top of the spreadsheet. (Vertical)

Front 53

Formula

Back 53

Equations with symbols for math operations. A formula begins with an equals sign. Example= B6+B7+B8+B9

Front 54

Function

Back 54

Special formulas that do not use operations to calculate a result. I.E. a shortcut formula. Example: =Sum(A6:A9)

Front 55

Label

Back 55

text, symbol, date, or number not used in calculations

Front 56

Rows

Back 56

identified by numbers that appear at the left of the spreadsheet. (Horizontal)

Front 57

Spreadsheet

Back 57

a program that allows you to use rows and columns of data to mange, predict, and present information

Front 58

value

Back 58

a number entered into a spreadsheet cell that will be used for calculations

Front 59

types of cell formatting

Back 59

general, number, currency, percentage, text, comma, date

Front 60

printing options

Back 60

(file, Page Setup): Portrait, Landscape, With/without gridlines, With/without row and column headings

Front 61

basic spreadsheet functions

Back 61

addition, subtraction, multiplication, division

Front 62

data types

Back 62

labels (left default alignment), data expressed in words, symbols, dates, or numbers not used in calculations; values (right default alignment, data expressed in numbers; formulas (algebraic format of formulas)

Front 63

alternate input devices

Back 63

PDA, Tablet PC, Speech Recognition, virtual keyboard

Front 64

keyboard or menu commands

Back 64

mouse, arrow keys, enter

Front 65

personal/home uses

Back 65

budget, check book, car loans, grades, investments

Front 66

business uses

Back 66

payrolls, budgeting, investments, inventory costs, loan payments

Front 67

spreadsheet applications

Back 67

budgets, checkbook, product prices, payroll, financial statements, profit/loss statements, company bids

Front 68

textbox

Back 68

_____________ is movable resizable container for text or graphics

Front 69

linked object

Back 69

_______ ______ maintains connection b/w two files

Front 70

source file

Back 70

______ ________ is created in and destination file it’s inserted into

Front 71

external reference

Back 71

reference to cell or range of cells on sheet in another Excel workbook, or reference to defined name in another workbook

Front 72

linking

Back 72

__________ reference to cell or range of cells on sheet in another Excel workbook, or reference to defined name in another workbook

Front 73

linked objects

Back 73

use ______ ________ when u want information in destination file to be updated as source data changes

Front 74

embedded object

Back 74

use ________ _________ when you don’t want to update the copied data as it changes in the source file

Front 75

linked object

Back 75

linked to source file

Front 76

embedded object

Back 76

no connection to source file

Front 77

source file

Back 77

updates the linked object

Front 78

Name 3 system resources to troubleshoot a scanner

Back 78

A) Direct Memory Access (DMA) Channel B) I/O Address C) Interrupt Request (IRQ)

Front 79

Name the most common problem with Scanners

Back 79

IRQ conflicts with Network Interface and Sound cards

Front 80

2 symptoms that there is an IRQ conflict between a Scanner and another device:

Back 80

A) Scanner does not scan even though power is on and scanner lights are active. B) A misaligned Scanner image on the screen.

Front 81

Name 4 common Tape device problems:

Back 81

A) Incorrect formatting B) Incorrect insertion into the drive C) Physical Damage D) write protection

Front 82

Name the most common problem with Tape drives in a Networked enrironment:

Back 82

The user does not have sufficient rights to backup or restore files on the network.

Front 83

Symptom: 6 short beeps on boot up:

Back 83

Keyboard error: Problem with attached keyboard or the internal keyboard electronics.

Front 84

Symptom: IBM compatible 301 error code:

Back 84

Keyboard did not respond to software reset or a stuck key has been detected.

Front 85

Symptom: Failure of characters to appear when you enter them on keyboard.

Back 85

Faulty or unplugged keyboard

Front 86

Incorrect characters display on screen.

Back 86

Incorrect language settings

Front 87

Your keyboard doesn't work. You replace it with a new keyboard and it doesn't work. What do you need to check?

Back 87

You need to troubleshoot the keyboard controller. If it is faulty, you may need to replace the system board.

Front 88

Name the 3 steps to service a faulty keyboard

Back 88

1) remove the back cover from the keyboard. 2) Check for the presence of a fuse in the 5 volt DC supply 3) Check the fuse for continuity

Front 89

True of False: You cannot hot swap a 5 pin DIN or 6 pin Mini-DIN keyboard

Back 89

True - Doing so may damage the keyboard or System board.

Front 90

Two steps to take when troubleshooting software or port problems for a mouse:

Back 90

A) Reboot in Safe Mode B) Check settings in CMOS setup utility.

Front 91

XP HW Requirement: Processor

Back 91

300MHz or higher Intel compatible Processor

Front 92

XP HW Requirement: Memory

Back 92

128MB

Front 93

XP HW Requirement: Free Hard Disk Space

Back 93

1.5GB

Front 94

XP HW Requirement: Floppy Disk

Back 94

Not Required

Front 95

XP HW Requirement: CD-ROM

Back 95

Required

Front 96

XP HW Requirement: Video

Back 96

SuperVGA or better

Front 97

XP HW Requirement: Mouse

Back 97

Required

Front 98

XP HW Requirement: Keyboard

Back 98

Required