System-Wide Exam Paper Format s1

Answer Key

Circle the correct answer.

Refer to the figure shown below and answer questions 1 to 3

1. Which items can be used in MS Excel to insert Header and footer?

A. / Item 1
√ / B. / Item 2
C. / Item 3
D. / Both Item 1 and Item 2

REF: Formatting the Page Layout- Page 320- Week 7- Comprehension- Locate

2. Which item you can select to have the default Zoom setting?

A. / Item 3
B. / Item 4
√ / C. / Item 5
D. / Both Item 3 and 5

REF: Managing Worksheets- Page 3.5- Week 7-Comprehension- recognize

3. Which item can be used to lock columns and/or rows so you can keep an area visible as you scroll through the worksheet?

A. / Item 4
B. / Item 5
C. / Item 6
√ / D. / Item 7

REF: Freezing Rows and Columns- Page 306- Week 7- Comprehension- recognize

4. Refer to the figure shown below and answer questions 4 to 8

What are the required steps to create item 3 and 5?

A. / Click the split box on the vertical scroll bar-> drag the split box
B. / Click the split box on the horizontal scroll bar-> drag the split box
√ / C. / Click “View” tab-> click split button
D. / All of the above
E. / None of the above

REF: Freezing Rows and Columns- Page 306- Week 7-Application- Relate

5. Which item used to create a new sheet?

A. / Item 1
B. / Item 2
C. / Item 3
√ / D. / Item 4

REF: Working with Multiple Worksheet- Page 308- Week 7-Knowledge

6. Which of the following steps can be used to remove the divided lines shown in item 3 and 5?

A. / Double-click the dividing line
B. / Right click the dividing line-> Remove
C. / Click “View” tab-> Toggle off the split button
√ / D. / Both A and C

REF: Freezing Rows and Columns- Page 306- Week 7-Knowledge

7. Which of the following is true about item 1?

A. / The print area is modified and identified with broken line border
B. / The print area can be extended
C. / Print area setting is saved with the workbook.
√ / D. / All of the above

REF: Customizing Print Options- Page 323- Week 7-Knowledge

8. You can print the row and/or column headings on every page by modifying the settings on which item?

A. / Item 1
√ / B. / Item 2
C. / Item 3
D. / Item 4

REF: Customizing Print Options- Page 323- Week 7-Knowledge

9. Which view shows exactly how the worksheet will print?

A. / Normal View
B. / Page layout view
√ / C. / Page Break Preview
D. / Full screen

REF: Managing worksheets- Page 304- Week 7-Knowledge

10. What are the required steps to print Row and column headings as shown in the figure bellow?

A. / Click “Page Layout” tab-> Print Titles from page setup group-> check row and column headings
B. / Click “Page Layout” tab-> Click page setup launcher-> select sheet tab -> check row and column headings
C. / Click “Page Layout” tab-> Click page setup launcher-> select Margin tab -> check row and column headings
√ / D. / Both A and B

REF: Customizing Print Options- Page 323- Week 7-Application- Practice

11. Refer to the figure bellow to identify Item 1 is inserted as a ______.

A. / Current Time
√ / B. / Field
C. / Footer
D. / Sheet Name

REF: Adding a Header and a Footer- Page 323- Week 7-Application- Practice

12. Which of the following statements is not true?

A. / By default the gridlines appear on screen in worksheets but they do not appear when the worksheets are printed.
B. / Print Gridlines check box is located in the Sheet Option group on the Page Layout tab
√ / C. / Gridlines appear on the screen in a worksheet, but they cannot be printed.
D. / All of the above statements are correct.

REF: Customizing Print Options- Page 323- Week 7-Application- Practice

13. You can base a sort on how many different columns?

A. / One Column
B. / Tow Columns
√ / C. / Three Columns
D. / Four columns

REF: Sorting and Filtering Data- Page 318- Week 7-Knowledge- Know

Refer to the figure shown below and answer questions 14 to 15

14. According to which column the table is filtered?

√ / A. / End of Billing Period
B. / Amount Paid
C. / Percent Increase/ Decrease
D. / Utility Billing History for 2012

REF: Sorting and Filtering Data- Page 318- Week 7-Application- Practice

15. How many rows will be hidden?

A. / 9 rows
B. / 10 rows
√ / C. / 11 rows
D. / 12 rows

REF: Sorting and Filtering Data- Page 318- Week 7-Application- Practice

16. The following figure refers to______dialog box.

A. / Custom AutoSort
√ / B. / Custom Autofilter
C. / Setup
D. / Sort

REF: Sorting and Filtering Data- Page 318- Week 7-Application- Practice

17. What are the steps required to change the page orientation from Portrait to Landscape?

A. / Click "Page Layout" tab-> Click the "Orientation" button -> select Portrait
B. / Right Click in the worksheet -> Click “Orientation” -> select the required Orientation
√ / C. / Click "Page Layout" tab-> Click the "Orientation" button -> select Landscape
D. / Click the "View" tab -> Click the costume view -> select Landscape

REF: Formatting the Page Layout- Page 320- Week 7-Application- Practice

18. The information provided in the header and footer fields is obtained from______?

A. / The workbook properties.
B. / The application
C. / System settings
√ / D. / All of the above

REF: Adding a Header and a Footer- Page 322- Week 7- Knowledge- Know

19. Which button is used to copy and apply font and paragraph formatting?

A. /
√ / B. /
C. /
D. /

REF: Formatting Cell Contents- Page 310- Week 7- Knowledge- Know

Refer to the figure shown below and answer question 20

20. Which item is used to wrap the contents inside the cell?

A. / Item 1
√ / B. / Item 2
C. / Item 3
D. / Both Item 1 and 2

REF: Formatting Cell Contents- Page 310- Week 7- Knowledge- Know

Page 8 of 8