carolsmith62's picture
From carolsmith62 rss RSS  subscribe Subscribe

MOS-E2K Practice Tests & Exams 

CertMagic.com is a place where you can find various types of MOS-E2K exam certifications preparation material. CertMagic’s full range of study material for the MOS-E2K exam helps you to be prepared for the MOS-E2K exam fully and enter the exam centre with full confidence.We provide you easy, simple and updated study material. After preparing from the MOS-E2K exam material prepared by us we guarantee you that you will be a certified professional. We guarantee that with CertMagic MOS-E2K study material, you will pass the Certification exam.

 

 
 
Tags:  MOS-E2K Exams  MOS-E2K Certification  MOS-E2K Training  MOS-E2K Practice Exams  MOS-E2K Tests  MOS-E2K Exam Materials  MOS-E2K download 
Views:  284
Published:  November 19, 2009
 
0
download

Share plick with friends Share
save to favorite
Report Abuse Report Abuse
 
Related Plicks
640-802 Practice Tests & Exams

640-802 Practice Tests & Exams

From: carolsmith62
Views: 2808 Comments: 0

CertMagic.com is a place where you can find various types of 640-802 exam certifications preparation material. CertMagic’s full range of study material for the 640-802 exam helps you to be prepared for the 640-802 exam full (more)

 
642-542 Practice Tests & Exams

642-542 Practice Tests & Exams

From: carolsmith62
Views: 2642 Comments: 0
CertMagic.com is a place where you can find various types of 642-542 exam certifications preparation material. CertMagic’s full range of study material for the 642-542 exam helps you to be prepared for the 642-542 exam fully and enter the exam centr (more)

 
4h0-100 Exam

4h0-100 Exam

From: Seal.heart
Views: 503 Comments: 0
CertMagic.com is a place where you can find various types of 4h0-100 exam certifications preparation material. CertMagic’s full range of study material for the 4h0-100 exam helps you to be prepared for the 4h0-100 exam fully and enter the exam centr (more)

 
1T6-511 Exam

1T6-511 Exam

From: Seal.heart
Views: 477 Comments: 0
CertMagic.com is a place where you can find various types of 1T6-511 exam certifications preparation material. CertMagic’s full range of study material for the 1T6-511 exam helps you to be prepared for the 1T6-511 exam fully and enter the exam centr (more)

 
See all 
 
More from this user
MB7-221 Practice Tests & Exam

MB7-221 Practice Tests & Exam

From: carolsmith62
Views: 1349
Comments: 0

000-301 Practice Tests & Exams

000-301 Practice Tests & Exams

From: carolsmith62
Views: 1470
Comments: 0

4H0-100 Practice Tests & Exams

4H0-100 Practice Tests & Exams

From: carolsmith62
Views: 1011
Comments: 0

650-175 Practice Tests & Exams

650-175 Practice Tests & Exams

From: carolsmith62
Views: 1060
Comments: 0

000-743 Practice Tests & Exams

000-743 Practice Tests & Exams

From: carolsmith62
Views: 1014
Comments: 0

HP0-763 Practice Tests & Exams

HP0-763 Practice Tests & Exams

From: carolsmith62
Views: 1339
Comments: 0

See all 
 
 
 URL:          AddThis Social Bookmark Button
Embed Thin Player: (fits in most blogs)
Embed Full Player :
 
 

Name

Email (will NOT be shown to other users)

 

 
 
Comments: (watch)
 
 
Notes:
 
Slide 1: MOS-E2K Microsoft Excel 2000 CORE Exam: MOS-E2K Demo Edition CERT MAGIC 1 http://www.certmagic.com
Slide 2: MOS-E2K QUESTION 1 Change the chart to a simple two-dimensional pie chart. Answer: Step 1: Select the Chart Type button Step 2: Select Pie chart. QUESTION 2 Add a header to the worksheet with Investment Analysis appearing at the left of the header, and the page number appearing at the right. In the footer, include the current data in the center. 2 http://www.certmagic.com
Slide 3: MOS-E2K Answer: Step 1: Select the View menu. Step 2: Select the Header and Footer command. Step 3: Click the Custom Header button. Step 4: Click in the Left section text box. Step 5: Write: Investment Analysis Step 6: Click in Center section text box. Step 7: Click the Page number button. Step 8: Click OK. 3 http://www.certmagic.com
Slide 4: MOS-E2K Step 9: Click the Custom Footer button. Step 10: Click in the Center section text box. Step 11: Click OK. Step 12: Click OK. QUESTION 3 Clear the contents of the quarterly values for France in the range B9:E9. Answer: 4 http://www.certmagic.com
Slide 5: MOS-E2K Step 1: Click cell B9. Step 2: Press the Shift key and click cell E9. Step 3: Press the Delete key. QUESTION 4 Delete the content in the cell range A9:F9. Then, add 1 row before Europe. Add England and Ireland in cells A9 and A10. Finally, copy the formula in cell F8 to cells F9 and F10. Answer: Step 1: Click cell A9. Step 2: Press the Shift key and click cell F9. Step 3: Press the Delete key. Step 4: Click cell A10. Step 5: Select the Insert menu. Step 6: Select the Rows command. Step 7: Click cell A9. Step 8: Type England and hit the Enter key. Step 9: Type Ireland and hit the Enter key. Step 10: Click the cell F8. Step 11: Use autofill to copy the cell to F9 and F10 (see below). QUESTION 5 In cell A3, type Date: and enter 01/07/99 in cell F3 as a date. When you are finished, enter the following revenue projections in cells D6 through E6 respectively. 5 http://www.certmagic.com
Slide 6: MOS-E2K D6: 278927 E6: 344981 Answer: Step 1: Click cell A3. Step 2: Type Date: and press enter. Step 3: Click cell F3. Step 4: Type 01/07/99 and press enter. Step 5: Click cell D6. Step 6: Type 278927 and press the Tab key. Step 7: Type 344981 and press Enter. QUESTION 6 Set a print area to display the investment information for years 2 through 10, including initial investment amount and the label in Cell A1. 6 http://www.certmagic.com
Slide 7: MOS-E2K Answer: Step 1: Click cell C7. Step 2: Press the Shift key and click cell G1. We select the investment information for years 2 through 10 Step 3: Press the Ctrl key, click cell B3, and click cell A1. We include the initial investment amount and the label in cell A1. Step 4: Select the File menu. Step 5: Select the Print Area command. Step 6: Select the Set print area subcommand. QUESTION 7 Format the specified cells and cell ranges as follows: F2 Change the date format to display in a Month/Year format. B6:F18 Change the numeric format to Number, 1 decimal place, and use a comma (,) to separate 1000s. G22:G34 Change the format to percentage with 1 decimal place. Answer: Step 1: Click cell F4. Step 2: Select the Format menu. Step 3: Select the Cells command. Step 4: Select the Number tab if it is not selected. Step 5: Select the Category Custom 7 http://www.certmagic.com
Slide 8: MOS-E2K Step 6: Select the Type mmm-yy. Step 7: In the type field replace mmm-yy with mmm/yy Step 8: Click OK. Step 9: Click cell F6. Step 10: Press the Shift key and click cell F18. Step 11: Select the Format menu. Step 12: Select the Cells command. Step 13: Select the Category Number Step 14: Change Decimal places to 1. Step 15: Select Use 1000 seperator (,). Step 16: Click OK. Step 17: Click cell G22. Step 18: Scroll down until you see cell G34. Step 19: Press the Shift key and click cell G34. Step 20: Select the Format menu. Step 21: Select the Cells command. 8 http://www.certmagic.com
Slide 9: MOS-E2K Step 22: Select the Category Percentage, Step 23: Change Decimal places to 1. Step 24: Click OK. QUESTION 8 Rename the first worksheet in this workbook 1999 Investment, and the second worksheet 2000 Amortization. Answer: Step 1: Right-click on the Investment Analysis tab. 9 http://www.certmagic.com
Slide 10: MOS-E2K Step 2: Select Rename. Step 3: Write: 1999 Investment Step 4: Press the Enter key Step 5: Right-click on the Investment Analysis tab. Step 6: Select Rename. Step 7: Write: 2000 Amortization Step 8: Press the Enter key QUESTION 9 Using the ClipArt Gallery, add the clip art, named Books from the Academic category into the existing worksheet in cell H1. Resize the image to fit above the worksheet title. Answer: Step 1: Click cell H1. Step 2: Select the Insert menu. Step 3: Select the Picture command. Step 4: Select Clip Art Step 5: Select the category Academic. Step 6: Find the Clip Books and select it. Step 7: Click Insert button. Step 8: Resize the image so it fits. 10 http://www.certmagic.com
Slide 11: MOS-E2K QUESTION 10 Format the Worksheet ranges as follows: A4:C4 Arial, 15 point, Bold A5:C10 Arial, 12 point, Bold, Italic, Red Answer: Step 1: Click cell A4. Step 2: Press the Shift key and click cell C4. Step 3: Select the Format menu. Step 4: Select the Cells command. Step 5: Select the Font tab. Step 6: Select Font Arial. Step 7: Select Font Style Bold. Step 8: Enter 15 in the Size field. Step 9: Click OK. Step 10: Click cell A5. Step 11: Press the Shift key and click cell C10. Step 12: Select the Format menu. Step 13: Select the Cells command. Step 14: Select the Font tab. 11 http://www.certmagic.com
Slide 12: MOS-E2K Step 15: Select Font Arial. Step 16: Select Font Style Bold Italic. Step 17: Select size 12. Step 18: Select red Color. Step 19: Click the OK button. QUESTION 11 Change the alignment of cell range A5:A16 to Left-aligned, cell range B4:E4 to Center-aligned, and cell range B5:E17 to right aligned. Answer: Step 1: Click cell A5. Step 2: Press Shift and click cell A16. Step 3: Select the Format menu. Step 4: Select the Cells command. Step 5: Select the Alignment tab. Step 6: Select Horizontal Left (Indendant). 12 http://www.certmagic.com
Slide 13: MOS-E2K Step 7: Click OK. Step 8: Click cell B4. Step 9: Press Shift and click cell E4. Step 10: Select the Format menu. Step 11: Select the Cells command. Step 12: Select the Alignment tab. Step 13: Select Horizontal Center. Step 14: Click OK. Step 15: Click cell B5. Step 16: Press Shift and click cell E17. Step 17: Select the Format menu. Step 18: Select the Cells command. Step 19: Select the Alignment tab. Step 20: Select Horizontal Right (Indent). 13 http://www.certmagic.com
Slide 14: MOS-E2K Step 21: Click OK. QUESTION 12 Create a clustered chart displaying the regions in cell range A5:A12 and their total revenues in cell range F5:F12. Title the chart Total Revenue, remove the legend and insert the chart as a new worksheet. Answer: Step 1: Click cell A5. Step 2: Press the Shift key and click cell A12. Step 3: Press the Ctrl key and clock cell F5. Step 4: Press the Shift key and click cell F12. Step 5: Select the Insert menu. Step 6: Select the Chart command. Step 7: Click the Next button. Note: By default a clustered Column diagram will be selected. Step 8: Click the Next button. Step 9: Enter the Chart title Total Revenue 14 http://www.certmagic.com
Slide 15: MOS-E2K Step 10: Click the Legend tab. Step 11: Disable the Remove legend option. Step 10: Click the Next button. Step 11: Select As new sheet. Step 11: Click the Finish button. QUESTION 13 Correct the formula in cell B17. 15 http://www.certmagic.com
Slide 16: MOS-E2K Answer: Step 1: Click the Formula bar. Step 2: Replace the formula =SUM(B1:C5) with =SUM(B5:B16) Step 3: Press Enter. QUESTION 14 Using the NOW worksheet function, enter the current date and time in cell A3. 16 http://www.certmagic.com
Slide 17: MOS-E2K Answer: Step 1: Click cell A3. Step 2: Enter the formula: =now() Step 3: Press Enter. QUESTION 15 Using the Go To feature navigate to cell F36. Answer: Step 1: Select the Edit menu. Step 2: Select the Go To command. Step 3: Type F36 in the Reference field. Step 4: Click OK. QUESTION 16 Apply the following formats: (1) Apply the light yellow shading to cell range A5:A12. (2) Add Outside Borders formatting to cell range A13:G13. 17 http://www.certmagic.com
Slide 18: MOS-E2K Answer: Step 1: Click the A5 cell. Step 2: Press the Shift key and click the A12 cell. Step 3: Select the Format menu. Step 4: Select the Patterns tab. Step 5: Select light yellow Cell shading. Step 6: Click OK. Step 7: Click cell A13 Step 8: Press the Shift key and click the G13 cell. Step 9: Select the Borders button. 18 http://www.certmagic.com
Slide 19: MOS-E2K Step 10: Select Outside Borders. QUESTION 17 Modify the format of the interest rates in cells B8:B21 to display 3 decimal places. Answer: Step 1: Click cell B8. Step 2: Press Shift and click cell B21. Step 3: Select the Format menu. Step 4: Select the Cells command. Step 5: Select the Number tab (if not selected) 19 http://www.certmagic.com
Slide 20: MOS-E2K Step 6: Increase Decimal places to 3. Step 7: Click OK. QUESTION 18 Complete the following tasks: (1) Freeze panes at cell C7. (2) Then, navigate to the value for the 20-year investment at 12 percent. Answer: Step 1: Click cell C7. Step 2: Select the Windows menu. Step 3: Select the Freeze panes command. Step 4: Scroll to the right until you see 12.5% 20 http://www.certmagic.com
Slide 21: MOS-E2K Step 5: Click cell 12.5%/20 Years. QUESTION 19 Enter a formula in cell H13 using the IF statement to determine if the total Revenue in cell F13 exceeded the goal in cell G13 and return the word "yes" if total revenue exceeded the goal and "no" if it did not. Answer: Step 1: Click cell H13 Step 2: Enter the following formula: =(IF,F13>G13,"yes","no") Note: The formula bar will look like: Step 3: Press the Enter key. 21 http://www.certmagic.com
Slide 22: MOS-E2K QUESTION 20 Change the following cell entries: A3: Change to Report Date: F3: Change to 02/09/99 B13: Change to 134211 Answer: Step 1: Click cell A3. Step 2: Enter text: Report Date: Step 3: Press the Enter key. Step 4: Click cell F3. Step 5: Enter text: 02/09/99 Step 6: Press the Enter key. Step 7: Click cell B13 Step 8: Enter text: 134211 Step 9: Press the Enter key. 22 http://www.certmagic.com

   
Time on Slide Time on Plick
Slides per Visit Slide Views Views by Location