What are the most important data formats seenin Excel and how they are used

i was asked this in my interview for internship that the most important data format seen in excel .

15 Answers
Top Voted Recent Answer
1-15 of  15
15 Answers
Top Voted Recent Answer
  • Subject
    0
  • text  , data , file , formal , conditional formatting are necessary formats
     
    0
  • Conditional formatting with goal seek is very important tool of data format.
    0
  • The most important data formats are 1) Conditional Formatting and 2) Data Formatting in excel. Although there are other various types as well; such as currency, date, numbers, etc. But the most important is Conditional Formatting; the powerful visualization technique.
    0
  • shortcutes keys most impotent in excel .
    0
  • I use Asap utilities toll it reduces risk and saves time, it gives shortcuts too, easily we can find and reduce errors than the normal,it only run fraction of second
    0
  • The most important data formats are conditional formatting and data formatting in excel.There are 11 data formatting . It can use with the help of existing Excel workbook or worksheet with extension .xls
    0
  • Existing Excel workbook or worksheet with extension .xls. ... Existing Excel workbook or worksheet with extension .xlsx. ... Comma-separated values text file with extension .csv. ... Text file, often with extension .txt or extension .asc.
    0
  • so, how can i describe all the things in this Anssheet
    0
  • The most important data formats are 1) Conditional Formatting and 2) Data Formatting in excel. Although there are other various types as well; such as currency, date, numbers, etc. But the most important is Conditional Formatting; the powerful visualization technique. It allows you to format various things; Background color, Border, Number formatting & Font formatting in the data assigned with certain conditions.This function is available under home tab in excel. it has already predefined rules such as highlight rules, top/bottom rules,data bars, color scales, etc. we can also add the rule from our side as well by clicking new rule.
    0
  • Numbers. Numbers are one of the most frequently-seen data types in Excel. They can be formatted with a customized number of decimal places, and appear with or without commas separating the thousands digits. Numbers can be added, subtracted, divided, multiplied, or included in formulas and functions that accept numerical inputs.
    Dates. Excel can display dates in any number of ways, including the classic US-style MM/DD/YYYY format. Dates can be added or subtracted using standard addition and subtraction, and can also be manipulated using a slew of date-based functions. Interestingly, dates in Excel are technically also stores as numbers, with each date represented as the number of days elapsed since January 1, 1900. For example, the date May 6, 2019 is stored in Excel as the number 42,129, because there are 42,129 days between January 1, 1900, and May 6, 2019.
    Percentages. Numbers can also be formatted as percentages, which multiplies the given number by 100 and adds a percentage sign at the end. For example, the number 0.08 is equivalent to the percentage 8%.
    Strings. Text is stored in Excel in a format called a string. Strings of text can contain standard characters such as letters, numbers, and punctuation; strings can be manipulated via text-manipulation functions like MID and RIGHT
    0
  • numbers and strings 
    we can modify as for our requirment like doing addition, subtration, multiplication etc...
    and we can adjust strings as we can change mid to end for surname name etc

    in numbers its easy to drag if they are in serial manner... time saving   easy work...
    0
forum   Other Related Discussions
Ms Excel

Didn't get the answer.
Contact people of Talent-Ms Excel directly by clicking here