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
Toggle
B
Format
C
Align
D
Orient
2) A formatting characteristic, such as bold, italic, or underlined text.
A
Attribute
B
Style
C
Template
D
Design
3) An Excel feature that enables you to specify how cells that meet one or more given conditions should be displayed.
A
Function
B
Formatting
C
Conditional Formatting
D
Formula
4) A set of text properties that affects the typeface, size, and similar aspects of text.
A
Formula
B
Font
C
Template
D
Screen Tip
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
Text link
B
Hyperlink
C
Macro
D
Video
7) Two or more cells combined into a single cell.
A
Justified cells
B
Merged cells
C
Split cells
D
Oriented 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
Mini Toolbar
B
Screen Tip
C
Hot Keys
D
Quick Access 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
Undo
B
Apply
C
Paste Special
D
Format Painter
10) A tool that enables you to set the order of multiple rules, fine-tune rule settings, and more.
A
Rules Manager
B
Text Manager
C
Functions 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
Conditional Formatting
B
Formula
C
Function
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
Wrap
B
Delete
C
Split
D
Merge
13) What command do you use to insert a cell into your worksheet?
A
Go to the Home tab and select Format Painter from the Clipboard group
B
The Insert command in the Cells group on the HOME tab
C
The Fill command in the Editing group on the HOME ribbon
D
Go to the Insert Tab and select Cell from the Editing Group
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
Justify
B
Align right
C
Align center
D
Align right
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 paper size
B
Adjust Sheet size
C
Adjust font style
D
Adjust text orientation
16) How do you display the Mini toolbar?
A
You cannot make it display, it just happens
B
Just select the cell
C
Click on the drop-down on the Quick Access Toolbar
D
Right-click a cell.
17) What is something you can not copy using Format Painter?
A
Font color
B
The contents of a cell
C
Bold
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 Formatting
C
Paste Values
D
Paste Formula and Formatting
19) How do you remove a hyperlink?
A
Select the Hyperlink and click copy
B
Right-click the cell and select Remove Hyperlink.
C
Click remove
D
Click Subtract
20) In which group on the HOME tab is the Clear Formats command located?
A
Number
B
Cells
C
Editing
D
Font
*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?