Name:     ID: 
 
Email: 

Excel Chapter 1 Concept Test

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

 1. 
An Excel _____ allows data easily to be summarized and charted.
a.
worksheet
c.
document
b.
workbook
d.
presentation
 

 2. 
The person or persons requesting the worksheet should supply their requirements in a _____ document.
a.
blank
c.
requirements
b.
test issues
d.
certified
 

 3. 
The _____ feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry.
a.
AutoComplete
c.
AutoFormat
b.
AutoCorrect
d.
AutoTyping
 

 4. 
A _____ reference is an adjusted cell reference in a copied and pasted formula.
a.
revised
c.
recycled
b.
relative
d.
retained
 

 5. 
The _____ is the small black square located in the lower-right corner of the heavy border around the active cell.
a.
selection handle
c.
fill handle
b.
sizing handle
d.
copy handle
 

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

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

 8. 
A(n) _____ chart is drawn on the same worksheet as the data.
a.
embedded
c.
embodied
b.
emboldened
d.
empowered
 

 9. 
_____ properties are associated with all Microsoft Office documents and include author, title, and subject.
a.
Automatic
c.
Document
b.
Hidden
d.
Standard
 

 10. 
The _____ area on the status bar displays common calculations, such as SUM or AVERAGE, for selected numbers in the worksheet.
a.
AutoFormat
c.
AutoFunction
b.
AutoComplete
d.
AutoCalculate
 

 11. 
A(n) __________________ conveys a  visual representation of data.
a.
chart
c.
format
b.
cell
d.
title
 

 12. 
_______________________ are used to represent an amount in a cell.
a.
text
c.
numbers
b.
bold
d.
special characters
 

 13. 
The Excel function ______________ adds all the numbers in a range.
a.
average
c.
sum
b.
max
d.
min
 

 14. 
The _______________ mode  is activated by double-clicking a cell, and allows for changes  to be made to a cell.
a.
over-type
c.
insert
b.
edit
d.
format
 

 15. 
The _________________ editing mode in Excel inserts the characters and moves all characters to the right of the typed character one position.
a.
over-type
c.
insert
b.
edit
d.
format
 

 16. 
The ________________ editing mode in Excel replaces the character(s) to the right of the insertion point.
a.
over-type
c.
insert
b.
edit
d.
format
 

 17. 
_________________ is used to place titles, such as worksheets titles, columns titles, and row titles on a worksheet.
a.
format
c.
style
b.
text
d.
theme
 

 18. 
A(n) _______________ font size gives more impact to the text in a cell.
a.
bold
c.
decreased
b.
increased
d.
colored
 

 19. 
Different cell _________________ help the reader of a worksheet differentiate between the sections of a worksheet.
a.
cells
c.
colors
b.
text
d.
numbers
 

 20. 
A __________ is a collection of cell styles and other styles that have common characteristics, such as color scheme and font.
a.
style
c.
format
b.
theme
d.
text
 

 21. 
The ________ specifies the size of the characters on the screen.
a.
font style
c.
font size
b.
font color
d.
fill handle
 

 22. 
A ______ word is a word or phrase that further describes the document.
a.
document properties
c.
sum function
b.
relative reference
d.
keyword
 

 23. 
When text does not fit in a cell you can modify cells  to ______________ the text.
a.
best-fit
c.
font color
b.
fill handle
d.
theme
 

 24. 
Why would you increase the font size of the text in a cell?
a.
To give more impact to the text in a cell.
c.
To help the reader find text.
b.
To show the skill of the designer of the spreadsheet.
d.
To explain the color of the text.
 

 25. 
Why would you want to change the font color of the cells?
a.
To help distract the reader viewing the spreadsheet.
c.
To help confuse the reader viewing the spreadsheet.
b.
To help the reader miss information.
d.
To help the reader differentiate between the sections.
 



 
         Start Over