# data[].attributes.body
Change the border using the paragraph border
Change the border of check box using the properties (Developer tab)

# data[].attributes.body
((Can only change one single variable))
Example:
Total hours for Kristen --> less than or equal to 40 hours
Set Cell --> D11 = D10/D4
*Used to change the number of individual clients for Kristen to keep the total hours for Kristen at less than or equal to 40.

Set Cell --> Cell containing goal value (D11)
To Value --> goal value for cell D11
By changing cell --> cell to adjust to reach goal value for cell D11

Examples: hours worked per week / time in lab or attendance

# data[].attributes.attachment_link.title
Excel Solver example and step-by-step explanation

# data[].attributes.body
Named combinations of values, or what-if assumptions, that are assigned to variables in a model. The primary uses of the Scenario Manager are to:
1-Create different scenarios with multiple sets of changing cells;
2-Build summary worksheets that contain the different scenarios
3-View the results of each scenario on your worksheet

# data[].attributes.body
Checks for invalid data entered as the result of a formula or automated tool, such as Goal Seek

# data[].attributes.headline
How should you approach solving a complex problem?

# data[].attributes.subject
How should you approach solving a complex problem?

# data[].attributes.body
Start with the least complex method:
1) Use trial and error - to modify the values in the worksheet.
2) Use Goal Seek - to have Excel automatically modify a cell's value in a worksheet in an attempt to reach a certain goal in a dependent cell
3) Use Solver - to provide Excel with all of the known rules, or constraints

# data[].attributes.body
Formula Auditing --> allows you to examine formulas to determine which cells are referenced by those formulas and examine cells to determine which formulas are built upon those cells
Data Validation --> allows you to set cells so that the values they accept are restricted in terms of type and range of data. This feature can be set up to display prompts and error messages when users select a cell or enter invalid data
Solver --> allows you to specify up to 200 cells that can be adjusted to find a solution to a problem. Lets you place limits or constraints on allowable values for some or all of those cells.
Constraint --> limitation on the possible values that a cell can contain
Watch Window - allows you to keep an eye on cells that you have identified as being related; this allows you to observe changes to the cells even when viewing a different worksheet or workbook

# data[].attributes.body
> Mailings > Recipient List > Filter (BEFORE Merge letters)

# data[].attributes.body
Finds the optimal value for a cell based on specific inputs

# data[].attributes.body
Increases worksheet accuracy by regulating the type of data users can manually enter in specific cells. It's possible to:
1) restrict cell entries to whole numbers or dates;
2) limit the number of characters a cell will accept
**It is also possible to attach an input message to a data validation rule that explains the rule and its parameters

Cell > Data > Data Validation > input message (title, input message) > ok OR Error Alert (style, title, input message) > ok > rule

# data[].attributes.body
Used to track down the source of the problem by clicking the Trace Error command
Cell > Formulas > Trace Error

# data[].attributes.body
Check for, get help with, edit or ignore formulas that contains errors
Formulas > Error Checking > Next to ignore error or Edit in formula bar > Resume (to finish)

# data[].attributes.headline
Trace Formulas Precedents and Dependents

# data[].attributes.subject
Trace Formulas Precedents and Dependents

# data[].attributes.body
Cell > Formulas > trace precedents or trace dependents (or both)

# data[].attributes.body
This method only remove the table formatting style, but keep both fill color and font color of original table.

# data[].attributes.body
=ROUND (Cell, Decimal)

# data[].attributes.body
Home > Editing > Fill > Series > Check Trend > OK

# data[].attributes.body
Select column/bar first > Format Data Series > Fill option > Vary colors by point

# data[].attributes.headline
What is the difference between Transpose (paste options) and regular paste? 

# data[].attributes.subject
What is the difference between Transpose (paste options) and regular paste? 

# data[].attributes.body
In some cases, the data will need to be transposed, meaning that the rows and columns need to be switched.
The transpose option in the Paste Gallery automatically flips the rows and columns during the paste.

# data[].attributes.body
#DIV/0! - Indicates that a formula divides a number by zero
#N/A - Indicates that a formula cannot locate a referenced value
#NAME? - Indicates use of an invalid function name
#NULL! - Indicates that a formula incorrectly contains a space between two or more cell references
#NUM! - Indicates that a formula contains invalid numeric values
#REF! - Indicates that a cell reference in a formula is not valid; it may be pointing to an empty cell, for instance
#VALUE! - Indicates that a calculation includes non numeric data

# data[].attributes.body
Column headings are represented by letters.

# data[].attributes.body
Row headings are represented by numbers

# data[].attributes.body
The term range usually refers to a group of cells.

# data[].attributes.body
The active cell is that cell to which you have clicked. An active cell can be recognized when the edge of the cell is thick and has a pronounced green color. Only one active cell can be selected.

# data[].attributes.body
The cells are the intersection of the rows by columns. Each cell has a name for example A1, B2

# data[].attributes.body
Shows the beginning and ending balances of a loan and the amount of payment that is applied to the principal and interest during each payment period.

# data[].attributes.body
Beginning Balance = Loan Amount
Ending Balance = PV Function or zero
Paid on Principal = Beginning Balance - Ending Balance
Interest Paid = 12 x Monthly Payment - Paid on Principal or 0
Paid on Principal Subtotal = SUM Function
Interest Paid Subtotal = SUM Function

# data[].attributes.body
Mortgage Amount = Price - Down Payment
Monthly Payment = PMT Function
Total Interest = 12 x Term x Monthly Payment - Loan Amount
Total Cost = 12 x Term x Monthly Payment + Down Payment

# data[].attributes.body
Examines the formula in a workbook similar to the way spelling checking does

# data[].attributes.body
Ensures that users do not change critical values to the worksheet

# data[].attributes.body
Automate data analysis and organize the results returned by Excel

# data[].attributes.body
Allows you to determine the present value of an investment

# data[].attributes.body
Allows you to determine a monthly payment for a loan

# data[].attributes.body
Formulas tab > Define Names > Apply Names > Select the names according to the equation order > OK

# data[].attributes.body
Create names for data ranges
Select the range > Formulas tab > Create From Selection > OK > Formula Bar > Type the appropriate name > Enter
Excel will highlight the selected name in the spreadsheet.