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
What are the functions of capicitor?
A capacitor is essentially a device that develops and stores an electric charge along a circuit. It consists of two conductive plates spaced a particular distance apart, with a material known as a dielectric between them.
How do you open a blank spreadsheet?
Assuming you already know how to open Excel to get an initial blank spreadsheet and want to open an additional blank worksheet within the same workbook, you would click on the next available blank tab at the bottom of the screen or use the keyboard shortcut Shift+F11.
Which tab do you use to begin to insert a chart in Excel?
Use the Insert tab and select from the Charts section.
Describe the four ways of viewing the content of an Excel spreadsheet?
normal view, page layout view, page break view, and formula view.
5 Advantages of using spreadsheet over pen and paper method?
- Space - Book keeping is infamously space consuming, filing cabinets full of paper can be condensed into a single file on a laptop.
- Speed - Book keeping normally features calculations which a spreadsheet when set up with the correct functions can do them automatically as data is entered.
- Accuracy - Because the calculations are copied and automated, there would be no user input, and thus no chance of someone forgetting to carry a 1 in the calculations.
- Statistics - Having the data all in one place makes it far easier than scrolling through a filing cabinet to find out what the most commonly sold item in your company is.
- Backup - Backing up a file to a secondary location is as simple as two clicks, try doing that with an office fill of paper files.
What does the Format Painter button do in Excel?
It enables you to copy the format you have used in one or more cells, and apply it to other cells. A cell using a combination of formatting can have all of its formatting applied to other cells, without having to apply the individual settings one at a time.
Can you use Excel as a database application?
Yes, it is possible to make Excel as a database and be able to be a database application just like Access. I am sure that you won't believe me when I say that anything that you can do with a regular programming language is also possible with Microsoft Excel.
But of course, there are advantages in using Microsoft Excel as database. What are the advantages?
- First and foremost, if you have the Microsoft Office in your PC, you don't need anything else to be installed in your computer. You are good to go and can start with your programming straight away.
- Second, if you are a beginner, you can easily learn the Excel VBA Programming because you are half familiar with the programming platform that you are going to use, which is Excel.
- Third, you can start with small Excel database application and as the need grows especially on records that are getting huge, you can still use the same Excel application and upgrade your database platform from Excel to other high-end databases like Access, SQL Server, Oracle, MySQL, etc.
- Fourth, Excel is capable of connecting directly to OLAP databases and can be integrated in Pivot Tables.
- Fifth, You don't need to create a your own financial modules. Excel is rich in financial functions like Fixed Assets Depreciation, Amortization, etc.
- Sixth, Excel is portable. You can send it to someone through email.
Excel database application also has its disadvantages. But these disadvantages are sometimes have some workaround that can be done to fix or sometimes there are little effect that you can just live with them. Here are the disadvantages:
- When you develop your application into one file it can be huge and will make your program execution very slow. But as I told you, there are workarounds. Design your program to have compact codes to lessen the bloating of the file. Another way is to separate each application function into more than one files. For example, if you are going to design a purchasing program, you can separate each of them; the purchase requisition function, item-and-price comparison matrix function, vendor master list maintenance, item master list maintenance, purchase order function, etc. Each will have small file, therefore execution is faster.
- When you separate functions to multiple files, Excel files are prone to get lost in your hard drive especially when you break your application to too many files. You should practice a good folders/sub-directories management.
- Excel worksheet as a database has a limited number of rows or records that you can store. But when you reach the 65k lines limit, you can convert it easily to Access and the rest of the application is can still be used.
- If you can send Excel via email, you can accidentally send your file to someone who should not have it or not authorized to have it. Solution? You can password protect your Excel file. You can do it in two ways. First, Excel is capable of password protection in many ways (I will also discuss that in the future). Second, you can create your own password protection by Macro/VBA programming.
What major companies use spreadsheets?
retail Sales figures are all spreadsheets
Most sales figures are
Anything that has a value you track recurrently can be put into a spreadsheet and become more usable information once it is cross referenced with a second tracked value or variable in a spreadsheet.
Can you change cell name in Excel?
Cells have cell references which cannot be changed. Cells can be given individual names too, and these can be changed. The cell can then be referenced by its name or cell reference.
Cells have cell references which cannot be changed. Cells can be given individual names too, and these can be changed. The cell can then be referenced by its name or cell reference.
Cells have cell references which cannot be changed. Cells can be given individual names too, and these can be changed. The cell can then be referenced by its name or cell reference.
Cells have cell references which cannot be changed. Cells can be given individual names too, and these can be changed. The cell can then be referenced by its name or cell reference.
Cells have cell references which cannot be changed. Cells can be given individual names too, and these can be changed. The cell can then be referenced by its name or cell reference.
Cells have cell references which cannot be changed. Cells can be given individual names too, and these can be changed. The cell can then be referenced by its name or cell reference.
Cells have cell references which cannot be changed. Cells can be given individual names too, and these can be changed. The cell can then be referenced by its name or cell reference.
Cells have cell references which cannot be changed. Cells can be given individual names too, and these can be changed. The cell can then be referenced by its name or cell reference.
Cells have cell references which cannot be changed. Cells can be given individual names too, and these can be changed. The cell can then be referenced by its name or cell reference.
Cells have cell references which cannot be changed. Cells can be given individual names too, and these can be changed. The cell can then be referenced by its name or cell reference.
Cells have cell references which cannot be changed. Cells can be given individual names too, and these can be changed. The cell can then be referenced by its name or cell reference.
What is the process of changing the appperance of cells and the overall layout of the worksheet?
It is called formatting. You first select the cells you want to format. Then you go to the Format menu and pick the formatting option you want to use.
When you paste copied data Excel displays the Paste Opinions Buttons?
You can paste in different ways, using the mouse, the keyboard or the menu options. So you have the option of showing more paste options if you want, and you would do this by using Paste Special.
How do you write a number in exponential form in Excel 2003?
For example, if you want 2.3 million, which in scientific notation is 2.3 x 106, you simply write 2.3e6.
For example, if you want 2.3 million, which in scientific notation is 2.3 x 106, you simply write 2.3e6.
For example, if you want 2.3 million, which in scientific notation is 2.3 x 106, you simply write 2.3e6.
For example, if you want 2.3 million, which in scientific notation is 2.3 x 106, you simply write 2.3e6.
What cell contents in Excel is extended to Qtr3 Qtr4 and Qtr1 by dragging the fill handle?
You need to type Qtr2 for that to happen.
In excel what formula to use that calculates the annual sales?
If you have previous figures to work from there are a few possible ways. You can use the FORECAST function if you have two sets of dependent figures. You could also use a standard formula if there is a pattern in the figures you have already have got. So if sales had gone up by 10% each year, you could increase the last sales you had by 10%. Forecasting is not always precise so to be accurate is not always certain, particularly with something like sales as it can be affected by many factors. So there are lots of functions that could be used.
How do you insert a function in a cell in Excel?
The CELL function is used to get information about a cell. This can be things like its address, format, filename etc. While some of those things can be obvious, there are times when it is useful to get them. If you are looking for the address of a cell that has been given a name for example, as in the following example. The characteristic that you are looking for must be enclosed in brackets, and they are given to you to choose from as you enter the function. The following example gets the address of a cell that has been given the name TotalSales.
=CELL("address", TotalSales)
How do you activate a cell in Microsoft Excel?
To select a cell (If you are looking for the answer for an IT class.)
Click on the cell using the mouse, or using the arrow keys, move the cursor to the cell you want. You could also press the F5 key and use the Goto command to go to the cell that you want to be active. You could also type its address into the Name Box. The Active Cell will show a black box around it or if it is part of a range it will be the only white cell. You'll also see the address of the Active Cell in the Name Box, beside the Formula Bar, so that you will know which cell it is.
What does Ready Cell mean in Microsoft Excel?
If you see Ready on the status bar, it means Excel is ready for you to start typing something into the active cell. Once you start typing, you will see Enter there, or if you edit a cell you will see Edit there.
How do you make a Fahrenheit sign in Excel?
Celsius = (Fahrenheit -32) * 5 /9
So you get the Fahrenheit and subtract 32. Then multiply the result by 5 and then divide by 9.
To put that into an Excel Formula, we could assume that the Fahrenheit value is in A2. Then you would put the following formula into another cell:
=(A2 - 32) * 5 / 9
How do you distinguish one part of an Excel worksheet from another?
There are various ways of answering that. Every cell has its own address, so is distinguishable. You can use the split option to show different parts of the worksheet at the same time. You can use the Name Manager to apply names to ranges of cells.
How do you break down a word by its letters in excel?
Use the LEN function. It will count the amount of characters in a cell or in a literal piece of text.
To count the amount of text in cell A3, put this formula into another cell:
=Len(A3)
The following will give you 11 as there are eleven characters, including the space in the piece of text:
=LEN("Hello World")
The options on the menu bar and submenus can help users to do lots of things in a Word document. Menus include the File, Edit, View, Insert, Format, Tools, Table, Window and Help. We can format text as we wish when we are in Word 2003 documents. We can open, close and save documents. We can do a wide range of editing tasks. We can insert all sorts of things, like text boxes, graphics, symbols, diagrams and other things. The Format menu includes a lot of things that we use to format the document and is one of the most useful menus. There are lots of tools for special use in Word. Tables are another important thing you can use Word for, so it has a menu of options. The Window menu has a few things you can do with the window you are working on and finally the Help menu gives you access to help for your work. Since Word 2007, menus have been got rid of, but the facilities they have are included in the new versions.
Why did Dan Bricklin and Bob Frankston invented Microsoft Excel?
He didnt invent Microsoft Excel he invented VisiCalcwhich is basically the same thing. And he didnt even Paten VisiCalc but it was known to be there invention. He invented it to make an easier way to organize information onto a spreadsheet.
