Question
1. Outline the points to consider before creating a spreadsheet based on the intended audience 2. List and briefly describe the features of cloud-based applications
1. Outline the points to consider before creating a spreadsheet based on the intended audience
2. List and briefly describe the features of cloud-based applications and non-cloud based applications
3. When planning spreadsheets, you need to consider organisational requirements and codes of practice Provide the common organisational requirements for the following items
Item | Organisational requirements and features |
Ergonomics (desk and chair) | |
Work periods and breaks | |
Sustainability - regarding printing |
4 Describe the following functions of spreadsheet
Function | Description |
Sum | |
Average | |
Minimum | |
Maximum | |
Count |
5. Answer the following questions:
a What are the key elements of formatting spreadsheets?
b How can you use an Excel spreadsheet to calculate sum totals, averages, and counts of values?
6. What factors should be considered when selecting the most appropriate application to produce a spreadsheet, according to available resources and organisational policies and procedures?
7. What are some techniques that can be used to confirm that a spreadsheet is designed to enhance readability and appearance, and how can these techniques improve the overall effectiveness of the spreadsheet?
8. Why is it important to consult with relevant stakeholders when creating and testing formulae in Excel, and how can the output be confirmed to meet the task requirements?
9. What are the most commonly used help functions in Excel, and how can these functions be used to resolve issues that may arise while working with an Excel spreadsheet?
10. What are some methods for delivering a document or Excel spreadsheet to the required stakeholders, and how can these methods ensure that the stakeholders receive the information in a timely and efficient manner?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Here are the answers to the outlined accounting questions 1 Points to Consider Before Creating a Spreadsheet Based on the Intended Audience Audiences Expertise Level Understand whether the audience is ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started