wps.pearsoncustom.comwps.pearsoncustom.com/wps/media/objects/2407/2464931/exp... · web viewto the...

Crosswords and Word Find PuzzlesHave fun while you learn!

To The Student: Almost everyone enjoys a good puzzle. With this in mind, we have created a series of unique crossword and “word find” puzzles to accompany our series, Exploring Microsoft® Office 2003. Every chapter has two puzzles, one of each type. We suggest that you start with the “word find” and use the list of key words and concepts at the end of the chapter to determine what each clue represents, and then locate the corresponding word or phrase in the puzzle. You can then try the accompanying crossword which repeats clues from the “word find” to reinforce the material, and which adds additional clues to challenge you further. And if you are up to a real challenge, try the composite (Sunday) crossword puzzles that combine the clues from multiple chapters in a single puzzle. We look forward to your comments.

Bob and [email protected]@miami.edu

List of PuzzlesGetting Started with Windows XP ...............................................................................................1

Microsoft® Office 2003 Word Chapter 1 – Introduction: What Will Word Processing Do For Me?..............................................3 Chapter 2 – Gaining Proficiency: Editing and Formatting ..............................................................5Chapter 3 – Enhancing a Document: The Web and Other Resources .............................................7Chapter 4 – Advanced Features: Outlines, Tables, Styles, and Sections .........................................9Super Challenge – Chapters 1 to 4..................................................................................................11

Microsoft® Office 2003 Excel Chapter 1 – Introduction to Microsoft Excel: What Is a Spreadsheet? ..........................................13Chapter 2 – Gaining Proficiency: The Web and Business Applications .......................................15Chapter 3 – Graphs and Charts: Delivering a Message .................................................................17Chapter 4 – Spreadsheets in Decision Making: What If? ..............................................................19Super Challenge – Chapters 1 to 4..................................................................................................21

Microsoft® Office 2003 Access Chapter 1 – Introduction to Microsoft Access: What Is a Database? ............................................23Chapter 2 – Tables and Forms: Design, Properties, Views, and Wizards .....................................25Chapter 3 – Information from the Database: Reports and Queries ................................................27Chapter 4 – Proficiency: Relational Databases, External Data, Charts, and the Switchboard ......29Super Challenge – Chapters 1 to 4..................................................................................................31

Microsoft® Office 2003 PowerPoint Chapter 1 – Introduction to PowerPoint: Presentations Made Easy ..............................................33Chapter 2 – Gaining Proficiency: Slide Show Tools, the Web, and Slide Masters .......................35Super Challenge – Chapters 1 to 2..................................................................................................37 Microsoft® Office 2003 Outlook.................................................................................................39

Essential Computing Concepts....................................................................................................41

Internet Explorer and the World Wide Web.............................................................................43

Getting Started with Windows® XP

Directions: Figure out the word or phrase that each clue represents, then find the word in the grid. (Every word or its abbreviation appears in the list of key words and concepts at the end of the chapter.) Words can go horizontally, vertically and diagonally in all eight directions.

Command that duplicates a fileCommand that erases a file

Windows operations take place hereView with file size and date

Indicates program that created fileHelps to organize files

Displays available choicesRadio and CD in a single program

Provides access to pull-down menusInterface between computer and telephone

Command that changes location of a fileAllows multiple programs in memory

Signifies mutually exclusive itemsStores deleted files

Command to change a file nameProvides quick access to a program

Displays information about the windowContains buttons for open programsView that displays miniature imagesAppears at the top of every window

Contains icons for common commandsHierarchical view of PC

Operating System

© 2004 – For use with the Exploring Office Series by Grauer and Barber Page 1

H N F R J R E C Y C L E B I N R T F R K

J Q I C E Y F T V R R T U C T R O H S Y

W D L M K Y H S R K A H H F K X L J T T

Z D E P X R A R L A N B T K Z K J N C K

C Q T T Z B F L L I B W E M M L L M T R

F T Y K M O M M P F A S T L G C E P R O

Q R P L L N W Y U A D N U N T D T B A P

X G E D F W K P R L I E B T O I R M B T

N B E D J K M O W T T D T M A M T G U I

Y R F X J T K C R I K I E A U T P G N O

S L L H R N P E T N N L T M I H S N E N

R M F H N T N H F N N D Q A R L T V M B

A K T M R A D T K Q B J O G S R S E K U

B Y Y R M R Q W F B R P T W A K T H T T

K M M E D X O B T S I L L B S E I X M T

S L K J Y N K N F T R R L L L X X N V O

A D E S K T O P L H M O V E N R P T G N

T K Q R R R B H D G O B D C K C Y G D T

G Y T C L Y R F N T L C J Q L F G K K M

Q Q W I N D O W S E X P L O R E R M Y Q

(c) Grauer and Barber 2004 - www.prenhall.com/grauer

Getting Started with Windows® XP

Across

3 Shows date file was last modified 5 Contains instructions to computer 8 Folder with tools to customize a PC 9 Windows operations take place here10 Indicates program that created file11 Provides access to pull-down menus12 Displays context-sensitive menu14 Operating system15 Command to cancel last operation19 Provides quick access to a program21 Interface between computer and phone22 Helps to organize files23 Contains buttons for open programs25 Command that changes location of a file26 Displays information about the window27 Ctrl+X is the keyboard shortcut29 Command that changes a file name30 Helps you locate lost files31 Ctrl+V is the keyboard shortcut32 Stores files deleted from a hard drive34 Hierarchical view of devices on PC

Down

1 Signifies mutually exclusive items 2 Required for Windows Messenger 4 Contains icons for commonly used

commands 6 Command that duplicates a file 7 Allows multiple programs in memory11 Personal folder provided for data files13 View that displays miniature images16 Begin here17 Radio and CD in a single program18 Command that erases a file19 Appears if contents don't fit in window20 Appears at the top of every window24 Returns to previous window28 Protects computer from unauthorized

access33 Ctrl+C is the keyboard shortcut

1 2 3 4

5 6

7 8

9

10 11

12 13 14

15 16

17 18 19 20

21 22 23 24

25

26

27

28

29 30

31

32 33

34

(c) 2004 Grauer and Barber - www.prenhall.com/grauer

Word Chapter 1 – Introduction


L W L P J G L F G D K N M N R T C T C T

R G R A M M A R C H E C K K Y C W Y P R

M D M M J P K T K M X R L L N E T B Q B

D P N P P D K S O F T R E T U R N L Y L

H I N S E R T I O N P O I N T R M F L D

C L K S U R U A S E H T B B Q O H P S N

T T C L O S E C O M M A N D H C N N T A

I W K E D O M T R E S N I A Y O R N A M

W M C F K W Z L N Y W E R R T T G F N M

S V E I V E Y L D R D D E T Z U T R D O

E K H L N K X G H O R V K X P A G R A C

L P C E Y H H I M E O M T P R X R A R N

G R L M Z L F E T C W R Z M D K T B D E

G G L E G R P U E C R O V R D J H S T P

O R E N K Y R R B G O A R Q Y W X U O O

T L P U T N O J B K J M B D M M R T O V

R K S R K T Z N B T V K M U W R M A L K

V X E C U W L Z R T K H N A N R X T B M

N V R A H C K W V R B X Y L N E A S A M

O G N I L L O R C S L C N M M D M P R T


Automatically changes 'teh' to 'the' Protects against document loss

Removes document from memory Closes Microsoft Word

Contains Save and Open CommandsFinds error in word usage Marks end of paragraph

Opposite of Overtype mode Location where text will be entered Provides access to pull-down menus

Brings a document into memory Replaces text as you type

Access to unseen part of document Created at end of line by word wrap

Avoids embarrassing mistakes Has icons for Open and Save

Displays location of insertion point Thesaurus/Provides synonyms Alternates between on and off

Continues text on next line

Word Chapter 1 – Introduction

Across 2 Protects against document loss when

system crashes 5 New view introduced in Word 2003 7 Improves appearance of document10 Shows keyboard shortcut for toolbar button12 Brings a copy of a document into memory14 Moves existing text to right as you type16 Finds error in word usage17 Extension used with Word documents19 Provides access to pull-down menus23 Shows margins and tab stops26 Provides synonyms27 Moves insertion point to start of document28 Created at end of line by word wrap29 Reverses previously executed commands30 Provides access to an encyclopedia31 Text recognized as a person's name32 Alternates between on and offDown

1 Displays location of insertion point 3 Closes Microsoft Word 4 Has icons for bold and italics commands 6 Automatically continues text on next line 8 Marks location where text will be entered 9 Removes current document from memory11 Provide access to unseen part of document13 Displays (Hides) non-printing characters15 Ensures correct spelling18 Has icons for Open and Print commands20 Contains Save and Open Commands21 Records changes made to document22 Marks end of paragraph24 Replaces existing text as you type25 Automatically changes 'teh' to 'the'

1 2 3

4

5 6

7 8

9 10

11

12

13

14 15 16

17 18

19

20

21 22 23

24

25 26

27 28

29

30

31

32


Word Chapter 2 – Gaining Proficiency


O F F I C E C L I P B O A R D K Y X T D

H M P K K N Y D L S R G C H Z W Z Q M P

M C R R L A L Y A K O C Y L H P P F N F

E T E L J T E N R T R X U G P E R T P I

G P D L L F S R O Z P Q N N V V O J J R

P M A V O S I C B T Z I P I D J P F Y E

L H E C E R O N Y N C N T N T O O T L S

T L L R S M P P D A O I K R H K R S A V

Q M I G M D E H P C S I X J T C T O I X

M F M A T S N S A N O N T P G R I F R T

R W N C I W E A E N T M K C M X O T A F

J D Y Z L N P S L D N T M M E M N P Q C

R G E W I O E H Q C J Q T A O S A A T F

G C N L T S F M C K H G T W N O L G C O

M D L S A C O U R I E R N E W D Z E W N

N M B C D R A C D L I W M R L D L B K T

L A T G K T Y M O N O S P A C E D R V N

T X X K A E R B E G A P D R A H M E R T

K J T N T I M E S N E W R O M A N A W R

N F G D M G N I L L O R C S T N D K T H


Sans serif typeface "Word" and "WORD" are different

Monospaced typeface Locates text in a document

Font/Times New Roman or Arial Moves to a specific place Ctrl+Enter is the shortcut

Opposite of portrait Draws reader's eye across page

Uses Ctrl+1 or Ctrl+2 as keyboard shortcuts

Courier New for example Collects multiple objects

Awkward page break

Opposite of monospaced Arial, for example

Displays unseen portion of document Needed when changing columns in a

document Typeface used for large amounts of text

Created automatically to start a new page Used to align text in columns

Serif typeface Measured in points Opposite of Redo

Used to match any character Changes magnification

Word Chapter 2 – Gaining Proficiency

Across 3 Uses Ctrl+1 or Ctrl+2 as keyboard

shortcuts 5 Displays unseen portion of document 6 Monospaced typeface 7 Opposite of Portrait orientation 9 Default page orientation12 Moves to a specific place in a document16 Changes magnification20 Typeface for large amounts of text22 Opposite of monospaced23 Awkward page break27 Replacement is made without user input28 Reverses previously executed commands29 Enables collection of multiple objects30 Determines white space at edges of page31 Locates text within a document32 Measured in points

Down 1 Used in a search to match any character 2 Used to align text in columns 3 Draws reader's eye across page 4 Needed when changing margins 8 Prevents soft page break between current

and next paragraph10 Serif proportional typeface11 Automatically created by Word to start a

new page13 Substitutes one character string with another14 "Word" is different from "WORD"15 Created by pressing Ctrl+Enter17 Used with bulleted and numbered lists18 Courier New (for example)19 Sans serif proportional typeface21 Times New Roman or Arial24 Selection of typefaces, sizes, and styles25 Typeface best used for headings and titles26 Alignment that produces lines of equal length

1

2 3

4 5

6

7

8

9 10 11

12 13

14 15 16 17

18 19

20 21 22

23

24 25

26

27

28

29

30

31 32


Word Chapter 3 – Enhancing a Document


Replaces (c) with © Legal protection for written work

Creates a target diagram Alternative to a footnote Used to cite a reference

Letter sent to many recipients Language of the Web Accesses a Web page

Adds clip art to a document

Network of networks Creates form letters

Material that is not copyright Easy way to create résumé

New file format Drag these to make object larger

Text recognized as person’s name Partially completed document

Decorative text

T K J R E S U M E W I Z A R D G H R R F

F Q T P T Q P J R M A I L M E R G E O R

H N C H E D E T A L P M E T L P P R E B

S L J P Q N L L N B L M T H T N M R G T

D I P Q M K D X R M K R G C N L M Y A K

F E Z V H Z C N H D N F M D E T J C P P

O R J I F V Y Z O L D K H T N F N T B Y

O U R J N N M D D T X M T Z T G P G E C

T T M J R G K B E Y E E S K C B U N W M

N C R W N L H N R N R M J L E W B K E T

O I D I A G R A M G A L L E R Y L W L J

T P K W K E R Z N R M R V T R W I D I Z

E T N T T N Y R T D L V H W O L C C F D

V R T N Y T I T B K L G C J C G D X E V

C E I R T N A L V Q I E P N O B O J L T

G S F Q A G T L R R R L S T T N M V G Q

G N Q Q S D P D Y E Q V T V U K A Y N L

Z I T K G Z R P L F P Z B T A P I Y I W

W C X P P K O O N J Q Y N Q M R N L S L

K M F G X C R C W T G F H N G T D W Y M


Word Chapter 3 – Enhancing a Document

Across 2 Unauthorized duplication of programs 5 Area on which shapes can be created with

various drawing tools 6 Web page 8 Provides additional information about an

item at bottom of page 9 Converts Word document to HTML10 Place holder for variable data12 Material that can be distributed freely18 Creates a customized template19 Replaces (c) with ©20 Creates pyramid or target diagram22 Underlined text to access a web page27 Alternative to a footnote28 Command to place clip art in a document29 Partially completed document with

formatting and text30 New Web page format in Word 200331 Allows you to use a quote as long as you

cite the source32 Replaces 1/2 with ½

Down 1 Catalogs clip art 3 Prompts for information, then it creates a

professional résumé 4 Web pages on a local area network 5 Names and addresses for a mail merge 7 Inserts a footnote or endnote 9 Click and drag these to make object larger11 Adds typographical characters to document13 Contains standardized text and merge fields14 Standardized letter for many recipients15 Creates a set of personalized form letters16 Language to create HTML documents17 Eliminates part of a picture21 Text automatically recognized as a name23 Decorative text24 Legal protection for written work25 Network of networks26 HTML document

1 2 3

4 5

6 7

8

9 10

11

12 13

14 15 16

17 18 19

20

21 22

23

24

25 26

27

28

29

30

31


Word Chapter 4 – Advanced Features


Automatically applies built-in styles to a document Applied to every paragraph by the AutoFormat command

Intersection of column and row in a table Removes rows or columns from a table

Text automatically printed at the bottom of every page Moves insertion point to a specific page

Text automatically printed at the top of every page Lists key terms and associated page numbers

Adds a row or column to a table Draws reader's eye across the page Stores the default paragraph settings

Sequences and prioritizes items Required with multiple headers or footers

Set of formatting specifications Lists main topics and their page numbers

Powerful feature in Word

E R U T A E F S E L B A T T T K K D L Y

V V Q R N J X C J V Q G Q A R H K M B F

C E L L R S E C T I O N B R E A K W C B

R F P X D F R H M T K L K T C N C Y Y M

D R M T T E D N O H E V V A T L G K Q M

N H L H D N F C X O N K Y M G F X F V B

A K Z A P E O V F P W M E R R E D A E H

M V E L M M L C F B C L V O H X Q K P D

M L W L M N O E R D Y N K F M R E K G R

O H D A N N U M T T J Y X O T H C D G Z

C N N N T J K M S E G F M T K B M B N L

T D Z E M L Y T B H C O T U V P K R K I

R L N J H T X V H E C O N A L K P Y T R

E T V Z T E J P Z M R T M M R J R P X N

S C G C T M Q L D B N E W M K T N M M K

N K H Y S Z H X W T R R D M A M F K J X

I N D C T L C V K X D M T L H N D T J T

K O G V Y R B T R Y M R J Y I D D M L F

B T T R L X Y C T J K N T L G S N B J R

W T K K E N O R M A L S T Y L E T X W X


Word Chapter 4 – Advanced Features

Across 1 Moves insertion point to a specific page 3 Adds a row or column to existing table 6 Moves item in a list to next higher level 8 Turns a feature on or off 9 Draws reader's eye across the page11 Lists main topics and their page numbers15 Displays headings in a separate pane16 Intersection of column and row in a table22 Removes rows or columns from a table23 Combine multiple cells into one24 Inserts a tab character into a cell of a table25 Text automatically printed at the top of

every page26 Creates a simple header or footer with the

page number27 Automatically applies built-in styles to a

document28 Lists key terms and associated page

numbers

Down 2 Portrait or landscape 4 Divide a single cell into multiple cells 5 Set of formatting specifications 6 Stores character and paragraph formatting 7 Provides a condensed view of a document10 Marks all occurrences of an index entry12 Stores character formatting13 Created when you change margins within

a document14 Moves item in a numbered list to next

lower level17 Stores the default paragraph settings18 Applied to every paragraph by the

AutoFormat command19 Emphasizes and separates items20 Sequences and prioritizes items21 Text automatically printed at the bottom of

every page

1 2

3 4

5

6 7 8 9 10

11 12 13

14

15 16

17

18 19 20

21

22

23

24

25

26

27

28


Microsoft® Word – Volume I (Chapters 1 to 4)

All Clues on Next Page

1 2

3 4 5 6

7

8 9 10 11

12

13 14 15

16 17 18

19 20 21 22 23

24

25

26 27 28 29

30

31 32 33 34

35

36 37

38 39

40

41

42 43 44

45 46

47 48

49 50

51 52

53 54 55

56 57 58 59 60

61 62

63

64

65 66

67 68

69

70 71

72

73 74 75 76

77

78

79 80


Microsoft® Word – Volume I (Chapters 1 to 4)

Across 1 Opposite of monospaced 3 Network of networks 5 Typeface best used for headings and titles 7 Used to align text in columns 8 Locates text within a document11 Serif proportional typeface13 Automatically changes 'teh' to 'the'19 Set of formatting specifications20 Process of selecting typeface, size, and style22 Inserts a tab character into a cell of a table24 Contains icons for bold and italics

commands29 Automatically continues text on next line30 Language used to create HTML documents32 Reverses previously executed commands35 Click and drag these to make an object

larger36 Created by pressing Ctrl+Enter39 Needed when changing margins in a

document40 Underlined text to access a Web page42 Material that can be distributed freely43 Changes magnification45 Substitutes one set of characters with

another49 Flags words not in the built-in or custom

dictionaries51 "Word" is different from "WORD"53 Displays location of insertion point55 Adds a row or column to a table62 Contains Save and Open Commands64 Courier New (for example)65 Lists main topics and their page numbers69 Typeface best used for large amounts of text70 Applied to every paragraph by the

AutoFormat command73 Prevents soft page break between current

and next paragraph75 Text automatically printed at the top of every

page77 Replaces existing text as you type78 Draws reader's eye across the page79 Portrait or landscape80 Text printed at the bottom of every page

Down 2 Places typographical characters in document 4 Partially completed document with formatting

and text 6 Inserts a footnote or endnote in a document 9 Removes rows or columns from a table10 Awkward page break12 Brings a copy of a document into memory14 Determines white space at edges of page15 Command to place clip art in a document16 Prompts for information, then it creates a

professional resume17 Standardized letter sent to many recipients18 Moves item in a list to next higher level21 Marks end of paragraph23 Turns a feature on or off25 Keystrokes that place insertion point at start

of document26 Has icons for Open and Print commands27 Removes current document from memory28 Decorative text31 Legal protection for written work33 Finds error in word usage34 Provides access to pull-down menus37 Eliminates part of a picture38 Intersection of column and row in a table41 Provides synonyms44 Creates a set of personalized form letters46 Monospaced typeface47 Catalogs clip art48 Enables collection of multiple objects50 Closes Microsoft Word52 Converts Word document to HTML53 Displays unseen portion of document54 Applies built-in styles to a document55 Location where text will be entered56 Moves to a specific place in a document57 Provides additional information about an

item at bottom of page58 Displays shortcut key equivalent to toolbar

button59 Uses Ctrl+1 or Ctrl+2 as keyboard shortcuts60 Sequences and prioritizes items61 Sans serif proportional typeface63 Used in a search to match any character66 Alternative to a footnote67 Measured in points68 Created at end of line by word wrap71 Automatically recognized as a person's name72 Moves item in list to next lower level74 Lists key terms and associated page numbers76 Times New Roman or Arial

Excel Chapter 1 – What is a Spreadsheet?


$A$1 for exampleCell into which entry will be made

Intersection of column and rowRange you are copying to

Displays contents of active cellPredefined mathematical formula

Adds rows to a spreadsheetOpposite of portrait

$A1 or A$1 for exampleBrings spreadsheet into memory

Controls printing options Range/Rectangular unit of cells

A1 for example Creates a copy of current file under a different name

Range you are copying from Provides access to basic tasks

Contains icons for common commands Contains one or more worksheets

D C E L L M T Y X N D Y X Z L D N V Z V

J R Z Y B K D Q J N G F R J E X K R B V

K F N M J L F L A V B R D K C C V E R Q

X W O T N L Q M H N T D C C N D N C E R

Q Z T R R Y M R R H F P Z D E E L N L Z

R R J J M O K K H U R L M N R S M E A P

Z M N X C U X F N V L V L R E T D R T K

K L E N K B L C C E J K T A F I K E I G

L B E P H E T A C C O X L B E N M F V F

G P Q G A I N E B O D Q C L R A K E E X

O R L F O C V A B A H L Z O E T K R R D

J T A N Y I S K P S R Q M O T I M D E N

K M K N T G R D A K K V B T U O T E F Z

T K M C G O L V N J S V D V L N Q X E M

J K A B W E E K P A H A J R O R J I R T

G R R L P A P R Q X L L T C S A L M E T

T F K M S F T K B L G B C B B N T M N T

H D N A M M O C T R E S N I A G C W C X

M P A G E S E T U P Y C F Y J E M V E F

T T E G N A R E C R U O S W L C M Q P R


Excel Chapter 1 – What is a Spreadsheet

Across

3 Opposite of portrait 5 Contains one or more worksheets 7 Rectangular unit of cells10 Displays information about command

being executed11 Used to select non-contiguous cells12 Transfers contents of cell to another

location13 Spreadsheet entry that does not change

until edited15 Opposite of Undo17 Provides access to basic tasks19 Brings a spreadsheet into memory21 Begins a formula22 Cell into which entry will be made27 Cancels previously executed command29 Adds columns or rows to a spreadsheet30 Duplicates contents of cell31 Excel-specific term for spreadsheet32 Contains icons for commonly used

commands33 Predefined mathematical formula34 Adjusts when you copy the formula

Down

1 Indicated by a red triangle 2 Removes cells, rows, and columns from

spreadsheet 4 Variable inputs to spreadsheet that are

referenced in formulas 6 $A1 or A$1, for example 8 Does not change when you copy formula 9 Extension assigned to an Excel workbook14 Command to modify the appearance of

entries in spreadsheet16 Range you are copying to18 Creates a copy of current file under a

different name20 On the left side of Open and Save As

dialog box23 Range you are copying from24 Command that controls printing options25 From high to low26 Displays contents of active cell28 Intersection of column and row

1 2 3 4

5 6

7 8 9 10

11

12

13 14

15 16

17 18

19 20

21 22

23

24 25 26

27

28

29 30 31

32

33

34


Excel Chapter 2 – Gaining Proficiency


$A$1 for example Format changes according to the value in a cell

Toolbar used with Web QueriesSmall black square in lower right corner of selected cell

Language in which web pages are writtenLink to a Web page

Command to add descriptive information to a cellNetwork of networks

Command to update a Web queryA1 for example

Provides access to encyclopedias New file format in Office 2003

Partially completed workbook with formulas but not dataEnters the current date into a cell

HTML document Retrieves information from the Web

C R F S I N G L E F I L E W E B P A G E B

O Y R E U Q B E W G L N F T V K J M N M L

N H F Z M K B N T N K N K K W C K L M J L

D S E F I L L H A N D L E X N Y L M T E T

I E C T C H D B M K Y W G H J T Y L C R A

T R N O F G H L T B E V F W T T K N C T X

I F E D N N J M T B C G Y T R M E C A R D

O E R A D C Y M P M V C P B E R L D M T P

N R E Y F K W A L W M L T V E N L J Q R C

A G F F F J G T Z T V N W F H A R R M H H

L T E U N E N W M W M K E Y N G T E K K Z

F Z R N Y K N L M Y T R P R R X T L T R V

O T E C M M Q L X M E E E J N X N K Z N R

R H T T F K N P R V R T M X Z R Q X X Y I

M B U I Q D Y N I L X L Y P G R Q Q L M G

A G L O W N Z T I E Q N C C L J F K N L C

T M O N N H A N T R V M D D F A F V M X T

T T S C C L K Y N V Q R C Y K L T Z P K M

I L B V E R N M T N E M M O C T R E S N I

N H A R N V M Z Q H L C Z F Q X M J D K D

G F T R E S E A R C H T A S K P A N E L H


Excel Chapter 2 – Gaining Proficiency

Across

2 Absolute, relative, or mixed 5 Link to a Web page 6 Run multiple applications simultaneously 9 Partially completed workbook10 Enters the current date into a cell12 Command that converts a worksheet to a

Web page16 Predefined mathematical calculation17 Toolbar used with Web Queries19 Multiplication symbol23 Allows you to edit a Web page in the

Office program used to create it25 Ctrl+V is the keyboard shortcut26 Adds descriptive information to a cell27 Network of networks29 Preferred way to add the contents of

multiple cells

Down

1 Cell reference that adjusts when the formula is copied

3 Format changes according to the value in a cell

4 Updates results of a Web query 7 New file format in Office 2003 8 Command to add custom header or footer11 Provides access to encyclopedias13 Small black square used to copy cells14 Copies formatting of selected cell 15 Language in which web pages are written18 Cell reference that stays the same when a

formula is copied20 Ctrl+C is the keyboard shortcut21 Opposite of Descending22 Arranges a list in alphabetical, numeric, or

chronological order24 Retrieves information from the web for

inclusion in a worksheet28 Collection of formatting specifications

1 2 3

4

5 6

7 8

9 10

11 12

13

14 15

16 17 18

19

20 21 22

23

24

25 26

27 28

29


Excel Chapter 3 – Graphs and Charts


Compares actual numbers and has a horizontal orientation Descriptive entries plotted on X-axis

Graphic representation of data Separate sheet within workbook that contains a chart

Contains tools for modifying chartsGuides you through process of creating a chart

Compares actual numbers and has a vertical orientation Numeric value

Group of data points Contains tools to create objects that add emphasis on charts

Chart that is placed on worksheet with the data Chart which has one slice separated for emphasis

Toolbar that can be positioned anywhere on worksheet Ability to have multiple applications in memory at the same time

Most effective way to display proportional relationshipsUsed to make embedded chart larger or smaller Chart type with columns on top of one another

Contains buttons for all open applications

T K X D R A W I N G T O O L B A R P L

N R R N M U L O C D E K C A T S R Z C

W V A J Z F D J R N V F P Z J L L H N

K S G H J T R A H C N M U L O C A M L

C E R K C X D D H D Y Z D R F R J T J

N I N M J E N T B W N V S C T K R P L

H R D H M P I G K W M I T W J A K E K

T E G C R B L P Q B Z K I R H J B G C

R S D C H A R T D I K Z C C W A N N H

A A Z X Y A M N N E A T D W L D B I A

H T T F F P R G V R D E Z Y R T J K R

C A H N Q L H T D W D O R D N H P S T

R D Z X I A O R S D L O L M V T I A T

A P V L N O A A E H G W C P N N E T O

B C N D R B P B T E E R Q T X K C I O

J Q L T K V M A T I T E L Z F E H T L

C E L S L E L A T Q N N T N H K A L B

S T A Z J R C G L A Q G W T M W R U A

D T M G Z Y L F B Y D X K R J K T M R


Excel Chapter 3 – Graphs and Charts

Across

2 Separate sheet within workbook that contains a chart

4 Chart that is placed on worksheet with the data

11 Contains tools for modifying charts14 Ability to have multiple applications in

memory at the same time15 Automatically enters a SUM function for

values above or to left of active cell16 Compares actual numbers and has a

horizontal orientation17 Descriptive entries plotted on X-axis19 Graphic representation of data20 Toolbar that is positioned along the edge

of the application window21 Saves time with formatting23 Data from one application used in a

document belonging to another application24 Chart with columns are on top of one

another display explicit totals25 Most effective way to display time related

information26 Numeric value27 Contains buttons for all open applications28 Toolbar that can be positioned anywhere

on worksheet

Down

1 Command used to change color or pattern of data series within the chart

3 Used to make embedded chart larger or smaller

5 Contains tools to create objects that add emphasis on charts

6 Most effective way to display proportional relationships

7 Group of data points 8 Vertical axis 9 Guides you through process of creating a

chart10 Horizontal axis11 Compares actual numbers and has a

vertical orientation12 Used when different scales are required

for multiple data series13 Chart which has one slice separated for

emphasis18 Displays shortcut menu21 Keyboard shortcut to cycle between open

applications22 Object Linking and Embedding

(abbreviation)

1 2 3

4 5

6 7 8

9 10 11

12 13

14

15

16

17 18

19

20

21 22 23

24

25

26

27

28


Excel Chapter 4 – Spreadsheets in Decision Making

Directions: Figure out the word or phrase that each clue represents, then find the word in the grid. (Every word or its abbreviation appears in the list of key words and concepts at the end of the

chapter.) Words can go horizontally, vertically and diagonally in all eight directions.Inputs to a function

Displays a subset of rows depending on criteria established Function that computes the arithmetic mean

Found in the first column of a table used in a VLOOKUPPredefined mathematical calculation Horizontal equivalent of VLOOKUP

Type of retirement plan Returns the highest value in a rangeReturns the lowest value in a range

A$4 or $A4 for example IF within an IF

Function used to determine a car paymentGreater than or less than, for example

Cell reference that adjusts when formula is copied Brings unseen areas of the spreadsheet into view

AVERAGE, MAX, and MIN, for example Adds all of the values in a range of cells

Partially completed workbook with formulas but no data

J S Z B M T J G J D Z P U K O O L H M T

Q T R O T A R E P O L A N O I T A L E R

C A B A U T O F I L T E R F P S W F Z X

V T R A N D M I N X X K W L T B O D M Z

F I A L T T V Q K M A J M N V R J K F H

J S T R K G R V T H M L E L E E J B N N

Y T P K I L L Z L W Z M F X T A P M I W

Y I R L C W Q B G B U U A E R K M M N B

G C L K C Z L M D G N M M R T P T L D R

G A F R T C L P R C P P K C F O Y V K T

N L Y D V J G A T L L D M F J I N E N D

I F N K V L S I E A R K Y P X N F T H H

L U N E V E O U T R V T D A H T L U F T

L N W R S N V E M K Q E M Z L S B L J G

O C W R P T Y I B Y Y W R F J V M O C D

R T Q L Y H E N T H N F F A Q R F S M P

C I Y R M B Z D P A K K Z T G J K B M D

S O K G R K T T I N L D D B P E K A X R

C N H H H R T F M F Z E L B K B C F V M

H S R M I X E D R E F E R E N C E V Q D


Excel Chapter 4 – Spreadsheets in Decision Making

Across 1 Greater than or less than, for example 4 Adds all of the values in a range of cells 8 $A$1, for example 9 Displays a subset of rows depending on

criteria established10 Horizontal equivalent of VLOOKUP13 A1, for example14 Found in the first column of a table used in

a VLOOKUP15 Used instead of a COUNT function when

the entries in a range are alphabetic17 A$4 or $A4, for example20 Returns one result if a condition is true,

another is it is false21 Stores 78.8 as 8025 Arranges a list in alphabetical, numeric, or

chronological order28 Function for an IRA calculation29 Function used to determine a car payment30 AVERAGE, MAX, and MIN31 IF within an IF

Down 2 Partially completed workbook 3 Initial conditions on which spreadsheet is

based 5 Returns a specified number of characters

at the beginning of a text entry 6 Makes A1 the active cell 7 Returns the highest value in a range11 Returns the lowest value in a range12 Type of retirement plan16 Keeps rows or columns out of sight18 Displays row and column headings when

scrolling in a large spreadsheet19 Determines a student's class ranking22 Inputs to a function23 Brings unseen areas of the spreadsheet

into view24 Predefined mathematical calculation26 Computes the arithmetic mean of the

values in a range27 Returns the number of cells in a range that

contain a numeric value

1 2 3

4 5

6 7 8

9

10

11 12

13 14

15

16 17 18 19

20

21 22 23

24 25

26 27

28

29

30

31


Microsoft® Excel – Volume I (Chapters 1 to 4)


1 2 3

4 5 6

7

8 9 10

11 12 13 14

15

16

17 18

19

20 21

22 23 24

25 26 27

28 29 30

31 32

33 34 35 36

37 38

39 40

41 42

43 44 45 46 47

48 49 50

51 52

53 54 55 56

57 58 59

60 61 62

63 64 65

66 67

68

69 70

71 72

73

74

75

76 77

78

79

80

81

82

83


Microsoft® Excel – Volume I (Chapters 1 to 4)

Across 2 Chart which has one slice separated for

emphasis 4 A1, for example 9 Keeps rows or columns out of sight10 AVERAGE, MAX, and MIN11 Contains tools for modifying charts15 Adds columns or rows to a spreadsheet16 HTML document17 Retrieves information from the Web18 Cell into which entry will be made i19 Ctrl+V is the keyboard shortcut20 From high to low21 On the left side of Open and Save As

dialog box24 Arranges a list in alphabetical, numeric, or

chronological order25 Displays shortcut menu26 IF within an IF29 Contains buttons for all open applications31 Returns the number of cells in a range that

contain a numeric value34 Greater than or less than, for example37 Makes A1 the active cell40 Format changes according to the value in

a cell42 Horizontal equivalent of VLOOKUP44 Found in the first column of a table used in

a VLOOKUP47 Most effective way to display proportional

relationships48 Use these to make embedded chart larger

or smaller49 Multiplication symbol51 Function used to determine a car payment54 Type of retirement plan55 Partially completed workbook57 Computes the arithmetic mean range60 Opposite of Undo64 Ctrl+C is the keyboard shortcut66 Updates results of a Web query68 Absolute, relative, or mixed72 Most effective way to display time related

information73 Collection of formatting specifications74 Chart with two different scales75 Used to select non-contiguous cells76 Begins a formula78 Command to add custom header or footer79 Cycles between open applications80 Predefined mathematical calculation82 Saves time with formatting83 Rectangular unit of cells

Down 1 Guides you through process of creating a

chart 3 Opposite of portrait 5 Network of networks 6 $A$1 for example 7 Graphic representation of data 8 Chart with columns are on top of one

another display explicit totals12 Inputs to a function13 Link to a Web page14 Descriptive entries plotted on X-axis22 Enters the current date into a cell23 Contains tools to create objects that add

emphasis on charts27 Provides access to basic tasks28 Function that stores 78.8 as 8030 Contains one or more worksheets32 Numeric value33 Toolbar that is positioned along the edge

of the application window35 Contains icons for commonly used

commands36 Displays a subset of rows depending on

criteria established38 Returns the lowest value in a range39 Indicated by a red triangle41 Excel-specific term for spreadsheet43 Cancels previously executed command45 Range you are copying from46 Small black square used for copying50 Displays information about command

being executed52 A$4 or $A4, for example53 Displays contents of active cell56 Run multiple applications simultaneously58 Opposite of Descending59 Separate sheet within workbook that

contains a chart61 Chart on same worksheet as data62 Copies formatting of selected cell63 Brings a spreadsheet into memory65 Range you are copying to67 Removes rows or columns69 Brings unseen rows (columns) into view70 Group of data points71 Extension assigned to an Excel workbook73 Preferred way to add the contents of

multiple cells75 Intersection of column and row77 Returns one result if a condition is true,

another is it is false81 Returns the highest value in a range

Access Chapter 1 – Introduction


Feature to expand abbreviations Uses triangle as record selector

Contains multiple tables and forms Displays objects in a database

Prevents addition of invalid data Used to add or delete records

Used to specify fields and properties Fact or data element

It can be by selection or by form Attractive interface for data entry

Garbage In, Garbage Out

Type of relationship Field that makes record unique

Displays selected records A set of fields

Consistent tablesSubstitutes one entry for anotherPrinted output from a database

List records in a specified sequenceA set of records

Command that reverses last action

Y Q W Q D N N V Q R J Y N F T J X M L L

T R V M R Y O F H V R U T K N R T N Q D

I E F K O X G K P E H R N T Z P O K L Z

R P G T C L I M U Q O G Q D K N T P H T

G L M T E N G Q X S Y P L R O Z R B E C

E A C Q R B W E I V T E E H S A T A D R

T C X R T V D A T A B A S E W I N D O W

N E G F N R L D N N X J Z M Y V F K Q F

I P F N E Q D R E F N F X O J N I R B X

L X L H R P R R Y S Z G N Z M F E L N N

A L V K R N K Z E Y I E K M C P L J T E

I G M J U V Q M D C T G F X C M D B S R

T N T R C P V D L O O I N N J L R A B F

N P J T O F X F M J L R D V W Q B H N C

E P R Z K F V A L T D K D L I A M R F G

R Y R M N M N Q E K T L M Y T E K Q M R

E D D T C Y V R V K J T T A N L W Y T L

F M F H M C J D C W M L D M Z M V N B H

E V D A T A V A L I D A T I O N L Z J K

R T Q T A B L E T Y E K Y R A M I R P N


Access Chapter 1 – Introduction

Across 1 Prevents addition of invalid data 3 Sort from high to low 4 A set of fields 9 List records in a specified sequence10 Sort from low to high11 It can be by selection or by form12 Move from field to field13 Use this to learn more about Access14 Command that reverses last action16 Has .mdb extension17 Garbage In, Garbage Out19 Contains Find and Replace commands23 Command to search for a specific record24 Portrait or Landscape (for example)26 Type of relationship28 Printed output from a database30 Fact or data element

Down 2 Design or Datasheet (for example) 3 Used to add or delete records 4 Ensures consistency between tables 5 Displays objects in an Access database 6 Indicated by triangle in record selector area 7 Command to substitute one entry for another 8 Used to specify fields and associated

properties15 Attractive interface for data entry18 Sequenced or selected data20 Displays selected records and/or fields21 Office feature to expand abbreviations22 Field that makes record unique25 Remove an existing record27 Enter a new record29 A set of records

1 2

3 4 5 6

7

8 9

10

11 12

13

14

15 16

17

18

19 20 21 22

23

24

25

26

27 28 29

30


Access Chapter 2 – Tables and Forms


Predesigned formAssigns values automatically

Tied to a field in a tableStores a formula or functionProperty for descriptive label

Control for a Yes/No fieldText or Number (for example)

Used to modify a formHelps to create a form

Field type for Web addressPattern to facilitate data entry

Field type for lengthy dataCannot contain text

Mutually exclusive itemsUniquely identifies each record

Characteristic of a controlData has to be entered

Helps to create a tableRecommended field type for zip code

Type of control used for a label="M" or "F", for example

Stores a value of true or false

X G H U N B O U N D R J R M X N F Z R

C Q X W E I V N G I S E D N E H L M E

C A L C U L A T E D F I E L D M R Q Q

E L U R N O I T A D I L A V K N O X U

T T P R R Y E S N O F I E L D M D D I

N M R L N R P U O R G N O I T P O R R

B O U N D C O N T R O L N K B P R A E

X R Y K K H K M G N K K T M R R K Z D

C Y N J M E P N Q L B T R I Y S T I P

Y N U K F C R D F V X C M W A P W W R

D M M N X K K R R E T A Q M N D Z E O

P M B I T B N L T A R Y T X A Q B L P

M R E L X O C C T Y Z U T T D M W B E

M O R R L X G A K H P I A R U H T A R

B F F E D F R E P N R T W N E K F T T

Z O I P N D Y G I T Y F O M W P F J Y

T T E Y K K R T X P I T G L R N O R M

K U L H T Q M G E R U O P V M O R R W

J A D K T T G X T A F Q N M M M F F P


Access Chapter 2 – Tables and Forms

Across

4 Property that says data must be entered 9 Field type for lengthy data10 Visual display of a pivot table11 Characteristic of a control12 Predesigned form14 Mutually exclusive items17 Command that changes printed margins18 Moves to next bound control20 Stores a formula or function21 Control used for a label24 ="M" or "F" (for example)25 Stores a value of True or False26 Field type that assigns values

automatically27 Tied to a field in a table29 Property to display upper-case letters30 Cannot contain text

Down

1 Control for a Yes/No field 2 It is bound, unbound or calculated 3 Property for descriptive label 5 Text or Number (for example) 6 Helps to create a form 7 Used to select multiple controls 8 Used to modify a form13 Store this rather than age15 Helps to create a table16 Pattern to facilitate data entry19 Form title goes here22 Uniquely identifies each record23 Field type for Web address28 Recommended field type for zip code

1 2 3 4 5

6 7 8

9 10 11

12 13

14

15

16 17

18

19 20

21 22

23

24

25 26

27 28

29 30


Access Chapter 3 – Information from the Database


Delete or Append; for exampleMultiple criteria in same row

Specifies records within a rangeJoin together

Returns the number of recordsDetermines selected records

Opposite of ascendingMain body of a report

Output of a queryContains summary data for a group

Returns the largest valueCriteria entered on different rowsIt's at the top of every report page

Greater than or less than (for example) Printed document

Opposite of report footerHelps to create a report

Most common type of queryDetermines if field is displayed in dynaset

Y M K X B E T W E E N F U N C T I O N T

R E L A T I O N A L O P E R A T O R J E

G W C L V B G N I D N E C S E D Z F C S

F C V O M A X F U N C T I O N L N L O A

K F Y R N Z N W O K J M R N N R K K U N

M W R D C C V O K R C L O Z E N R Y N Y

Y K E Y R L A X I L C I L T C P Z R T D

H B U T L A Q T F T T O O W Q P G J F H

Y Z Q H O L Z C E I C O N H Y F K B U F

R H N R N P G I D N F E W D C Y Y P N G

E M O D M Z V N W P A O S R I R F H C P

U F I B P R O A U T R T I L E T K N T A

Q M T Y C C Y O L W R T E P I Y I T I G

T W C P D Y R R O U E O O Q N A Q O O E

C D A N W G Z H K R E R P P F L T N N H

E H A P L V S W I L T S M E K L L E Q E

L T C L N Y W A B W J W W F R K N K D A

E J F V X K R R E D A E H T R O P E R D

S V M D N O L K Z X T Z P N B M K N M E

R M J W W V M J Z G Z R X H G T H B F R


Access Chapter 3 – Information from the Database

Across

1 Multiple criteria in same row 4 Concatenation symbol 7 Helps to create a report 9 Greater than or less than (for example)11 Main body of a report12 Number of report section types15 Property to list the top 10%18 Join together20 Bound, Unbound, or Calculated22 Printed document24 Specifies records within a range25 Returns the largest value26 Opposite of ascending27 Menu with Database Properties command28 Determines if field is displayed in query29 Returns the number of records

Down

2 Ctrl+C is shortcut for this command 3 Ctrl+V is shortcut for this command 5 Opposite of report footer 6 Delete, Append, or Update (for example) 7 Tool with exclamation point as its icon 8 Question mark or asterisk, for example10 Criteria entered on different rows11 Output of a query13 Determine selected records14 Contains summary data for a group16 Where reports are modified17 It's at the top of every report page19 Most common type of query21 Used to select multiple controls23 An "if" within an "if"

1 2

3

4 5 6 7

8 9 10

11

12

13 14 15

16

17 18 19

20 21

22 23

24

25

26

27

28


Access Chapter 4 – Proficiency


Sum or Count, for exampleFunction to determine the number of records

Command to send Access table to ExcelPrimary key of another table

Command to import data from external sourceApplication to create a graph or chart

Type of relationshipCompanion to pivot table

Flexible way to display summary statisticsThe field(s) that makes a record unique

Ensures consistency between tablesProperty used to open switchboard automatically

Computes a totalFriendly user interface

Table used with a switchboardUsed with multiple-table query

Performs calculations on a group of records

T L K H R T V Z W X C O U N T P K J L G

C B N N E T R P R I M A R Y K E Y T E N

Q H O Q F R Y V W Y M C P Q Y M Y T P E

F J I S E A P N Q Q D K W H T F E K L J

O L T W R H S T A Z M V D N V X T P L H

R D C I E C P T F M M L Z K T J M H X H

E L N T N T Y C A L O R D E L A B C G V

I N U C T O J M D R M T R J X M N M L E

G N F H I V B R R R T N E E R L T R L T

N L E B A I L M N B A U R N V T N B T P

K H T O L P B V N L F O P E O L A P N L

E G A A I R B H D T F B B X X T R G Z K

Y T G R N B X A R L T D Q H T P L R B L

T A E D T N T B P X P G F O C R O N N J

L B R I E A L R G T C G V V Q T H R B P

W L G T G J N K P N W I K N W G I M T W

M E G E R M T B L T P N L F R K C W D K

V R A M I M Y R E U Q L A T O T H K S D

F O N S T D H P A R G T F O S O R C I M

L W K M Y K C N O I T C N U F M U S Z M


Access Chapter 4 – Proficiency

Across

1 Table used with a switchboard 6 Report header or footer (for example) 7 Function determines number of records 9 Ensures consistency between tables11 Command to send Access table to Excel14 Property to open switchboard automatically16 Command to import data from Excel18 A subset of a table19 Function to display the current date20 Opposite of the Max function21 Primary key of another table22 The field(s) that makes a record unique23 Type of relationship

Down

2 Location of Database Utilities command 3 Entry in Total row to aggregate records 4 Where relationships are created 5 Application to create a graph or chart 6 Friendly user interface 8 Flexible way to show summary statistics10 Sum or Count, for example12 Used to create a keyboard shortcut13 Opposite of Page Footer15 Companion to pivot table17 Does calculations on a group of records

1 2 3

4

5 6 7

8

9 10

11

12

13 14 15

16 17

18

19

20

21

22

23


Microsoft® Access – Volume I (Chapters 1 to 4)

All clues are on the next page

1 2

3 4

5 6 7 8 9

10 11

12 13 14

15 16 17

18 19

20

21

22 23

24 25 26 27

28

29 30 31 32

33

34

35 36 37 38

39 40 41

42

43 44

45 46 47 48

49

50 51 52

53 54

55 56 57

58 59

60 61

62

63 64

65

66 67

68

69

70 71

72

73 74 75 76 77

78 79


Microsoft® Access – Volume I CluesAcross

1 An "if" within an "if" 5 Store this rather than age13 Does calculations on a group of records14 Remove an existing record15 Field type to assign values automatically20 Determine selected records24 Button to display all records in filtered

table25 Form title goes here27 Enter a new record28 Property for descriptive label29 Used to select multiple controls30 Stores a value of True or False34 Table used with a switchboard37 Displays the objects in an Access

database42 Ensures consistency between tables43 Property to list the top 10%44 Field type for lengthy data46 Function to display the current date47 Sort from low to high51 At the top of every report page58 Friendly user interface59 Indicated by triangle in record selector

area60 Bound, Unbound, or Calculated61 Printed document62 Opposite of ascending64 Number of report section types65 Sum or Count, for example66 Contains summary data for a group70 Characteristic of a control71 Concatenation symbol73 Returns the largest value75 Contains the Find and Replace

commands76 Main body of a report78 Question mark or asterisk, for example79 Output of a query

Down

2 Most common type of query 3 Design or Datasheet (for example) 4 Field(s) that makes a record unique 6 Used to add or delete records 7 Command that reverses last action 8 ="M" or "F" (for example) 9 Mutually exclusive items10 Tied to a field in a table11 Entry in Total row to aggregate records12 Primary key of another table16 Determines if field is displayed in query17 Control used for a label18 Pattern to facilitate data entry19 Has .mdb extension21 Property that says data must be entered22 Where relationships are created23 Ctrl+V is shortcut for this command26 Field type for Web address31 Property opens switchboard automatically32 Type of relationship33 A set of fields35 Fact or data element36 Control for a Yes/No field37 Prevents addition of invalid data38 A set of records39 Garbage In, Garbage Out40 Helps to create a table41 Opposite of report footer45 Stores a formula or function48 Ctrl+C is shortcut for this command49 Helps to create a report50 Companion to pivot table52 Returns the number of records53 Command to import data from Excel54 Helps to create a form55 Sequenced or selected data56 Command that changes printed margins57 Append or Update (for example)63 Cannot contain text67 Where forms and reports are modified68 Use this to learn more about Access69 Recommended field type for zip code72 A subset of a table74 Attractive interface for data entry77 List records in a specified sequence

PowerPoint Chapter 1 – Introduction


Controls how object moves on and off slideMove item to next lower level in outline

Contains tools for creating and formatting objects on slidesCloses PowerPoint

Command to add clip art to slideShows the slide and speaker notes

Brings copy of existing presentation into memory Slide area for text, title, or other object

Move item to next highest level in outlineRestores previous commands that have been cancelled

Creates a copy of document under another name or in another folderIndicates there are additional slides currently not visible

Determines nature and position of objects on slideView that makes it easy to reorder slide and apply transitions

Specifies color scheme and background design for presentationControls how slide moves on and off screen

Reverses previously executed command

C Q D R A W I N G T O O L B A R P H

K M P R T U O Y A L E D I L S Q Q H

S L I D E S O R T E R V I E W F Q T

B V M J M F L E T C K Y K L R D C N

M I R R F E H W T R J D K C B E D O

T N Y K L L K R R A N Y V G J N N I

R S E M J T N X E A L P Y B K O X T

S E R X L I Y L M D R P O J T I G I

A R D K I T T M P H O R M E Q T N S

V T N L J T O P B R E C S E S A T N

E P N T O C C N Q H T P O C T M V A

A I F N O H X O T T A R R M R I L R

S C X D P E E O M G H O B K M N R T

G T N F T Y R C E M L J K C K A M N

Q U N O Y O N V A L A N E P O R N Y

G R M H R Z I C B L B N G X D Y N D

T E H K B E C A M N P Y D B L C R G

D K P N W M R F N P R O M O T E M D


PowerPoint Chapter 1 – Introduction

Across 1 Catalogs clip art 3 View that makes it easy to reorder slide

and apply transitions 5 Brings existing presentation into memory 7 Flags words not found in built-in dictionary11 Specifies overall design for presentation12 Changes magnification of slide13 Move item to next lower level in outline14 Slide miniatures15 Restores previous commands that have

been cancelled19 Reverses previously executed commands20 Fastest way to enter or edit text22 Actual slide show itself23 Displays outline, speaker notes, and

enlarged view of slide25 Determines position of objects on slide26 Indicates there are additional slides

currently not visible27 Subset of slides for specific audience28 Where new text will be entered29 Object stored in its own file, but displayed

in presentation30 Used to search dictionaries and

encyclopedias

Down 1 Specify order in which objects are to

appear on slide 2 Command to add clip art to slide 4 Closes PowerPoint 6 Object is stored within presentation 8 Controls how object moves on and off

slide 9 Creates a copy of document under

another name or in another folder10 Indicates current slide number and total

number of slides16 Contains tools for creating and formatting

objects on slides17 Shows the slide and speaker notes18 Slide area for text, title, or other object21 Controls how slide moves on and off

screen24 Move item to next highest level in outline

1 2 3 4

5 6

7 8 9

10

11 12

13

14 15 16

17 18

19

20 21

22

23 24 25

26

27

28

29


PowerPoint Chapter 2 – Gaining Proficiency


Entrance or Exit effectsJump starts a presentation

Protects intellectual propertyRemoves part of a pictureCommon format for clip artAbsent during slide show

Click it to open a Web pageCommon format for photographs

Convenient place to save photographsSaves presentation to CD

Imports photographs into a presentationContains the Crop tool

Exempt from copyright protectionRecords duration of a presentation

Displays reviewer changesCommand to initiate a review

Moves slide on and off the screen

C K B K L P H O T O A L B U M N L Y

C N L L R V Y C R O P T O O L R B R

G P L N O I T I S N A R T R R G H E

R X U K D Y T V P T Y D N E A E L D

G T K B T Z H M H P C H O H B N M L

G V Y M L J R G Q R R I I E L A T O

B H P T P I I F O Y S D T A O P R F

B N B M R R C F K E L D A R O S T S

W C L R Y L E D N X H E M S T N R E

Q T L P C G L D O Y J N I E E O D R

F R O K A B T R P M K S N T R I K U

P C J K N O H E C K A L A I U S N T

W N C F G N R N G P R I M M T I N C

G A G X X L X D G G D D N I C V T I

P E N X I K L G R G K E G N I E X P

C N P N Y D R M I W H M Z G P R R Y

L R K J B K K Q T F Z G W S D T K M

D R A Z I W T N E T N O C O T U A Z


PowerPoint Chapter 2 – Gaining Proficiency1

2 3 4

5 6

7 8

9 10 11

12 13

14

15 16

17

18

19 20 21

22 23

24

25

26

27

28 29

30

31

32


Across 3 Imports photographs into a presentation 6 Keyboard Shortcut to annotate a slide 8 Records duration of a presentation10 Saves presentation to CD12 Common format for photographs15 Displays reviewer changes16 Shows outline, slide, and notes22 Ctrl+C is the shortcut25 Command to make photographs smaller26 Command to initiate a review27 Decorative text28 Click it to open a Web page29 Thumbnails or Details31 Contains the Crop tool32 Removes part of a picture

Down 1 Jump starts a presentation 2 Convenient place to save photographs 4 Entrance or Exit effects 5 Helps to align objects 7 Moves slide on and off the screen 9 Popular Web browser11 Ctrl+X is the shortcut13 Ctrl+V is the shortcut14 Common format for clip art17 Absent during slide show18 Exempt from copyright protection19 Tool to copy formatting20 Contains the Properties command21 Use this menu to learn more about

PowerPoint23 Run multiple applications simultaneously24 Protects intellectual property30 Web address

PowerPoint Volume I – (Chapters 1 and 2)


1 2 3 4 5

6 7 8

9

10

11 12

13 14 15 16

17 18 19 20 21

22

23 24 25 26

27

28 29

30 31 32

33 34 35

36

37 38

39 40

41

42 43 44

45

46

47 48 49

50

51 52

53

54 55

56

57

58

59


PowerPoint Volume I – (Chapters 1 and 2)Across

4 Command to make photographs smaller 6 Web address 7 Contains tools for creating objects on

slides 9 Shows the slide and speaker notes11 Convenient place to save photographs12 Fastest way to enter or edit text13 Indicates there are additional slides

currently not visible14 Move item to next lower level in outline15 Tool to copy formatting18 Flags words not found in built-in dictionary21 Removes part of a picture23 Moves slide on and off the screen24 Object is stored within presentation28 Popular Web browser29 Specify order in which objects are to

appear on slide31 Helps to align objects35 Actual slide show itself36 Object stored in its own file, but displayed

in presentation38 Determines nature and position of objects

on slide42 Records duration of a presentation44 Reverses previously executed commands46 Protects intellectual property50 Exempt from copyright protection51 Common format for clip art52 Closes PowerPoint53 Restores previous commands that have

been cancelled55 Changes magnification of slide56 Contains the Properties command57 Subset of slides for specific audience58 Decorative text59 Saves presentation to CD

Down

1 Jump starts a presentation 2 View that makes it easy to reorder slide

and apply transitions 3 Move item to next highest level in outline 5 Keyboard Shortcut to annotate a slide 8 Specifies color scheme and background

design for presentation10 Command to add clip art to slide16 Use this menu to learn more about

PowerPoint17 Ctrl+X is the shortcut19 Catalogs clip art20 Brings copy of existing presentation into

memory22 Creates a copy of document under

another name or in another folder25 Run multiple applications simultaneously26 Command to initiate a review27 Imports photographs into a presentation30 Contains the Crop tool32 Displays reviewer changes33 Entrance or Exit effects34 Used to search dictionaries and

encyclopedias37 Ctrl+V is the shortcut39 Click it to open a Web page40 Where new text will be entered41 Ctrl+C is the shortcut43 Indicates current slide number and total

number of slides45 Absent during slide show47 Common format for photographs48 Slide area for text, title, or other object49 Shows outline, slide, and notes54 Thumbnails or Details

Microsoft® Outlook


Sent with e-mail message Maintains your appointments

Similar to an address bookFolder with erased messagesGet messages from a serverHolds unfinished messages

[email protected], for exampleFolder with colored flagsWhere new mail is kept

Logs activity on your computer

Scheduled for multiple attendeesDisplays Outlook folders

Grants access to a mailboxHolds text of selected message

Periodic appointmentClick button to respond to message

Has a copy of mailed messagesOutlook's version of a "to do" list

Send messages to a serverYou need this plus a password

R T H D Z J S S E R D D A L I A M E

D E C P E K N W G D M B C D K T E T

R A P G L L M E E T I N G M B D L H

E D O L J R E A D I N G P A N E I L

C R Z L Y J R T K N J W Q L S B F E

U O F P P T J X E P X N M E W D D N

R W R W C U G O V D B K N P R R E A

R S D L Z L V B P Z I T J A K M H P

I S O K X J M N Z U I T F C A R C N

N A W C R M R I R T W T E N M L A O

G P N V B K C A E Z S O R M A K T I

E C L K M L D M Q F Q E L N S M T T

V W O R R N S R O N S D R L P K A A

E H A L E M N L K U L U M Z O J J G

N T D L V B D L R M O L X L D F W I

T L A D X E R M J J R P C G C L K V

R C B H R F P W T S I L K S A T G A

T C O N T A C T S F O L D E R X R N


Microsoft® Outlook

Across 1 Folder with copies of mailed messages 2 Grants access to a mailbox 4 Temporary destination of sent messages 7 Similar to an address book 9 Stores Outlook equivalent of Post-Its10 Contains the Options command11 Send messages to a server13 Use this menu to learn about Outlook14 Get messages from a server16 Folder with unopened messages17 Click this button to check for new mail20 Folder with colored flags21 Used to create periodic appointments24 Junk e-mail25 [email protected] (for example)26 Where your new mail is kept27 Adds personal touch to e-mail28 Maintains your appointments

Down 1 Consistent closing for e-mail message 3 List of multiple recipients 5 You need this plus a password 6 Folder that stores erased messages 8 Displays text of selected message12 Document sent with an e-mail message14 Holds unfinished messages15 Displays Outlook folders18 Logs activity on your computer19 Outlook's version of a "to do" list22 Click this button to respond to message23 Scheduled for multiple attendees25 It's much better than snail mail

1 2 3

4 5

6

7 8

9

10

11 12

13

14 15

16

17

18 19

20

21 22 23

24 25

26 27

28


Essential Computing Concepts


Coding schemeInternet Explorer (for example)

Eight bitsThe brain of a computerHigh speed connectionHolds more than a CD

Media for drive AProgram to upload or download files

Approximately one billion bytesA measure of clock speedUses a mouse and icons

Company that created open PCManufactures the Pentium

Network of networksInput device used with games

Approximately one thousand bytesConnected computers (short distance)

Common output deviceCompany that created Windows

Connected computersUsed to measure resolutionProgram for presentationsYou need at least 256MB1024 x 768 (for example)

Operating SystemBerners-Lee creation

Language to describe data

C B Q L K Z T R E H A G I G T V T H K

T M R N X Y M N T M A R N K X W R B Z

R N G M L M K B N T K W L G L C M I T

E T Q U G Z L T I D R N M G F V T I M

S F P V I L A S E R P R I N T E R C C

O O X Z M D T K N H B B J N D J D S T

L S S P H Q N D S L W G R L L M V A X

U O W N V Z I M N N P P L O L E D T P

T R O M Z C O C M D J E T R W H T G T

I C D M F G P T L T X C G Z L S I N K

O I N M T Y R L K I E K C R X G E S I

N M I K P W E M P D C N R X A G I R L

K K W L H V W X L I M D R B B D W Q O

W L A B K R O W T E N R Y E Y B T T B

P N Y N Z R P S N R R T T P T N W M Y

X T J K B R Y K D T E Z P G U N J N T

E D F R X O H W W W H O N P H W I T E

L Z N B J J R F T C L N C M T G V X N

L T C K L K L L C F K J K Z G R G T T


Essential Computing Concepts

Across

5 You need at least 256MB 8 Operating System10 Approximately one thousand bytes13 Company that created Windows15 Infectious program17 Manufactures the Pentium19 Connected computers (short distance)20 Common output device21 Internet Explorer (for example)24 Eight bits25 The brain of a computer28 Enables plug and play29 A measure of clock speed30 Coding scheme34 Computer by Apple35 Used to measure resolution36 Arial (for example)37 Approximately one billion bytes

Down

1 Program for presentations 2 Media for drive A 3 Uses a mouse and icons 4 High speed connection 6 Input device 7 Input device used with games 9 Connected computers11 Holds more than a CD12 History's first programmer14 Network of networks16 Used to organize documents18 Specification of a digital camera21 Early computer pioneer22 Berners-Lee creation23 1024 x 768 (for example)26 Printed output27 Program to upload or download files31 Company that created open PC32 Language that describes data33 Text-based operating system

1 2

3 4 5 6

7 8 9

10

11 12 13 14

15

16 17

18

19 20

21 22 23 24 25

26 27

28 29

30 31

32 33

34

35

36

37


The Internet and World Wide Web


Boolean operatorReturns to previous page

Internet Explorer (for example)Small text file

Protects intellectual propertyInvisible realm of the Internet

High speed connectionUsed with HTTPS

Returned by a search engineLanguage of the Web

Secure protocolTakes you to a new page

Provides Internet AccessConnected Computers (short distance)

Internet Explorer competitorTechnology used by Napster

Gateway to the InternetHTTP (for example)

Request to search engineGoogle (for example)

Builds search engine databaseInvented the WebInternet address

Berners-Lee creationLanguage to describe data

E J M C O P Y R I G H T S Z Y N B N

N V L T Y M Z N J B E E K R K E E O

C Y L M L I Z K V C A N E F R T I T

R M K K H R S M A R M U L M T S K T

Y P R X N R U P C K Q Z R N E C O U

P D D G R K S H R L H E H Y E A O B

T K N I L R E P Y H S T K P L P C K

I C L W E N D F W W M H O G S E F C

O Y L B G T I H O L R R T K R N R A

N M Y I P H D R N L T F R B E A G B

Y C N D M R B M E A Q B H V N V F M

K E L A N E O B L D Y K T H R I D R

H Z L M H T D T F L I J T K E G R J

J Z K D D W T O O P M P P N B A F M

L K N N W X M L M C M G S W M T P K

T M A Z N W R M T L O T J C I O G W

J M C B Z T W H K R S L R F T R H G

R E E P O T R E E P R D R W X M L J


The Internet and World Wide Web

Across

2 Web sites from last week 4 Boolean operator 9 Takes you to a new page11 Protects intellectual property12 Interface with telephone system13 Language of the Web15 Secure protocol18 Invented the Web19 New file format22 Invisible realm of the Internet25 High speed connection26 Alternative to DSL29 High level domain for Australia31 Used to cite a reference32 Request to search engine33 Google (for example)35 Program to create Web sites36 201.102.85.123 (for example)37 Small text file38 Gateway to the Internet

Down

1 Used with HTTPS 3 Builds search engine database 5 Connected computers (short distance) 6 HTTP (for example) 7 Has icons for common commands 8 An Internet address10 Technology used by Napster14 Competitor to Internet Explorer16 .com or .edu (for example)17 Berners-Lee creation20 Provides Internet access21 Contains the Page Setup command23 Returns to previous page24 Language to describe data27 Internet Explorer (for example)28 Improves PC performance30 ShockWave or RealPlayer34 Returned by a search engine

1 2 3

4 5

6 7 8

9 10 11

12

13 14

15

16

17 18

19 20 21

22

23 24 25

26 27 28

29

30 31

32

33 34

35

36

37

38


wps.pearsoncustom.comwps.pearsoncustom.com/wps/media/objects/2407/2464931/exp... · web viewto the...

Documents