EXCEL

1.      While printing the result sheet of your class you find that one column is getting printed onto the next page, you want the complete result on a single sheet. Which one of the following actions should you perform in the Page Setup dialog box to print the Remarks column of the report card?

    1. Decrease the values in the Top, Bottom, Left and Right boxes on the Margins tab
    2. Change the orientation to Portrait on the Page tab
    3. Change the paper size to Legal on the Page tab
    4. Change the orientation to Landscape on the Page tab

2.      To arrange the marks of your students in the result sheet in descending order which one of the following features should you use for the purpose?

a.      Filter

b.      Sort

c.      Autofill

d.      Validation

3.     Sheena wants to calculate the area of a rectangle for the length and breadth values in the cells B4 and C4 respectively. Which one of the following formulae should Sheena use for the purpose?

a.      =B4*C4

b.      =*(B4*C4)

c.      =(B4 X C4)

d.      =1/2(B4*C4)

4.  You want to show the subject wise performance of your class. Which one of the following types of charts is best suited for the purpose?

a.      Pie chart

b.      3-D Surface chart

c.      Radar chart

d.      Scatter chart

 

5.      While printing the quiz results maintained in excel , Raju wants the contents to be printed in the middle of the page . Which one of the following actions should Raju perform in the Page Setup dialog box?

    1. Change the orientation to Portrait in the Page tab
    2. Change the paper size to Legal in the Page tab
    3. Change the orientation to Landscape in the Page tab
    1. Select Vertically under Centre on page in the Margins tab

      

6.      Ramesh has kept the data about the population of countries in in a worksheet, in one column he has put the names of countries and in the other he has kept the population numbers, when he selects the Population column and click the Sort Ascending button on the Standard toolbar, the Population column is sorted leaving the Country column unchanged. What could be the reason? What could be the reason?

a.      You would have selected Population under Sort by in the Sort dialog box

b.      You would have selected Country under sort by and selected Population under Then by in the Sort dialog box

c.      You would have selected the Continue with the current selection command in the Sort Warning dialog box

d.      You would have selected the Expand the selection command in the Sort Warning dialog box

 

7.      Amit, a clerk is calculating the salary of the employees , he uses a formula to calculate the Net salary He then copies the same formula and pastes it in all the cells to calculate the Net Salary for all the employees.. He later observes that a few cells in the Total column hold the message #VALUE instead of numbers. What could be the reason?

a.      One or more cells in the selected range do not contain numeric data

b.      One or more cells is empty

c.      The correct range of cells are not selected

d.      The formula should be independently typed in all the cells

8.      Prakash wants to show the performance of class in different subjects in the final exams. She creates a worksheet with average marks for each subject.. She wants to represent the data in the worksheet as a chart. Which one of the following types of charts is best suited for the purpose?

a.      Area chart

b.      Column chart

c.      Scatter chart

d.      Radar chart

    9.   Your report is more than one page. You wants the page numbers and the worksheet name to appear at the bottom of every page. Which one of the following commands should you use for the purpose?

    1. Header
    2. Footer
    3. Rows to repeat at top

d.      Columns to repeat at left

 

    10. Amit, a clerk wants to know the names of the employees who have salary more than Rs 10000.. Which one of the following features should Amit use for the purpose?

a.      Sort

b.      AutoFill

c.      Validation

d.      Filter

 

11. Nisha enters the salary of all the employees in the cells C5 to C35 .  She wants to find the total number of employees who have salary more than 5000. Which one of the following options should Nisha use for the purpose?

a.      COUNT(C5:C35; >5000)

b.      COUNT(C5:C35; “>5000”)

c.      COUNTIF(C5:C35, >5000)

d.      COUNTIF(C5:C35, “>5000”)

 

 

BACK TO HOME PAGE

 

 

     

Hosted by www.Geocities.ws

 1