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 advantages are there to using Microsoft Excel?
You can easily do calculations without having to do them by hand.
It is widely used so your work is compatible with what other users may be using.
It is very versatile, so it gives a huge range of features.
With a little training, you can use it; with lots of training you can do a lot more.
How do you remove contents of selected cells so they are saved to the clipboard?
Select the cell and press the Del key.
That will depend on what the error is. Different problems result in a formula not being able to calculate. The appropriate error message for the situation will be displayed. Here are error messages you will see:
#REF!
#DIV/0!
#NAME?
#NULL!
#N/A!
#NUM!
#VALUE!
Where is a chart displayed in Excel?
A chart can be displayed on a sheet, in which case it is known as an embedded chart, or on a sheet of its own, known as a chart sheet.
A chart can be displayed on a sheet, in which case it is known as an embedded chart, or on a sheet of its own, known as a chart sheet.
A chart can be displayed on a sheet, in which case it is known as an embedded chart, or on a sheet of its own, known as a chart sheet.
A chart can be displayed on a sheet, in which case it is known as an embedded chart, or on a sheet of its own, known as a chart sheet.
A chart can be displayed on a sheet, in which case it is known as an embedded chart, or on a sheet of its own, known as a chart sheet.
A chart can be displayed on a sheet, in which case it is known as an embedded chart, or on a sheet of its own, known as a chart sheet.
A chart can be displayed on a sheet, in which case it is known as an embedded chart, or on a sheet of its own, known as a chart sheet.
A chart can be displayed on a sheet, in which case it is known as an embedded chart, or on a sheet of its own, known as a chart sheet.
A chart can be displayed on a sheet, in which case it is known as an embedded chart, or on a sheet of its own, known as a chart sheet.
A chart can be displayed on a sheet, in which case it is known as an embedded chart, or on a sheet of its own, known as a chart sheet.
A chart can be displayed on a sheet, in which case it is known as an embedded chart, or on a sheet of its own, known as a chart sheet.
What is the default name for the first worksheet in a workbook?
Normal View is the default view for a worksheet.
Normal View is the default view for a worksheet.
Normal View is the default view for a worksheet.
Normal View is the default view for a worksheet.
Normal View is the default view for a worksheet.
Normal View is the default view for a worksheet.
Normal View is the default view for a worksheet.
Normal View is the default view for a worksheet.
Normal View is the default view for a worksheet.
Normal View is the default view for a worksheet.
Normal View is the default view for a worksheet.
What are the short cut keys for saving a workbook?
Key Alone Shift Ctrl Alt Shift Ctrl F1 Help What's This Help Insert Chart Sheet F2 Edit Mode Edit Comment Save As F3 Paste Name Formula Paste Function Define Name Names From Labels F4 Repeat Action Find Again Close Window Quit Excel F5 Goto Find Restore Window Size
F6 Next Pane Prev Pane Next Workbook Switch To VBA Prev Workbook F7 Spell Check Move Window F8 Extend Selection Add To Selection Resize Window Macro List F9 Calculate All Calculate Worksheet Minimize Workbook F10 Activate Menu Context Menu Restore Workbook
F11 New Chart New Worksheet New Macro Sheet VB Editor F12 Save As Save Open
Print A Select All Formula Arguments B Bold C Copy D
Fill Down Data Menu E
Edit Menu F
Find File Menu Font Name G Goto H Replace Help Menu I Italics Insert Menu J
K
Insert Hyperlink
L
M N New Workbook O Open Workbook Format Menu Select Comments P
Font Size Q
R
Fill Right
S Save T Tools Menu U Underline V
Paste
W
Close Workbook Window Menu X
Cut
Y Repeat Active Z Undo ` (~) Toggle Formula View General Format 1 (!)
Cell Format
Number Format 2 (@)
Toggle Bold
Time Format 3 (#)
Toggle Italics
Date Format 4 ($) Toggle Underline Currency Format 5 (%) Toggle Strikethru Percent Format 6 (^) a Exponent Format 7 (&)
a
Apply Border 8 (*)
Outline
Select Region 9 (()
Hide Rows
Unhide Rows 0 ()) Hide Columns Unhide Columns - Delete Selection Control Menu No Border = (+) Formula Auto Sum Insert dialog [
Direct Dependents
Direct Precedents ]
All Dependents
All Precedents ; (semicolon)
Insert Date Select Visible Cells Insert Time ' (apostrophe) Style Copy Cell Value Above : (colon) Insert Time / Select Array Select Array \
Select Differences
Select Unequal Cells Insert Insert Mode
Copy
Delete Clear
Delete To End Of Line
Home Begin Row Start Of Worksheet End End Row End Of Worksheet Page Up Page Up Previous Worksheet Left 1 screen Page Down Page Down
Next Worksheet Right 1 screen Left Arrow Move Left Select Left Move Left Area
Right Arrow Move Right Select Right Move Right Area
Up Arrow Move Up Select Up Move Up Area Down Arrow Move Down Select Down Move Down Area Drop down list Space Bar Space Select Row Select Column Control Box Select All Tab Move Right Move Left Next Window Next Application Previous Window BackSpace Goto Active Cell
What are built in functions in a spreadsheet application?
Excel has many dozens of functions. An example of some of the functions are:
IF
ISERR
LEFT
LEN
LOOKUP
RIGHT
SUM
SUMIF
Functions allways begin with the equal sign. An example of a function is =SUM(A1:A13).
See related links for a list of Excel functions.
The labels and data under them could be referred to as a table.
They need to be able to calculate profits and forecast how well they think the business will do during the next year.
They also need to calculate the wages of all the staff each month.
Teachers
Teachers can use spreadsheets to keep track of marks given for homework and recording exam results and also for registers.
EngineersEngineers need to perform thousands of calculations when designing bridges, buildings, aeroplanes, cars etc.They need to make sure that bridges will be able to support themselves and will not collapse under the weight of traffic or the force of strong winds. They need to work out how deep the foundations of a house need to be in order to support the walls and roof. They need to make sure that the aerodynamics of a plane will enable it to take off and fly.
Sales peopleSales people use spreadsheets to keep track of the items they sell, the value of the items, the profit made on each item and more importantly, the commission they have earned! ScientistsScientists need to be able to keep track of their results from experiments.They use spreadsheets to help them to analyse what happened with the experiment and also to predict what might happen if they were to change one variable.
SupermarketsSupermarkets use spreadsheets to keep track of finances i.e. sales, losses and money spent.They also use spreadsheets to work out queuing times and what are the best number of checkouts to have open at any one time during the day.
Market researchersMarket researchers collect data from shoppers about their spending habits and their awareness of different brands. All of this data has to be collated and analysed in order to provide the company with a detailed report of what customers think about their products.accountants
teachers
engineers
landlords
Just about anyone can find a use for spreadsheets. See related questions for some ideas how you can use a spreadsheet.
All major companies and a lot of smaller ones do use spreadsheets.
It is useful in budgets, accounting, graphing and a lot of clerical work.
accountant
People from almost all occupations and vocations can benefit from using spreadsheets. See related questions for some ideas how people use spreadsheets.
Microsoft Excel is used to create spreadsheets. You can use it to create sheets such as budgets. It's made up of columns and rows that allow you to calculate totals using formulas.
Why legend identifies each data series in a chart?
Charts have various parts depending on the type of the chart, so to determine the slice in a pie chart or a line in a line chart or a bar in a bar chart, you need a legend that shows the colours and styles, so you know which thing is which.
Charts have various parts depending on the type of the chart, so to determine the slice in a pie chart or a line in a line chart or a bar in a bar chart, you need a legend that shows the colours and styles, so you know which thing is which.
Charts have various parts depending on the type of the chart, so to determine the slice in a pie chart or a line in a line chart or a bar in a bar chart, you need a legend that shows the colours and styles, so you know which thing is which.
Charts have various parts depending on the type of the chart, so to determine the slice in a pie chart or a line in a line chart or a bar in a bar chart, you need a legend that shows the colours and styles, so you know which thing is which.
Charts have various parts depending on the type of the chart, so to determine the slice in a pie chart or a line in a line chart or a bar in a bar chart, you need a legend that shows the colours and styles, so you know which thing is which.
Charts have various parts depending on the type of the chart, so to determine the slice in a pie chart or a line in a line chart or a bar in a bar chart, you need a legend that shows the colours and styles, so you know which thing is which.
Charts have various parts depending on the type of the chart, so to determine the slice in a pie chart or a line in a line chart or a bar in a bar chart, you need a legend that shows the colours and styles, so you know which thing is which.
Charts have various parts depending on the type of the chart, so to determine the slice in a pie chart or a line in a line chart or a bar in a bar chart, you need a legend that shows the colours and styles, so you know which thing is which.
Charts have various parts depending on the type of the chart, so to determine the slice in a pie chart or a line in a line chart or a bar in a bar chart, you need a legend that shows the colours and styles, so you know which thing is which.
Charts have various parts depending on the type of the chart, so to determine the slice in a pie chart or a line in a line chart or a bar in a bar chart, you need a legend that shows the colours and styles, so you know which thing is which.
Charts have various parts depending on the type of the chart, so to determine the slice in a pie chart or a line in a line chart or a bar in a bar chart, you need a legend that shows the colours and styles, so you know which thing is which.
What are columns in Excel ordinarily labeled with?
Columns are labelled using letters. First they go from A to Z, the AA, AB, AC and so on until AZ and then BA, BB, BC and so on.
What do we call a calculation that involves more than one or more mathematical operators?
A formula or an expression.
How do you convert horizontal data to vertical format in Excel?
Copy the table. Go to a clear part of the worksheet. Then go to Paste Special and click Transpose and then OK. You can also use the TRANSPOSE function.
left mouse click on the tab that you want to rename (this is called setting the focus).
Then
Right mouse click on it and a small menu appears - left mouse click on the RENAME option and the tab will trun from white background and black text to black background and white text. Type in the name you wish the worksheet to be called then left mouse click on the work sheet anywhere to keep that name in the tab
What is the equivalent function to antilog in Excel?
Excel has no AntiLog function. However, it's just a simple calculation:-
Assuming base 10, the antilog of x is 10^x. 10^x = z is the same as LOG(z) = x
e.g.
LOG10(100) = 2
or
LOG(100,10) = 2
The antilog of 2 is 10^2 = 100
If the 2 was in the cell A5, then the formula could be:
=10^A5
What is a range of cells containing values for variables used in formulas in Excel?
It can simply be a range. It could also be an array. It will depend on the formula itself.
Rows run vertically or across your screen in a spreadsheet, with the row number on the left at the beginning of the row.
What is the most useful function in Excel?
There is no simple answer to that question. Excel has hundreds of functions. Some are used very frequently, like the the SUM function, so that could be the most useful. Then there are others that are very powerful, like the IF function, which enables Excel to make decisions. It is very useful. A lot of users have specialised areas that they work in, so they might make use of functions in a particular category, like the financial functions. For those users, functions in those categories might be very useful. A lot of formulas have a combination of functions, and lots of functions work together with other ones. So it is very hard to pick a single function and say it is the most useful, as there are lots of opinions.
Can you import data from the web to excel?
There are lots of ways of doing it and some websites give you special ways to do it so as to keep dynamic data up to date, such as changing share prices. It really depends on what it is you are trying to import and where it is coming from.
How do you type in numbers in a chart in Excel?
That depends on what you mean. You can type numbers into the titles. You can type numbers into a text box that you create yourself. You can show the values for what is on the chart by adding Data Labels in the Chart Options.
That depends on what you mean. You can type numbers into the titles. You can type numbers into a text box that you create yourself. You can show the values for what is on the chart by adding Data Labels in the Chart Options.
That depends on what you mean. You can type numbers into the titles. You can type numbers into a text box that you create yourself. You can show the values for what is on the chart by adding Data Labels in the Chart Options.
That depends on what you mean. You can type numbers into the titles. You can type numbers into a text box that you create yourself. You can show the values for what is on the chart by adding Data Labels in the Chart Options.
That depends on what you mean. You can type numbers into the titles. You can type numbers into a text box that you create yourself. You can show the values for what is on the chart by adding Data Labels in the Chart Options.
That depends on what you mean. You can type numbers into the titles. You can type numbers into a text box that you create yourself. You can show the values for what is on the chart by adding Data Labels in the Chart Options.
That depends on what you mean. You can type numbers into the titles. You can type numbers into a text box that you create yourself. You can show the values for what is on the chart by adding Data Labels in the Chart Options.
That depends on what you mean. You can type numbers into the titles. You can type numbers into a text box that you create yourself. You can show the values for what is on the chart by adding Data Labels in the Chart Options.
That depends on what you mean. You can type numbers into the titles. You can type numbers into a text box that you create yourself. You can show the values for what is on the chart by adding Data Labels in the Chart Options.
That depends on what you mean. You can type numbers into the titles. You can type numbers into a text box that you create yourself. You can show the values for what is on the chart by adding Data Labels in the Chart Options.
That depends on what you mean. You can type numbers into the titles. You can type numbers into a text box that you create yourself. You can show the values for what is on the chart by adding Data Labels in the Chart Options.
Can excel spreadsheet be used as the data source for a word mail merge?
Yes it can be, as long as the data has been laid out properly, with the field headings in the first row and the data in the columns below that.
How do you convert a formula to zero if negative in Excel?
You could use an IF function like this, where the number you want to possibly round is in cell A2 and the formula is in another cell. It basically says if the value is less than zero then make it zero or else use the value that it already is.
=IF(A2<0,0,A2)
You could use an IF function like this, where the number you want to possibly round is in cell A2 and the formula is in another cell. It basically says if the value is less than zero then make it zero or else use the value that it already is.
=IF(A2<0,0,A2)
You could use an IF function like this, where the number you want to possibly round is in cell A2 and the formula is in another cell. It basically says if the value is less than zero then make it zero or else use the value that it already is.
=IF(A2<0,0,A2)
You could use an IF function like this, where the number you want to possibly round is in cell A2 and the formula is in another cell. It basically says if the value is less than zero then make it zero or else use the value that it already is.
=IF(A2<0,0,A2)
You could use an IF function like this, where the number you want to possibly round is in cell A2 and the formula is in another cell. It basically says if the value is less than zero then make it zero or else use the value that it already is.
=IF(A2<0,0,A2)
You could use an IF function like this, where the number you want to possibly round is in cell A2 and the formula is in another cell. It basically says if the value is less than zero then make it zero or else use the value that it already is.
=IF(A2<0,0,A2)
You could use an IF function like this, where the number you want to possibly round is in cell A2 and the formula is in another cell. It basically says if the value is less than zero then make it zero or else use the value that it already is.
=IF(A2<0,0,A2)
You could use an IF function like this, where the number you want to possibly round is in cell A2 and the formula is in another cell. It basically says if the value is less than zero then make it zero or else use the value that it already is.
=IF(A2<0,0,A2)
You could use an IF function like this, where the number you want to possibly round is in cell A2 and the formula is in another cell. It basically says if the value is less than zero then make it zero or else use the value that it already is.
=IF(A2<0,0,A2)
You could use an IF function like this, where the number you want to possibly round is in cell A2 and the formula is in another cell. It basically says if the value is less than zero then make it zero or else use the value that it already is.
=IF(A2<0,0,A2)
You could use an IF function like this, where the number you want to possibly round is in cell A2 and the formula is in another cell. It basically says if the value is less than zero then make it zero or else use the value that it already is.
=IF(A2<0,0,A2)
What does the AVERAGE function find in Excel?
There are a few ways. It is a Statistical function, so it is in that group of functions. You could also click on the Autosum button and choose Average from it. You can just type it in rather than having to look for it.
