1 / 12
Télécharger la présentation

MS-Excel XP

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. MS-Excel XP Lesson 8

  2. Inserting and Formatting a Comment • Select cell or cell range • Insert menu, comment menu item • Type message to comment • Minimize the comment range • Right click on comment frame • Select format comment • Format comment font, alignment and colors and lines • Click ok • Insert menu, Edit comment menu item for editing a comment • Right click on commented cell or range and select delete comment to deleting a comment

  3. Validating Cells • Select cell or cell range • Data menu, Validation menu item • Settings tab sheet, select validation criteria (allow, data, minimum, maximum) • Input message tab sheet, title and message • Error alert tab sheet, error style, title and message • Click ok • Select Data, Validation, Clear All to remove a validation from cell or cell range

  4. Freeze Panes • Select row or column for freezing (immediate below row or immediate right side column) • Window menu, Freeze panes menu item • Use horizontal and vertical scroll bars to scrolling in freeze panes • To remove freeze panes, select window menu, Unfreeze panes menu item

  5. Hiding and Unhiding a Workbook • Window menu, hide menu item • To unhide a workbook • Window menu, unhide menu item • Select workbook • Click ok Splitting a Workbook • Window menu, split menu item (4 split windows) • To removing split • Window menu, remove split menu item

  6. Macros • You can use macro for storing a process that you are doing using excel and you can run the macro to do same process irrespectively • Recording a macro • Tools menu, Macro sub menu, Record new macro menu item • Select macro name, short cut key and store macro in values and click ok • Create worksheet process • Click stop button in macro tool bar

  7. Running a Recorded Macro • Select workbook and worksheet • Tools menu, Macro sub menu, Macros menu item • Select macro and click run button • You can use shortcut key to call the macro

  8. Assigning a Macro to Drawing Object • Use drawing tool bar and draw object on worksheet • Right click on drawing object and select assign macro menu item • Select macro and click ok button • Click on drawing object to run the macro

  9. PMT Function • Financial function • Calculates the amount of periodic payment needed to pay off a loan • Calculates the payments for a loan based on constant payment and a constant interest rate • =PMT(Monthly interest rate, Loan paying duration in months, negative value of a loan amount)

  10. PMT Function Eg. Loan amount: Rs. 800,000 in B1 cell Annual interest rate: 10% B2 cell Duration: 5 years in C2 cell Monthly Payment: D2=PMT(B2/12,C2*12,-B1)

  11. LOG Function • Math & Trig function • Returns the logarithms of a number to the base you specified. • =LOG(number,base) Eg. =LOG(5,10)  0.69897 PI Function • Returns the value of a pi =PI() RADIANS Function • Converts degrees to radians =RADIANS(90)

  12. DEGREES Function • Converts radians to degrees =DEGREES(1.570796) SIN Function • Returns the sin of an angle =SIN(90) COS Function • Returns the cosine of an angle =COS(90)

More Related