Accounting Application of Electronic Spreadsheet

Accounts · Chapter 13 · 6. Accounting Application of Electronic Spreadsheet (Section C)

Not started Not started

Your path through this chapter

1
Visual lesson Beta
1. Part 1: Spreadsheet Basics, Formatting and Functions23 slides
2. Part 2: Accounting Applications, Charts and Databases22 slides
Step 1: Not started
Notes Beta
8 sections with key terms, formulas and exam tips.
Read the notes Step 2: Not started
Flashcards Beta
32 cards for quick recall of key terms and facts.
Review the cards Step 3: Not started
Practice
79 board-style questions with instant checks: Multiple choice 27, Short answer 19, Numerical 7, Assertion and reason 6.
Practise Step 4: Not started
5
Chapter test Free
Short and long chapter tests in board pattern, with results and analysis.
- Chapter test (long) — Accounting Application of Electronic Spreadsheet · 40 marks · 100 min
- Chapter test (short) — Accounting Application of Electronic Spreadsheet · 20 marks · 50 min
Step 5: Not started

Electronic spreadsheet: meaning, utility, merits and demerits
Working with worksheets and workbooks: entering data, saving, navigating, copying and moving sheets
Formatting, previewing and printing worksheets
Formulas and functions: arithmetic, average, percentage, date, IF; freezing panes
Accounting applications: payroll, sales and salesmen's commission, student marks, journal
Data presentation: charts and graphs; database creation, sorting, querying and filtering