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
There already is a shortcut to do that. Press and hold the Ctrl key and press the semi-colon key. That date won't change if you save it and open the worksheet on another day. If you need the date to be the current date on whatever day you open it, then use the TODAY() function, or else press Ctrl and the colon key every day.
What does a green arrow in the corner of an Excel cell mean?
A green arrow in the corner of an excel cell means that excel suspects soemthing may be wrong with the formula in a particular cell.
How many ways can you save an excel file?
· File -> Save
· File -> Save As
· [Ctrl] + Save
· Save button
· [Alt] + [F], [S]
· Create a macro to save a spreadsheet
· F12
· Close
If the condition is true does Excel apply the formatting?
It will if you are asking about conditional formatting.
What are the things that you can do using the formatting toolbar?
change font size and color basically
What is difference between Delete and Hide Column in Excel?
Delete completely gets rid of a column. Columns to the right of it all move over. So if you deleted column D, column E would become column D.
Hiding a column makes it disappear from view, but it is still part of the spreadsheet and can be hidden. If you hid column D, you would still see column C and to the right of it would be column E. You can still use cells in columns that are hidden in formulas.
What allows users to easily sort data in a spreadsheet?
Spreadsheets allow you to layout data in columns. Once you have your data entered, you can select it and sort it using the built-in sorting facility that all spreadsheet applications have. It is an important aspect of spreadsheets, so all of them have ways of doing everything from simple to much more complex sorting or your data.
Is all format of MS Office data files the same?
No, each software contains its own extension (i.e. format) like Ms Word will have '.doc' or '.docx', .xls for Ms Excel, .ppt, .pps for PowerPoint template and PowerPoint slideshow.....
Will MS Excel will it create memos?
Excel is not generally used for creating memos, but you could use it to do so. You are more likely to use a word processor, like Microsoft Word.
Autofilled.
What is the answer to Annie apples amazing adventure worksheet?
ANNIE APPLE'S AMAZING
ADVENTURE
1. mechanical digestion
2. saliva
3. esophagus
4. stomach
5. chyme
6. small intestine
7. bile
8. large intestine
9. anus
10. kidney
11. nephrons
12. ureter
13. urinary bladder
14. urethra
How do you calculate range in maths in Excel?
The range is the difference between the highest and the lowest values. You can find the highest using the MAX function less the value found by the MIN function. So if you wanted to get the mathematical range for the cell range A2 to A30, you would do this:
=MAX(A2:A30) - MIN(A2:A30)
What function key will change a cell reference formula value to an absolute value in Excel 2010?
The F4 key can be used as you are typing in the cell reference in order to change it to a different reference type.
the main problem with 'tally' (also known as the 'Gate' system because of it's likeness to a 5-bar gate) is that you tick or enter the values in one spot (or cell) the 5th being the diagonal 'cross' to signify that this set is complete and to start a new 'tally' or set, the total of tallys (counted in 5's) then shows the number of items present. The method is ideal for counting (say) sheep wandering past, or boxes being loaded. It is also useful for tally of more than one type, black sheep and white sheep, red boxes and green boxes etc, thus more than one 'tally' or set may be in progress at a time.
To tally in Excel using a single cell as the 'tally' one must remember that the nature of an Excel cell is that when you enter the second '1' the first is overwritten (that is, assuming you are not retaining the input until 5 '1's are pressed and then pressing ) When the third '1' is pressed then the previous contents are lost etc.
As the main purpose of 'tally' is to make totalling easier it would seem a waste to expend the effort to install and maintain a tally system, this would involve VB code to capture entry into a cell (the current tally), count up to 5 '1's and represent that as a 1111 with a diagonal (bottom left to top right) border, then bar any further entry to that cell until the tally were completed and cleared.
A Spin button, to increment a cell, or a Button which counted +1 to a cell would keep a count, and would require only one cell for it's task (the tally would require one cell for each 5 counted to emulate the manual system)
Alternately the Spin button or Button could set the tally, but that again might require a column (or row) of cells to maintain the tally (symbol) count. If anyone planning to do tally course or excel course i can suggest you one institute which is located both in delhi and noida. It is one of the best institute. Their trainers are well experienced and explain the topic in depth with good anmount of examples. I have also done my solidworks training from here and i really had a great experience over here. so, I highly recommend this institute to everyone.
What Excel commands is accomplished by double-clicking a column's border to set its width?
Best fit.
Best fit.
Best fit.
Best fit.
Best fit.
Best fit.
Best fit.
Best fit.
Best fit.
Best fit.
Best fit.
What is the cell reference of the cell containing a heading?
The top row of the sheet is row 1 and the first column is column A. Where you see the actual row numbers, above row 1, and the column headings, to the left of column A are not cells, so they do not have cell references. So if that is what you are referring to then there is no reference for them.
For your data itself you can type in headings into cells like "Sales" or "Wages" or whatever, but those headings are in actual cells. So the references of those are wherever they are actually typed.
The top row of the sheet is row 1 and the first column is column A. Where you see the actual row numbers, above row 1, and the column headings, to the left of column A are not cells, so they do not have cell references. So if that is what you are referring to then there is no reference for them.
For your data itself you can type in headings into cells like "Sales" or "Wages" or whatever, but those headings are in actual cells. So the references of those are wherever they are actually typed.
The top row of the sheet is row 1 and the first column is column A. Where you see the actual row numbers, above row 1, and the column headings, to the left of column A are not cells, so they do not have cell references. So if that is what you are referring to then there is no reference for them.
For your data itself you can type in headings into cells like "Sales" or "Wages" or whatever, but those headings are in actual cells. So the references of those are wherever they are actually typed.
The top row of the sheet is row 1 and the first column is column A. Where you see the actual row numbers, above row 1, and the column headings, to the left of column A are not cells, so they do not have cell references. So if that is what you are referring to then there is no reference for them.
For your data itself you can type in headings into cells like "Sales" or "Wages" or whatever, but those headings are in actual cells. So the references of those are wherever they are actually typed.
The top row of the sheet is row 1 and the first column is column A. Where you see the actual row numbers, above row 1, and the column headings, to the left of column A are not cells, so they do not have cell references. So if that is what you are referring to then there is no reference for them.
For your data itself you can type in headings into cells like "Sales" or "Wages" or whatever, but those headings are in actual cells. So the references of those are wherever they are actually typed.
The top row of the sheet is row 1 and the first column is column A. Where you see the actual row numbers, above row 1, and the column headings, to the left of column A are not cells, so they do not have cell references. So if that is what you are referring to then there is no reference for them.
For your data itself you can type in headings into cells like "Sales" or "Wages" or whatever, but those headings are in actual cells. So the references of those are wherever they are actually typed.
The top row of the sheet is row 1 and the first column is column A. Where you see the actual row numbers, above row 1, and the column headings, to the left of column A are not cells, so they do not have cell references. So if that is what you are referring to then there is no reference for them.
For your data itself you can type in headings into cells like "Sales" or "Wages" or whatever, but those headings are in actual cells. So the references of those are wherever they are actually typed.
The top row of the sheet is row 1 and the first column is column A. Where you see the actual row numbers, above row 1, and the column headings, to the left of column A are not cells, so they do not have cell references. So if that is what you are referring to then there is no reference for them.
For your data itself you can type in headings into cells like "Sales" or "Wages" or whatever, but those headings are in actual cells. So the references of those are wherever they are actually typed.
The top row of the sheet is row 1 and the first column is column A. Where you see the actual row numbers, above row 1, and the column headings, to the left of column A are not cells, so they do not have cell references. So if that is what you are referring to then there is no reference for them.
For your data itself you can type in headings into cells like "Sales" or "Wages" or whatever, but those headings are in actual cells. So the references of those are wherever they are actually typed.
The top row of the sheet is row 1 and the first column is column A. Where you see the actual row numbers, above row 1, and the column headings, to the left of column A are not cells, so they do not have cell references. So if that is what you are referring to then there is no reference for them.
For your data itself you can type in headings into cells like "Sales" or "Wages" or whatever, but those headings are in actual cells. So the references of those are wherever they are actually typed.
The top row of the sheet is row 1 and the first column is column A. Where you see the actual row numbers, above row 1, and the column headings, to the left of column A are not cells, so they do not have cell references. So if that is what you are referring to then there is no reference for them.
For your data itself you can type in headings into cells like "Sales" or "Wages" or whatever, but those headings are in actual cells. So the references of those are wherever they are actually typed.
You use formulas rather than actual numeric values. Logical values are usually generated from formulas, so they are rarely typed in literally, so you would type formulas in instead of them, with cell references in those formulas, and possibly some values.
If power faild where the running excel file is save?
It will be saved up to the last point that you saved it at or when an autosave was done. You may be able to recover the file, but you will have probably lost some of the most recent work. Always save your files regularly.
What fields are in a doctors database?
Whatever the doctor want to track. There are too many thousands of options to try to list anything meaninful here. The database would need to contain patient information and medical history items.
When Excel follows the order of operations the formula 83 plus 2 equals?
83 + 2 = 85 (Excel formula: =83+2)
What does the formula b3d7 mean in Excel?
That is not a formula. Formulas must start with an equals sign, have an operation like a plus or minus etc., in it or have a function. So it could be something like this, which adds the content of cell b3 and d7 together:
=b3+d7
If you replace the plus with another sign, you could do other kinds of calculations. If you were adding all cells in the range from b3 to d7, you could use the SUM function like this:
=SUM(b3:d7)
Lots of other functions, such as AVERAGE or COUNT or MAX could also use the same structure, so for example:
=AVERAGE(b3:d7)
Which Excel feature would allow you to change the font and color of a cell based on its value?
Conditional Formatting.
How multiple worksheets can be connected?
Using the sheetname, followed by an exclamation mark followed by a cell reference, you can refer to any cell on any sheet from any other sheet. So if you had something in cell C5 on Sheet1 then on Sheet2 you could type the following in order to show that value in any cell on Sheet2.
=Sheet1!C5
You can do things like sum the same cell on each individual sheet into a single total. The following sums the cell A9 on each of Sheet1, Sheet2 and Sheet3 together.
=SUM(Sheet1:Sheet3!A9)
Using the sheetname, followed by an exclamation mark followed by a cell reference, you can refer to any cell on any sheet from any other sheet. So if you had something in cell C5 on Sheet1 then on Sheet2 you could type the following in order to show that value in any cell on Sheet2.
=Sheet1!C5
You can do things like sum the same cell on each individual sheet into a single total. The following sums the cell A9 on each of Sheet1, Sheet2 and Sheet3 together.
=SUM(Sheet1:Sheet3!A9)
Using the sheetname, followed by an exclamation mark followed by a cell reference, you can refer to any cell on any sheet from any other sheet. So if you had something in cell C5 on Sheet1 then on Sheet2 you could type the following in order to show that value in any cell on Sheet2.
=Sheet1!C5
You can do things like sum the same cell on each individual sheet into a single total. The following sums the cell A9 on each of Sheet1, Sheet2 and Sheet3 together.
=SUM(Sheet1:Sheet3!A9)
Using the sheetname, followed by an exclamation mark followed by a cell reference, you can refer to any cell on any sheet from any other sheet. So if you had something in cell C5 on Sheet1 then on Sheet2 you could type the following in order to show that value in any cell on Sheet2.
=Sheet1!C5
You can do things like sum the same cell on each individual sheet into a single total. The following sums the cell A9 on each of Sheet1, Sheet2 and Sheet3 together.
=SUM(Sheet1:Sheet3!A9)
Using the sheetname, followed by an exclamation mark followed by a cell reference, you can refer to any cell on any sheet from any other sheet. So if you had something in cell C5 on Sheet1 then on Sheet2 you could type the following in order to show that value in any cell on Sheet2.
=Sheet1!C5
You can do things like sum the same cell on each individual sheet into a single total. The following sums the cell A9 on each of Sheet1, Sheet2 and Sheet3 together.
=SUM(Sheet1:Sheet3!A9)
Using the sheetname, followed by an exclamation mark followed by a cell reference, you can refer to any cell on any sheet from any other sheet. So if you had something in cell C5 on Sheet1 then on Sheet2 you could type the following in order to show that value in any cell on Sheet2.
=Sheet1!C5
You can do things like sum the same cell on each individual sheet into a single total. The following sums the cell A9 on each of Sheet1, Sheet2 and Sheet3 together.
=SUM(Sheet1:Sheet3!A9)
Using the sheetname, followed by an exclamation mark followed by a cell reference, you can refer to any cell on any sheet from any other sheet. So if you had something in cell C5 on Sheet1 then on Sheet2 you could type the following in order to show that value in any cell on Sheet2.
=Sheet1!C5
You can do things like sum the same cell on each individual sheet into a single total. The following sums the cell A9 on each of Sheet1, Sheet2 and Sheet3 together.
=SUM(Sheet1:Sheet3!A9)
Using the sheetname, followed by an exclamation mark followed by a cell reference, you can refer to any cell on any sheet from any other sheet. So if you had something in cell C5 on Sheet1 then on Sheet2 you could type the following in order to show that value in any cell on Sheet2.
=Sheet1!C5
You can do things like sum the same cell on each individual sheet into a single total. The following sums the cell A9 on each of Sheet1, Sheet2 and Sheet3 together.
=SUM(Sheet1:Sheet3!A9)
Using the sheetname, followed by an exclamation mark followed by a cell reference, you can refer to any cell on any sheet from any other sheet. So if you had something in cell C5 on Sheet1 then on Sheet2 you could type the following in order to show that value in any cell on Sheet2.
=Sheet1!C5
You can do things like sum the same cell on each individual sheet into a single total. The following sums the cell A9 on each of Sheet1, Sheet2 and Sheet3 together.
=SUM(Sheet1:Sheet3!A9)
Using the sheetname, followed by an exclamation mark followed by a cell reference, you can refer to any cell on any sheet from any other sheet. So if you had something in cell C5 on Sheet1 then on Sheet2 you could type the following in order to show that value in any cell on Sheet2.
=Sheet1!C5
You can do things like sum the same cell on each individual sheet into a single total. The following sums the cell A9 on each of Sheet1, Sheet2 and Sheet3 together.
=SUM(Sheet1:Sheet3!A9)
Using the sheetname, followed by an exclamation mark followed by a cell reference, you can refer to any cell on any sheet from any other sheet. So if you had something in cell C5 on Sheet1 then on Sheet2 you could type the following in order to show that value in any cell on Sheet2.
=Sheet1!C5
You can do things like sum the same cell on each individual sheet into a single total. The following sums the cell A9 on each of Sheet1, Sheet2 and Sheet3 together.
=SUM(Sheet1:Sheet3!A9)
