Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Excel Lesson 6 (Part 1)
Test Description: Formatting Cells and Ranges
Instructions: Answer all questions to get your test result.
1) What term means to arrange in a line or bring into alignment.
A
Format
B
Toggle
C
Orient
D
Align
2) A formatting characteristic, such as bold, italic, or underlined text.
A
Style
B
Design
C
Attribute
D
Template
3) An Excel feature that enables you to specify how cells that meet one or more given conditions should be displayed.
A
Formula
B
Function
C
Conditional Formatting
D
Formatting
4) A set of text properties that affects the typeface, size, and similar aspects of text.
A
Template
B
Screen Tip
C
Font
D
Formula
5) A feature found in most Office applications that allows you to quickly copy formatting attributes that you have already applied and “paint” those attributes onto other text, shapes, pictures, and worksheet cells.
A
Template
B
Style
C
Format Painter
D
Copy/Paste
6) A shortcut that enables you to navigate to a web page or a location in another file in just one click of the mouse.
A
Video
B
Macro
C
Hyperlink
D
Text link
7) Two or more cells combined into a single cell.
A
Justified cells
B
Merged cells
C
Oriented cells
D
Split cells
8) A formatting tool that appears above or below the shortcut menu when you right-click a cell and that displays the most commonly used formatting commands.
A
Screen Tip
B
Hot Keys
C
Quick Access Toolbar
D
Mini Toolbar
9) A tool that enables you to control specifically what you want to paste after using the Copy or Cut commands, such as cell content, formulas, values, formatting, and much more.
A
Apply
B
Paste Special
C
Format Painter
D
Undo
10) A tool that enables you to set the order of multiple rules, fine-tune rule settings, and more.
A
Rules Manager
B
Functions Manager
C
Text Manager
D
Formulas Manager
11) A set of formatting attributes that you can apply to a cell or range of cells more easily than by setting each attribute individually.
A
Function
B
Formula
C
Conditional Formatting
D
Style
12) To automatically display data on the next line when it is too long to display within the cell’s width. Doing this automatically increases a cell’s height.
A
Merge
B
Wrap
C
Split
D
Delete
13) What command do you use to insert a cell into your worksheet?
A
Go to the Insert Tab and select Cell from the Editing Group
B
The Insert command in the Cells group on the HOME tab
C
Go to the Home tab and select Format Painter from the Clipboard group
D
The Fill command in the Editing group on the HOME ribbon
14) You want to format a cell so the text is spread evenly throughout the cell, wrapping automatically and adjusting the row height, if necessary. Which alignment option do you choose?
A
Align right
B
Justify
C
Align right
D
Align center
15) You want to fit a long column heading into a small space without changing the font size or column width. What is the best choice?
A
Adjust Sheet size
B
Adjust paper size
C
Adjust font style
D
Adjust text orientation
16) How do you display the Mini toolbar?
A
Just select the cell
B
Right-click a cell.
C
You cannot make it display, it just happens
D
Click on the drop-down on the Quick Access Toolbar
17) What is something you can not copy using Format Painter?
A
Bold
B
Font color
C
The contents of a cell
D
Font style
18) Which Paste Special option pastes only the result of a formula rather than the formula itself?
A
Paste Formula
B
Paste Values
C
Paste Formula and Formatting
D
Paste Formatting
19) How do you remove a hyperlink?
A
Right-click the cell and select Remove Hyperlink.
B
Select the Hyperlink and click copy
C
Click Subtract
D
Click remove
20) In which group on the HOME tab is the Clear Formats command located?
A
Cells
B
Font
C
Number
D
Editing
*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?