In MS-Excel you can use the drag and drop method to
A. | Copy cell contents |
B. | Move cell contents |
C. | Add cell contents |
D. | (A) and (B) |
Option: D Explanation : Click on Discuss to view users comments. |
In MS-Excel which of the following is not a worksheet design criterion?
A. | Efficiency |
B. | Aditibility |
C. | Description |
D. | All of these |
Option: C Explanation : Click on Discuss to view users comments. |
In MS-Excel it is acceptable to let long text flow into adjacent cells on a worksheet when
A. | Data will be entered in the adjacent cells |
B. | No data will be entered in the adjacent cells |
C. | Both (a) & (b) |
D. | None of these |
Option: B Explanation : Click on Discuss to view users comments. |
In MS-Excel suppose you have columns of data that span more than one printed page. How can you automatically print the column headings on each page?
A. | Click page setup on the file menu, click the sheet tab, and enter the row that contains these column headings under print titles. |
B. | Click page setup on the file menu, click the page tab, click the options button, then enter your choices. |
C. | Click page setup on the file menu, click the sheet tab, and make a selection under the print heading. |
D. | All of above |
Option: A Explanation : Click on Discuss to view users comments. |
In MS-Excel a fast way to add up data in a column is to click in the cell below the numbers and then
A. | Click subtotals on the data menu |
B. | View the sum in the formula bar |
C. | Click the autosum button on the standard toolbar, then press enter |
D. | All of above |
Option: C Explanation : Click on Discuss to view users comments. |