USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Column D in a spreadsheet contains employee ID Numbers. Which formatting would be most appropriate for the data in column D?
|
|
Currency
|
|
|
Date
|
|
|
Number
|
|
|
Text
|
Explanation:
Detailed explanation-1: -Column: Columns run vertically on the spreadsheet screen. An Excel spreadsheet contains 256 columns that are labeled with the letters of the alphabet.
Detailed explanation-2: -Text data, also called labels, is used for worksheet headings and names that identify columns of data. Text data can contain letters, numbers, and special characters such as ! or &. By default, text data is left-aligned in a cell. Number data, also called values, is used in calculations.
Detailed explanation-3: -Generally, you should use the Format Cells dialog (Ctrl+1) or Home > Number > Accounting Number Format option to apply a currency formatting to a cell. This is because the DOLLAR function returns the number provided as text.
There is 1 question to complete.