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 data types can be input into Microsoft Excel 2000 Spreadsheets?
text and numbers formatted in a variety of ways
value axis
What is a spinner for Microsoft Excel?
A spinner is a form control that increases or decreases the amount in the cell linked to it. It is represented on your worksheet by an icon with both up and down arrowheads with a small line between the arrowheads. Holding down the mouse button on a spinner makes it change continuously. You add a spinner to your form by selecting the Spinner button on the Forms toolbar.
See related links for information about forms controls.
Which elements can be modified on a chart?
Almost everything, let's take the example of a bar graph, this is some of the things you can change:
1. The appearance of the bar.
2. Colors.
3. Labels.
4. Scales (in 100,1000...).
5. Background.
6. Grids.
And much more!
What are the functions of attenuator?
An attenuator decreases (attenuates) the level of the incident signal by a specified, sometimes adjustable amount.
Common uses for attenuators include limiting signal strength, buffering components, or adjusting power levels
Which items appear in the income statement column of the worksheet?
List of anything that produced income (e.g. selling goods, performing services, renting property), usually referred to as gross profit. You would list the amounts you actually received (minus discounts, returns, allowances, etc.).
What is a receiver cell in Microsoft Excel?
There is no specific term "receiver cell" associated with Excel. Within an individual spreadsheet a user may have cells which hold information about receivers of one kind or another, like a telephone receiver or audio receiver or data receiver, and they may enter something into it. This is like you could have an "Age cell" or a "country cell" or a "gender cell" to hold information about things relating to ages, countries or genders on a particular spreadsheet.
What you may be referring to is a cell that receives something that has been copied or cut. The proper term for that is a destination cell.
What is an external spreadsheet?
External means outside. An external spreadsheet is a spreadsheet that is not located in the spreadsheet file you have open at the moment.
Why do you freeze columns in datasheet?
Frequently you will have too many columns of data to appear on the screen at one time. If you start to scroll across, the first few columns will disappear from the screen. Usually the first few columns are the most important ones, so you want to keep them on the screen as you scroll across. Freezing columns allows you to do this.
Is there a way to see all formatting in an Excel document?
You can see the formatting in the displayed cells, because that is the purpose for formatting. However, if the cell is blank, you need to look at each cell to determine its format.
What position the insertion point at the last editing location?
The insertion point is directly after the last character you inserted.
What are the outputs of Excel?
The results of formulas that you type in are outputs in Excel. If you do filters, the results you get are outputs. Charts are an output. If you print anything from Excel, that is an output.
Why are the dollar signs necessary in the VLOOKUP?
They are not always necessary. If your formula is not going to be copied then you don't need them. If you are copying a formula using a VLOOKUP function, then the reference to the cells for your table will change and then your formula won't work, because it won't be looking at the correct cells for your table. If you use the dollar signs then the reference to the table will not change when the formula is copied and the function will work correctly. The dollars change them to absolute references, so they stay the same when copied. Without the dollars they are relative references and will change when the formula is copied.
They are not always necessary. If your formula is not going to be copied then you don't need them. If you are copying a formula using a VLOOKUP function, then the reference to the cells for your table will change and then your formula won't work, because it won't be looking at the correct cells for your table. If you use the dollar signs then the reference to the table will not change when the formula is copied and the function will work correctly. The dollars change them to absolute references, so they stay the same when copied. Without the dollars they are relative references and will change when the formula is copied.
They are not always necessary. If your formula is not going to be copied then you don't need them. If you are copying a formula using a VLOOKUP function, then the reference to the cells for your table will change and then your formula won't work, because it won't be looking at the correct cells for your table. If you use the dollar signs then the reference to the table will not change when the formula is copied and the function will work correctly. The dollars change them to absolute references, so they stay the same when copied. Without the dollars they are relative references and will change when the formula is copied.
They are not always necessary. If your formula is not going to be copied then you don't need them. If you are copying a formula using a VLOOKUP function, then the reference to the cells for your table will change and then your formula won't work, because it won't be looking at the correct cells for your table. If you use the dollar signs then the reference to the table will not change when the formula is copied and the function will work correctly. The dollars change them to absolute references, so they stay the same when copied. Without the dollars they are relative references and will change when the formula is copied.
They are not always necessary. If your formula is not going to be copied then you don't need them. If you are copying a formula using a VLOOKUP function, then the reference to the cells for your table will change and then your formula won't work, because it won't be looking at the correct cells for your table. If you use the dollar signs then the reference to the table will not change when the formula is copied and the function will work correctly. The dollars change them to absolute references, so they stay the same when copied. Without the dollars they are relative references and will change when the formula is copied.
They are not always necessary. If your formula is not going to be copied then you don't need them. If you are copying a formula using a VLOOKUP function, then the reference to the cells for your table will change and then your formula won't work, because it won't be looking at the correct cells for your table. If you use the dollar signs then the reference to the table will not change when the formula is copied and the function will work correctly. The dollars change them to absolute references, so they stay the same when copied. Without the dollars they are relative references and will change when the formula is copied.
They are not always necessary. If your formula is not going to be copied then you don't need them. If you are copying a formula using a VLOOKUP function, then the reference to the cells for your table will change and then your formula won't work, because it won't be looking at the correct cells for your table. If you use the dollar signs then the reference to the table will not change when the formula is copied and the function will work correctly. The dollars change them to absolute references, so they stay the same when copied. Without the dollars they are relative references and will change when the formula is copied.
They are not always necessary. If your formula is not going to be copied then you don't need them. If you are copying a formula using a VLOOKUP function, then the reference to the cells for your table will change and then your formula won't work, because it won't be looking at the correct cells for your table. If you use the dollar signs then the reference to the table will not change when the formula is copied and the function will work correctly. The dollars change them to absolute references, so they stay the same when copied. Without the dollars they are relative references and will change when the formula is copied.
They are not always necessary. If your formula is not going to be copied then you don't need them. If you are copying a formula using a VLOOKUP function, then the reference to the cells for your table will change and then your formula won't work, because it won't be looking at the correct cells for your table. If you use the dollar signs then the reference to the table will not change when the formula is copied and the function will work correctly. The dollars change them to absolute references, so they stay the same when copied. Without the dollars they are relative references and will change when the formula is copied.
They are not always necessary. If your formula is not going to be copied then you don't need them. If you are copying a formula using a VLOOKUP function, then the reference to the cells for your table will change and then your formula won't work, because it won't be looking at the correct cells for your table. If you use the dollar signs then the reference to the table will not change when the formula is copied and the function will work correctly. The dollars change them to absolute references, so they stay the same when copied. Without the dollars they are relative references and will change when the formula is copied.
They are not always necessary. If your formula is not going to be copied then you don't need them. If you are copying a formula using a VLOOKUP function, then the reference to the cells for your table will change and then your formula won't work, because it won't be looking at the correct cells for your table. If you use the dollar signs then the reference to the table will not change when the formula is copied and the function will work correctly. The dollars change them to absolute references, so they stay the same when copied. Without the dollars they are relative references and will change when the formula is copied.
MOS can refer to a Microsoft Office Specialist. It is an exam to test you on different Office applications, which can be done individually. So there is a MOS exam for Excel. You need a good knowledge of Excel to pass the exam. See the link below.
MOS can refer to a Microsoft Office Specialist. It is an exam to test you on different Office applications, which can be done individually. So there is a MOS exam for Excel. You need a good knowledge of Excel to pass the exam. See the link below.
MOS can refer to a Microsoft Office Specialist. It is an exam to test you on different Office applications, which can be done individually. So there is a MOS exam for Excel. You need a good knowledge of Excel to pass the exam. See the link below.
MOS can refer to a Microsoft Office Specialist. It is an exam to test you on different Office applications, which can be done individually. So there is a MOS exam for Excel. You need a good knowledge of Excel to pass the exam. See the link below.
MOS can refer to a Microsoft Office Specialist. It is an exam to test you on different Office applications, which can be done individually. So there is a MOS exam for Excel. You need a good knowledge of Excel to pass the exam. See the link below.
MOS can refer to a Microsoft Office Specialist. It is an exam to test you on different Office applications, which can be done individually. So there is a MOS exam for Excel. You need a good knowledge of Excel to pass the exam. See the link below.
MOS can refer to a Microsoft Office Specialist. It is an exam to test you on different Office applications, which can be done individually. So there is a MOS exam for Excel. You need a good knowledge of Excel to pass the exam. See the link below.
MOS can refer to a Microsoft Office Specialist. It is an exam to test you on different Office applications, which can be done individually. So there is a MOS exam for Excel. You need a good knowledge of Excel to pass the exam. See the link below.
MOS can refer to a Microsoft Office Specialist. It is an exam to test you on different Office applications, which can be done individually. So there is a MOS exam for Excel. You need a good knowledge of Excel to pass the exam. See the link below.
MOS can refer to a Microsoft Office Specialist. It is an exam to test you on different Office applications, which can be done individually. So there is a MOS exam for Excel. You need a good knowledge of Excel to pass the exam. See the link below.
MOS can refer to a Microsoft Office Specialist. It is an exam to test you on different Office applications, which can be done individually. So there is a MOS exam for Excel. You need a good knowledge of Excel to pass the exam. See the link below.
Why is there 65536 columns in Excel 2010 not showing 1048756 rows in Excel?
Excel 2010 has 1,048,576 rows. It relates to computers using binary. Many numbers are powers of 2 in computing. 65536 is 2 to the power of 16. In other words if you keep doubling up 2 you will come to 65536 as follows, like 2, 4, 8, 16 etc. Versions of Excel up to Excel 2003 had 65536 rows. All newer versions of Excel have even more rows, having 1,048,576. That is 2 to the power of 20.
Which function divides the sum total by the number of values?
To divide the sum of a data set by the number of values is called the "mean" function of the data set. It is called the AVERAGE function in Excel.
It is used to copy things ,like copying a formula or putting in the days of week or months of the year automatically ,or putting in a set of numbers with an equal gap between them.
Example -in cell A1type 5.in cellA2 type 10.now select both cells.click on the fill handle at the bottom corner of
A2,and press and hold the mouse button and drag down.you will see that numbers with the gap of 5 are filled.
What is B16 an example of in Excel?
B16 is a cell reference or address, referring to the cell where column B meets row 16.
What is the column and rows designators that identify each cell?
Columns are identified by letters. Rows are identified by numbers. A cell has an address made up by a column letter and row number. For example, cell D28 is in column D and row 28.
List 2 things you should NOT do when deleting data in Excel?
You should not delete data that is crucial to the working of the spreadsheet. You should not delete data that will interfere with how formulas work.
Why is it important to check external data file before importing them to a spreadsheet?
because its important
How do you merge cells in Excel?
Direct short cut is not available for Merge in Excel. Rather one can create his own Macro for merging operation else follow the below informations for your reference.
1. Select the cells which whom you want to merge
2. then press CTRL 1 and ALT M and ENTER
Functions of DFHI:
- To discount, re-discount purchase and sell Treasury bill, trade bill, bills of exchange, commercial bills and commercial papers.
- To play important role as a lender, borrower, or broker in the interbank call money market.
- To promote and support company funds, trusts and other organisations for the development of short-term money market.
- To advise government, banks and financial institutions in evolving schemes for growth and development of money market.
