MS excel set 1 Detailed Explanation And More Example

Question : 1

In Excel when you group worksheets

a) You can enter common data, formats, and formulas on multiple worksheets at one time

b) You can print more than one worksheet at a time

c) You can enter variable data on multiple worksheets at one time

d) (B) and (C)

Question : 2

In 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 page tab, click the options button, then enter your choices.

b) Click page setup on the finle menu, click the sheet tab, and make a selection under the print heading.

c) Click page setup on the file menu, click the sheet tab, and enter the row that contains these column headings under print titles

d) All of above

Question : 3

There are three types of data found in a spreadsheet

a) numbers formulas, labels

b) words, numbers, labels

c) equations, data, numbers

d) data, words, numbers

Question : 4

In Excel you can edit a cell by

a) Selecting Edit>Edit Cell from the menu

b) Clicking the formula button

c) Double clicking the cell to edit it in-place

d) None of above

Question : 5

In Excel which of the following is not a worksheet design criterion

a) Auditability

b) Efficiency

c) Clarity Correct Answer:

d) Description

Question : 6

In Excel you can convert existing excel worksheet data an charts to an HTML document by using

a) Import wizard

b) Intranet wizard

c) Internet assistant wizard

d) FTP wizard