3.7 Respond Appropriately To Any Problems With Spreadsheets
Submitted By cowlingpam
Words: 1495
Pages: 6
When I submit on onefile, ensure I separate by task.
Task 4
[3.6] Describe how to find errors in spreadsheet formulas
Should you make an error when creating a formula in Excel, you will see one of the following signs in the cell: #DIV/0!, #N/A, #NAME?, #NULL!, #NUM!, #REF!, and #VALUE!. Each of these errors have different causes and are resolved in different ways. If you click on the exclamation mark with the error, you will be able to correct your formula using the prompt from Excel.
3.7 Respond appropriately to any problems with spreadsheets
Should you find a problem with a spreadsheet, you can always use the Help section in Excel first, then you could ask a colleague for assistance. If the problem is complicated, google the issue for more in-depth information.
Task 5
[1.1] Explain reasons for knowing the purpose of communication
You need to know the purpose of communication in order to communicate with the right people in the right way. Communication is a way of sharing information with others.
[1.2] Explain reasons for knowing the audience to whom the communication is being presented
In order for the information being communicated to be effective, you need to know who will be receiving the information. For example, a child will need to have information appropriate to their age so they understand it. A colleague will have a good understanding of the business, so will not need lots of background information. A technical person will need more in depth information.
ac[1.3] Describe different methods of communication
Information can be communicated in various ways including verbal - in person, on the telephone, video conferencing, written via email, a letter sent in the post, fax, text and many types of social media. Visual - posters, videos, leaflets.
ac[1.4] Describe when to use different methods of communication
Verbal communication is instant. You can communicate with work colleagues whilst sitting at your desk, in an informal manner throughout the day. You can also pick up the telephone and have a conversation with someone. You will also communicate verbally in meetings and video conferences. This type of communication is best when you are discussing things as you can interact freely and instantly back and forth. However, it is possible that information shared verbally can be forgotten.
Written communication can be almost instant via email and text and is usually an informal way to communicate. A letter is a more formal way to communicate and is usually sent in the post. Written information can be kept as a record, so should always be accurate. It also means you can refer back to the information, so is a better way to share more important information that may be needed in the future.
ac[2.1] Identify different sources of information that may be used when preparing written communication
When preparing written communication it is important that the information being given is accurate. It is therefore important to consider where you get your information from. The internet is a great source of information, but you should check the authenticity of the websites being used. You will be able to find useful information that is relevant to your business within your offices and on your shared drive of your computer. Colleagues are another source of information and can help point you in the right direction using their knowledge. You may find the library another place you can research information. Newspapers and TV may also help.
ac[2.2] Describe the communication principles for using electronic forms of written communication in a business environment
Nearly all forms of written communication are done electronically now. This includes email, Microsoft Office products and other software on your computer. This is the fastest, cheap and the most universal way to communicate with your colleagues, customers and suppliers etc. ac[2.3] Describe the reasons for using language that suits the purpose of