0
What documents do you need to ensure correct design of a spreadsheet?
Wiki User
∙ 11y ago
That will really depend on the spreadsheet itself and what is going to be in it. You may need a document with figures or other data to enter into it. You might need a general specification to say what the spreadsheet has got to do, often called the requirements. You might want a document of test data to see if it works as it should. You might want a document showing how it is going to be laid out. The more complicated it is, the more likely you are going to need these things. With a very simple spreadsheet you might not need any of them.
Wiki User
∙ 11y ago
Add your answer:
Earn +20 pts
What are some process design documents?
Some process design documentations are: Block Flow Diagrams (BFD), Process Flow Diagrams (PFD), Piping and Instrumentation Diagram (P&ID's). The process design documents ensure that the design documents fit together.
How documents are obtained and how to check that they are current and valid?
The drawings and documentation are delivered to the tool room once they are finished. To ensure the documents are correct these have to be stamped, dated and signed by the creator of the documentation.
How do check that the documents are currents and valid?
Some documents have regular revisions and so it is important to check the dates and revision numbers to ensure you are using the latest and correct revision. Some documents have expiry dates and observation to this detail may be critical, ie: legal regulation paperwork.
What are the 2 main rules when inserting formulas into a spreadsheet?
There are several rules related to inserting formulas into a spreadsheet.Ensure your use the equal sign (=) to start a formula.If you use a function, ensure you select the correct function.Double-check your cell references to ensure you are referencing the correct cells.If you copy a formula from another cell, ensure you are referring to the correct cells (verify if you should be using relative, versus absolute cell references).Check the cell format to ensure the value displays what you want to display. If you are trying to display currency, do not format the cell as date.Pay attention to precedence of operators and use parentheses, as required.
What is a Human Resources Administrator?
In short, an HR Administrator works more behind the scenes with paperwork than directly with employee performance. An HR Administrator will file documents, ensure the correct documents are in place, i.e. I9 forms, W4's, applications are on file, etc.
Is there a tendency for people to believe that everything on a spreadsheet or graph is true just because it has been created using a computer?
Some people will, but those who know about computers and spreadsheets know that there can be mistakes. However, those mistakes are usually down to things the person who created the formulas and figures rather than the spreadsheet itself. If you have done a formula wrong or typed in a wrong number, the spreadsheet will still try and do the calculations and provide an answer. It is up to the person that creates the spreadsheet to ensure formulas and figures are correct. If they are, then the results are more trustworthy.
What does a Document Administrator do?
Document administrators ensure that documents are protected. They may operate a system that allows users to check documents in and out.
How does the design of cooking equipment ensure safety while cooking and ease of cleaning?
how does the design of cooking equipment ensure safety while cooking and ease of cleaning
What is correct spelling of ensured?
ensure
Which documents are meant to ensure equality for either the people of Canada or people of the US?
The Canadian Charter of Rights and Freedoms is one of the more major documents that helps ensure equality in Canada, but it doesn't cover the US.
How do you check that the documents are current and valid?
Some documents have regular revisions and so it is important to check the dates and revision numbers to ensure you are using the latest and correct revision. Some documents have expiry dates and observation to this detail may be critical, ie: legal regulation paperwork.
What is auditing in excel?
Auditing is the process of checking formulas and the spreadsheet in general to find errors and correct errors. It enables you to do things like find out if a cell is being used by another formula or find out what cells a formula uses. This enables you to ensure that cells that should be included in a formula, like when you are totalling a range of cells, are included. It can also help identify cells that are in a spreadsheet with values that are not being used. This could enable you to correct formulas that should include a cell, or get rid of cells with values that are not needed. It also may help to define more efficient formulas and simplify a spreadsheet.
