COMM 205: Midterm 2 - Excel Notes Questions
And Correct Answers With Complete Solutions |
Graded A+
Data Types in Excel - ANSWERS 1. Logical (ex. T/F)
2. Number (Whole or Decimal Numbers)
3. Text Type - String of Characters (All data that is not logical or number types)
4. Error Type
Maximum number of criteria that can be tested: - ANSWERS 127 Criteria.
Quotation Marks for IF functions. - ANSWERS Indicate text, instead of
numbers - used when referring to text in a formula or function. DO NOT USE
QUOTATION MARKS AROUND CELL REFERENCES, VALUES, OR FORMULAS.
Ex. =IF (B2>D2, "Jeff Bezos","Bill Gates")
<> (sign) - ANSWERS Not equal to.
Logical Test - ANSWERS Tells us "true" or "false"
, Ex: =IF(A2>=A3,"TRUE","FALSE")
IF Function (Logical Function) - ANSWERS Used to test for specific conditions:
1. Condition satisfied - True
2. Condition not satisfied - False
Nested IF - ANSWERS Used when there is more than two possible
outcomes/results (i.e. "CR", "D", "F")
Example:
=IF(A2>=55,"CR",IF(A2>=50,"D","F")).
Absolute Referencing - ANSWERS Keeping the same cell reference (i.e.
formula) when dragging down. Do this by adding $'s to columns and rows.
Example: =$A$1+$B$1
Mixed Cell Referencing - ANSWERS Putting a $ sign before either the column
or row. In front of column means the column number (A) stays the same when
you drag down. While in front of row means row number (2) stays the same.
Example: $A2 copied to the next column is ($A3)
And Correct Answers With Complete Solutions |
Graded A+
Data Types in Excel - ANSWERS 1. Logical (ex. T/F)
2. Number (Whole or Decimal Numbers)
3. Text Type - String of Characters (All data that is not logical or number types)
4. Error Type
Maximum number of criteria that can be tested: - ANSWERS 127 Criteria.
Quotation Marks for IF functions. - ANSWERS Indicate text, instead of
numbers - used when referring to text in a formula or function. DO NOT USE
QUOTATION MARKS AROUND CELL REFERENCES, VALUES, OR FORMULAS.
Ex. =IF (B2>D2, "Jeff Bezos","Bill Gates")
<> (sign) - ANSWERS Not equal to.
Logical Test - ANSWERS Tells us "true" or "false"
, Ex: =IF(A2>=A3,"TRUE","FALSE")
IF Function (Logical Function) - ANSWERS Used to test for specific conditions:
1. Condition satisfied - True
2. Condition not satisfied - False
Nested IF - ANSWERS Used when there is more than two possible
outcomes/results (i.e. "CR", "D", "F")
Example:
=IF(A2>=55,"CR",IF(A2>=50,"D","F")).
Absolute Referencing - ANSWERS Keeping the same cell reference (i.e.
formula) when dragging down. Do this by adding $'s to columns and rows.
Example: =$A$1+$B$1
Mixed Cell Referencing - ANSWERS Putting a $ sign before either the column
or row. In front of column means the column number (A) stays the same when
you drag down. While in front of row means row number (2) stays the same.
Example: $A2 copied to the next column is ($A3)
