1. A
Sparkline is a little chart that helps people to see trends.
a. True
b. False
Tip: Intermediate Excel, page 178
2. Where is the command for Sparklines?
a. Insert-> Sparkline
b. Insert-> Chart-> Sparkline
c. View-> Sparklines
Tip: Intermediate Excel, page 178
3. Which is a type of Sparkline? (Select all correct answers)
a. Line
b. Column
c. Win/Loss
Tip: Intermediate Excel, page 180
4.
Sparklines have Styles
a. True
b. False
Tip: Intermediate Excel, page 181
5. A Sparkline chart has many of the formatting options of a regular
chart.
a. True
b. False
Tip: Intermediate Excel, page 184
6. Which is the way to rename a Spreadsheet? (Select all correct
answers)
a. Double-click the spreadsheet tab, then type a new name
b. Right click the tab and select Rename Sheet
Tip: Intermediate Excel, page 185
7. Which is
the command to insert a new sheet in a workbook?
(Select all
correct answers)
a. Home-> Cells-> Insert-> Insert sheet
b. Page Layout-> Insert-> Sheet
c. Right-click the sheet tabs and select Insert Sheet
Tip: Intermediate Excel, page 190
8. A hyperlink can link to which of the following (Select all correct
answers.)
a. A website
b. Another spreadsheet
c. A specific sheet in a workbook
d. An email address
Tip: Intermediate Excel, page 195