Option Explicit
'Main Function
Function SpellNumber(ByVal MyNumber)
Dim Rupees, Paisa, Temp
Dim DecimalPlace, Count
ReDim Place(9) As String
Place(2) = " Thousand "
Place(3) = " Million "
Place(4) = " Billion "
Place(5) = " Trillion "
' String representation of amount.
MyNumber = Trim(Str(MyNumber))
' Position of decimal place 0 if none.
DecimalPlace = InStr(MyNumber, ".")
' Convert Paisa and set MyNumber to Rupee amount.
If DecimalPlace > 0 Then
Paisa = GetTens(Left(Mid(MyNumber, DecimalPlace + 1) & _ "0", 2))
MyNumber = Trim(Left(MyNumber, DecimalPlace - 1))
End If
Count = 1
Do While MyNumber <> ""
Temp = GetHundreds(Right(MyNumber, 3))
If Temp <> "" Then Rupees = Temp & Place(Count) & Rupees If Len(MyNumber) > 3 Then
MyNumber = Left(MyNumber, Len(MyNumber) - 3)
Else
MyNumber = ""
End If
Count = Count + 1
Loop
Select Case Rupees
Case ""
Rupees = "No Rupees"
Case "One"
Rupees = "One Rupee"
Case Else
Rupees = Rupees & " Rupees only"
End Select
Select Case Paisa
Case ""
Paisa = ""
Case "One"
Paisa = ""
Case Else
Paisa = " and " & Paisa & " Paisa"
End Select
SpellNumber = Rupees '& Paisa
End Function

' Converts a number from 100-999 into text
Function GetHundreds(ByVal MyNumber)
Dim Result As String
If Val(MyNumber) = 0 Then Exit Function
MyNumber = Right("000" & MyNumber, 3)
' Convert the hundreds place.
If Mid(MyNumber, 1, 1) <> "0" Then
Result = GetDigit(Mid(MyNumber, 1, 1)) & " Hundred "
End If
' Convert the tens and ones place.
If Mid(MyNumber, 2, 1) <> "0" Then
Result = Result & GetTens(Mid(MyNumber, 2))
Else
Result = Result & GetDigit(Mid(MyNumber, 3))
End If
GetHundreds = Result
End Function

' Converts a number from 10 to 99 into text.
Function GetTens(TensText)
Dim Result As String
Result = "" ' Null out the temporary function value.
If...

...Week 6
Excel
PF008 A14
Introduction to Spreadsheets
A spreadsheet is an electronic file that contains a
grid of columns and rows used to organize related
data and perform calculations.
Excel is a spreadsheet program used to create and modify
electronic spreadsheets.
An electronic spreadsheet makes data-entry changes easy,
and if the formulas are correctly constructed, the results
recalculate automatically and accurately.
A worksheet is a single spreadsheet that typically contains
descriptive labels, numeric values, formulas, functions, and
graphical representations of data.
A workbook is a collection of one or more related
worksheets contained within a single file. Each worksheet
is identified by a sheet tab. By default, new workbooks
have three worksheets.
The whole file is a workbook
Worksheet
Planning Structure of Worksheets
1. State the purpose of the worksheet
2. Decide what input values are needed
An input area is a range of cells containing values
3. Decide what outputs are needed
An output area is a range of cells containing
results
4. Assign the worksheet inputs and results
Use rows and columns
5. Enter the labels, values, and formulas
6. Format the numerical values
7. Format the descriptive titles and labels
8. Document the worksheet
9. Save the completed workbook
Exploring the Excel Window
• Worksheet rows lie horizontally
• Worksheet columns lie vertically
• A...

...Spreadsheet Evaluation
To create an ICT solution to record and analyse costs for the Actors Associates business I chose Microsoft Excel because it presents the information in a clear way which is easy for the reader to understand. It also performs quick and easy calculations.
Use of Formulae.
In my excel spreadsheet, I used different formulae to perform calculations. Some of the formulae I used include addition and multiplication, which i believe are input correctly. I used replication to prevent inputting the same formula repetitively. This also saved time but the only problem that would have occurred, would be if the original formula was incorrect and it was replicated throughout the whole column. I also used if statements and absolute cell references in the worksheets. If statements check if a statement is true or false and inputs the data appropriate. An absolute cell reference is useful to refer to another and replicate the formula without changing that cell reference, e.g =($M$4*J4). Another useful formula I used was to linking worksheet within my spreadsheet. For example, =COST!E5. This allowed me to update data in a cell in one worksheet and have the changes applied to the appropriate cell in other worksheets.
Data Validation.
Data validation is a tool on excel which makes it possible to control the values input into a given cell. I used this tool to prevent...

...Situation 1
The general approach for facilitating this customer over the telephone is to explain the functions that would help to organize his spreadsheet for his monthly expense reports. I would explain to him that he can add formulas to the spreadsheet that will add up totals for him. He can set it up so it gives him the total expenses by day, week, and month. He can also set it up so that it calculates the totals spent on just meals, hotels, and transportation. He can also calculate what was spent on fuel, phone, entertainment, and misc expenses. I would also explain how using filters can help to narrow down data for an easy view without having to search through a lot of data to see what he needs for instance, if he just wanted to know what was spent on food. I would then explain that he can add charts and graphs to show what was spent in each category whether it is by day, week, month, or quarter. He would have an understanding of how graphs and charts are a quick and easy way to analyze information.
The possible challenges to doing this over the phone are for the customer to see how a spreadsheet would be useful. I can explain all the features but if he were able to see a spreadsheet and all the possibilities that are offered, he would be able to better understand the features I am explaining to him.
Strategies to overcome the challenges would be to ask a lot of questions of what he needs to accomplish what he is looking for, also to use simple terms...

...Started in Excel
Many of the editing tools that you use in Excel are similar to Word and PowerPoint
You will need to become familiar with a few new things for Excel: Rows, Columns, Various Formulas, and Charts just to name a few
When you see a reference such as A7, A is the column and 7 is the row, this will give you the particular cell that is being referenced.
You will learn that you can click or enter in information when it comes to cells and formulas. Everyone will have their own preference on how to do this and one way is not better than the other.
Basic calculations can be done as follows:
=SUM(A1:A7)
=A1+B2
=4+3
Once you have entered a formula for a cell – if the following cells require the same formula you can click and drag your mouse to copy the formula to adjacent cells
Once you have entered a formula you can change one of the numbers used in the formula and it will automatically adjust the results of the formula!! This allows you to use spreadsheets repeatedly without having to redo everything.
There are several display options for the way the numbers will appear (accounting, general, etc.)
For formulas just think back to the basic operations of math (parenthesis, adding, subtracting, dividing, etc.) – Excel does what you tell it to.
If you find your numbers are not...

...Financial Analysis using Excel
Function
Information requirements for function
Dates
Prices and par values
Frequency, and related
Yields and interest/ discount rates Discount
Any amount paid at maturity ?
Frequency of payme nts pa
First coupon
Redemption amount
Investment amount
# of periods
Settlement
Par/coupon
Maturity
COUPDAYBS COUPDAYS COUPDAYSNC COUPNCD COUPPCD COUPNUM DURATION MDURATION PRICE PRICEDISC PRICEMAT RECEIVED YIELD YIELDDISC YIELDMAT ACCRINT ACCRINTM INTRATE DISC
Excel for Professionals 2002 VJ Books. All rights reside with the author.
Interest
Basis
Issue
Yield
Price
Financial Analysis using Excel
Financial Analysis using Excel Financial Analysis using Excel
Volume 6 in the series Excel for Professionals Excel for Professionals
Volume 1: Excel For Beginners Volume 2: Charting in Excel Volume 3: Excel-- Beyond The Basics Volume 4: Managing & Tabulating Data in Excel Volume 5: Statistical Analysis with Excel Volume 6: Financial Analysis using Excel Published by VJ Books Inc
All rights reserved. No part of this book may be used or reproduced in any form or by any means, or stored in a database or retrieval system, without prior written permission of the publisher except in the case of brief quotations...

...APPENDIX
B
Excel Template Instructions
for the Glo-Brite Payroll
Project (Using Excel 2010)
The Excel template for the Payroll Project is an electronic version of the books of
account and payroll records. This is not an automated payroll system, but an
example of how you might use a spreadsheet program to keep payroll records
and account for payroll transactions.
You will need to follow the instructions in the textbook to complete the project. The instructions provided below will enable you to use the Excel template in
place of the journal, general ledger, payroll register, and employee’s earnings
records. Other forms, such as tax forms, are required for the Payroll Project. You
will use those provided in the book.
GETTING TO KNOW EXCELExcel ﬁles are called workbooks. A single workbook can store many worksheets,
which are stored like pages in a notebook. The workbook for this project has
four worksheets: the journal, the general ledger, the payroll register, and employee’s earnings records.
Each worksheet is made up of rows and columns. Rows are numbered from 1
to 65,536, and columns are labeled with letters. Column 1 is A, Column 26 is Z,
Column 27 is AA, and so on. The intersection of a row and column is called a cell.
Cells have addresses based on the row and column in which they appear. Each cell
can hold a number, text, a mathematical formula,...

...- Politeness formulas in Arabic:
When talking about politeness formulas in Arabic and in English and how they are different, it is crucial to take into account the distinction between propositional content of a formula and its illocutionary force potential. A good example showing the relationship between semantic content or propositional content and illocutionary force illustrates in using congratulations in English and “shukran” in Arabic which is equivalent to “thanks”. Sometimes illocutionary force is not completely predictable, but simply can be learnt by what people agree upon. For instance, there are three expressions in Arabic performing different forces according to the matter of conventions; \baraka-allahu-fik\ “God bless you” is used to perform the act of thanking, whereas \barakafik\ “blessing in yourself” has a different force, addressing the family members and the relatives of the deceased. \mabruuk\ “blesses” is another formula used for congratulations of marriage or success in examinations.
There are many other expressions used by Arabs in one of the earliest means of demonstrating politeness in a second language which are” greetings”. Greetings actually are the first task one should know when learning a new language. In Arabic greetings; for example, one would not restrict themselves to say \ahlan wa sahlan\ “hello” rather they would precede it by \marhaba\ “welcome” and they may...

...Student ID: 21709822
Exam: 038229RR - Microsoft Excel
When you have completed your exam and reviewed your answers, click Submit Exam. Answers will not be recorded until you
hit Submit Exam. If you need to exit before completing the exam, click Cancel Exam.
Questions 1 to 20: Select the best answer to each question. Note that a question and its answers may be split across a page
break, so be sure that you have seen the entire question and all the answers before choosing an answer.
1. The order of precedence is very important when building formulas in Excel. Which of the following
formulas will produce 778 as the result?
A. =25*(27/9 + 5) + 309*2
B. =25*27/9 + 5 + 309*2
C. =25*((27/9 + 5) + 309*2)
D. =(25*(27/9) + 5 + 309)*2
2. Which of the following identifies the patterns used for each data series in a chart?
A. The horizontal and vertical axes
B. Data series
C. Legend
D. Data point
3. Helga needs to lay out her newly created pivot table. What are the two ways she can set up a pivot
table?
A. When Helga created the pivot table, Excel automatically put the fields to the appropriate cells of the pivot table. There aren't
two ways to set up a pivot table.
B. Helga can check the field or type in the data in the pivot table.
C. Helga can drag the fields to the four boxes in the pivot table field list or right-click a field name and choose its location from
the shortcut menu.
D. Helga can slide cells to...