2 John

Please use a word document to type out the book of 2 John.

USE spell check. Use Arial 18 pt. Insert a photo related to this passage. Select to have text wrap through photo. Include a summary of the passage and explain how God wants you (personally)  grow from this reading. Minimum two paragraphs.

Submit in email as an attachment with 2 John and your first name in the subject line. Include a link within the email to the site that you copied this passage from.

Due by the end of class today.

1 Peter 3:12

1 Peter 1:3-12    (NIV)

Praise to God for a Living Hope

³ Praise be to the God and Father of our Lord Jesus Christ! In his great mercy he has given us new birth into a living hope through the resurrection of Jesus Christ from the dead, ⁴ and into an inheritance that can never perish, spoil or fade. This inheritance is kept in heaven for you, ⁵ who through faith are shielded by God’s power until the coming of the salvation that is ready to be revealed in the last time. ⁶ In all this you greatly rejoice, though now for a little while you may have had to suffer grief in all kinds of trials. ⁷ These have come so that the proven genuineness of your faith—of greater worth than gold, which perishes even though refined by fire—may result in praise, glory and honor when Jesus Christ is revealed. ⁸ Though you have not seen him, you love him; and even though you do not see him now, you believe in him and are filled with an inexpressible and glorious joy, ⁹ for you are receiving the end result of your faith, the salvation of your souls.
¹⁰ Concerning this salvation, the prophets, who spoke of the grace that was to come to you, searched intently and with the greatest care, ¹¹ trying to find out the time and circumstances to which the Spirit of Christ in them was pointing when he predicted the sufferings of the Messiah and the glories that would follow. ¹² It was revealed to them that they were not serving themselves but you, when they spoke of the things that have now been told you by those who have preached the gospel to you by the Holy Spirit sent from heaven. Even angels long to look into these things.



Use word to type out (using correct fingering) the above passage. 

Write 2 paragraphs (paragraphs = minimum 5 sentances) about what God wants you to know through this passage.

When complete post to the blog. Then play around in EXCEL to prepare for the test....

Lesson 2 Quiz Study sheet

Lesson 2
Working with Formulas and Functions

Functions: are predefined worksheet formulas that Excel supplies for you.  A few predefined are:
Sum, Average, Count Numbers, Max, Min

Formulas consist of the following elements:
Math Operators,       Cell references,    Values or text,     Worksheet functions

A formula is a series of mathematical instructions that you place in a cell. Formula results are usually numbers, although you can create formulas that have text or BOOLEAN (true or false) results.

Formulas can be simple or complex, but in all cases they share the same basic characteristics:

• YOU ENTER EACH FORMULA IN TO A SINGLE CELL

• FORMULAS CAN EVALUATE A COMBINATION OF NUMBERS

• EXCEL CALCULATES THE RESULT OF A FORMULA EVERY TIME YOU OPEN A SPREADSHEET OR CHANGE THE DATA

• TO VIEW A FORMULA, YOU HAVE TO SELECT THE CELL CONTAINING THE FORMULA AND LOOK AT THE FORMULA BAR, WHERE YOU CAN ALSO EDIT A FORMULA

After you enter a formula, the cell displays the formula's calculated result. the formula itself appears in the formula bar when you select the cell.

SIMPLE formulas use basic arithmetic operators: +, *,  -,  or /.  Example:

=150*.05                                         Multiplies 150 times .05
=SUM(A1:A2)                                Adds cells A1 through A12
=Income-Expenses                          Subtracts the value of Expenses from the value of Income

Example of COMPLEX formulas:  (will not be on Quiz)

="Part-"&"23A"                              Joins the two text strings to produce this: Part-23A

=A1<=A2                                        Returns TRUE if the value in cell A1 is less than or equal

=B1< > B2                                       Returns TRUE if the value in cell B1 isn't equal to the value in B2

ORDER OF OPERATIONS
Order of precedence determines the order in which the operations are calculated.

1. Values inside parentheses are calculated before any other operations
2. Reference operators are calculated first
3. Exponents are calculated next
4. Multiplication and division are calculated from left to right

Relative & Cell References
Copying a cell allows you to reuse formulas that you've already created. The Copy and Paste can be used to copy a formula. The FILL Down option can be used for rows or FILL right for columns or both to fill in formulas.

Difference between relative and absolute in EXCEL:

1. Relative cell references tell Excel how ti find another cell starting from the cell that contains the formulas. When you use a relative reference, it's like giving someone driving directions. There's a starting point (the current location) and a final destination point. When a formula containing relative references is moved, it will reference new cells based on their location in relation to the formula. Relative references are the default type of reference.
2. Absolute cell references refer to the same cell address, even when the formula is moved. 
3. Mixed cell references combine both elements of absolute and relative references. 

How relative references work:

1. Next,  when cell C2's formula is copied to C2:C11, the formula is calculated for the row that it's in. For example, in C11 it's calculated as =SUM(A11:B11). Because the formula calculates the values in its row, the cell references are relative.
2. The formula =SUM(A2:B2) is applied to cells  A2 and B2, and the result is displayed in cell C2.

ROUNDING VALUES
Excell allows you to round off values. Highlight the cell or cells of values you want to round off, and, under the FORMULAS tab and in the FUNCTION LIBRARY group, select MATH & TRIG. Scroll down to the ROUND function.