Quiz 3/Lab 3 Information:

Optional Homework 3 (a SAM Training Assignment), Quiz 3 (a SAM Exam), and PRACTICE for Lab Test 3 (a SAM Project) will be posted in your SAM account (http://sam.cengage.com).

Review the following:

• All pages EX 131-182 in your textbook.
• Visual Overview on pgs EX 132-133 
  Insert Function, Arguments, Optional Arguments, etc.)
  Definition of Arguments - numbers, text, or cell references used by function to calculate result          
• Excel Function Categories on pg EX 140. Figure 3-4.
• Function Syntax on pg EX 141
  Function arguments are always separated by a _____.
  Tip on pg EX 141 (Optional Arguments)
• Common Math, Trig, and Statistical Functions on pg EX 141. Figure 3-5.
• Nested Functions on pg EX 142
• Nested Function Examples:
  =INT(AVERAGE(A1:A100))
  =ROUND(AVERAGE(B2:B50),0)
• Entering Formulas with Quick Analysis Tool on pg EX 142-145
• Entering Functions using Insert Function (fx) on pg EX 145-149
• Interpreting Error Values on pg EX 150
• Excel Error Values on pg EX 151. Figure 3-15.
  #N/A error value is returned if VLOOKUP function cannot find the lookup value in the lookup table.
• Insight Box on pg EX 151
• Cell Reference Types (Relative, Absolute, Mixed) on pg EX 152-159
• 1st paragraph on pg EX 156 (Use F4 to change cell reference type. Mac users press fn and F4 simultaneously)
• Insight box on pg EX 159 (Understanding the different cell reference types)
• Review Session 3.1 Quick Check on pg EX 159
• Visual Overview on pgs EX 160-161
  Lookup Table, Compare Values, Lookup Value, VLOOKUP Function, Logical Function, IF function, WORKDAY, etc.
• Reference Window on pg EX 162 (AutoFill)
• Figure 3-22 on pg EX 163 (Fill Handle and AutoFill Options button)
• Reference Window on pg EX 164 (AutoFill to Create Series)
• Figure 3-24 on pg EX 165 (AutoFill Series)
• Working with Date Functions on pg EX 166
• Date Functions on pg EX 167. Figure 3-27.
  =TODAY() displays current date
  =NOW() displays current date and time
• WORKDAY Function on pg EX 168
  =WORKDAY(start, days)
• COUNT Function on pg EX 170
  =COUNT(value1, value2, etc.)
  =COUNT(A1:A50) will count the number of values (numbers and dates) in A1:A50
  =COUNTA(A1:A50) will count the number of entries (numbers, dates, or text - i.e.  nonblank) in A1:A50
• Logical Functions on pg EX 172 (Logical functions return True/False values)
• Using IF Function on pg EX 172
  IF function syntax is =IF(logical test, value of true, value if false)
• Figure 3-31 on pg EX 172 (Comparison Operators)
• Tip on pg EX 173 (Use opening and closing quotation marks if you want the formula result to show no text)
• Figure 3-32 on pg EX 174 (Function Arguments dialog box for IF)
• Using a Lookup Function on pg EX 176
• Using the VLOOKUP function on pg EX 177
• VLOOKUP function syntax is =VLOOKUP(lookup value, table array, column index number, range lookup)
  Example:
  =VLOOKUP(C9, A1:B9, 2, False)
  The lookup value is in cell C9, the lookup table is located in A1:B9, the 2nd column of the lookup table has the value to be returned, and this is an exact match lookup.
• Tip on pg EX 177- #N/A error value is returned if VLOOKUP function cannot find the lookup value in the lookup table.
• Performing What-If-Analysis on pg EX 179
• Using Goal Seek on pg EX 180
• Goal Seek Dialog Box on pg EX 181. Figure 3-38.
• Review Session 3.2 Quick Check on pg EX 182

SAM Project 3 Hint:

Practice Project Instructions, Step # 6:

In cell B5, create a formula using the VLOOKUP function to look up the value of cell B4 (in the current worksheet) in the range A3:B10 on the Room List worksheet and then return the value in the second column of that range. Use FALSE as value of the Range_Lookup argument to specify an exact match lookup.
To reference A3:B10 on the Room List sheet, use ‘Room List’!A3:B10
Formula is:
=VLOOKUP(B4,'Room List'!A3:B10,2,FALSE)