Microsoft Excel Interview Questions and Answers
Q1 : How many data formats are available in Excel? Name some of them. A : Eleven data formats are available in Microsoft Excel for data Storage. Example: Number – Stores data as a number Currency – Stores data in the form of currency Date – Data is stored as dates Percentage – Stores numbers as a percentage Text Formats – Stores data as string of texts Q2 : Explain few useful functions in Excel. A : Following are the functions