Week 2 Flashcards
•Explain the syntax of basic formulas and functions •Use formulas and functions to perform simple calculations •Describe the difference between relative and absolute cell references
Entered into a cell to perform a calculation
Formula
A ‘mini-program’ that you can use to make more complex calculations.
Function
Functions are used inside formulas an therefore, you need to start with an______ sign
equal (=)
Where is the formula bar located?
underneath the ribbon.
When text is entered into a cell without being assigned a number format, we refer to them as _____
labels.
A _______ refers to two or more cells. When these cells are together, we call _____________
range ; adjacent range
The colon (:) basically stands for”
‘through to’.
Whenever we want to define a range of cells that are not all in one place, we talk about ___________________
non-adjacent ranges:
How do you write 2 non-adjacent cells in Excel syntax?
A1:A2 and C1:C2. In Excel syntax this is written as A1:A2, C1:C2.
How do you make a cell, for example, A1 , absolute cell reference
You must include a $ before each element of the cell reference: $A$1.
What is the keyboard shortcut?
press F4 (Fn+F4 for MAC)
Order of basic mathematical operations: Calculations in Excel follow the general mathematical rules for calculations. What does this mean?
Multiplication (*) and Division (/) come before Addition (+) and Subtraction (-).
How would Excel read the formula : =3+4*5? How should you write it if you want excel to multiply first?
Excel reads the formula from left to right, so one might assume it adds 3 and 4 together before multiplying the result by 5. However, as multiplication takes precedence over addition, Excel will calculate 3 plus the result of 4 multiplied by 5. The formula should look like this: =(3+4)*5
What is the function in which Excel randomly select a number between a range of numbers you specify?
RANDBETWEEN
The function RANDBETWEEN has two arguments:
bottom and top.
