Foundation of Information Technology - II

Foundation of Information Technology

Summative Assessment - II

Class- IX^th

^{code -165}

^{Time- 3hours                                                                                                                                                                                                     MM-90}

^{Part -A Fill in the blanks -                                                                                                                                                      10*1=10}

       ^{1- A _________ is a 'see through' picture or image more transparent than a than a} 

          ^Background.

       ^{2- The slide master is used to you make changes on ____________.}

       ^{3- ___________ view is an exclusive view of your slides in thumbnail from.}

   ^{4- ____________view is the main editing view of Power Point.}

   ^{5- A layout generally consists of ___________for different types of objects}

          ^{Or text.} 

       ^{6- Microsoft PowerPoint has _______main views.}

   ^{7- The blank space around the edges of the page are called ______ margins.}

   ^{8- _________ option are used in combination to copy text.}

   ^{9- _________ option are used in combination to move text.}

  ^{10- The ________option helps in canceling the previous changes made in document.}

^{Part-B Complete the Sentences -                                                                                                                              10*1=10              1- Formatting commands include fonts, _________}

   ^{2- Alignment is adjusting the text to fit with respect to the ______________.}

   ^{3-The alignment available are: ____________________________.}

   ^{4- Charts are a pictorial or graphical representation of number information on the}

      ^{_______________.}

   ^{5- A file in MS excel is called as a workbook by default named as ____________.}

   ^{6- A workbook is made up of many worksheets by default named as ___________ etc.}

       ^{7- The facility where excel will automatically fill contiguous cells values is called __________.}

       ^{8- The three basic forms of data that excel recognizes are: _____________.}

       ^{9- Performing addition of all numbers in a range without using a formula- _________.}

      ^{10- Breaking up of a single cell in a table into multiple cells is called __________-.}

^{Part-C Short answer type question--                                                                                                                    10*3=30}

      ^{1- How many types of indents. Give the name.}

  ^{2- Write the component name of MS Excel window.}

  ^{3- What is Spreadsheet?}

  ^{4- What is Merge Cells?}

  ^{5- What are Auto shapes?}

  ^{6- What are number formats in MS Excel?}

  ^{7- What are the different Paragraph Alignment possible in MS Word?} 

  ^{8- Explain some font styles available in MS Word.}

  ^{9- What is Presentation Software?} 

 ^{10- Explain the terms Cell, Cell Address, Cell pointer.}

^{Part- D Differentiate between-                                                                                                                                    5*2=10}

      ^{1- Workbook and Worksheet}

      ^{2- Splitting and merging of cells in a table}

      ^{3- Super script and Sub script}

      ^{4- Print layout and reading layout}

      ^{5- Header and Footer}

^{Part- E Name the menu in which the following sub menus found -                                                           5*1=5}

      ^{1- ________--- Picture --Auto shapes}

      ^{2- ________ --- Track changes}

      ^{3- ________--- spelling and grammar}

  ^{4- _________ --- Paragraph -- indents and spacing}

  ^{5- _________--- row - height}

^{Part- F Long Answer Type Question-                                                                                                                           5*3=15}

      ^{1- How many types of document view buttons and scroll bar.}

      ^{2- Cell A1 contains the number 20 and B1 contains 3 what will be the contents of cell C1 if the}

         ^{Formula=A1+B1*2 is entered in cell C1?}

      ^{3- How many types of Chart .Give the names.}

      ^{4- Write the components name of Chart.}

      ^{5- Describe a few features of MS Excel.}

^{Part- G Multiple choice Type Questions (Tick the correct option)                                    10*1=10}

       ^{1- Power point can be started from____________.}

  ^{A) Start menu           B) task bar                   C) recycle bin}

       ^{2- In how many different major views can you see your presentation?}

          ^{A) 1                                B) 3                              C) 6                             D) none of these}

       ^{3- _________ displays the name of the presentation.}

          ^{A) Status bar                  B) menu bar     C) tool bar        D) title bar}

       ^{4- ________ is used to create charts and graphs.}

  ^{A) Chart wizard        B) pivot table     C) pie chart   D) bar chart}

       ^{5- _____ are built in formula that do some specific operations.}

          ^{A) Formula                     B) function                   C) formatting    D) range}

       ^{6- Formulae start with ______ sign.}

          ^{A) equal sign(=)             B) /                               C) +}

       ^{7- A cursor in excel that indicates the current cell is}

      ^{A) Cell pointer                         B) cell reference          C) cell border}

   ^{8- In excel 2007 workbook are given _______ extension.}

      ^{A) .doc                                    B) . xls                                     C) .xlsx                                    D) .exlx} 

   ^{9- IN excel A to Z are used to number ______.}

      ^{A) Cells                                   B) rows                                    C) columns}

  ^{10- You can perform ________ using tables.}

      ^{A) Merging                  B) splitting                    C) insert rows D) All of these}