Software Development Exam  >  Software Development Videos  >  Microsoft Excel 2013: Be the Excel Master  >  Microsoft Excel 2013 Tutorial - 4 - Formatting Numbers

Microsoft Excel 2013 Tutorial - 4 - Formatting Numbers Video Lecture | Microsoft Excel 2013: Be the Excel Master - Software Development

25 videos

FAQs on Microsoft Excel 2013 Tutorial - 4 - Formatting Numbers Video Lecture - Microsoft Excel 2013: Be the Excel Master - Software Development

1. How do I format numbers as currency in Microsoft Excel 2013?
Ans. To format numbers as currency in Microsoft Excel 2013, you can select the cells you want to format, then go to the "Home" tab, click on the "Number Format" dropdown menu, and select the "Currency" option. This will format the numbers with the default currency symbol and decimal places.
2. Can I customize the currency format in Excel 2013?
Ans. Yes, you can customize the currency format in Excel 2013. After selecting the cells you want to format, right-click and choose "Format Cells." In the Format Cells dialog box, go to the "Number" tab, select "Currency," and click on the "Customize" button. Here, you can modify the currency symbol, decimal places, and other formatting options to suit your needs.
3. How do I apply different number formats to different cells in Excel 2013?
Ans. To apply different number formats to different cells in Excel 2013, you can select the cells you want to format, right-click and choose "Format Cells." In the Format Cells dialog box, go to the "Number" tab, select the desired number format, and click on the "OK" button. This will apply the selected format to the selected cells only.
4. Is it possible to format numbers in Excel 2013 with thousands separators?
Ans. Yes, you can format numbers in Excel 2013 with thousands separators. After selecting the cells you want to format, right-click and choose "Format Cells." In the Format Cells dialog box, go to the "Number" tab, select "Number" or "Currency" as the category, and choose the desired number format with thousands separators. This will display the numbers with commas or dots as thousands separators.
5. Can I change the default number format in Excel 2013?
Ans. Yes, you can change the default number format in Excel 2013. Go to the "File" tab, click on "Options," and select the "Advanced" tab. Scroll down to the "Display" section and find the "Show this number of decimal places" option. Adjust the number of decimal places as desired, and click on the "OK" button. This will change the default number format for all new workbooks in Excel 2013.
Related Searches

Objective type Questions

,

Summary

,

Exam

,

Microsoft Excel 2013 Tutorial - 4 - Formatting Numbers Video Lecture | Microsoft Excel 2013: Be the Excel Master - Software Development

,

Free

,

past year papers

,

shortcuts and tricks

,

video lectures

,

MCQs

,

Sample Paper

,

Microsoft Excel 2013 Tutorial - 4 - Formatting Numbers Video Lecture | Microsoft Excel 2013: Be the Excel Master - Software Development

,

Microsoft Excel 2013 Tutorial - 4 - Formatting Numbers Video Lecture | Microsoft Excel 2013: Be the Excel Master - Software Development

,

ppt

,

mock tests for examination

,

pdf

,

Viva Questions

,

practice quizzes

,

Previous Year Questions with Solutions

,

study material

,

Extra Questions

,

Important questions

,

Semester Notes

;