CIS 2200 ENNOURE EXCEL CORRECT
100%
Spreadsheet - ANSWER is an electronic file used to organize related data and perform
calculations
Worksheet - ANSWER a spreadsheet that contains formulas, values, text, and visual
aids
Workbook - ANSWER a file containing related worksheets
Cell - ANSWER intersection of a row and column
Input Area - ANSWER range of cells containing values
Output Area - ANSWER range of cells containing results
Differentiate relative absolute and mixed addresses - ANSWER by default every cell
reference is relative to make absolute you have to include $ sign beforehand
A2--->$A$2 now absolute column and row
A2--->$A2, absolute column, relative row, this is a mixed reference
Use of the If function - ANSWER SYNTAX: IF(Something is True, then do this,
otherwise do this)
example: =IF(C2>B2,"Over Budget","Within Budget")
Perform What If Analysis - ANSWER the process of changing the values in cells to see
how those changes will affect the outcome of formulas on the worksheet.
Scenarios and Data tables take sets of input values and determine possible results.
Goal Seek takes a result and determines possible input values that produce that result.
Formulas - ANSWER combinations of cell addresses, math operators, values and/or
functions
•A formula begins with the equal sign =
-Examples:
=A1+A2
=C2*5
Order of Precedence - ANSWER controls the sequence in which math operators are
computed
-Parentheses
-Exponentiation
-Multiplication and Division
-Addition and Subtraction
100%
Spreadsheet - ANSWER is an electronic file used to organize related data and perform
calculations
Worksheet - ANSWER a spreadsheet that contains formulas, values, text, and visual
aids
Workbook - ANSWER a file containing related worksheets
Cell - ANSWER intersection of a row and column
Input Area - ANSWER range of cells containing values
Output Area - ANSWER range of cells containing results
Differentiate relative absolute and mixed addresses - ANSWER by default every cell
reference is relative to make absolute you have to include $ sign beforehand
A2--->$A$2 now absolute column and row
A2--->$A2, absolute column, relative row, this is a mixed reference
Use of the If function - ANSWER SYNTAX: IF(Something is True, then do this,
otherwise do this)
example: =IF(C2>B2,"Over Budget","Within Budget")
Perform What If Analysis - ANSWER the process of changing the values in cells to see
how those changes will affect the outcome of formulas on the worksheet.
Scenarios and Data tables take sets of input values and determine possible results.
Goal Seek takes a result and determines possible input values that produce that result.
Formulas - ANSWER combinations of cell addresses, math operators, values and/or
functions
•A formula begins with the equal sign =
-Examples:
=A1+A2
=C2*5
Order of Precedence - ANSWER controls the sequence in which math operators are
computed
-Parentheses
-Exponentiation
-Multiplication and Division
-Addition and Subtraction
