To make a line break in a cell (not everything fits well within a cell) -type first part then press alt+enter and then type the rest, it'll put the rest on second line when you hit enter

In a cell the number '1' is equivelent to 100%

Excel stores dates as serial numbers starting at 1 (which is January 1, 1900) so 9/15/2012 is 41167 (the number of days from 1/1/1900 to 9/15/2012)

To adjust colum width (the horizontal measurement of a column) -Click "Format" in cells group (on Home tab) then select colum width, type a value in the Column width box then click ok

To hide a colum or row (for confidential info, etc.) click "Format" in the Cells group, point to Hide & Unhide) and select "Hide Columns or Hide Rows", right click the colum or row heading(s) you want to hide and then select "Hide" -To hide multiple rows or columns, drag across the adjacent column or row headings and press and hold down Control while you click the column or row headings

--To Unhide, to unhide column A or row 1, type A1 in the Name Box, then press Enter. Click Format in the Cells group, point to Hide & Unhide, then select Unhide Columns or Unhide Rows to display column A or row 1, respectively

Horizontal Alighnment-positions data between the left and right cell margins Vertical Alignment-positions data between the top and bottom cell margins

Wrap Text, enagles a label to appear on multiple lines within the current cell. -When you click it (in the "Alignment" group, Excel wraps the textg on two or more lines within the cell

Order of precendence controls the sequence in which Excel performs operations Try to remember -PLEASE EXCUSE MY DEAR AUNT SALLY- (Parentheses, Exponentiation, Multiplication or Division and then Addition or Subtraction)

example: A1 IS 10 AND A2 IS 5...Formula =A1+A2*A3 (THAT IS 5 X 2=10) tHE PRODUCT 10 IS THEN ADDED TO 10 STORED IN CELL A1 SO THE RESULT IS ...20...

Auto Fill enables you to copy the contents of a cell or cell...

...Advance Excel2010
Duration- 2 Days (16 Hrs)
Course Objectives
At the end of the course, the participant can
•
•
•
•
•
•
•
•
•
•
•
Use outlines, range names, databases & the data form
Use AutoFilter & advanced filters
Work with Data Series
Use advanced functions
Modify charts
Use Scenarios & Goal Seek
Use templates, data tables & solve problems
Use automatic formatting & styles
Work with views, consolidate worksheets
Create & revise PivotTables
Use, record & edit macros
Advanced Excel Training Course Prerequisites
Participants should already:
•
Be using Excel on a regular basis and or
•
Knowledge of Excel Introduction topics
•
New Features of Excel2010
o Spark lines
o Slicers
o Microsoft SQL Server Power Pivot for Excel add-in
o New statistical functions
o Customizing Ribbon
o Adding Tabs, Groups and Commands on Ribbon
•
Improved features in Excel
o Improved Filtering
o Improved Pivot Table
o Improved Conditional formatting
o Improved Charting
Page 1 of 3
Head Office: Aptech House, A- 65 , MIDC Marol , Andheri (E), Mumbai 400 093.
Tel: 022 – 28272300, Fax: 228272399
•
Using Formatting and Functions
o Applying Formatting to Numbers
o Creating Custom Number Formats
o Applying Conditional Formats
o Using Formulas in Conditional Formats
o Absolute and Relative References
o Naming a Range
o Using a Named Range in a Formula
o Using Tables...

...Question:Sarah receives a company turnover summary in the form of an embedded Excel chart (as shown in the above image) in a Microsoft Word 2010 document from her boss. Her boss wants the chart to be sent over to the Public Relations department with a line in the chart showing the variations in the company's turnover, as well as a prediction for the next 2 years. The turnover values for each year also need to be sent separately in an Excel file. What should Linda do to achieve this in the shortest possible time?
a. Take a screenshot of the chart and ask a designer to draw a line showing the trends. She can then type the data manually into an excel sheet.
b. Import the chart into an Excel sheet and change the formatting of the chart to a line chart. She can then copy the corresponding fields into a separate Excel file and send it over.
c. Change chart type to a line chart and type all the values into an Excel file.
d. Use the Trendline feature to create a line showing the trends and copy the data from the Excel sheet field which opens up on clicking Edit Data.
Question:You want to add an image as the first character in your paragraph. Which type of text wrapping treats your graphic as if it were a character?
a. Through
b. Square
c. In Font of Text
d. In Line with Text
Question: Roger was editing a Word document, when his mobile phone rang. By...

...How to Create and Format a Pivot Chart in Excel2010 - For Dummies
Page 1 of 3
How to Create and Format a Pivot Chart in
Excel2010
By Greg Harvey
7 of 9 in Series: The Essentials of Excel2010 Pivot Tables and Pivot Charts
After you create a pivot table in Excel2010, you can create a pivot chart to display
its summary values graphically. You also can format a pivot chart to improve its
appearance. You can use any of the chart types available with Excel when you
create a pivot chart.
Create a pivot chart
Follow these steps to create a pivot chart based on an existing pivot table in a
worksheet:
1. Create the pivot table and then click any cell in the pivot table on which
you want to base the chart.
2. Click the PivotChart button in the Tools group of the PivotTable Tools
Options tab.
The Insert Chart dialog box appears.
You have many design choices for your pivot chart.
http://www.dummies.com/how-to/content/how-to-create-and-format-a-pivot-chart-in-excel-... 2/6/2012
How to Create and Format a Pivot Chart in Excel2010 - For Dummies
Page 2 of 3
3. Click the thumbnail of the type of chart you want to create.
4. Click OK.
Excel displays the pivot chart in the worksheet.
To delete a pivot chart, select a chart boundary and press the Delete key.
Move a pivot chart to its own sheet
You...

...Frist step , collecting the data from Yahoo. Finance, and calculate the quarterly return by the formula (return of fourth mouth- the return of frist mouth)/ retrun og first mouth
Question a
Average quarterly return= average (all returns of one asset)
Standard deviations= stdeva (all returns of one asset)
Question b and c
File—options—add-ins—solver add in--go, and click all the options, then using the data analysis, choosing correlation (covariance), then selecting all the returns of all assets.
Question d
The average weight= 1/12
Sum of weight =1
Solver portfolio
Return=MMULT(whole covariance matrix, TRANSPOSE(whole correlation matrix))
Variance ==MMULT(average weight,MMULT(whole covariance matrix, TRANSPOSE(average weight)))
Risk =SQRT(Variance)
Mvp
First calculate sigma and return
Sigma =SQRT(MMULT(MMULT(weight,whole covariance matrix),TRANSPOSE(weight)))
Return=MMULT(weight,TRANSPOSE(annual return))
Then using solver set sigma in target cell, choosing min, by changing cells: total weight
The constrains should be sum of weight =1
Lastly, click solve.
Question e
Set a target of sigma ,similarly to one of weight, and though slover,
set the return as target cell, choosing max , by changing cells : all weight, the constraints should be :sigma= target of sigma, sum of weight =1,click solve.
So after getting a new group figure of sigma, return and weight, change target of sigma slowly, and get 10 different sigma result, the last three should...

...Taja Charrier
LSP 120
11/4/13
Activity 12
1. Suppose that you deposit $500 in a bank that offers an annual percentage rate of 6.0% compounded annually.
a. What is your account balance after one year? 530
b. What is your account balance after 10 years? 895.42
2. How long will it take your money to triple at an annual percentage rate of 8% compounded annually? 14.27 years
3. Suppose that you deposit $750 in a bank that offers an annual percentage rate of 4.0% compounded monthly.
a. What is your account balance after one year? 812.25
b. What is your account balance after 8 years? 1234.92
c. What is the annual percentage yield for this account? (Recall that the annual percentage yield is the percentage change in the account for one year, in this case in 12 months.) 8.3%
4. Compare the accumulated balance in three accounts that all start with an initial deposit of $1000. All three accounts have an annual percentage rate of 5.5%, but the first account compounds interest annually, the second account compounds interest quarterly while the third account compounds interest monthly. Make a table that shows the accumulated balance in all three accounts for the first ten years.
a. Paste the first ten rows of each table your Word document.
annual
quarterly
monthly
0
1000
1000
1000
1
1055
1056.144809
1056.408
2
1113.025
1115.441858
1115.998
3
1174.241
1178.068128
1178.949
4
1238.825
1244.210538
1245.451
5
1306.96
1314.066502
1315.704...

... Lovely Professional University
Term Paper
Numerical Analysis
MTH 204
Topic: Comparison of rate of convergence of iterative methods
Submitted To: Ramanjeet Kaur
Submitted By: Angad Singh
Roll no: 37
Section: B1801
Regd No: 10801352
Content
Acknowledgement.
Iterative method.
Rate of convergence.
Different Iterative methods.
Rate of convergence of different iterative methods.
Comparison of rate of convergence of iterative methods.
Bibliography.
Acknowledgment
I “Angad Singh” having registration No 10801352 has successfully completed my term paper. I thank our teacher Ms Ramanjeet Kaur for providing this term paper and helping in clearing doubts. I also want to thank the esteemed library of the University for providing the interesting material regarding this topic. I also thank my parents and my friends for being there for me always and for providing moral support.
Terminology
Iterative method:
The term ``iterative method'' refers to a wide range of techniques that use successive approximations to obtain more accurate solutions to a linear system at each step.
Rate of convergence:
In numerical analysis, the speed at which a convergent sequence approaches its limit is called the rate of convergence. Although strictly speaking, a limit does not give information about any finite first part of the sequence, this concept is of practical importance if we deal with a sequence of successive...

...2.3 Study Questions
1. According to functionalism, a mental states are functional states meaning that the mind is what the brain does.
2. Lewis’ pained madman thought experiment describes a man that feels pain for different reasons than most. It attempts to undermine functionalism by showing how being in a certain functional state is not a necessary condition for being in a mental state.
3. The Block’s Chinese Nation thought experiment describes a situation in which the people in China function like neurons. His experiment attempts to undermine functionalism by showing a functional organization does not have a mind, thus not being a sufficient condition for having a mind.
4. Putnam’s Inverted Spectrum thought experiment is two people that sees blue things as red and vice versa. It attempts to undermine functionalism by stating even though they may be in the same functional state they are not in the same mental state.
5. The turning test for intelligence is a test that determines whether a computer can “think” by asking questions. To pass the test the computer would have to lie.
6. Searle’s Chinese Room thought experiment is describes a situation in which a person is locked in a room filled with Chinese symbols and book in English that matches them to other symbols thus, allowing the person to answer any question asked while remaining ignorant of their doing so. This also allows them to pass the turning test while remaining ignorant. This attempts to...

...won’t find a more comprehensive book on Excel2010 than this!”
—Dick Kusleika, Microsoft MVP, DailyDoseOfExcel.com
• Searchable PDF of the book
• Understand functions, charts, worksheets, and workbooks
System Requirements: See the CD
Appendix in the book for details and
complete system requirements.
• Master “what-if” analysis, Goal Seeking, external database ﬁles,
and pivot tables
• Develop custom functions, program with VBA, and create UserForms
• Try new slice-and-dice tools to dynamically ﬁlter your data
Preview how your copied
text will look
www.wiley.com/compbooks
Spot trends in your data
with Sparklines
John Walkenbach
aka “Mr. Spreadsheet” is the principal
of J-Walk and Associates, Inc. and a
Microsoft Excel MVP. He is a leading
authority on spreadsheet software
and the creator of the award-winning
Power Utility Pak. John has written more
than 50 books, as well as articles and
reviews for publications including PC
World, InfoWorld, and Windows. He
also maintains the popular Spreadsheet
Page at spreadsheetpage.com.
®
• All the examples and workbook
ﬁles used in the book
Microsoft®
Follow the examples in the book,
chapter by chapter, using the bonus
materials on the CD-ROM:
Excel2010
What’s on the
CD-ROM?
• Get up to speed on everything new in Excel2010
• Perform magic with array formulas—and even more...