Mod 4 - Intro to Excel

Question 1

Describe the basic layout of Excel

Answer 1

The spreadsheet file is called a workbook in which you can have several worksheets. Columns are labelled by letters & rows are labelled by numbers. Where a column & row intersect is a cell that each have their own unique addresses. You can have cell ranges that are separated by a colon.
ex. cell A3 or A3:B7

Question 2

What are the different kinds of values that can be entered into cells?

Answer 2

• Labels: letters, punctuation, digits, etc.
• Numeric: pos/neg numbers (number format can be changed to reflect work - ex. number to currency)
• Formulas: ex. =A3/B2
• Boolean: true/false

Question 3

Describe how a formula is set up.

Answer 3

All formulas in cells must start with “=” & can contain any combination of numbers, cell references, cell names, etc.
ex. A3 + B7; 17/4; 12*Tax_Rate

Question 4

What order of operations is used in excel?

Answer 4

BEDMAS :)

Question 5

What makes up a function?

Answer 5

1. function name: identifies what calculation is to be performed
2. function parameters (anything in the brackets): represents the data used to calculate

Question 6

Give examples of functions

Answer 6

• =SUM(#, #, #)
• =AVERAGE(#, #, #)
• =PMT(#, #, #)
  You can combine functions: =AVERAGE(#:#) + SUM(#, #)
  You can nest functions: =SUM(AVERAGE(#, #), #, #)

Question 7

How do you autofill?

Answer 7

Highlight a region & use the black plus to drag down and excel will recognize the pattern to autofill the cells.

Question 8

What is absolute referencing?

Answer 8

When copied/filled in, the cells values do not change according to location, the values stay the exact same. Dollar signs are used for this.
ex:
$A$3 - row & column stay the same
$A3 - column stays the same but row changes
A$3 - column changes but row stays the same

Question 9

What is a named range?

Answer 9

It is when a range of cells is selected & given a special name to make referencing easier. It is also an alternative to using absolute cell referencing.