Name:     ID: 
 
Email: 

Unit G Excel - Experienced

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

 1. 

A worksheet is an electronic grid that performs numeric calculations.
 

 2. 

You can add more worksheets if you need more than the default number.
 

 3. 

When you first start Excel or open a workbook, the cell in the upper-right corner of Sheet1 is always the active cell.
 

 4. 

Entering data in a worksheet requires you to first type data into the active cell and then accept the entry.
 

 5. 

AutoFit allows you to single-click on a column boundary to automatically widen or narrow it to fit the longest entry in the column.
 

 6. 

Formulas can only contain numbers and mathematical operators.
 

 7. 

You can copy and move formulas just like other data in a worksheet.
 

 8. 

You can revise the contents of a cell by editing its contents in the formula bar or by double-clicking and typing directly in the cell.
 

 9. 

When you first enter data in a cell, Excel automatically right-aligns labels and left-aligns values.
 

 10. 

You can format numbers to appear in one of several standard formats, including currency, percent, and date.
 

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

 11. 

A ____ can contain one or more worksheets.
a.
notebook
c.
spreadbook
b.
workbook
d.
sheetbook
 

 12. 

The intersection of a row and column is called a(n) ____.
a.
block
c.
data point
b.
object
d.
cell
 

 13. 

In a worksheet, the cell with the dark border around it is the ____ cell.
a.
active
c.
preferred
b.
editing
d.
updating
 

 14. 

You can refer to a cell by its ____, a column letter followed by a row number.
a.
cell id
c.
placement
b.
cell address
d.
grid id
 

 15. 

The ____ box shows the address of the selected cell.
a.
formula
c.
name
b.
data
d.
address
 

 16. 

The ____ bar just above the column headings shows the contents of the selected cell.
a.
formula
c.
name
b.
data
d.
address
 
 
nar001-1.jpg
 

 17. 

In the accompanying figure, item 1 points to the ____.
a.
Name box
c.
Formula bar
b.
Office button
d.
Quick Access toolbar
 

 18. 

In the accompanying figure, item 2 points to the ____.
a.
View buttons
c.
Formula bar
b.
Office button
d.
Quick Access toolbar
 

 19. 

In the accompanying figure, item 4 points to the ____.
a.
Name box
c.
Formula bar
b.
Office button
d.
Quick Access toolbar
 

 20. 

In the accompanying figure, item 5 points to the  active cell its name is;.
a.
1A
c.
A1
b.
B5
d.
D10
 

 21. 

In the accompanying figure, item 8 points to the ____.
a.
View buttons
c.
Formula bar
b.
Office button
d.
Quick Access toolbar
 

 22. 

In the accompanying figure, item 12 points to the ____.
a.
View buttons
c.
Formula bar
b.
Office button
d.
Quick Access toolbar
 

 23. 

In a spreadsheet, the boxes at the top containing letters are known as ____ headings.
a.
data
c.
row
b.
sheet
d.
column
 

 24. 

The boxes containing numbers on the left are known as ____ headings.
a.
data
c.
row
b.
sheet
d.
column
 

 25. 

References to cell addresses, such as A1, E42 are known as ____.
a.
cell ids
c.
referent addresses
b.
cell references or address
d.
referent ids
 

 26. 

All formulas must begin with a(n) ____.
a.
equal sign (=)
c.
minus sign (-)
b.
plus sign (+)
d.
forward slash
 

 27. 

When you copy a formula using the fill handle, Excel automatically replaces the original cell references with cell references that are in the same ____ position as those in the original formula.
a.
absolute
c.
relative
b.
approximate
d.
possible
 

 28. 

To indicate an absolute cell reference, you type a ____ before the part of the address you want to remain constant.
a.
percent sign (%)
c.
forward slash (/)
b.
dollar sign ($)
d.
back slash (\)
 

 29. 

You can copy or move cells, rows, or columns using the ____ group on the Home tab.
a.
Duplicate
c.
Clipboard
b.
Search
d.
Save
 
 
nar002-1.jpg
 

 30. 

In the accompanying figure, item 1 points to the ____.
a.
Center button
c.
Enter button
b.
Formula bar
d.
Merge and Center button
 

 31. 

In the accompanying figure, item 5 points to the ____.
a.
Center button
c.
Enter button
b.
Formula bar
d.
Merge and Center button
 

 32. 

You can format individual cells or a range of cells using the ____ group on the Home tab.
a.
Format
c.
Object
b.
Font
d.
Style
 

 33. 

You can add headers and ____ in an Excel worksheet containing important information that you want to include at the top or bottom of each page.
a.
footers
c.
bottoms
b.
footnotes
d.
tails
 

 34. 

It is important to ____ your work before printing, so that if you experience technical problems while printing you do not lose your work.
a.
update
c.
review
b.
check
d.
save
 

 35. 

____ lets you examine your document as it will appear when printed.
a.
Print View
c.
Print Preview
b.
Test Print
d.
Test View
 



 
         Start Over