MS excel set 1 Detailed Explanation And More Example

Question : 1

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 : 2

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 : 3

In Excel the following describes how to select all the cells in a single column?

a) Use data – text to columns menu item

b) Right click on column and select Pick from list

c) Pressing Ctrl + A on the keyboard

d) Left click on the gray column title button

Question : 4

In Excel when you use the fill effects in the format data series dialog box, you cannot

a) Select a fore ground color

b) Select a pattern

c) Select a background color

d) Rotate text on the chart

Question : 5

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 : 6

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

a) Auditability

b) Efficiency

c) Clarity Correct Answer:

d) Description