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