41. Evelyn wants to work on different parts of a workbook at the same time by displaying worksheets in separate windows. Which option on the View tab should she select?

	a.	Arrange All
	b.	New Window
	c.	Zoom
	d.	Page Break Preview

42. To create a workbook containing text, formulas, macros, and formatting that you use repeatedly, you create a _____.

	a.	master
	b.	model
	c.	template
	d.	standard

43. Joe wants to format several worksheets at the same time. What is the easiest way for him to perform this task?

	a.	Create a custom view of the worksheets.
	b.	Group the worksheets.
	c.	View the worksheets side by side.
	d.	Link the worksheets.

38. Which of the following can you do to make a chart title stand out on a chart?

a.

Change the text direction.

b.

Resize the chart.

c.

Display the title on the outside end of the data series.

d.

Increase the font size.

39. If you see a cells with blue fills of varying lengths representing the values, the cells most likely have ________ applied to them.

	a.	themes
	b.	icon sets
	c.	data bars
	d.	cell styles

31. Binay wants to create an X-Y scatter plot. To do so, he should select the data he wants to plot in the scatter chart, then click the Insert tab, and then click Insert Scatter (X, Y) or Bubble Chart.

	a.	True
	b.	False

33. Which of the following chart types show how two numeric data series are related to each other?

	a.	Pie
	b.	Bar
	c.	Line
	d.	Scatter

34. Niki wants to insert a Line sparkline in Excel. To do this, she can click on the cell she wants to insert a Sparkline, then click Insert tab, select Line Sparkline from the Sparklines group and then OK.

	a.	True
	b.	False