How does microsoft excel work?

Question

I was wondering what the formulas were for finding subtotal and such. Also when you have a word in one cell and you select the two next to it how do you center the word? THANKS!!

Answer 1

the Excel formula for subtotal is SUM...

=SUM(cell1, cell2, cell3, etc.) or type = sum( then select a group of cells with the mouse, or you can hit the SUM function button in the button menu bar (it is a sigma symbol, looks like a weird capital E) ;)

To center a word over several cells, select the cells and click the MERGE button (it looks like an a with arrows at each side). This will merge the selected cell and center any text entered into them. Note that if you already have text in cells that you merge, all the text will be deleted except for the text in the far left cell in your selection.

Good luck :)

Answer 2

Know your Environment:
You should know the computer environment you are using, whether that is MS-Windows or the Macintosh. Learn how to do things like move, re-size and close windows. You should also know how to select items from menus.

Getting Started:
To start Excel, double-click on the icon for Microsoft Excel in the Excel folder or Excel work group on your computer. You can also start Excel by double clicking on an Excel spreadsheet file. This will automatically start up Excel and work with the spreadsheet you selected.
To exit Excel, select "File" from the Excel menu, then "Quit". Excel will warn you if any changed spreadsheets need to be saved. You can also save spreadsheets by choosing "File" then "Save" from the menus.


Parts of the Spreadsheet:
Excel consists of several parts. At the top is the Menu, which provides options for performing tasks in Excel. Beneath that is the Tool-bar, which consists of shortcut "buttons" for operations available in the menu. Below that is the Data Entry Area, where you can edit the contents of cells in the worksheet. At the bottom is the Status Area which displays instructions, short summaries of what menu entries do, etc. Finally we have the Spreadsheet Windows, where the spreadsheets containing your data are.

How to Enter Information:
To enter information (text or numbers), use the mouse to select a cell in the spreadsheet, then type the information and press the key. You can change this information by selecting the cell, then changing the contents of the cell in the Data Entry area.

How to Enter Formulas:
The easiest way to enter formulas is to select the "Formula" menu, and the "Paste Function" entry within that menu.

Answer 3

=a1+b1: will add those cells; =a1*b1: will multiply those cells; =a1/b1: will divide the cells; and =a1-b1: will subtract the cells. Use can also use =sum(a1+b1). To center a cell, there is a tool bar on top that allows you to left, right justify and center. Hope this helps. There is also an auto sum feature on the tool bar, that will add the cells for you.

Answer 4

The formula for getting the sum of 1 or more cells is =SUM(A1:A2). This example would add cell A1 and cell A2 together and return the total.

Answer 5

This may help:
http://office.microsoft.com/en-us/training/CR061831141033.aspx