Describe how to find errors in spreadsheet formulas

Assignment Help Other Subject

Reference no: EM132348770

Spreadsheet Software

1. Use a spreadsheet to enter, edit and organise numerical and other data.

1.1 Identify what numerical and other information is needed in the spreadsheet and how it should be structured

1.2 Enter and edit numerical and other data accurately

1.3 Combine and link data across worksheets

1.4 Store and retrieve spreadsheet files effectively, in line with local guidelines and conventions where available

2. Select and use appropriate formulas and data analysis tools to meet requirements

2.1 Identify which tools and techniques to use to analyse and manipulate data to meet requirements

2.2 Select and use a range of appropriate functions and formulas to meet calculation requirements

2.3 Use a range of tools and techniques to analyse and manipulate data to meet requirements

3. Select and use tools and techniques to present and format spreadsheet information

3.1 Plan how to present and format spreadsheet information effectively to meet needs

3.2 Select and use appropriate tools and techniques to format spreadsheet cells, rows, columns and worksheets

3.3 Select and format an appropriate chart or graph type to display selected information

3.4 Select and use appropriate page layout to present and print spreadsheet information

3.5 Check information meets needs, using spreadsheet tools and making corrections as necessary

3.6 Describe how to find errors in spreadsheet formulas

3.7 Respond appropriately to any problems with spreadsheets

1. Use a spreadsheet to enter, edit and organise numerical and other data.

Scenario.

You work in customer services at hotel in the Lake District.

Your manager has sent you the results from the customer feedback forms from last month. She wants to compare the grades between the departments.

Task 1.

• Transfer this data onto a spreadsheet.

• Sort departments into alphabetical order

• Adjust cells so all text can be read.

• Add borders to all data.

• Save the spreadsheet as ‘April Customer Feedback’

• Paste a screen shot to show the folder you have created and the content.

Task 2

You will need to select and use appropriate formulas and data analysis tools this will help you compare the performance of the departments and indentify where improvements are needed.

• Add a row to your table. Title it “Averages”.

• Create a formula to calculate the average grade of each column.

• Add a column at the end of the table and title it “Needs improvements”.

• The manager has set a target of 7 and above in Excellent for each department. Use a function to show target met or needs improvement in the grade is below 7.

• Add a filter to the table

Q1. Identify which tools and techniques to use to analyse and manipulate data to meet requirements.

The tools and techniques that I used to analyse and manipulate data to meet requirements was Format and Configuration.

Task 3

Your manager wants to use your table in a presentation to all departments.

• Explain what you could do to the table to make it look professional and how you would make relevant information stand out.

• Now make these changes to the table.

• Create an appropriate chart or Graph to how comparisons of department grades in “Excellent”. Then save this on a separate sheet and Name the sheet “Chart”

• Set the Page with the Chart on to Landscape and page with Graph to Landscape.

• Format the Chart and make sure there are no mistakes.

Describe how to find errors in spreadsheet formulas

1. Go to "Home" tab

2. Click "Find & Select"

3. Click "Go to Special..."

4. Click "Formulas"

5. Enable "Errors"

Q2. Respond appropriately to any problems with spreadsheets

1. Always try to recover it from a backup or a previous working revision - Even though it means thatyou may lose some current data, you get the file back with the data that is accurate.

2. Use Open & Repair in Excel- Open Excel, find and select the corrupted Excel file, instead of clicking open, chooseOpen & Repair from the down arrow in the Open button.

Attachment:- Spreadsheet Software.rar

Reference no: EM132348770

Questions Cloud

Factors that influence the occurrence of merger waves : Defend your arguments, with specific references to the various motivations for M&As and the factors that influence the occurrence of merger

Define risk and explain how risk is affected : Define risk and explain how risk is affected if we diversify our investment by holding a variety of securities?

How is this possible and if is what are the cause and effect : Management should understand that turnover for staff may rise due to changes and heavy workloads. How is this possible and if is what are the cause and effect?

Determining the discounted cash flow : To value company A using the discounted cash flow (DCF) method, the forecasts of Free Cash Flows (FCFs) of $135 million, $145 million, $146 million

Describe how to find errors in spreadsheet formulas : Identify what numerical and other information is needed in the spreadsheet and how it should be structured.Enter and edit numerical and other data accurately.

When verifying a customer account : When verifying a customer account - what three things could you ask to verify the customer and the account are the correct match?

Clearly labelled diagram showing the expiry profit : Construct a clearly labelled diagram showing the expiry profit as a function of shareprice, from the hedged position.

Percent coupon consol : Compute the price of a $ 8,602 par value, 17 percent coupon consol, or perpetual bond (i.e., coupon interest payment is a perpetuity)

What must the expected return on this stock be : A stock beta of 1.15, the expected return on the market is 10.3 percent, and the risk-free rate is 3.8 percent. What must the expected return on this stock be?

User Account

All Pages