Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Excell Lesson 6 (Part 2)
Test Description: Formatting Cells and Ranges-Part 2
Instructions: Answer all questions to get your test result.
1) Contains additional number formats specific to your country. In the United States, there are four (Zip Code, Zip Code+4, Phone Number, and Social Security Number); in Canada, there are two (Phone Number and Social Insurance Number); in most other cou
A
Number Format
B
Special Formatting
C
Paste Special
D
General Format
2) This format displays days, months, and years in the mm/dd/yyyy style by default.
A
Now Function
B
Long Date
C
Short Date
D
Today Function
3) Where do you go to change the vertical alignment of a cell's contents?
A
Page Setup dialog box and select Alignment tab
B
Format cells dialog box and select the Alignment tab
C
Home tab, Editing group
D
View tab, alignment group
4) When you enter numbers, the content is ______________aligned by default.
A
Justified
B
Center
C
Left
D
Right
5) What group on the home ribbon do you find the command to insert or delete cells in your spreadsheet?
A
Number
B
Styles
C
Cells
D
Editing
6) What command do you use to apply a background color to cells in a worksheet?
A
Fill color
B
Line color
C
Font color
D
Borders
7) Cheyanna notices that the data in cell E4 reads #######. What command could she choose to correct this problem?
A
Delete
B
Split
C
Merge
D
Autofit
8) On what ribbon can you find the command to apply a fill color to a cell or range of cells in a worksheet?
A
Home
B
Insert
C
Page Layout
D
View
9) Which quick-number style button formats numbers to display as currency in the worksheet? *Hint: This format left-aligns the dollar sign in each cell.
A
General
B
Currency
C
Accounting
D
Number
10) Kathryn needs the title in cell A1 to align horizontally across cells A1 through D1. Which alignment option should she select?
A
Merge and Center
B
Merge
C
Split
D
Center
11) Which dialog box contains the commands to specify an exact date and time format to use for a selected cell in a worksheet?
A
Page Setup
B
Settings
C
Clipboard
D
Format Cells
12) You would like to outline the cell range A1:F20. Which formatting style should you select?
A
Styles
B
Font color
C
Borders
D
Fill color
13) Jacob would like to apply a rule to the data in cell range A1:D20 that will highlight numbers greater than 20,000 with a green fill color and dark red text. Which formatting style should he select?
A
Define Name
B
Trace Precedents
C
Trace Dependents
D
Conditional Formatting
14) Column D in a spreadsheet contains Product Prices. Which formatting would be most appropriate for the data in column D?
A
Number
B
Currency
C
General
D
Percentage
15) Column D in a spreadsheet contains employee ID Number. Which formatting would be most appropriate for the data in column D?
A
Number
B
General
C
Text
D
Currency
16) Which command do you use to increase the margin between the border and the text in an indented cell?
A
Merge
B
Split
C
Increase Indent
D
Decrease Indent
*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?