Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Excel Number Formatting
Test Description: Excel number formatting
Instructions: Answer all questions to get your test result.
1) All numbers aligned to the left. The text has no change.
A
scientific
B
text
C
percentage
D
fraction
2) 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
fraction
B
text
C
percentage
D
scientific
3) 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
text
C
percentage
D
scientific
4) 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
scientific
B
percentage
C
text
D
fraction
5) 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
long date
B
time
C
short date
D
fraction
6) 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
percentage
D
time
7) 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
currency
B
accounting
C
short date
D
long date
8) 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
short date
C
time
D
currency
9) All numbers display with two decimal places and a currency symbol in front. `currency symbol. The text has no change.
A
accounting
B
currency
C
long date
D
short date
10) All numbers display with two decimal places. The text has no change.
A
accounting
B
currency
C
general
D
number
11) You should see no change, as General is the default, or starting, number format on all cells
A
number
B
currency
C
text
D
general
*select an answer for all questions
Check Results & Get Answers
Play Games with the Questions Above
Teachers: Create FREE classroom games with your questions
Click for more info!
©2007-2024
ReviewGameZone.com
|
About
|
Privacy
|
Contact
|
Terms
|
Site Map
WAIT! Find what you needed?
×
Still Looking for the Answers?
Have Another Question?
Play a Review Game with These Questions?
Want to Make Your Own Test Like This One?