1 / 23

Excel application for accounting principles

Excel application for accounting principles. Formatting in EXCEL. Using the Home Tab Commands to Format Data. Merging Cells. Merging Cells. Notice: (1) When you click on “merge & centre “ button, there are many options: (a) Merge & Centre (b) Merge Across

shino
Download Presentation

Excel application for accounting principles

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. Excel application for accounting principles

  2. Formatting in EXCEL

  3. Using the Home Tab Commands to Format Data

  4. Merging Cells

  5. Merging Cells • Notice: (1) When you click on “merge & centre “ button, there are many options: (a) Merge & Centre (b) Merge Across (c) Merge Cells (d) Unmerge Cells. (2) Wrap text button used to type a text in the merged cells.

  6. Merge & centre: merge the cells and centre the text that already typed in the cells. • Merge Across: merge the cells only for the text that has been typed in the cells. • Merge cells: merge more than one cell to type something. • Unmerge cells: let the cells unmerged (the cells returned to their normal case).

  7. Conditional Formatting • Conditional formatting was available in Excel to set up sixty four conditions for analysing your data. Excel then highlights interesting cells that match your conditions.

  8. Conditional Formatting

  9. Highlight Cell Rules • To find specific cells within a range of cells, you can format those specific cells based on a comparison operator. • For example, in a sales report you could emphasise cells where the profit margin was below a particular percentage.

  10. Highlight Cell Rules

  11. Using Data Bars • The data bar conditional format helps you see the value of a cell relative to other cells. • The length of the data bar represents the value in the cell. • A longer bar represents a higher value and a shorter bar represents a lower value. • Data bars are useful for spotting higher and lower numbers especially with large amounts of data.

  12. Using Data Bars

  13. MCQs (1) The home tab commands are using particularly for formatting the data. (a) True. (b) False. (2) Wrap text button used to type a text in any cell. (a) True. (b) False.

  14. (3) When using the highlight cell rules, you should click on merge & centre button. (a) True. (b) False. (4) The data bar conditional format helps you see the value of a cell. (a) True. (b) False.

  15. (5) Conditional formatting was available in Excel to help you for analysing your data. (a) True. (b) False. (6) The alignment groups are used to format the Cells. (a) True. (b) False.

  16. (7) ........... are useful for spotting higher and lower numbers especially with large amounts of data. (a) highlight cell rules. (b) merge & centre. (c) data bar. (d) top/bottom rules. (8) ........ is used to merge the cells only for the text that has been typed in the cells. (a) merge & centre. (b) merge across. (c) merge cells. (d) unmerge.

  17. (9) To find specific cells within a range of cells, you can use .............. (a) highlight cell rules. (b) data bar. (c) merge & centre. (d) top/bottom rules. (10) .......... button used to type a text in the merged cells. (a) font. (b) Conditional format. (c) wrap text. (d) alignment.

  18. (11) When some one needs to set up some rules for the data in his report, ......... can be used. (a) alignment button. (b) merge & centre button. (c) Office button. (d) Conditional Formatting button.

More Related