Module 4

Question 1

Ribbon

Answer 1

The thing on top of sheet with all the things like font, numbering etc

Question 2

Formula bar

Answer 2

Has active cell on ot

Question 3

Values

Answer 3

-When you put in a value into the cell, the cell and the formula bar show the same thing, but if u click it to change it to something like currency, then the formula bar will show the value what u typed (the content of the cell), but the cell will show it in the new format (value)

-Value displayed in current cell depends on content of the cell and fonts and stuff applied from ribbon

-Content of the cell (seen in formula bar) can be a formula (=123+1), and the content of the cell will not show the formula, but the answer

-Values dont have to only be numbers, they can be text as well (called LABELS) , Date/Time values, and BOOLEAN values (true or false)

Question 4

Excel keeps track of days since

Answer 4

1900, so if u have a number in there and u click date, it will give u the day that is that many days from 1900.

Question 5

Formulas and Expressions (module 4.3)

Answer 5

-start with equal
-content of cell has formula, value is the answer of formula found in cell

Question 6

What is formula a bad word for the things we enter into excel cells

Answer 6

because we are actually entering a expression,

-formula is like physics: F=ma

expressions are
D2=1+1 because when we have an operator, which is the plus, minus etc, that is expression
-also the fact that we dont say D2= we just put = is bad too mathematically

Question 7

Operators in excel

Answer 7

+ = - x ^

Question 8

Formulas in excel follow bedmas? T or F

Answer 8

Yep

Question 9

Functions

Answer 9

-has name, and parameters
like f(x)=
-

Question 10

What does it mean to next a formula

Answer 10

a function within a function

=SUM(AVERAGE(3,4,5),2,3)

Question 11

How to reference a cell

Answer 11

Type in the cell name: ex D2

Question 12

If i reference a cell in SUM for example, and change the orgiinal cell number, will it change my SUM cell value?

Answer 12

YES! This is why referencing cells more beneficial

Unless i add $ to it. in the other cell

Question 13

How is range indicated

Answer 13

using :

Always specify upper left and lower right cell for range

Or can drag the corner of the range which u want

Question 14

PAYMENT EXAMPLE

Answer 14

Price of Car: Whatever given
Annual Monthly Interest Rate: usually given
Monthly Interest Rate: Annual/12
Number of Years; Given
Number of Months: years*12

Monthly Payment: =PMT(monthly interest rate, #of periods, principle price)

Question 14

Autofill

Answer 14

Excel detects pattern and continues it
-drag left corner to do this

-if you copy and drag, it will now be the cell u copied, plus +1, then that cell +1, etc. Content of this looks different than normal drag

-if it cant detect a pattern, it will just copy paste

Question 14

Absolute References

Answer 14

-used when you dont want excel to use normal referencing behaviour such as copying the pattern of what was referenced and continuing (ie, if the cell is one above and one to the left for formula, it will continue this)

-bascially used if u dont want the contents of the cell u are referencing to change, and u dont want toi change which cell u are referencing

How to do this?

In the formula: =SUM($C$3,2)
can use F4 key, or do $C$4

-First dollar sign keeps column the same, second dollar sign keeps row the same, WHATEVER THE DOLLARSIGN IS INFRONT OF IS WHAT IS GOING TO BE KEPT THE SAME

so if u want to keep column same but change row, do $C4
or row same but not column c$4

Question 15

What happens when u copy a formula in excel

Answer 15

It will generate a new formula in that cell, based on the orgiinal formula

References are relative to the cell they are entered in

ex: so if i copy a cell in the up three, left one, if i move it and paste the cell somewhere else, it will be the same pattern.

-If you move a cell that is being referenced somewhere else, then it will reference the new cell that u moved it too. Ex: A1 references B2, move B2 to B3, A1 now references contents in B3

Question 15

Copy and Paste in excel

Answer 15

-copies content of cell and format automatically (can change what u want to paste tho)
-if u copy something, then go do something else, u will lose the copy

Question 16

Define Name Button

Answer 16

-Go to formula tab, then click define name (when u are on that cell)

-give it a name
now u can reference this cell using that name

-u can also name ranges, and this will be useful

Question 17

TO edit a name

Answer 17

GO to name manager and change the range of it