Name:     ID: 
 
Email: 

Excel 1

Multiple Choice
Identify the choice that best completes the statement or answers the question.
 

 1. 

An Excel ____ allows data to be summarized and charted easily.
a.
worksheet
c.
document
b.
workflow
d.
presentation
 

 2. 

The first step in creating an effective worksheet is to make sure you ____.
a.
apply font formatting
c.
insert a chart
b.
understand what is required
d.
enter the data
 

 3. 

To enter data in a cell, you must first select the ____.
a.
row
c.
column
b.
worksheet
d.
cell
 

 4. 

The ____ is a blinking vertical line that indicates where the next typed character will appear.
a.
scroll box
c.
insertion point
b.
sheet tab
d.
split bar
 

 5. 

By default, text is ____ in a cell.
a.
left-aligned
c.
justified
b.
centered
d.
right-aligned
 

 6. 

In Excel, a number can contain the characters ____.
a.
0 1 2 3 4 5 6 7 8 9
c.
. $ % E e
b.
+ - ( ) , /
d.
all of the above
 
 
nar001-1.jpg
 

 7. 

A ____ is a series of two or more adjacent cells in a column or row or a rectangular group of cells, as shown in the accompanying figure.
a.
range
c.
nearby cell
b.
bunch
d.
neighbor
 

 8. 

The ____ preceding a formula alerts Excel that you are entering a formula or function and not text.
a.
quotation mark (“)
c.
plus (+)
b.
colon (:)
d.
equal sign (=)
 

 9. 

You ____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand.
a.
save
c.
format
b.
print
d.
clear
 

 10. 

Combining two or more selected cells into one cell is called ____ cells.
a.
merging
c.
combining
b.
mixing
d.
spanning
 

 11. 

A pie chart with one or more slices offset is referred to as a(n) ____ pie chart.
a.
exploded
c.
offset
b.
outer
d.
rasterized
 

 12. 

The date you change a file is an example of a(n) ____ property.
a.
automatically updated
c.
standard
b.
baseline
d.
indexed
 

 13. 

The ____ button allows you to erase recent cell entries.
a.
Undo
c.
Bold
b.
Cell Style
d.
Increase Decimal
 

True/False
Indicate whether the statement is true or false.
 

 1. 

A thin red border indicates the active cell.
 

 2. 

When you tap or click the Enter box to complete an entry in a cell, the active cell moves down to the next cell in the same column.
 

 3. 

When text is longer than the width of a column, Excel displays the overflow characters in adjacent cells to the right as long as those adjacent cells contain no data.
 

 4. 

When entering dollar values in cells, you also must type the dollar sign ($), commas, and any trailing zeros.
 

 5. 

A single point is about 1/32 of one inch in height.
 

 6. 

To add a pie chart, first select the data to be charted and then tap or click the Insert Pie or Doughnut Chart button (INSERT tab | Charts group).
 

 7. 

You can clear cell contents and formatting by tapping or clicking Clear Contents on the Clear button menu.
 

 8. 

You should press the SPACEBAR to clear a cell.
 

Modified True/False
Indicate whether the statement is true or false. If false, change the identified word or phrase to make the statement true.
 

 1. 

In a worksheet, columns typically contain information that is similar to a list. _________________________

 

 2. 

The opposite of merging cells is splitting a merged cell. _________________________

 

 3. 

If you accidentally undo an action, you can use the Redo button to redo it. _________________________

 

 4. 

To change the worksheet’s tab color, double click on the tab.

 



 
         Start Over