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 is the difference between pre-defined formulas and user-generated formulas?
Pre-defined comes built in as a function. [=SUM(A1:A12]
User-generated is created by the user. [=A1+A2]
What the purpose of autocalculate in excel?
Any time a value is changed in a spreadsheet, it automatically recalculates the entire worksheet. This keeps it up to date for the values that are now in the worksheet. A worksheet can have many formulas. Changing one value can affect many of those formulas, so it is important that they do recalculate when changes are made.
What function would you use to calculate today's current date?
That depends, based on what information you want to calculate it.
What is the purpose of your formula tab in Microsoft Excel?
The formulas tab brings together many of the common things used in working with formulas, like functions, names and auditing formulas.
What are data and formulas keyed in fields?
It can be a record, when a set of related data is entered together. Formulas will calculated new data and are usually known as calculated fields.
What kind of formula in Excel is J1H4?
J1 is a reference to cell J1
H4 is a refernce to cell H4
J1H4 is an incorrect reference and is not understood by Excel.
The Status Bar is the area at the bottom of the Excel screen that shows the Zoom level, the viewing mode, and the current mode.
How do you find RevPar in Excel?
You can find an easy RevPAR calculator in Excel at http://www.revparguru.com/REVPAR-Calculator.html. This easy to use excel spreadsheet allows you to calculate automatically your hotel RevPAR by entering occupancy and ADR in the fields provided. Additionally this excel spreadsheet allows you calculate automatically your hotel ADR or occupancy by entering values in the fields provided. You can download it for free at http://www.revparguru.com/REVPAR-Calculator.html. There are also some great videos and demos on how to increase RevPAR for hotels. Bruno
What does Excel use to automatically to modify values?
Formulas will change their results as other things change in a spreadsheet.
Which is the correct process for adding page numbers to a spreadsheet you will print?
Click View and then Header and Footer. Choose the option to enter page numbers in the Header or Footer box.
Why would you save a file in standard file format?
A file saved/exported in Standard format can be viewed on Standard media players, whereas files still in project form cannot.
What is the definition Point Mode for Excel 2007?
In Excel it allows you to enter formulas using the mouse, by clicking on cells as you type a formula, instead on typing the cell references.
The defaults work sheet tabs in Excel is 3?
Yes, if you set it to 3 in the preferences. On a Mac, under the heading "Excel", select "Preferences". Select "General". There, you can set the number of sheets to be in a new workbook.
Is right alignment the default text in Excel?
No. By default, text is left aligned in Excel.
No. By default, text is left aligned in Excel.
No. By default, text is left aligned in Excel.
No. By default, text is left aligned in Excel.
No. By default, text is left aligned in Excel.
No. By default, text is left aligned in Excel.
No. By default, text is left aligned in Excel.
No. By default, text is left aligned in Excel.
No. By default, text is left aligned in Excel.
No. By default, text is left aligned in Excel.
No. By default, text is left aligned in Excel.
What does the cancel box do in Excel?
It stops you doing something, like when you are entering or editing a formula and you want to stop. It only appears when you start to enter something into a cell.
Which structure would a bateriophage use to attach itself to the outside of a bacterial cell?
The general structure of a bacteriophage includes a head, tail sheath, and tail fiber. It uses its tail fibers to bind to a receptor site of a bacteria cell.
How much does the 2013 VA compensation chart?
The United States Department of Veterans Affairs publishes Veterans Compensation Benefits Rate Tables. The most recent online version dates from December 1, 2012. These tables explain how much personnell of various service levels, in various situations, are elegible for.
Why doesn't excel consider dates a text string?
Because a date is a number. It can be displayed with words for the month and day of the week, but a date is a number. It also means calculations can be done with dates, like finding out how many days are between two dates or by adding an amount of days to a date or taking away an amount of days from a date. If they were actually text, then those things could not be done. It would also sort dates alphabetically, which would mean dates would be in the wrong order. All dates starting with the digit 1 would come before anything starting with the digit 2, which means a date like 12/2/10 would come before 2/2/10. So there are lots of reasons why dates are numbers and not text.
Because a date is a number. It can be displayed with words for the month and day of the week, but a date is a number. It also means calculations can be done with dates, like finding out how many days are between two dates or by adding an amount of days to a date or taking away an amount of days from a date. If they were actually text, then those things could not be done. It would also sort dates alphabetically, which would mean dates would be in the wrong order. All dates starting with the digit 1 would come before anything starting with the digit 2, which means a date like 12/2/10 would come before 2/2/10. So there are lots of reasons why dates are numbers and not text.
Because a date is a number. It can be displayed with words for the month and day of the week, but a date is a number. It also means calculations can be done with dates, like finding out how many days are between two dates or by adding an amount of days to a date or taking away an amount of days from a date. If they were actually text, then those things could not be done. It would also sort dates alphabetically, which would mean dates would be in the wrong order. All dates starting with the digit 1 would come before anything starting with the digit 2, which means a date like 12/2/10 would come before 2/2/10. So there are lots of reasons why dates are numbers and not text.
Because a date is a number. It can be displayed with words for the month and day of the week, but a date is a number. It also means calculations can be done with dates, like finding out how many days are between two dates or by adding an amount of days to a date or taking away an amount of days from a date. If they were actually text, then those things could not be done. It would also sort dates alphabetically, which would mean dates would be in the wrong order. All dates starting with the digit 1 would come before anything starting with the digit 2, which means a date like 12/2/10 would come before 2/2/10. So there are lots of reasons why dates are numbers and not text.
Because a date is a number. It can be displayed with words for the month and day of the week, but a date is a number. It also means calculations can be done with dates, like finding out how many days are between two dates or by adding an amount of days to a date or taking away an amount of days from a date. If they were actually text, then those things could not be done. It would also sort dates alphabetically, which would mean dates would be in the wrong order. All dates starting with the digit 1 would come before anything starting with the digit 2, which means a date like 12/2/10 would come before 2/2/10. So there are lots of reasons why dates are numbers and not text.
Because a date is a number. It can be displayed with words for the month and day of the week, but a date is a number. It also means calculations can be done with dates, like finding out how many days are between two dates or by adding an amount of days to a date or taking away an amount of days from a date. If they were actually text, then those things could not be done. It would also sort dates alphabetically, which would mean dates would be in the wrong order. All dates starting with the digit 1 would come before anything starting with the digit 2, which means a date like 12/2/10 would come before 2/2/10. So there are lots of reasons why dates are numbers and not text.
Because a date is a number. It can be displayed with words for the month and day of the week, but a date is a number. It also means calculations can be done with dates, like finding out how many days are between two dates or by adding an amount of days to a date or taking away an amount of days from a date. If they were actually text, then those things could not be done. It would also sort dates alphabetically, which would mean dates would be in the wrong order. All dates starting with the digit 1 would come before anything starting with the digit 2, which means a date like 12/2/10 would come before 2/2/10. So there are lots of reasons why dates are numbers and not text.
Because a date is a number. It can be displayed with words for the month and day of the week, but a date is a number. It also means calculations can be done with dates, like finding out how many days are between two dates or by adding an amount of days to a date or taking away an amount of days from a date. If they were actually text, then those things could not be done. It would also sort dates alphabetically, which would mean dates would be in the wrong order. All dates starting with the digit 1 would come before anything starting with the digit 2, which means a date like 12/2/10 would come before 2/2/10. So there are lots of reasons why dates are numbers and not text.
Because a date is a number. It can be displayed with words for the month and day of the week, but a date is a number. It also means calculations can be done with dates, like finding out how many days are between two dates or by adding an amount of days to a date or taking away an amount of days from a date. If they were actually text, then those things could not be done. It would also sort dates alphabetically, which would mean dates would be in the wrong order. All dates starting with the digit 1 would come before anything starting with the digit 2, which means a date like 12/2/10 would come before 2/2/10. So there are lots of reasons why dates are numbers and not text.
Because a date is a number. It can be displayed with words for the month and day of the week, but a date is a number. It also means calculations can be done with dates, like finding out how many days are between two dates or by adding an amount of days to a date or taking away an amount of days from a date. If they were actually text, then those things could not be done. It would also sort dates alphabetically, which would mean dates would be in the wrong order. All dates starting with the digit 1 would come before anything starting with the digit 2, which means a date like 12/2/10 would come before 2/2/10. So there are lots of reasons why dates are numbers and not text.
Because a date is a number. It can be displayed with words for the month and day of the week, but a date is a number. It also means calculations can be done with dates, like finding out how many days are between two dates or by adding an amount of days to a date or taking away an amount of days from a date. If they were actually text, then those things could not be done. It would also sort dates alphabetically, which would mean dates would be in the wrong order. All dates starting with the digit 1 would come before anything starting with the digit 2, which means a date like 12/2/10 would come before 2/2/10. So there are lots of reasons why dates are numbers and not text.
What are statistical packages of lotus and Excel used in research?
Lotus 123 and Microsoft Excel are electronic spreadsheet applications. Both can be used for doing statistics because spreadsheets are for numerical analysis and manipulation.
Lotus 123 and Microsoft Excel are electronic spreadsheet applications. Both can be used for doing statistics because spreadsheets are for numerical analysis and manipulation.
Lotus 123 and Microsoft Excel are electronic spreadsheet applications. Both can be used for doing statistics because spreadsheets are for numerical analysis and manipulation.
Lotus 123 and Microsoft Excel are electronic spreadsheet applications. Both can be used for doing statistics because spreadsheets are for numerical analysis and manipulation.
Lotus 123 and Microsoft Excel are electronic spreadsheet applications. Both can be used for doing statistics because spreadsheets are for numerical analysis and manipulation.
Lotus 123 and Microsoft Excel are electronic spreadsheet applications. Both can be used for doing statistics because spreadsheets are for numerical analysis and manipulation.
Lotus 123 and Microsoft Excel are electronic spreadsheet applications. Both can be used for doing statistics because spreadsheets are for numerical analysis and manipulation.
Lotus 123 and Microsoft Excel are electronic spreadsheet applications. Both can be used for doing statistics because spreadsheets are for numerical analysis and manipulation.
Lotus 123 and Microsoft Excel are electronic spreadsheet applications. Both can be used for doing statistics because spreadsheets are for numerical analysis and manipulation.
Lotus 123 and Microsoft Excel are electronic spreadsheet applications. Both can be used for doing statistics because spreadsheets are for numerical analysis and manipulation.
Lotus 123 and Microsoft Excel are electronic spreadsheet applications. Both can be used for doing statistics because spreadsheets are for numerical analysis and manipulation.
Why would you want to use text box in Excel?
Sometimes you want text floating over something instead of being in a cell on the worksheet. This is where a textbox is useful. It can be used to highlight something, often using arrows to point at things, like you can do with a callout.
