1 / 23

Excel Application for Accounting: Mastering Tables and Data Management

Learn how to effectively create, modify, sort, and filter tables in Excel, enhancing your accounting skills. This guide covers the fundamentals of table creation and management, including inserting and deleting rows, applying predefined and custom styles, and sorting data by multiple levels and colors. Additionally, test your knowledge with multiple choice questions that reinforce your understanding of Excel table functionalities. Whether you're new to Excel or looking to deepen your expertise, this resource will help you utilize tables for better data analysis.

noma
Télécharger la présentation

Excel Application for Accounting: Mastering Tables and Data Management

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. Working with Tables

  3. Creating a Table • When you create a table in Excel , you can manage and analyse the data in that table independently of data outside of the table

  4. Creating a Table

  5. Inserting or Deleting Rows • You can quickly and easily insert additional rows or columns into an existing table area.

  6. Inserting or Deleting Rows

  7. Modifying a Table • Excel provides numerous predefined table styles that you can use to quickly format a table. • If the predefined table styles don't meet your needs, you can create and apply a customtable style.

  8. Modifying a Table

  9. Sorting Data in a Table • You can sort data up to a maximum of 64 levels instead of 3 for previous versions. • In addition to sorting text and values, you can also sort by colour.

  10. Sorting Data in a Table

  11. Filtering

  12. MCQs (1) To create a table, you can click on Data tab. (a) True. (b) False. (2) Excel provides numerous predefined table styles that you can use to quickly format a table (a) True. (b) False.

  13. (3) To insert or delete rows or column, you can click anywhere with the table area (a) True. (b) False. (4) To modify a table, you can click on the area where you want to modify (a) True. (b) False.

  14. (5) In addition to sorting text and values, you can also sort by colour. (a) True. (b) False. (6) If the predefined table styles don't meet your needs, you can create and apply a custom table style (a) True. (b) False.

  15. (7) To sort data, you can click on Data tab only. (a) True. (b) False. (8) The filter arrows can be used to select the data you wish to view (a) True. (b) False.

  16. (9) To modify a table, you should click on......... tab. (a) Home. (b) Insert. (c) Design. (d) Formula. (10) When doing a filtering to the data, you can click on the .......... button to revert back to the table data. (a) Undo. (b) Clear. (c) Filter. (d) Sort.

  17. (11) To insert or delete rows in a table, you should click on......... tab. (a) Home. (b) Insert. (c) Design. (d) Formula. (12) Click anywhere with the table area when doing .......... (a) Filtering to the data. (b) Inserting rows. (c) Deleting rows. (d) Modifying a table .

  18. (13) To sort data, you can click on......... tab. (a) Formula. (b) Insert. (c) Design. (d) Home. (14) To create a table, .......... Button can be used (a) Formula. (b) Insert. (c) Design. (d) Data.

More Related