Computer Apps Excel Exam 1 and 2 Part 1

0.0(0)
studied byStudied by 0 people
0.0(0)
full-widthCall Kai
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
GameKnowt Play
Card Sorting

1/11

encourage image

There's no tags or description

Looks like no tags are added yet.

Study Analytics
Name
Mastery
Learn
Test
Matching
Spaced

No study sessions yet.

12 Terms

1
New cards


Explain the primary difference between a line plot and a scatter plot in Excel.

  • Line graphs don’t displace data points

  • Line graphs don’t correctly space the intervals

  • Line graphs don’t seem to use x values 

2
New cards

Identify two situations when you should use a log-scale on your graph

  1. if you know its log scale

  2. if the data is clustered

  3. if the values span a high order of magnitude

3
New cards

Central Processing Unit

Brains of computer, runs programs, performs computations

4
New cards

Hard Drive 

Permanent storage of programs and files, relatively slow

5
New cards

Random Access Memory RAM

Temporary storage of files and programs while in use

6
New cards

All Graphs should include

  1. Informative title

  2. Axis and label units

  3. Correct axis limits

  4. Gridlines. Needed? Not Needed?

  5. Do you need a legend? (yes, if more than one series of data)

  6. Data and equation graphs are different

    1. Data = xy scatter

    2. Equation = smooth line graph

7
New cards

Picking a trendline

  1. Check the R² value

  2. Use your engineering knowledge

  3. Take into account using the trendline equation for forecasting

  4. USE COMMON SENSE

8
New cards

If you plan on inserting a table into a lab report, what are the key technical writing issues to pay attention to?

  • Less is more- only present the crititcal information. If you are creating a large table or multiple tables, a graph may be a better way to convey the information

  • Table should have a number and a title

  • table labels must be above the table

9
New cards

What is a macro?

A recoding of your actions that can be played back to repeat those actions using a quick key stroke

10
New cards

Newton-Raphson
Newton-Raphson technique

  1. make a good initial guess, x0 and find f(x0)

  2. Draw a tangent line at f(x0) and extend through the x axis

  3. Where tangent crosses x axis is an improved guess, x1

  4. Repeat until your meet the convergence criteria

11
New cards

Error bars 

Wider error bars show that there is more range (less precision) in the data at that particular region 

12
New cards

Probablility

Nor.dist(x, mean, standard-dev, cumulative)