Formatting Numbers Excel Test

Free Online Microsoft Excel 2010 Test Excel Formulas and Functions

* General Formatting in Excel * How to change Decimal Places in Excel * How to change Currency in Excel * Negative Numbers in Excel * Formatting Dates in Excel - change format of date in Excel * Formatting Fractions in Excel 10 Question Multiple Choice Quiz with Answers and Answer Explanations

***GO TO THE TEST ANSWER EXPLANATIONS PAGE

Formatting Numbers Excel Test

1) Study the screenshot above.  Kayla created this spreadsheet and needs the content to display as currency but despite her selecting the Currency formatting option, amounts are still displaying with an extra zero at the end. Which of the following options will solve this issue?
a) Kayla needs to change the formatting of the number values to General first and then apply the Currency formatting to it.
b) Kayla needs to click in each cell and manually delete the extra zeros.
c) Kayla should use the Decrease Decimal button to remove the extra decimal number at the end of each value.
d) Kayla should use the Increase Decimal button to accommodate the extra zero so that it will not display.

2) Study the screenshot above.  Is there a quick way for Kayla to format the dates in the Dates column above to display as complete written out dates, for example, 12 December 2015 instead of 12/12/2015?
a) Yes, by selecting the cells and in the Number group selecting Format as Date.
b) No, this is not possible.  The dates above are in a format not recognized by Excel and will need to be retyped.
c) No, this is not possible.  If dates are not entered as dates, it cannot be changed later on.
d) Yes, by selecting the cells and in the Number group selecting Long Date.

3) Which of the following options best represent the actions needed to format currency amounts so that negative numbers are automatically prefixed with a minus symbol and formatted in red font?
a) Select cells to format, launch the Format Cells dialogue box, select the correctly formatted option from the Negative Numbers box and press OK.
b) Select cells to format, from the Font group change the font to red and in the Format Cells dialogue box, select Negative Numbers Only and press OK.
c) Select cells to format, launch the Format Cells dialogue box, select Autoformat from the Font Options tab and press OK.
d) All of the above options are correct.

4) Study the screenshot above.  What happens when the arrow circled in yellow is clicked?
a) The Number group will expand and icons will display with explanations and labels.
b) The Numbers dialogue box will open, offering formatting options for numbers.
c) A list of number formats will appear from which you can choose a number format.
d) This will launch the Format Cells dialogue box from where you can chose different Number formats and other formatting options.

5) Is it wrong to manually insert currency symbols ahead of numbers in Excel?
a) It is not wrong, just more time consuming than using the number formatting options to format numbers automatically with a currency symbol.
b) It is not a good idea to manually insert numbers as formulas will not calculate correctly.
c) Some users prefer to insert currency manually, this is not wrong and will not cause any problems.
d) It is not a good idea to manually insert numbers as the numbers will not line up correctly.

6) Study the screenshot above.  Why is the formula above not calculating the cell references correctly and displaying a formula instead of a calculated value?
a) The cell containing the formula is formatted as Text.
b) The cells containing the numbers are formatted as Text.
c) There is hidden text in the cells that is formatted as Text.
d) All of the above options are correct.

7) When a date displays as a number instead of as a date, which format has been applied?
a) The Short Date format has been applied.
b) The Long Date format has been applied.
c) The Number format has been applied.
d) The Custom date format has been applied.

8) What is the purpose of formatting numbers as text and would this ever be useful?
a) No, text formatting is applied to cells containing words and letters only.
b) Yes, this function is used when you wish Excel to treat numbers as text, for example, a phone number.
c) Yes, this function is used when you wish Excel to calculate how many letters a word or phrase has.
d) All of the above options are correct.

9) Cameron needs to format a list of decimal numbers as hundredth fractions, for example, 26/100.  How can he go about doing this?
a) Insert a formula to convert the decimal numbers to whole numbers and then format as fractions.
b) Select the As Hundredths from the Type list in the Fraction group under the Number tab in the Format Cells dialogue box.
c) Use the Fractions format by clicking on it in the Number Format list in the Number group under the Home tab on the Ribbon.
d) Insert the values as fractions and use a divider symbol to format numbers as fractions.

10) Which of the following date formats is not an automatic date option available in the Date group in the Format Cells dialogue box?
a) The format: 22.1.2015 is not available.
b) The format: 2015-01-22 is not available.
c) The format: 14/3/01 is not available.
d) All of the above formats are valid date formats available in Excel.