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
Special Formatting
B
Paste Special
C
Number Format
D
General Format
2) This format displays days, months, and years in the mm/dd/yyyy style by default.
A
Now Function
B
Today Function
C
Long Date
D
Short Date
3) Where do you go to change the vertical alignment of a cell's contents?
A
View tab, alignment group
B
Page Setup dialog box and select Alignment tab
C
Home tab, Editing group
D
Format cells dialog box and select the Alignment tab
4) When you enter numbers, the content is ______________aligned by default.
A
Justified
B
Center
C
Right
D
Left
5) What group on the home ribbon do you find the command to insert or delete cells in your spreadsheet?
A
Editing
B
Number
C
Cells
D
Styles
6) What command do you use to apply a background color to cells in a worksheet?
A
Borders
B
Fill color
C
Font color
D
Line color
7) Cheyanna notices that the data in cell E4 reads #######. What command could she choose to correct this problem?
A
Merge
B
Delete
C
Split
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
Page Layout
B
Insert
C
View
D
Home
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
Number
B
Accounting
C
Currency
D
General
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
Center
D
Split
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
Clipboard
B
Settings
C
Page Setup
D
Format Cells
12) You would like to outline the cell range A1:F20. Which formatting style should you select?
A
Borders
B
Font color
C
Styles
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
Trace Dependents
B
Conditional Formatting
C
Trace Precedents
D
Define Name
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
Percentage
D
General
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
Text
C
General
D
Currency
16) Which command do you use to increase the margin between the border and the text in an indented cell?
A
Split
B
Increase Indent
C
Decrease Indent
D
Merge
*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?