Muutke küpsiste eelistusi

Prentice Hall MOUS Test Preparation Guide for Excel 2000 with CD [Pehme köide]

,
  • Formaat: Paperback / softback, 431 pages, laius x paksus: 275x15 mm, kaal: 923 g
  • Ilmumisaeg: 15-Sep-2000
  • Kirjastus: Pearson
  • ISBN-10: 0130277444
  • ISBN-13: 9780130277442
Teised raamatud teemal:
  • Pehme köide
  • Hind: 42,39 €*
  • * saadame teile pakkumise kasutatud raamatule, mille hind võib erineda kodulehel olevast hinnast
  • See raamat on trükist otsas, kuid me saadame teile pakkumise kasutatud raamatule.
  • Kogus:
  • Lisa ostukorvi
  • Tasuta tarne
  • Lisa soovinimekirja
Prentice Hall MOUS Test Preparation Guide for Excel 2000 with CDSuurem pilt
  • Formaat: Paperback / softback, 431 pages, laius x paksus: 275x15 mm, kaal: 923 g
  • Ilmumisaeg: 15-Sep-2000
  • Kirjastus: Pearson
  • ISBN-10: 0130277444
  • ISBN-13: 9780130277442
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9780130277442.html
Märksõnad:
Based on the actual MOUS exams, the streamlined PH MOUS Test Prep Guide text/software packages coach students through successful completion of the MOUS certification examsfrom Core to Expert skill levels. Dynamically interactiveenhanced by the unparalleled MOUS PinPoint 2000 softwarethe series takes students step-by-step to guaranteed success. Each chapter focuses on specific learning objectives (based on the Core and Expert MOUS objectives), discusses specific skills necessary to complete the MOUS certification exam, and walks students through condensed step-by-step mini-tutorials for a specific skill set. Students then use the interactive program on the student MOUS PinPoint interactive CD-ROM (included in every copy of the text) to see the material demonstrated, to complete in-text projects, and to practice for the MOUS exams.
Preface xi
Start with Windows 1(1)
Turn on the Computer
2(2)
Get Used to the Pointing Device
4(3)
Use the Start Menu
7(1)
Handle Windows
8(5)
Interact with Programs
13(2)
View the Contents of Your Computer
15(6)
Manage the Contents of Your Computer
21(7)
Customize Windows
28(7)
Exit Windows
35(6)
Key Terms
36(1)
Review Questions
36(3)
Exercise and Project
39(2)
Get Started with Excel
41(26)
Start Excel
42(1)
Explore the Excel Screen
43(3)
Show Full Menus and Toolbars
46(1)
Move Around in a Workbook
47(2)
Enter Text, Numbers, and Dates
49(3)
Use AutoSum
52(2)
Save a Workbook
54(2)
Save Another Version of the File
56(1)
Create a New Folder
57(1)
Print a Worksheet
58(1)
Use the Office Assistant
59(1)
Start a New Workbook
60(1)
Close Files and Exit Excel
61(6)
Use PinPoint
62(1)
Key Terms
62(1)
Review Questions
63(2)
Exercise and Project
65(2)
Edit Worksheet Contents
67(23)
Open a Workbook
68(1)
Locate a Workbook
69(1)
Enter Formulas in a Cell
70(3)
Create a Budget
73(1)
Format Cells
74(2)
Edit Cell Content
76(2)
Use AutoFill
78(2)
Clear Cell Content
80(1)
Use the Undo and Redo Features
81(1)
Use Find and Replace
82(2)
Check Spelling
84(6)
Use PinPoint
85(1)
Key Terms
85(1)
Review Questions
85(4)
Exercise and Project
89(1)
Modify Worksheet Structure
90(19)
Select Cells, Rows, or Columns
91(1)
Rearrange Text
92(3)
Collect and Paste
95(2)
Insert and Delete
97(2)
Change the Size of Rows and Columns
99(2)
Freeze and Unfreeze
101(1)
Use Zoom and Full Screen
102(2)
Calculate an Average
104(5)
Use PinPoint
104(1)
Key Terms
105(1)
Review Questions
105(2)
Exercise and Project
107(2)
Control Cell References
109(15)
Use Relative and Absolute Cell References
110(2)
Create a Running Sum
112(1)
Use Named Ranges
113(4)
View Formulas
117(1)
Use Auditing Tools
117(7)
Use PinPoint
120(1)
Key Terms
120(1)
Review Questions
120(3)
Exercise and Project
123(1)
Manage Pages and Printing
124(18)
Print a Document
125(1)
Use Print Preview
126(1)
Set the Print Area
127(1)
Print Large Worksheets
128(1)
Set Margins and Centering
129(2)
Set Up Headers and Footers
131(1)
Specify Sheet Options
132(3)
Manage Page Breaks
135(7)
Use PinPoint
137(1)
Key Terms
138(1)
Review Questions
138(3)
Exercise and Project
141(1)
Format Worksheets
142(25)
Format Numbers
143(3)
Create Custom Number Formats
146(2)
Format Text
148(2)
Format Alignment
150(3)
Format Borders and Shading
153(2)
Use AutoFormat
155(1)
Remove Cell Formatting
156(1)
Copy Formatting
157(3)
Find the Breakeven Point with Goal Seek
160(7)
Use PinPoint
161(1)
Key Terms
161(1)
Review Questions
161(3)
Exercise and Project
164(3)
Use Functions
167(18)
Use Basic Functions
168(1)
Use Date Functions
169(1)
Use the Formula Palette
170(3)
Use Lookup Functions
173(2)
Create Conditional Formulas and Formatting
175(3)
Nesting Functions
178(7)
Use PinPoint
180(1)
Key Terms
180(1)
Review Questions
180(3)
Exercise and Project
183(2)
Use Financial Functions
185(17)
Use the Pmt Function
186(2)
Create an Amortization Table
188(4)
Find Present and Future Values
192(2)
Depreciate an Asset
194(8)
Use PinPoint
196(1)
Key Terms
197(1)
Review Questions
197(2)
Exercise and Project
199(3)
Work with Pictures and Objects
202(21)
Insert Pictures
203(3)
Modify a Picture
206(2)
Create Drawing Objects
208(2)
Modify Drawing Objects
210(6)
Use WordArt
216(7)
Use PinPoint
218(1)
Key Terms
218(1)
Review Questions
218(3)
Exercise and Project
221(2)
Create Charts
223(29)
Create an Automatic Chart
224(1)
Learn About Charts
224(1)
Create Charts Using the Wizard
225(2)
Size and Move an Embedded Chart
227(1)
Turn on the Chart Toolbar
228(1)
Choose the Chart Type
229(4)
Modify the Chart
233(4)
Format Chart Components
237(6)
Use Pictures in Charts
243(2)
Print Charts
245(7)
Use PinPoint
246(1)
Key Terms
247(1)
Review Questions
247(2)
Exercise and Project
249(3)
Handle Multiple Worksheets
252(16)
Insert and Delete Sheets
253(1)
View and Rename Sheets
254(1)
Move and Copy Sheets
255(2)
Link Worksheets and Workbooks
257(1)
Consolidate Worksheets
258(4)
Preview and Print Multiple Worksheets
262(6)
Use PinPoint
263(1)
Key Terms
263(1)
Review Questions
263(3)
Exercise and Project
266(2)
Import and Export
268(16)
Import a Text File
269(4)
Import from Other Applications
273(2)
Convert an Imported File to Excel
275(1)
Export a Worksheet or Chart
276(8)
Use PinPoint
279(1)
Key Terms
279(1)
Review Questions
279(3)
Exercise and Project
282(2)
Manage Data and Lists
284(30)
Add and Edit Data
285(1)
Use the Data Form
286(1)
Validate Data
287(3)
Sort
290(2)
Use a Custom Data List
292(1)
Summarize Data
293(3)
Find a Record Using a Data Form
296(1)
Use an AutoFilter to Find Certain Records
297(2)
Use Advanced Filters
299(2)
Query an External Database
301(2)
Use PivotTable and PivotChart Reports
303(11)
Use PinPoint
308(1)
Key Terms
308(1)
Review Questions
308(4)
Exercise and Project
312(2)
Do What-If Analysis
314(15)
Use Data Tables
315(2)
Use Scenarios
317(3)
Use Report Manager
320(1)
Use Solver
321(8)
Use PinPoint
324(1)
Key Terms
324(1)
Review Questions
324(3)
Exercise and Project
327(2)
Use Excel with the Web
329(19)
Send Excel Data via Email
330(1)
Use Hyperlinks
331(3)
Save a Workbook as a Web Page
334(4)
Save and Publish on the Web
338(2)
Edit an Excel Web Page
340(1)
Publish a PivotTable on the Web
341(7)
Use PinPoint
344(1)
Key Terms
344(1)
Review Questions
344(3)
Exercise and Project
347(1)
Work with Templates and Macros
348(19)
Use Templates
349(3)
Use Macros
352(2)
Modify an Existing Macro
354(1)
Customize Excel's Toolbars
355(4)
Customize Excel
359(8)
Use PinPoint
361(1)
Key Terms
362(1)
Review Questions
362(3)
Exercise and Project
365(2)
Collaborate with Workgroups
367(51)
Make Comments
368(3)
Create a Shared Workbook
371(2)
Track Changes
373(2)
Protect a Workbook
375(2)
Add File Passwords
377(2)
Merge Workbooks
379(1)
Change Workbook Properties
380(7)
Use PinPoint
382(1)
Key Terms
382(1)
Review Questions
382(3)
Exercise and Project
385(2)
Appendix
A MOUS Skill Guides for Core and Expert Objectives
387(5)
MOUS Core Skill Guide
387(2)
MOUS Expert Skill Guide
389(3)
B Use PinPoint 2000 Software
392(17)
Introduction to PinPoint 2000
392(1)
The PinPoint 2000 Launcher
392(1)
Concurrency
392(1)
Trainer/Evaluation Pairs
393(1)
Tasks
393(1)
System Requirements
394(1)
Run PinPoint 2000
394(1)
Install the Launcher to Your Computer
395(1)
Prepare to Run the PinPoint 2000 Launcher
396(1)
Start the PinPoint 2000 Launcher
397(1)
Start PinPoint 2000 Trainers and Evaluations
398(3)
Run a Trainer
401(3)
Run an Evaluation
404(1)
View Reports in the Launcher
405(2)
Recover from a Crash During a Trainer or Evaluation
407(1)
Remove PinPoint 2000
407(2)
C Prepare for MOUS Certification
409(3)
How to Prepare for the Exams
409(1)
Register for and Take and the Exam
409(1)
The Day of the Exam
410(1)
The Exam Itself
410(1)
General Tips
411(1)
D Answers to Review Questions
412(6)
Index 418