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
Where is the worksheet called the Reds of February?
It is at the top of the page below the line where it says reproducible page.
MIS report format in excel format for educational institutions?
Reports doesn't matter even it is educational institution. Instead of various department, it can be produced from two department 1. Academic 2.Administrative
Academic Report includes all academic staff detail (all detail) & in second sheet it will show daily activity report. For administration (same report as in Industry)
What can you apply conditional formatting to?
You apply conditional formatting to as many cells on a worksheet as you like.
What is a label entry in a cell?
It is a piece of text in a cell that acts as a heading or title for a value or values. So if you had a load of sales figures in a column, at the top you could have a label like SALES and beside a figure at the bottom that was all the sales added up you might have a label like TOTAL. You could then have other labels for data you might have. Without labels, you would not know what the data on your screen refers to.
Here is a video tutorial http://www.videojug.com/film/how-to-create-tables-in-excel on how to make a table in Excel.
What applications would be the best choice to create a resume Excel or Word?
Microsoft Word should be the best choice to create a Resume. It is because it does not need pictures or Graphs.
B2 times D2 = 8,334
which for a cell calculation needs an = at the beginning,
and instead of an x for times, it is a * symbol.
All with no spaces, so it is
=B2*D2
typed in F2 cell.
What topics are most useful in Microsoft Excel?
There is no real answer to that. Excel is a very versatile application. It can do a huge amount of things and anyone that uses it would be doing different things with it. So what might be useful to one person, may be of little interest to others.
How do you select all columns and rows that have data in them within excel?
Press the F5 key. Then press click Special on the dialog box that opens. You will then be able to select types of data and formulas to find and be able to select them.
Excel's split window feature allows you to view at the same time.?
It allows you to view different parts of a worksheet at the same time.
What is the maximum number of characters a Tweet can contain?
You can send a maximum of 60,000 tweets per day.
What is Microsoft Excel intended use?
Excel is a spreadsheet. It prime function is in maths where the cells can contain values that operate mathematically against other cells.
It is often mistakenly used as a database. In a database it is not possible to split a line of information.
In a spreadsheet you could do a 'one armed bandit' on one row of information which would be catastrphic. Imagine sorting telephones numbers numerically but leaving the names of the people in place.
How the absolute cell reference is used by businesses?
Absolute cell referencing is used for formulas that are being copied from one cell to another and the required to reference a constant cell. A business could use them for working with percentages that are being used by a range of calculations. So if they have a list of values that have to be taxed, the tax rate could be put in near the top of the column and then used for all values. So say the values to be taxed are in column B, starting at cell B3 and the tax rate is in cell C2. A formula that could be used would be as follows, being put in C3:
=B3*$C$2
When the formula is copied down, the B3 will become B4 and then B5 and so on, which is what we would want. As the rate is in the cell C2, we would not want it to change, so it won't. To adjust the rate we just change what is in cell C2 and do not have to do anything to the formulas.
Businesses use an absolute reference when they are referring to formulas and worksheets in Excel. When they do this, they are doing it to ensure that the formula doesn't change with the data.
What does AT-AN mean in Excel?
AT1-AN1 means to subtract the contents of the cell AN1 from AT1, but I am not aware of any specific meaning of AT-AN in Excel.
What displays the current date on each page of an Excel worksheet use the function?
In a cell you can put:
=Today()
If you are talking about on printed pages, there are options to insert the date into the header and/or footer areas if you go into Page Setup before printing.
Click on Page Break View in the View section. This will display only what you plan to print and leave the rest of the worksheet background gray. You can drag the borders to any print range you like.
How do you export data from Notepad to Excel?
You can open a Notepad document direct in Excel. If it has been saved as a CSV file, then the data will come in separated into cells in Excel, where commas occur in the document. Each new line of data in the Notepad document will appear on a new row in Excel.
What happens when you press the Home button on an Excel worksheet?
You are brought to the first cell on the current row.
How do you automatically paste information from Excel to Word?
There is no automatic method for pasting data from Excel to Word.
- Open both Word and Excel.
- Go to Excel and highlight the cell range you want to paste to Word.
- Copy the range using the method you like.
- Go to Word and paste the contents at the location you want in Word.
- Clean up the location and formatting, as you like.
The best way to resize a column and row of the excel?
Go to Format (at top of page) then click on Row or Column, and Height or Width is first option on the list.
