0
There are lots of data types in Excel. For example: Number, Text, Date, Time, Logical. You can take Number in a broad sense or you can think of numbers in terms different data types like Percentage, Scientific Notation, Currency and others.
Wiki User
∙ 6y ago
Wiki User
∙ 14y agoThe main categories of functions in Excel are:
Text
Date and Time
Logical
Database
Information
Math & Trig
Lookup & Reference
Statistical
Financial
Wiki User
∙ 8y agoThey are the headings for the values. For example, if you had totals for the amount of sales for each month of a year, the months would be the categories. For most charts, they are the titles on the horizontal or x axis. In a pie chart, they would be the names on the slices. Each value in a series of values, has an associated category. So, taking the earlier example, each total of sales would be for a different month, or in technical terms a different category.
Wiki User
∙ 14y ago- General: This is the default format for numbers when you start Excel.
- Number: Allows you to control the way numbers are displayed. Some examples are number of decimal places, show a comma to separte every three digits in a large number, and displaying negative numbers as red.
- Currency: Specify a currency symbol which will be displayed next to the value.
- Accounting: Same as the Currency category, except it will align the currency symbols and decimal points with the cell (like full justification).
- Date: Treat the contents of the cell as a date and adjust to different date display formats.
- Time: Formats the contents of the cell as time in a format you choose.
- Percentage: Automatically multiply the cell contents by 100 and display the result with a percentage symbol at the end.
- Fraction: Display the contents of a cell as a fraction instead of as a decimal. You can choose from various format options.
- Scientific: Display the contents of the cell in Scientific notation.
- Text: Forces the contents of the cell to display exactly entered. This is helpful when entering text which contains numbers or special characters.
- Special: The Special category works only for certain locations. For example, selecting the United States location will let you enter ZIP codes and phone numbers while keeping any leading zeros.
- Custom: Allows you to configure the cell entry as you choose.
Wiki User
∙ 10y agoNumbers, text or logical (True/False). Numbers can include dates and times, and there are many ways numbers can be formatted.
Wiki User
∙ 14y ago* General * Number * Currency * Accounting * Date * Time * Percentage * Fraction * Scientific * Text * Special * Custom
Add your answer:
Earn +20 pts
How do you export data from PRMS to Microsoft Excel?
You Can't
What Microsoft application is best for managing quantitative data?
Microsoft Excel, as it is for numerical analysis and manipulation, which is what is done with quantitative data.
What are examples of types of data in Microsoft Excel?
numbers and text
Why do pharmacy technicians use Microsoft Excel?
Pharmacy technicians use Microsoft Excel because it is a fast and efficient means of organizing data.
In Microsoft Excel what is the meaning of Data Validity?
In Excel, you can set validation rules on a cell to ensure the data meets specified conditions before Excel will accept the entry.
What is the role played by the MS-Excel?
The role played by Microsoft excel is handling data and spreadsheet work.
How can data be printed on a page using a printer?
Microsoft excel then print it
How do you draw a data flow diagram for an insurance?
use Microsoft excel
What is a computer program usefu for organizing and analyzing data is?
Microsoft Excel is good for organizing data
How can you exchange data between Excel and other applications that are not part of Microsoft office suit?
You can do a simple copy and paste. You can save a file into different formats and then import them into other applications. Some things can be very easily converted for Excel, like different kinds of tables in Word and Access. Powerpoint gives the facility to create simple spreadsheets like Excel ones. You can enter links into the different applications and have them automatically updated when the various applications are opened so that data can be shared.
What can you import from Microsoft Excel 2007?
It depends on where you are exporting to if you are tyring to import from Excel. Generally, you can import Excel data to many applications, but the target application will determine what will transfer from Excel and how the data will disply in the target application.
What is Microsoft execel?
MS stands for Microsoft so ms word and ms excel are Microsoft Word and Microsoft Excel respectively. We can create documents in windows operating system with usually MS Word used to create word documents and MS excel for creating spreadsheet for calculation etc.
