Spreadsheet basics

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

For which ONE of the following could a spreadsheet be used?

Sending out supplier statements
Maintaining detailed customer records
Preparing budgets and forecasts (correct)

Which THREE of the following are true regarding spreadsheets?

Spreadsheets can be used for word processing.
Data in a spreadsheet can be easily updated. (correct)
Spreadsheet data can be output in the form of graphs. (correct)
Spreadsheets can be used to replace accounting packages.
Spreadsheets are used to store and manipulate data. (correct)
Sophisticated databases are making spreadsheets obsolete.

Identify which TWO of the following would occur before the introduction section of a business report.

Appendices
Conclusion
Main body
Recommendations
Title (correct)
Executive summary (correct)

Identify which ONE of the following describes the contents of the 'main body' section of a business report.

Provides an analysis of the results of the research (C) Signup and view all the answers

Complete the following statement by selecting the most appropriate answer from the picklist. When considering the order of a formal business report, which section will usually appear between the executive summary and the main body?

Introduction Signup and view all the answers

What would be the most appropriate method of communication in each of the following circumstances?

Explaining to a customer that a prompt payment discount that has been deducted was not valid, as the invoice was not paid within the discount period = Letter Requesting customer balances from a colleague in the receivables ledger department = Email Providing negative feedback to a colleague on the quality of their work = Face-to-face discussion A formal complaint to a supplier regarding the delivery times of goods, which are not as agreed = Letter Information to be provided to the sales director regarding the breakdown of sales geographically for the last two years = Email Signup and view all the answers

Task 4.8 (a) What will be the amount required to restore the imprest level on 1 December? (The petty cash imprest level is £75. Opening balance is £27, cash from bank on 1 November is £48, expenditure during month is £21)

£48 Signup and view all the answers

Task 4.8 (b) Will the receipt from the bank on 1 December be a debit or credit entry in the petty cash book?

Debit (B) Signup and view all the answers

Task 4.9 (a) State four benefits of cloud accounting.

Cost savings, increased collaboration, scalability, and improved data security. Signup and view all the answers

Task 4.9 (b) State four potential problems of cloud accounting.

Data security concerns, internet connectivity issues, vendor lock-in, and regulatory compliance challenges. Signup and view all the answers

Task 4.14 Review the draft letter and identify TWELVE words or collections of letters or digits which are either spelt incorrectly, missing, are inappropriate or are technically incorrect.

Statment (A), too highlight (B), £357.29 (C), setle (D), £794.53 (E), posible (F), sending (G), XУ (H), is not known to us (I), corespond (J), 12.01.XX (K), sincerely (L) Signup and view all the answers

Task (b) You do not need to proofread emails as this is an informal method of communication.

False (B) Signup and view all the answers

Task (b) When deciding upon the best method of communication, you only need to consider the information you are trying to communicate.

False (B) Signup and view all the answers

Task 4.7 (a) Which of the following items would explain the difference?

You have requested a credit note from the supplier for £1,586 which you have not yet received. (C) Signup and view all the answers

Flashcards

Spreadsheet Use

Used for preparing budgets and forecasts.

Spreadsheet Capabilities

Store, manipulate, update data, and output graphs easily.