Test Yourself

 

 

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