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 many spaces does the increase indent button add?
The increase indent button indents the contents of a cell to the right by three spaces each time you click it.
How many work sheet add in ms Excel file?
This question is not clear. Please ask again with more specific words. I am not sure if you are asking how many worksheets you can put in a single workbook, how many add-ins are available for MS Excel, or something else.
What does clicking and dragging top of chart do in Excel?
It allows you to move the chart. Depending on where you click exactly, you can pick up the chart and then drag it to a new location. This only works if you are in an embedded chart. It does not do anything on a chart sheet. You can also move the plot area within the chart area on both an embedded chart or a chart on a chart sheet, when you click at the top or on any part on the plot area.
What does the NPV function do in Excel?
You use the NPV function. Start by specifying the rate and follow it with a list of future values that you want to help determine your result. So you could have something like this:
=NPV(5%,10,20)
Can excel files and word files be saved in the same folder?
Yes - I have a folder at home that has both in
Is it possible to choose formats that are applied only when a cell meets a specific condition?
Yes. There is a facility in Excel called Conditional Formatting that will allow you to do that.
Can a autofill be used to copy a formula updownleftor right within a worksheet?
Autofill can be used to drag a series in either direction vertically or horizontally.
Dragging right or down increases the references and dragging left or up decreases them. For example if you have the formula =C5+C6 in a cell dragging it down will place the formula =C6+C7. Dragging right would produce the formula =D5+D6, dragging up would produce =C4+C5 and dragging left would produce =B5+B6.
If you had a month of the year in a cell dragging down or right would produce the following months and dragging up or left would produce the preceding months.
Microsoft Excel is an example of a package because it can be used for calculations and comparisons?
It is a spreadsheet package.
Differecne between Access has which Excel does not?
Access is a database, whereas Excel is a spreadsheet. A database is used for manipulating data and lists of data and processing information, like finding all the people born in a certain year, or the amount of people working in each department of a company, or the names of all the captains of a set of football teams. Spreadsheets focus mainly on numerical analysis and manipulation. Databases can work on a much broader range of data. There are a lot of things that both are capable of doing. If it is nearly all numerical, then a spreadsheet is usually better, but if you are looking for different kinds of data, like a list of names and addresses from a set, then it is better to use a database.
What is the best way to quiz yourself using your two-column notes?
To ask yourself the questions while covering up the notes with a piece of paper. -Apex (:
When you right click a hyperlink the Mini toolbar displays?
A shortcut menu will display when you right-click a link.
What is a filter arrow in MsExcel?
If you have a database-type table in Microsoft Excel, with a row of column headers at the top of the table, you can turn on "autofilter" to display filter arrows next to the elements in the header row. If you click the arrow, you can select one item and the list will be filtered so that only rows that match the selected entry will be displayed. It's a quick and easy way to display only the desired elements from your database.
How do you multiply 40 percent in excel?
Assuming the value you want to multiply by 40% is in cell B2 you could use any of these formulas:
=B2*40%
=B2*0.4
=B2/100*40
=B2/10*4
debit column of the income statement and the credit column of the balance sheet.
If a cell contains incorrect data how can it be corrected in excel?
Click on the cell with the incorrect data and change the data to the correct information.
How do you use Excel in a sentence?
As a noun: He worked for many years to achieve excellence in his craft.
As a noun: The teacher appreciated her excellence in school.
As an adjective: She was awarded the excellenceprize for photography.
As an adjective: The principal gave me an excellence award.
Difference of an auto filter from advanced filter?
The Advanced Filter gives you much more flexibility in specifying what you want to filter and how you do it. It allows you to specify a criteria and take the filtered results and put them into another part of your spreadsheet. The normal filter will just filter things in place and does not allow you to do as complex a filter as Advanced Filter does.
When i open Excel it is blank?
When you open Excel, it is supposed to be blank. That way, it will be ready for you to create a worksheet.
How do you use bahttext function to convert English text in excel?
It converts numbers to Thai text. So if you wanted the number 6 in Thai, you can do something like this:
=BAHTTEXT(6)
It does not convert actual text and it does not convert numbers to English text.
What is the cell reference A1 for Microsoft Excel?
A1 is the first cell, in the first column and the first row: Column A, row 1.
A1 is the first cell, in the first column and the first row: Column A, row 1.
A1 is the first cell, in the first column and the first row: Column A, row 1.
A1 is the first cell, in the first column and the first row: Column A, row 1.
A1 is the first cell, in the first column and the first row: Column A, row 1.
A1 is the first cell, in the first column and the first row: Column A, row 1.
A1 is the first cell, in the first column and the first row: Column A, row 1.
A1 is the first cell, in the first column and the first row: Column A, row 1.
A1 is the first cell, in the first column and the first row: Column A, row 1.
A1 is the first cell, in the first column and the first row: Column A, row 1.
A1 is the first cell, in the first column and the first row: Column A, row 1.
