Top 20
Microsoft EXCEL 2004 for Mac Questions & Answers
Having issues entering data in mac excel
For Microsoft Office technical errors, the easiest way is to reach Microsoft customer service. They provide an instant solution and help for email setup and password related issues.
Services offered-
Microsoft Office Activation Key
Microsoft account setup
Microsoft password reset
Outlook technical support
account live password reset
Microsoft sign in errors
Install MS office
MS Office 365 setup
MS Excel support
Dial directly 1888-315-9712
or visit toll-free Microsoft Office Technical Support Number from the below link-
microsoft tech support number
What are the formulas in
Formulas are used to specify calculations based on values in designated cells. Excel supports basic calculations as well as statistical, trigonometric and other specialized functions.
Formulas used in Excel must follow a certain syntax.
- All formulas begin with an equals sign (=).
- Some formulas use operands such as +,-, *,/ for addition, subtraction, multiplication or division.
For example, the formula =A1+A2+A3 would add the contents of cells A1, A2 and A3.
- Other formulas refer to different functions such as SUM, AVERAGE and others.
For example, the formula =SUM(A1:A3) would add the contents for the range A1 through A3.
- Formulas can be combined with operands.
For example, the formula =10*SUM(A1:A3) would add the contents cells A1 through A3 and multiply them by 10.
- Functions can be nested within each other.
For example, the formula =SQRT(10*SUM(A1:A3)) would take the square root of ten times the sum of cells A1 through A3. When functions are nested, it is important that the number of left parentheses match the number of right parentheses.
I am trying to type numbers with more than 3
- Right click on the the letter at the top of the column you are entering the larger numbers in and choose "format cells" from the drop down menu.
- Then click on "number" and this is where you can set the number of decimal places or other adjustments.
Thanks,
Robert
My worksheet has a lot of pages visible and so my
The number of pages you have is not related to the size of the columns and rows. You can set those to any size you wish.
By "a lot of pages" do you mean there are many colums or many tabs?
If you have lots of columns, just resize them to a good size. Each tab acts like a separate sheet and the columns and rows can be sized independently of the others.
So, right-click on the column letters and choose the column size you want.
Right-click on the row numbers and do the same for row height.
Good morning,
I think that the file is actually corrupted
You can always try to open it on a different PC
Using excel to solve problem by trial and error method
In A1, put a random value of d as 0.1. Then in B1, put your equation 5*d^4 - 10.29*d^(-1.333), wherein refer d as A1. Then use goal seek function on Tools Menu. First "Set cell" as B1, "To value" as 0.124 and "By Changing Cell" as A1. Excel will do the Trial & Error and will give you the answer in Cell A1.
Nilesh
Doesn't remember there's a Header Row
You can try to select all data (except for the entire row which contain your header) and try to sort thru columns. This can sorted in ascending or descending order.
Vlookup in 2004 excel for mac o/s
First make sure there is an "=" sign at the beginning of the formula. If there is and the formula still shows in the cell go to Preferences and click View. Make sure the "Formulas" box under Window Options is not checked.
Excel data is Delimited
Try opening the file from the Excel File/Open menu rather than double clicking to open it. If that does not work try Importing from it into a new blank spreadsheet.
Not finding what you are looking for?
