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 can a spreadsheet help in forecasting?
It can help them to predict what will happen in the future and allow them to plan for that, like investing enough money to keep them in profit, or stop spending money on something that isn't working for them.
How do you put a comment in worksheet?
Comments can be placed in a cell by pressing Shift and F2. The comment goes into a text box. A red triangle will appear in the top right corner of the cell to show that a comment has been entered. Putting the cursor over the cell will show the comment as a pop up.
What is a feature that applies the formats associated with a selection to another selection?
The Format Painter.
Why you start a formula with an equal sign?
Without it, Excel will treat what you type in as a number, date or text. What you type will then literally appear in the cell. All functions start with letters. If the first thing you type is a letter, then it would be treated as text. The equals sign tells Excel to do the calculation that follows it. If you try typing any formula or function without an equals sign it will just appear in the cell and not do a calculation.
Does cell references in formulas have to be entered in uppercase?
No. You can type in lower or upper case and you can include spaces. When the formula has been entered Excel will change cell references and function names to uppercase and remove unnecessary spaces.
Can spreadsheets be handwritten?
Yes. Originally spreadsheets were all handwritten. Some still are. It was a piece of paper with rows and columns enabling you to do calculations on it, used by people in business and finance in particular. This could be difficult to use, especially when values changed or new ones needed to be added, so a computerised spreadsheet was invented in 1978, known as VisiCalc. Since then, many spreadsheet programs have been developed.
What is difrrence between paste and paste special?
Paste will just paste whatever you've copied. Paste Special in Wordpad has a few options to paste in different formats which are as a Wordpad document, Rich Text Format, a picture and unformatted text. It is much more limited in options compared to Paste Special in other applications.
What features can be performed in Microsoft Excel that cannot be done in Microsoft Word?
- Calculate a Square Root.
- Created a chart based on a list of data and update that chart in real time.
- Add numbers together from different worksheets and display the results in one location.
- Automatically change the color of text based on pre-defined criteria and change the color if the referenced criteria changes.
- Automatically update multiple totals in multiple tables everytime you changed a referenced value.
Simple bottom line: Excel is for working with numbers and Word is for working with words.
Does windows xp home edition have Microsoft Word?
No. MS word is part of the MS office package which is not included with MS windows. Windows does come with wordpad, a no-frills word processor, but if you want the features of MS Word, you will have to buy the program (or the MS office package) separately.
Printing a file requires one to connect a computer to a printer. With the appropriate drivers of the printer installed, open the file and choose the print command. The printer will print the file so long as there is paper.
The
combination chartis a visualization that combines the features of the bar chart and the line chart.
In chemistry periodic table is one of the best example of combination chart.
What are the different forms of mouse pointers in the spreadsheet?
In Excel different mouse pointers perform different tasks.
Cross Pointer
Used for selecting ranges of cells
Fill Handle
Used to copy cell contents to adjacent cells
Arrow Pointer
Used to move cell contents
Resizing Arrows
Used to change column widths
Resizing Arrows
Used to change row heights
Cursor
Used to edit cell contents in Formula Bar
How is it label in Excel chart?
A label is normally a cell with text that acts as a heading for something in another cell. So you could have a formula that has a total in it of some kind, and beside it have a cell saying what that total is like "Total Sales". You could also have a label at the top of a column to indicate what is the cells below it, or at a start of a row to indicate what the cells beside it contain.
what is displayed in a cell
Labels are simply text you enter into any cell. Labels are left aligned in the cells, while values (numbers) are right aligned. Labels describe what the numbers in the spreadsheet means, and makes it easy to work with.
to put your name so you no it yours
Anything that is text, or anything that you type. (A title or name)
What is the advanced filter on Excel?
They are used for filtering data based on the text values. You can use them to build more complex criteria, like basing them on more than one column. They can do things like find data that has certain pieces of text in it, or text that is alphabetically after some text. Data can be extracted to a separate part of the worksheet.
Where is the title bar located in windows?
The title bar is at the very top of your screen and shows the name of the application you are using and the name of the document that is open.
What does cell reference mean on a spreadsheet?
You use its column letter and row number. So the cell that is in column C and row 3 is referenced as C3. Technically that is a relative reference. Cells can also be referenced as mixed, like $C3 and C$3, and as absolute like $C$3.
What is the difference between Microsoft Excel and regular Microsoft excel?
1.Word is a word processing application while Excel is a spreadsheet application
2.You usually use Word in writing letters or essays while Excel is good for creating documents that has a lot of data that needs to be presented in table form
3.You can insert Excel tables inside a Word document
4.Excel lacks some advanced formatting abilities that are present in Word
5. Word has some, but very limited, abilities to write custom equations and formulas, whereas Excel is designed for numerical analysis and manipulation and so has extensive abilities to write formulas and equations.
Excel allows you to write spreadsheets while Word allows you to write documents/papers.
How do you type the omega symbol on Microsoft Excel?
It's not specific to excel, but hold down alt and press 234.
It's also under Insert>Symbols, under the subset pick Greek.
The right click button
Use what to check which cells are referenced in the formula assigned to the active cell?
Pressing F2 will show the formula and the referenced cells in it will be colour-coded and highlighted. Pressing and holding the Ctrl key and then pressing the [ key will select the cells referenced in the formula.
Can negative numbers be displayed in red in Excel?
Yes. In the format cells option, under number, there are various number formats. Some enable negative values to be shown in red. You could even use Conditional Formatting to do it, but as there are already built-in formats, there is no need to do that.
