Computer Based Training: …, Windows 95 & NT Basics/a1454501.iso/msoae/AE03Q.TXT

Text File | 1997-03-26 | 10.8 KB | 567 lines

@@QUES 030101 SXY Q,210,406,220,318
Which rows do you think row 7 summarizes?
|
Choose an option.
|
4, 5, and 6
8, 9, and 10
|

|
1
|
That's right.
|
That's not it. The correct option is now highlighted.
|
The correct option is now highlighted.

@@QUES 030102 GD1 Q,125,379,247,183
Click the button that you think hides rows 4, 5, and 6.
|
Click an button.
|
0301021,(187,-1,16,20)
|

|
That's it.
|
0301022,(50,-1,189,79)
|
You haven't clicked the correct button. Try again.
|
In fact, it's the hide detail button.
|
The correct button is now indicated.

@@QUES 030103 FIB Q,328,341,263,221
To group the data on the sheet so that you can choose to display only the grand totals in row 20, you first select rows 4 to __.
|
Type the missing number.
|

|
19
|
That's right.
|

|
Yes, but the word used here is "".
|

|
Try again.
|

|

|
That's not the number required here. Try again.
|
The missing number is "19".
|
The full statement is now shown.
|
@@QUES 030104 T/F Q,202,452,288,282
Do you think the following statement is true or false?

If you click the 1 level button, all the detail on the sheet is displayed.
|
2
|

|
That's right.
|
Actually, the statement is false.
|
The statement is false.
|
@@QUES 030105 SXY Q,355,453,275,389
Excluding row 20, which do you think are the summary rows in the 1997 Sales Report sheet?
|
Choose an option.
|
Rows 4, 8, 12, and 16
Rows 7, 11, 15, and 19
All the rows containing numbers, other than rows 7, 11, 15, and 19
All the rows containing numbers, other than rows 4, 8, 12, and 16
|

|
2
|
That's right.
|
That's not it. The correct option is now highlighted.
|
The correct option is now highlighted.

@@QUES 030201 GD1 Q,18,198,301,177
Click the menu option that you think you need to select to consolidate data.
|
Click a menu.
|
0302011,(167,231,147,19)
|

|
That's it.
|
0302012,(21,231,147,146),0302013,(186,231,148,100)
|
You haven't clicked the correct menu. Try again.
|
In fact, it's Consolidate.
|
The correct menu is now indicated.

@@QUES 030202 SXY Q,291,352,315,272
What do you think you specify in the Reference field?
|
Choose an option.
|
The cell that you want to contain the consolidated data
The cells that contain the data you want to consolidate
|

|
2
|
That's right.
|
That's not it. The correct option is now highlighted.
|
The correct option is now highlighted.
@@QUES 030203 GD1 Q,18,246,281,220
Click the button that you think you now need so that the reference in the Reference field is used when you consolidate data.
|
Click a button.
|
0302031,(234,340,83,34)
|

|
That's it.
|
0302032,(134,340,85,91),0302033,(268,340,89,34)
|
You haven't clicked the correct button. Try again.
|
In fact, it's the ^UAdd^u button.
|
The correct button is now indicated.

@@QUES 030204 T/F Q,47,389,309,350
Do you think the following statement is true or false?

Cells B4, B5, and B6 now contain the values in the B4 cells on each of the other sheets in the workbook.
|
1
|

|
That's right.
|
In fact, they do.
|
The statement is true.

@@QUES 030205 SXY Q,275,445,350,379
Suppose you want to use the row and column labels on the NE Budget sheet to organize the data on the consolidation sheet.
Which cell is the first cell of the range you need to select on the NE Budget sheet?
|
Choose an option.
|
^UB4^u
^UB3^u
^UA3^u
^UA4^u
|

|
3
|
That's right.
|
That's not it. The correct option is now highlighted.
|
The correct option is now highlighted.

@@QUES 030206 SXY Q,277,458,350,384
What do you think happens if the labels on the source sheets are different?
|
Choose an option.
|
Excel uses only the labels common to all the source sheets to consolidate data
Excel uses none of the labels on the source sheets to consolidate data
Excel assigns a separate row or column to each label selected on any of the source sheets when consolidating data
|

|
3
|
That's right.
|
That's not it. The correct option is now highlighted.
|
The correct option is now highlighted.

@@QUES 030401 T/F Q,325,429,234,287
Do you think the following statement is true or false?

The window will now be split into two separate panes.
|
1
|

|
That's right.
|
In fact, the statement is true.
|
The statement is true.
|
@@QUES 030402 Y/N Q,205,312,241,260
Do you think you can still scroll to a new position within the top and left-hand panes?
|
1
|

|
You're right.
|
In fact, you can.
|
The answer is Yes.
|
@@QUES 030403 GD1 Q,6,302,249,227
Click the menu option that you think you now need to select to prevent scrolling in the top and right-hand panes.
|
Click a menu.
|
0304031,(126,264,115,24)
|

|
That's it.
|
0304032,(21,265,114,105),0304033,(150,264,116,32)
|
You haven't clicked the correct menu. Try again.
|
In fact, it's Freeze Panes.
|
The correct menu is now indicated.

@@QUES 030404 GD1 Q,39,367,320,198
Click the button in the Standard toolbar that you think you need to click to view a print preview.
|
Click a button.
|
0304041,(23,105,27,25)
|

|
That's it.
|
0304042,(22,6,99,26),0304043,(23,132,507,52)
|
You haven't clicked the correct button. Try again.
|
In fact, it's the ^UPrint Preview^u button.
|
The correct button is now indicated.

@@QUES 030405 SXY Q,238,457,378,395
Why do you think you cannot see all of the sheet in the preview?
|
Choose an option.
|
The sheet is too large to fit on a single page
You need to remove the split bars from the sheet before viewing the preview
You need to freeze the panes on the sheet before viewing the preview
Only the part of the sheet that was visible when you clicked the ^UPrint Preview^u button is displayed in the preview
|

|
1
|
That's right.
|
That's not it. The correct option is now highlighted.
|
The correct option is now highlighted.


@@QUES 030406 GD1 T,230,418,275,198
Click the button that you think will change the way that the sheet is divided into pages.
|
Click a button.
|
0304061,(1,337,109,24)
|

|
That's it.
|
0304062,(1,448,107,24),0304063,(1,2,333,27)
|
You haven't clicked the correct button. Try again.
|
In fact, it's the ^UPage Break Preview^u button.
|
The correct button is now indicated.

@@QUES 030407 MXY Q,279,453,350,350
Which of the following columns do you think will now be displayed on the first page of the print preview?
|
Choose each appropriate item.
|
The July column
The June column
The Total column
|

|
2
|
That's right.
|
Partly right. The only correct option is now highlighted.
|
You have not made any correct choices. The only correct option is now highlighted.
|
The only correct option is now highlighted.

@@QUES 030101t MXY Q,0,0,320,350
Suppose that row 5 on a sheet contains the totals of the values in rows 2, 3, and 4.

Which rows do you need to select to create an outline for rows 2 to 5?
|
Choose each appropriate item.
|
^U2^u
^U3^u
^U4^u
^U5^u
|
1,2,3
|
20
|
Correct.
|
5 per correct decision
|
Partly right. The correct options are now highlighted.
|
You have not made any correct choices. The correct options are now highlighted.

@@QUES 030102t SXY Q,0,0,305,350
Identify the menu that contains options that allow you to outline sheets.
|
Choose an option.
|
^UEdit^u
^UFormat^u
^UData^u
^UWindows^u
|
3
|
20
|
Correct.
|
Incorrect. The correct option is now highlighted.

@@QUES 030103t SXY Q,0,0,280,364
Suppose an outlined sheet displays four row level symbols.

Which symbol do you need to click to display all the rows on the sheet?
|
Choose an option.
|
^U1^u
^U2^u
^U3^u
^U4^u
|
4
|
20
|
Correct.
|
Incorrect. The correct option is now highlighted.

@@QUES 030104t T/F Q,0,0,382,284
The ^UClear Outline^u option in the ^UGroup and Outline^u submenu removes only the last outline symbol added to a sheet.
|
2
|
10
|
Correct.
|
Incorrect. It removes all outline symbols from a sheet. The statement is false.

@@QUES 030105t T/F Q,0,0,352,303
To outline a sheet automatically, the sheet must contain rows and columns that summarize the data in other rows and columns.
|
1
|
10
|
Correct.
|
Incorrect. The statement is true.

@@QUES 030201t SXY Q,0,0,235,350
Which menu do you need to select to consolidate data?
|
Choose an option.
|
^UView^u
^UInsert^u
^UFormat^u
^UTools^u
^UData^u
|
5
|
20
|
Correct.
|
Incorrect. The correct option is now highlighted.

@@QUES 030202t SXY Q,0,0,350,370
Suppose you want to consolidate the data on a set of sheets so that you can view the number of items in the source data.

Which worksheet function do you need to use to consolidate the data?
|
Choose an option.
|
^USum^u
^UCount^u
^UAverage^u
^UProduct^u
|
2
|
20
|
Correct.
|
Incorrect. The correct option is now highlighted.

@@QUES 030203t T/F Q,0,0,274,298
When you consolidate data, Excel automatically adds outline symbols to the consolidation sheet.
|
1
|
10
|
Correct.
|
Incorrect. The statement is true.

@@QUES 030204t T/F Q,0,0,350,350
When you use the row and column labels on source sheets to consolidate data, Excel only uses the labels that are common to all the source sheets.
|
2
|
10
|
Correct.
|
Incorrect. The statement is false.

@@QUES 030401t T/F Q,0,0,294,264
When you split a window, all the new panes are automatically frozen.
|
2
|
10
|
Correct.
|
Incorrect. The statement is false.

@@QUES 030402t MXY Q,0,0,384,383
Suppose you have split a window into four panes.

If you select ^UFreeze Panes^u from the ^UWindow^u menu, which panes have their scroll bars removed?
|
Choose each appropriate item.
|
The top right pane
The top left pane
The bottom right pane
The bottom left pane
|
1,2,4
|
28
|
Correct.
|
7 per correct decision
|
Partly right. The correct options are now highlighted.
|
You have not made any correct choices. The correct options are now highlighted.

@@QUES 030403t MXY Q,0,0,350,350
If the first page of a print preview does not display all of the sheet that you want to print, what could be the reason?
|
Choose each appropriate item.
|
Page breaks have been inserted into the sheet
The window for the sheet has been split into panes
The sheet is too large to fit on a single page
|
1,3
|
21
|
Correct.
|
7 per correct decision
|
Partly right. The correct options are now highlighted.
|
You have not made any correct choices. The correct options are now highlighted.

@@QUES 030404t SXY Q,0,0,300,350
Which of the following represents a page break in a page break preview?
|
Choose an option.
|
A black, dotted line
A blue line
A red line
|
2
|
20
|
Correct.
|
Incorrect. The correct option is now highlighted.

@@QUES 030405t T/F Q,0,0,295,277
You can move a page break when you are viewing a page break preview.
|
1
|
10
|
Correct.
|
Incorrect. The statement is true.