0
Microsoft Excel
Excel is a spreadsheet application developed and distributed by Microsoft Corporation for computers using the Microsoft Windows and Mac OS X operating systems. It features graphing tools, chart wizards, calculations, formatting options, and pivot tables.
9,788 Questions
How do you keep the date updated using today function in Microsoft Excel?
The TODAY() function always shows the date of the current day, no matter when you open it. That is what it is used for. Other elements of the spreadsheet can make use of it for their calculations.
How do you select a row in Excel?
Click on the label for the row you want, then hold 'Ctrl' and click on any extra row you want. You can also press the Shift key and the spacebar to select the current row or rows, if cells from more than one row are already selected.
Autosum allows you to quickly add values in ranges of cells. If you have a column of numbers and put the cursor on the cell below them and click the Autosum, it will automatically add the cells above it by highlighting the range into the formula. If you try the same thing at the end of a row, it will add those.
Is a worksheet always stored in a workbook in Microsoft Excel?
Yes, an MS Excel worksheet is always stored in a workbook.
Normal view shows the main worksheet without things like the header areas and footer areas. It is the view we usually work in. It does not indicate page sizes, unless you do a print preview. In Normal view we focus on the worksheet itself, its formulas and workings, rather than how it will look on a printed page.
What is a systematic arrangement of data usually in rows and columns called?
In information technology / database technology this would be a data table. Conceptually, think of it as a spread sheet. Each row contains a set of columns. The values in the columns usually represent a single instantiation of a entity.
It is the fill handle, enabling you to drag down a cell with a formula or for extending pre-defined lists. For example: if you type Sunday into a cell and press return, and then use the fill handle to fill down, it will automatically put in the other days of the week. You can do the same for Months.
What does ctrl enter do in Microsoft Excel?
If you have more than one cell selected and type something and then press Ctrl-Enter, it will put what is typed into all the selected cells. So it can be used as a quick way of filling a lot of cells or copying a formula into a range when it is entered, rather than copying it separately afterwards. If just one cell is selected, then after pressing Ctrl-Enter the same still will still be active, rather than moving to a different cell.
Excel is one of those programs that has many features, many of which might need a tutorial. I think your best bet would be to use a search engine to start and enter what you're trying to learn.
As example, in Google you might type excel tutorial vlookup. If you just want general items, you might leave off the "vlookup" portion and just use "excel tutorial" in quotes.
Some general sites you might try include:
www.j-walk.com
www.vitalnews.com
www.timeatlas.com
What are the advantages of using a spreadsheet?
Using a spreadsheet you can see all the data at once and when you change anydata all computations can be instantaneously updated with the change.
It is a place where you can organize your information. Also if you are using numbers, you can input eqautions to help run those numbers (ex. Excel).
you dont really have to any of the work because if you are finding out sums(working out) you can just drag it and it will bring up all of the other answers for you
They are faster to set up and allow easier copying and duplication for data with repetitive patterns They are neat, easily edited and much quicker.
1. It can help you with finances.
2. It can help you with calculations.
If you had ever used a paper spreadsheet in duplicate or triplicate, etc., you wouldn't have asked. In the old days, if you made one error, you would have to erase, whiteout or rewrite the spreadsheet and all the carbons or duplicates from the point of the error or in its entirety. With software you just correct the wrong entry and recalculate. I almost cried the first time I saw a computer program recalculate a spreadsheet after an error and display it in under 2 seconds in a sales demonstration (the year was 1983). Another advantage besides accuracy and editing is the ability to email and print copies.
It can help you with your finances and it can help you easily with your calculations.
Is a group of cells called a cell range or range in excel?
You create them. A range is a collection of cells, you choose.
EXAMPLE:
You want to find the sum of a range of cells from C2 through C23. The range would be C2:C23. The formula to find the sum of this range of numbers is =SUM(C2:C23).
Which symbol inserted between two cell indicates a range?
A colon is used for a range, by putting it between two cell references. So if you want to refer to the range from cell A3 to cell C9, it would be A3:C9 which could be then used in a function:
=SUM(A3:C9)
=AVERAGE(A3:C9)
=MAX(A3:C9)
Is it true you press the space bar to clear the cell in Excel?
If you put the cursor onto a cell with content and press the space bar, it will get rid of the content, of the current cell, but replace it with a space, which means the cell is not completely empty. If you want to get rid of what is in the cell, you are better to press the Delete key.
To be technically accurate, no function does this. The answer you are looking for is the AVERAGE function. It divides by the amount of cells that have values in them, not by the amount of cells. In most situations, all of the selected cells have values in them, but there are cases when they don't.
What does Excel store in documents?
They are stored wherever the user wants to save them to. There is usually a default folder to save them to that can be set in the options in Excel. Normally it is the user's My Documents folder. It can be changed and the user is free to save a file wherever they want to if they don't want it to go to the default folder, so there is no single answer to the question.
How do you copy formatting of a cell in Excel?
ctrl-1 will copy the format of the selected cell then you will have to select the cell in which you want to change. On the menu bar there is a icon that looks like a paint brush. You can select this icon to copy a cells format as well but you will have to still select the cell in which you want the change to happen.
What does layout refer to in excel?
It would be the structure you put on your data and how you position it in your spreadsheet. Data should be laid out in rows and columns and you should have headings to indicate what the data is. Usually figures you want to total would be put in columns and at the bottom of the columns you would be able to get totals, or other things like averages. You would have related data in the same column. So you might have a list of people's wages in one column and in the next a list of their tax paid. If you were going to have their names, that should be in a column before their wages and tax, rather than in a column after them. Those are the kinds of things to consider. Data should be laid out in a logical and structured manner.
Laying out data properly in a spreadsheet can make it a lot easier to use and to maintain. If you put numbers randomly all around the spreadsheet that you would like to add up, it can still be done but it would be much more awkward, and it would be harder to follow. The exact same data laid out in an erratic manner, will be a lot harder to work with than if it is laid out properly. So it is very important to have a good layout for a spreadsheet.
What do you think the best kind of embedded chart would be for a budget?
There is not really a single answer to that. Different kinds of charts can be used, depending on what you want to show. There is all sorts of things that can be shown in a chart relating to a budget, so there are many ways those things can be shown.
You might want to show a continuation of how your spending or income or amount you have left each month goes up or down, so you might use a line chart for that. A column chart could be used to compare months.
You may have your budget broken down into different elements, like different kinds of expenses such as rent, food, heat etc. and might show them in a pie chart or a stacked column chart. You could use several different charts to look at the same data in different ways. It is really up to you and what you want.
In Excel which symbol is the mathematical operator for multiplication?
You use the * key, which can be found on the numeric keypad.
In a spreadsheet what is a numeric?
Any number is a numeric value. So it can be a whole number or a decimal number. Even times and dates have numeric forms. There are also many other ways of getting numbers, like counting the amount of characters in a cell.
Formatting fonts and adding appropriate cell borders is a quick way to enhance the look of a worksheet. Another idea is to merge all cells in heading rows and center the heading within that merged range.
