Course 2: Module 3 Flashcards
Some common math functions used in spreadsheets:
- Sum
- Average
- Count
- Min
- Max
Spreadsheet tasks:
Organize your data
-Pivot table
-Sort and filter
Calculate your data
users who will work within a spreadsheet by developing organizational standards. This can mean formatting your cells, the headings you choose to highlight, the color scheme, and the way you order your data points. When you take the time to set these standards, you will improve communication, ensure consistency, and help people be more efficient with their time.
Plan
Plan, Capture, Manage, Analyze, Archive, Destroy
Operator
A symbol that names the type of operation or calculation to be performed
DIV/0!
A formula is trying to divide a value in a cell by 0 or by an empty cell
ERROR
A formula can’t be interpreted as input (also known as a parsing error)
N/A
Data in a formula can’t be found by the spreadsheet
NAME?
A formula or function name isn’t understood
NUM!
A formula or function calculation can’t be performed as specified
VALUE!
A general error that could indicate a problem with a formula or reference cells
REF!
A formula is referencing a cell that is no longer valid or has been deleted
Function
A preset command that automatically performs a specific process or task using the data
Relative references
will change when you copy and paste the function into a different cell. With relative references, the location of the cell that contains the function determines the cells used by the function.
Absolute references
will not change when you copy and paste the function into a different cell. With absolute references, the cells referenced always remain the same.
Mixed references
(cells partially referenced with a dollar sign, like $A2 or A$2) will change when you copy and paste the function into a different cell. With mixed references, the location of the cell that contains the function determines the cells used by the function, but only the row or column is relative (not both).
Problem domain
The specific area of analysis that encompasses every activity affecting or affected by the problem
Structured thinking
The process of recognizing the current problem or situation, organizing available information, revealing gaps and opportunities, and identifying the options
Scope of work (SOW)
An agreed-upon outline of the work you’re going to perform on a project
Deliverables
What work is being done, and what things are being created as a result of this project? When the project is complete, what are you expected to deliver to the stakeholders? Be specific here. Will you collect data for this project? How much, or for how long?
Milestones
This is closely related to your timeline. What are the major milestones for progress in your project? How do you know when a given part of the project is considered complete?
Timeline
a way of mapping expectations for how long each step of the process should take. The timeline should be specific enough to help all involved decide if a project is on schedule. When will the deliverables be completed? How long do you expect the project will take to complete? If all goes as planned, how long do you expect each component of the project will take? When can we expect to reach each milestone?
Reports
How will you communicate progress with stakeholders and sponsors, and how often? Will progress be reported weekly? Monthly? When milestones are completed? What information will status reports contain?
Context
the condition and circumstances that surround and give meaning to the data