MS excel set 3 Detailed Explanation And More Example

Question : 1

In a report, you need to show the monthly rainfall in Nepal. The best way to do this is to insert a

a) calendar

b) photograph of rainfall

c) chart showing rainfall amounts

d) data base of rainfall

e) None of these

Question : 2

You can auto fit the width of column by

a) double clicking on the column name or-column header

b) Double click on the cell pointer in worksheet

c) Double clicking on column right border on column header

d) Double clicking on the column left border of column header

e) None of these

Question : 3

In Excel without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?

a) Press Ctrl +Home

b) Press Home

c) Press Shift + Home

d) Press Alt + Home

Question : 4

You can create only a horizontal page break by first selecting

a) A row below the row where you want the page break to occur

b) A cell in row 1

c) A cell in column A

d) a and c

e) None of these

Question : 5

How do you rearrange the data In ascending or descending order?

a) Data, Sort

b) Data, Form

c) Data, Table

d) Data Subtotals

e) None of these

Question : 6

Which of the following is the latest version of Excel

a) Excel 2000

b) Excel 2002

c) Excel ME

d) Excel XP

e) None of these