Excel Number Formatting Question Preview (ID: 60322)


Excel Number Formatting. TEACHERS: click here for quick copy question ID numbers.

All numbers aligned to the left. The text has no change.
a) text
b) scientific
c) fraction
d) percentage

Scientific format displays a number in exponential notation, replacing part of the number with E+n, in which E (exponent) multiplies the preceding number by 10 to the nth power. For example, a 2-decimal scientific format displays 12345678901 as 1.23E
a) scientific
b) text
c) percentage
d) fraction

Decimal numbers display lined up with whole numbers, and have the fraction to the right after a space. Negative numbers have the minus sign in front of the number. The text has no change.
a) fraction
b) scientific
c) text
d) percentage

Numbers display with a percent sign on the right and have been multiplied by 100. Negative numbers have the minus sign in front of the number. The text has no change.
a) percentage
b) fraction
c) scientific
d) text

Numbers display as a time in the format of hour:minutes:seconds, and AM or PM. Note the time for zero. Negative numbers and the extreme large number are invalid times so they appear as # symbols filling the cell. The text has no change.
a) time
b) long date
c) short date
d) fraction

Numbers display as a date in the format of full day name, full month name and two-digit day, and four-digit year. Note the date for zero. Negative numbers and the extreme large number are invalid dates so they appear as # symbols filling the cell. Th
a) long date
b) short date
c) time
d) percentage

Numbers display as a date in the same format as your computer. Note the date for zero. Negative numbers and the extreme large number are invalid dates so they appear as # symbols filling the cell. The text has no change.
a) short date
b) long date
c) accounting
d) currency

All numbers display with two decimal places and a currency symbol aligned on the left. Negative numbers are in parentheses and positive numbers have extra space on the left and right where the parentheses would be so all decimals line up. Zero numbe
a) accounting
b) currency
c) short date
d) time

All numbers display with two decimal places and a currency symbol in front. `currency symbol. The text has no change.
a) currency
b) accounting
c) short date
d) long date

All numbers display with two decimal places. The text has no change.
a) number
b) general
c) currency
d) accounting

You should see no change, as General is the default, or starting, number format on all cells
a) general
b) number
c) currency
d) text

Play Games with the Questions above at ReviewGameZone.com
To play games using the questions from above, visit ReviewGameZone.com and enter game ID number: 60322 in the upper right hand corner or click here.

TEACHERS / EDUCATORS
Log In | Sign Up / Register

Help / Support / FAQ




Gaming Links