2. List some common formats that you can use for formatting numbers?
Answers
Answer:
You can select standard number formats (General, Number, Currency, Accounting, Short Date, Long Date, Time, Percentage, Fraction, Scientific, Text) on the home tab of the ribbon using the Number Format menu. Note: As you enter data, Excel will sometimes change number formats automatically.
Answer:
INTRODUCTION
Number formats control how numbers are displayed in Excel. The key benefit of number formats is that they change how a number looks without changing any data. They are a great way to save time in Excel because they perform a huge amount of formatting automatically. As a bonus, they make worksheets look more consistent and professional.
Explanation:
What can you do with custom number formats?
Custom number formats can control the display of numbers, dates, times, fractions, percentages, and other numeric values. Using custom formats, you can do things like format dates to show month names only, format large numbers in millions or thousands, and display negative numbers in red.
Sample custom number formats
Where can you use custom number formats?
Many areas in Excel support number formats. You can use them in tables, charts, pivot tables, formulas, and directly on the worksheet.
Worksheet - format cells dialog
Pivot Tables - via value field settings
Charts - data labels and axis options
Formulas - via the TEXT function
What is a number format?
A number format is a special code to control how a value is displayed in Excel. For example, the table below shows 7 different number formats applied to the same date, January 1, 2019:
Input Code Result
1-Jan-2019 yyyy 2019
1-Jan-2019 yy 19
1-Jan-2019 mmm Jan
1-Jan-2019 mmmm January
1-Jan-2019 d 1
1-Jan-2019 ddd Tue
1-Jan-2019 dddd Tuesday
The key thing to understand is that number formats change the way numeric values are displayed, but they do not change the actual values.
Where can you find number formats?
On the home tab of the ribbon, you'll find a menu of build-in number formats. Below this menu to the right, there is small button to access all number formats, including custom formats:
Number format menu on Home tab of Ribbon
This button opens the Format Cells dialog box. You'll find a complete list of number formats, organized by category, on the Number tab:
Format Cells dialog box on Number tab
Note: you can open Format Cells dialog box with the keyboard shortcut Control + 1.
HOPE IT WILL HELP YOU........
MARK AS BRAINLIEST ANSWER........