Microsoft Excel

There are lots of things you can do. A good book and someone who knows a lot about Excel and can show you is what you need. So doing some sort of Excel course is what you should consider. At the very least, buy a good book that takes you from a beginner's level. There are many good books out there, too many to recommend any single one. Go into a bookshop with a large computer section and have a look at some of the books they have and see what suits your needs.

Create the function =SpellNumber(). See related links for more details.

Option Explicit

'Main Function

Function SpellNumber(ByVal MyNumber)

Dim Dollars, Cents, 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 cents and set MyNumber to dollar amount.

If DecimalPlace > 0 Then

Cents = GetTens(Left(Mid(MyNumber, DecimalPlace + 1) & _

"00", 2))

MyNumber = Trim(Left(MyNumber, DecimalPlace - 1))

End If

Count = 1

Do While MyNumber <> ""

Temp = GetHundreds(Right(MyNumber, 3))

If Temp <> "" Then Dollars = Temp & Place(Count) & Dollars

If Len(MyNumber) > 3 Then

MyNumber = Left(MyNumber, Len(MyNumber) - 3)

Else

MyNumber = ""

End If

Count = Count + 1

Loop

Select Case Dollars

Case ""

Dollars = "No Dollars"

Case "One"

Dollars = "One Dollar"

Case Else

Dollars = Dollars & " Dollars"

End Select

Select Case Cents

Case ""

Cents = " and No Cents"

Case "One"

Cents = " and One Cent"

Case Else

Cents = " and " & Cents & " Cents"

End Select

SpellNumber = Dollars & Cents

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 Val(Left(TensText, 1)) = 1 Then ' If value between 10-19...

Select Case Val(TensText)

Case 10: Result = "Ten"

Case 11: Result = "Eleven"

Case 12: Result = "Twelve"

Case 13: Result = "Thirteen"

Case 14: Result = "Fourteen"

Case 15: Result = "Fifteen"

Case 16: Result = "Sixteen"

Case 17: Result = "Seventeen"

Case 18: Result = "Eighteen"

Case 19: Result = "Nineteen"

Case Else

End Select

Else ' If value between 20-99...

Select Case Val(Left(TensText, 1))

Case 2: Result = "Twenty "

Case 3: Result = "Thirty "

Case 4: Result = "Forty "

Case 5: Result = "Fifty "

Case 6: Result = "Sixty "

Case 7: Result = "Seventy "

Case 8: Result = "Eighty "

Case 9: Result = "Ninety "

Case Else

End Select

Result = Result & GetDigit _

(Right(TensText, 1)) ' Retrieve ones place.

End If

GetTens = Result

End Function

' Converts a number from 1 to 9 into text.

Function GetDigit(Digit)

Select Case Val(Digit)

Case 1: GetDigit = "One"

Case 2: GetDigit = "Two"

Case 3: GetDigit = "Three"

Case 4: GetDigit = "Four"

Case 5: GetDigit = "Five"

Case 6: GetDigit = "Six"

Case 7: GetDigit = "Seven"

Case 8: GetDigit = "Eight"

Case 9: GetDigit = "Nine"

Case Else: GetDigit = ""

End Select

End Function

horizontal...vertical

this doesnt help you , but idk im trying to figure the same thing i dont pay attention in class lol its bad

Filtering reduces the amount of records you can see, by picking ones that meet certain criteria. Pivot tables are for getting totals for categories. So if you had a list of data for different regions, you could just show the list of one region using filtering, whereas with a pivot table you could show different kinds of totals based on the different regions. They could include counts, averages, a max or min for each category, and many other things. A pivot table can do far more things and is a very powerful tool, so there are many other differences.

Open your mhtml file in Internet Explorer( it usually only opens in Internet Explorer).

Next, Press Ctrl+P, this is the command.

Next, just proceed.....

That's all.

If the contents of a cell are too big to display within that cell Excel will use empty cells to the right to display it in full. However, if adjacent cells aren't empty Excel will display ##### to indicate that the column is not wide enough to display the contents.

Make the column wider by dragging the right hand border of the column header to the right. If you double click instead of dragging the column will re-size itself to accommodate the longest entry.

In MS Excel, click the UNDO button.

If you have data in C3:C15 and D3:D15 use the formula =Average(C3:C15).

Having images in any application will always affect the file size, so the answer is yes.

assumes fact

You can add an entire column by using =sum(a:a) for example, which would sum all amounts in column A. Also, holding down the Alt key while hitting the equal sign right below a column of numbers will sum that column

If you have the newer version of MS Excel (2007+), the wrap text button is on the home ribbon above the 'Merge & Center button' in the Alignment box. If you want to do this manually you could right click the box you want to wrap text in, scroll to format cell, go to alignment and chech the Wrap Text box under Text Control.

You may use to utility below. It allows you to recover excel document after modified. Software recovers *.xls, *,xlt, *.xlsx, *.xlsm, *.xltm, *.xltx and *.xlam formats. It saves the original structure of file during restoration.

the title,

Y Axis

X axis

label

and/or legend. (this either replaces the "X axis" making it just "axis" , or its just a wrong answer.

Beecause your "CAPS LOCK" key is depressed. Tell it a funny story & it will cheer right up!

You can interrogate data in Excel 2007 by using the filter and sort options in Excel. This re-organizes the data in a way that makes it easy to analyze and evaluate the data.

There is no such thing as a "row shok test" in MS Excel. Please check your spelling and category for your question. Perhaps a different spelling or category will get you a meaningful answer.

You can put in dotted border lines. The regular lines that show rows and columns are known as gridlines, though they are solid, not dotted. Borders are set by the user and can be put in with different styles.

Extra cells or rows or columns are inserted or removed, though the total amount of each stays the same. As there are so many columns/rows/cells, Excel can effectively push off blank cells at the ends of the spreadsheet. Formulas can update themselves when changes are made, so it is not necessary to change formulas.

Before 2 hrs from dparture of origin station. Ravi

Scrollbars.

Column reading is an act of analyzing an article

Select the cells and then either click the merge and center icon on the standard toolbar or go to the Format menu and pick Cells and in Alignment, pick Merge Cells and set the alignment to be centred.