Question 1 (1 point)
Joe wants to format several worksheets at the same time. What is the easiest way for him to perform

this task?

 a
Group the worksheets.
 b
Link the worksheets.
 c
Create a custom view of the worksheets.
 d
View the worksheets side by side.
Question 2 (1 point)
When you arrange windows in a Vertical or Side by Side layout, you can use synchronized _____ to more easily compare the two worksheets.

 a
Grouping
 b
Inking
 c
Scrolling
 d
Updating
Question 3 (2 points)
When you use the Arrange All button to arrange more than one workbook window, which of the following layout options can you use? Select all the options that apply.

 a
Vertical
 b
Scrolling
 c
Tiled
 d
Cascade
Question 4 (2 points)
The expression Overview!D12 is a    reference to cell D12 on the Overview worksheet.

Blank 1: 
Question 5 (1 point)
To ungroup worksheets after grouping them and working on them simultaneously, right-click any worksheet tab in the group and click Ungroup Sheets.

 True
 False
Question 6 (1 point)
Ricki has an Analysis workbook containing many worksheets of sales data that she wants to use in a new workbook. What is the easiest way for her to use the sales data in the new workbook?

 a
Hide the worksheets in the Analysis workbook.
 b
Copy the worksheets from the Analysis workbook to the new workbook.
 c
Insert hyperlinks from the Analysis workbook to the new workbook.
 d
Copy the cells containing sales data to the new workbook.
Question 7 (1 point)
How does Excel indicate that worksheets are grouped? Select all the options that apply.

 a
The sheet tab names are bold.
 b
The word "Group" is added to the sheet tab names.
 c
The word "Group" is added to the title bar.
 d
The word "Group" appears in large letters in the background of each worksheet.
Question 8 (1 point)
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
Link the worksheets.
 c
View the worksheets side by side.
 d
Group the worksheets.
Question 9 (2 points)
Which of the following are external references? Select all the options that apply.

 a
'[Annual Sales.xlsx]January'!A14
 b
[Sales.xlsx]Jan:March!A14
 c
[Sales.xlsx]January!A14
 d
January!A14
Question 10 (1 point)
Before Barry inserts new formulas in the range A5:F5, he wants to clear the cell contents. How can he do so?

 a
Drag the fill handle from cell A5 to cell F5.
 b
Select the range and then press DELETE.
 c
Select the range and then click Clear on the AutoFill Options menu.
 d
Select the range and then click the Clear Formats button.
Question 11 (1 point)
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
New Window
 b
Arrange All
 c
Page Break Preview
 d
Zoom
Question 12 (1 point)
After beginning a formula, what can you do instead of typing the syntax of a 3-D reference?

 a
Use the fill handle to select the external range.
 b
Copy a sheet tab and then press CTRL+V to paste it in the formula.
 c
Click a sheet tab, click a cell range, and then press ENTER.
 d
Click the Enter button on the formula bar, click a sheet tab, and then click a cell range.
Question 13 (1 point)
Which of the following is a simpler way to write the following formula: June!C5+July!C5+Aug!C5?

 a
[June-Aug]!C5
 b
June:Aug+C5
 c
June:Aug!C5
 d
(June:Aug), C5
Question 14 (1 point)
What happens when you click the sheet tab of a worksheet not included in a worksheet group?

 a
The worksheet grouping does not change.
 b
You add the worksheet to the group.
 c
You create a new group of the first and last worksheets.
 d
You ungroup the worksheets.
Question 15 (1 point)
Lucinda wants to apply conditional formats to three worksheets that have the same structure. She can apply the conditional formats to the three worksheets at the same time by grouping the worksheets. 

 True
 False