FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO MODIFY THE WORKSHEET TAB IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
What are the different data formats in Excel?
A
Text and Numbers only
B
Text, Date and Nambers only
C
Text, Numbers, Currency, Percentages and Date.
D
None of the above
Explanation: 

Detailed explanation-1: -In a Data Model, each column has an associated data type that specifies the type of data the column can hold: whole numbers, decimal numbers, text, monetary data, dates and times, and so on.

Detailed explanation-2: -The TEXT function lets you change the way a number appears by applying formatting to it with format codes. It’s useful in situations where you want to display numbers in a more readable format, or you want to combine numbers with text or symbols.

There is 1 question to complete.