Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Excel 2010 Lesson 4
Test Description: Excel 2010 Lesson 4 Review
Instructions: Answer all questions to get your test result.
1) The _____ tab contains formatting commands used to enhance a worksheet's appearance.
A
Page Layout
B
View
C
Home
D
Data
2) By clicking the arrow next to the Insert button in the Cells group of the Home tab, you can insert ________________.
A
cells
B
new worksheets
C
rows
D
all of the answers
3) When inserting a new cell into a worksheet, existing cells in the same column will shift ______________.
A
right
B
donw
C
up
D
left
4) When inserting a new cell into a worksheet, existing cells in the same row will shift ____________.
A
up
B
left
C
down
D
right
5) If ____________ symbols appear in a cell, it means that the numeric value entered is wider than the cell.
A
###
B
!!!
C
none of the answers
D
***
6) When you enter a number in Excel, the default format is _________________.
A
Currency
B
General
C
Number
7) Number formatting can be applied to cells _________.
A
both answers
B
after you select the data
C
before data is entered
D
none of the answers
8) Use the _______ command in the Font group to change teh background color to a cell.
A
Fill color
B
Font color
C
Border color
D
all of the answers
9) A character can be a ______________.
A
all of the answers
B
symbol
C
punctuation mark
D
letter or number
10) An attribute is a formatting characteristic, such as _____________.
A
all of the answers
B
underlined
C
bold
D
italic
11) One point is equal to ______________________.
A
1/72 cm.
B
1/72 in.
C
1/72 mm.
D
1/72 ft.
12) Font size is measured in _________________.
A
none of the answers
B
degrees
C
points
D
distance
13) A(n) ____________ is a set of text characteristics designed to appear a certain way.
A
all of the answers
B
attribute
C
font
D
alignment
14) The default font for Excel 2010 is ____________.
A
10-point Arial
B
none of the answers
C
11-point Calibri
D
12-point Courier
15) If you want cells to be highlighted when you print a worksheet, you must use formatting features to apply
A
none of the answers
B
borders
C
font color
D
shading
16) Color scales, icon sets, and data bars make up Excel's __________.
A
cell background options
B
data formatting options
C
style formatting options
D
preset conditional format options
17) When a cell is formatted to _____________ text, any data in the cell automatically breaks to fit the column width.
A
wrap
B
accomodate
C
accept
D
ignore
18) You can use the Merge and Center command in the __________ group.
A
Changes
B
Format
C
Insert
D
Alignment
19) You can use the Delete command in the Cells group to delete _____________.
A
columns
B
all of the answers
C
ranges
D
rows
20) To select all cells in a worksheet you can _____________.
A
both answers
B
Press Ctrl + A
C
none of the answers
D
Click the Select All button
*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?