1 / 151

Create a new , blank work book

Create a new , blank work book. SUBMIT. TRY AGAIN. Open the ECDL.xls workbook that is in My Document folder. SUBMIT. TRY AGAIN. Save this workbook (which is currently a Microsoft Excel 2000 file ) in a format suitable for users with a previous version of Excel

kimberly
Download Presentation

Create a new , blank work book

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Create a new, blank work book

  2. SUBMIT TRY AGAIN

  3. Open theECDL.xlsworkbook that is in My Document folder

  4. SUBMIT TRY AGAIN

  5. Save this workbook (which is currently a Microsoft Excel 2000 file ) in a format suitable for users with a previous version of Excel Note: Don't change the file location

  6. SUBMIT TRY AGAIN

  7. Advanced filter Use Microsoft Excel help to access information on Advanced filter

  8. SUBMIT TRY AGAIN

  9. Sangor Change the user name of this application to Sangor

  10. SUBMIT TRY AGAIN

  11. 416 Enter the value 416 in cell E58 Click any other cell when you finish

  12. SUBMIT TRY AGAIN

  13. Click on the location that selects all the cells in row 5

  14. SUBMIT TRY AGAIN

  15. You wish to reverse the last changes that you have made to this work sheet Choose the appropriate command to do this.

  16. SUBMIT TRY AGAIN

  17. Automatically adjust the height of row 94 to fit it's tallest content.

  18. SUBMIT TRY AGAIN

  19. Cost Change the content of cell D114 to the word Cost Press Enter when you have finished.

  20. SUBMIT TRY AGAIN

  21. Copy the selected range and past it cell A1 in the worksheet entitled Osman in this work book

  22. SUBMIT TRY AGAIN

  23. Clear the content of cell B3 without deleting the cell

  24. SUBMIT TRY AGAIN

  25. ECDL ICDL Use the replacement tool to replace all words ECDL with ICDL

  26. SUBMIT TRY AGAIN

  27. Automatically sort this list so that the highest mark displays at the top of the list

  28. SUBMIT TRY AGAIN

  29. Insert a new work sheet into this workbook

  30. SUBMIT TRY AGAIN

  31. Move the Osman worksheet into Elsangary workbook so it will displays after the other worksheet

  32. SUBMIT TRY AGAIN

  33. Which one of the following formulas would be appropriate to calculate the the monthly surplus for September in this worksheet? =B5+B11 =SUM(B5:D5)-SUM(B11:D11) =B5-B11 =AVERAGE(B5:D5)-AVERAGE(B11:D11)

  34. SUBMIT TRY AGAIN

  35. If the enter key was pressed to accept the formula in cell B9 which of the following would be the result: A #REF! error message A #VALUE? error message A #NAME? error message

  36. SUBMIT TRY AGAIN

  37. Which formula entered into C3 would calculate the Total Cost of Barrels for the Oil Deco company and if it copied down automatically calculate the Total Cost for all the other customers. =B3*C1 =B3*C$1 =B$3*$C$1 =$B$3*C1

  38. SUBMIT TRY AGAIN

  39. Which formula entered into B5 will calculate the total Cost of a Colonial style chair (including delivery) and if copied to C5 will perform a similar calculation for the Metro style chair? =Sum($B$2:$B$4)+B8 =Sum(B2:B4)+$B$8 =Sum(B2:B5)+$B$8 =Sum(C2:C4)+$C$8

  40. SUBMIT TRY AGAIN

  41. Which formula entered into B5 will calculate the total Cost of a Colonial style chair (including delivery) and if copied to C5 will perform a similar calculation for the Metro style chair? =Sum($B$2:$B$4)+B8 =B2+B3+B4+$B$8 =Sum(B2:B5)+$B$8 =Sum(C2:C4)+$C$8

  42. SUBMIT TRY AGAIN

  43. Type a function into cell B7 that smallest value in the highlighted range.Press the enter key when you have finished. =MIN(B2:B6)

  44. SUBMIT TRY AGAIN

  45. Which formula entered into B10 would calculate the total amount of a rainfall that fell in the seven days? =SUMB3:B9 =SUM(B3:B9) =(SUM)B3:B9 SUM=(B3:B9)

  46. SUBMIT TRY AGAIN

  47. Which formula would display into Pass in cell C2 if the mark is over 74 , and Fail if not. =IF(B2>74,Pass,Fail) =IF(C2>74,”Pass”,”Fail”) =IF(B2<74,”Pass”,”Fail”) =IF(B2>74,”Pass”,”Fail”)

  48. SUBMIT TRY AGAIN

  49. Add a border round the selected range. Note: Don't change the default line style

  50. SUBMIT TRY AGAIN

More Related