Course 2: Module 3

Question 1

Some common math functions used in spreadsheets:

Answer 1

• Sum
• Average
• Count
• Min
• Max

Question 2

Spreadsheet tasks:

Answer 2

Organize your data
-Pivot table
-Sort and filter

Calculate your data

Question 3

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.

Answer 3

Plan

Question 4

Plan, Capture, Manage, Analyze, Archive, Destroy

Question 5

Operator

Answer 5

A symbol that names the type of operation or calculation to be performed

Question 6

DIV/0!

Answer 6

A formula is trying to divide a value in a cell by 0 or by an empty cell

Question 7

ERROR

Answer 7

A formula can’t be interpreted as input (also known as a parsing error)

Question 8

N/A

Answer 8

Data in a formula can’t be found by the spreadsheet

Question 9

NAME?

Answer 9

A formula or function name isn’t understood

Question 10

NUM!

Answer 10

A formula or function calculation can’t be performed as specified

Question 11

VALUE!

Answer 11

A general error that could indicate a problem with a formula or reference cells

Question 12

REF!

Answer 12

A formula is referencing a cell that is no longer valid or has been deleted

Question 13

Function

Answer 13

A preset command that automatically performs a specific process or task using the data

Question 14

Relative references

Answer 14

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.

Question 15

Absolute references

Answer 15

will not change when you copy and paste the function into a different cell. With absolute references, the cells referenced always remain the same.

Question 16

Mixed references

Answer 16

(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).

Question 17

Problem domain

Answer 17

The specific area of analysis that encompasses every activity affecting or affected by the problem

Question 18

Structured thinking

Answer 18

The process of recognizing the current problem or situation, organizing available information, revealing gaps and opportunities, and identifying the options

Question 19

Scope of work (SOW)

Answer 19

An agreed-upon outline of the work you’re going to perform on a project

Question 20

Deliverables

Answer 20

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?

Question 21

Milestones

Answer 21

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?

Question 22

Timeline

Answer 22

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?

Question 23

Reports

Answer 23

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?

Question 24

Context

Answer 24

the condition and circumstances that surround and give meaning to the data