MULTITECH

RSCIT

Exam Description: chapter-11, 12, 13
Total Questions : 35
Exam Duration: 30 minutes

• Question # 1: shift +f3 is used in ms-excel 2010 for:
  • A. inserting a image
  • B. inserting a function
  • C. inserting a sheet
  • D. none of the above

  Correct Answer: inserting a function

• Question # 2: The process of identifying specific rows and columns so that certain columns and rows are always visible on the screen is called ________.
  • A. Freezing
  • B. Locking
  • C. Selecting
  • D. Fixing

  Correct Answer: Freezing

• Question # 3: from which tab you can insert picture, text box and chart etc. in ms-powerpoint 2010?
  • A. file
  • B. edit
  • C. insert
  • D. view

  Correct Answer: insert

• Question # 4: ___ are used to incorporate text into a document that is repeated on each page.
  • A. Mail Merge
  • B. Bookmarks and Hyperlinks
  • C. Save and save as
  • D. Header and footer

  Correct Answer: Save and save as

• Question # 5: Which type of personal email account is typically used to download emails to your computer?
  • A. Microsoft Exchange
  • B. POP3
  • C. IMAP
  • D. HTTP

  Correct Answer: POP3

• Question # 6: what is the output of round (3.7544,2)?
  • A. 3.7
  • B. 3.75
  • C. 3.75
  • D. 3.7

  Correct Answer: 3.75

• Question # 7: A files name extension for MS-Word 2007 file is ___________.
  • A. .gif
  • B. .txt
  • C. .docx
  • D. .exe

  Correct Answer: .docx

• Question # 8: suppose you download an excel file from internet and you open in ms-excel 2010 it will first open in:
  • A. private view
  • B. public view
  • C. backstage view
  • D. protected view

  Correct Answer: public view

• Question # 9: extensions of excel 2003, excel 2007 and excel 2010 file are-
  • A. xlsx, xls and xlsx
  • B. docx, doc and docx
  • C. xls, xlsx and xlsx
  • D. xls, xls and xlsx

  Correct Answer: xls, xlsx and xlsx

• Question # 10: ______ bar contains several options such as page number, Word count, proof check etc. in MS-Word 2010.
  • A. Title
  • B. Status
  • C. Scroll
  • D. Task

  Correct Answer: Status

• Question # 11: How to create a uniform appearance by adding a background image to all slides?
  • A. Create a template
  • B. Edit the slide master
  • C. Use the auto correct wizard
  • D. All of the above

  Correct Answer: Edit the slide master

• Question # 12: Intersection of a row and column in a spreadsheet is called:
  • A. Rectangle
  • B. cell
  • C. range
  • D. box

  Correct Answer: cell

• Question # 13: which of the following option allows you to select more than one slide in a presentation?
  • A. alt+click each slide
  • B. shift+drag each slide
  • C. shift+click each slide
  • D. ctrl+click each slide

  Correct Answer: shift+click each slide

• Question # 14: how do you change column width to fit the contents in ms excel 2010?
  • A. single -click the boundary to the left to the column heading
  • B. double click the boundary to the right of the column heading
  • C. press alt and single click anywhere in the column
  • D. all of above

  Correct Answer: double click the boundary to the right of the column heading

• Question # 15: In ms word 2010, cut or copied text is stored on a temporary storage area called
  • A. Home Tab
  • B. Ribbon
  • C. Clipboard
  • D. Macro

  Correct Answer: Clipboard

• Question # 16: --------is the default name of the file created with ms-word 2010.
  • A. workbook1
  • B. worksheet1
  • C. document1
  • D. book 1

  Correct Answer: document1

• Question # 17: Flow charts are planning tools, generally used to represent:
  • A. An algorithm
  • B. A step by step process
  • C. Any logic
  • D. All of the above

  Correct Answer: All of the above

• Question # 18: ______ is the network of physical objects embedded with electronics, software, sensors, and network connectivity which enables the object to collect and exchange data over the cloud.
  • A. Li-Fi
  • B. Iot
  • C. Drone
  • D. MS-Word 2010

  Correct Answer: MS-Word 2010

• Question # 19: A “____” is a prewritten formula that performs calculation automatically in MS Excel.
  • A. Function
  • B. Equation
  • C. Template
  • D. Reaction

  Correct Answer: Function

• Question # 20: _______ is a way for Microsoft Word 2010 to keep track of the changes you make to a document .
  • A. Track changes
  • B. Bullets
  • C. Macros
  • D. Template

  Correct Answer: Template

• Question # 21: Which features of MS-Word 2010 is used for monitoring all document changes?
  • A. Edit Documents
  • B. Monitor Changes
  • C. Track Changes
  • D. Let‘s play

  Correct Answer: Track Changes

• Question # 22: the shortcut key for save as in microsoft word 2010 is-
  • A. f11
  • B. f12
  • C. f10
  • D. f 9

  Correct Answer: f12

• Question # 23: to insert hyperlinks in powerpoint presentation ,the shortcut key combination used is:
  • A. ctrl+j
  • B. ctrl+k
  • C. ctrl+m
  • D. shift+ctrl+z

  Correct Answer: ctrl+k

• Question # 24: Tiny charts embedded in a cell that give a visual trend summary alongside your data are :
  • A. Embedded charts
  • B. Sparklines
  • C. Chart styles
  • D. Borderline

  Correct Answer: Sparklines

• Question # 25: ........is used to insert decorative text in ms power point 2010:
  • A. word clip
  • B. word art
  • C. clip art
  • D. deco text

  Correct Answer: word art

• Question # 26: what is the correct formula to perform the addition of data present in a1to a5 cells?
  • A. =sum(a1:a5)
  • B. =sum(a5:a1)
  • C. =sum(a1,a2,a3,a4,a5)
  • D. all of the above

  Correct Answer: all of the above

• Question # 27: which type of software typically supports the computer to manage its internal resources ?
  • A. Application software
  • B. System software
  • C. Word processor
  • D. Presentation application

  Correct Answer: Presentation application

• Question # 28: portrait and landscape are:
  • A. page orientation
  • B. paper size
  • C. page layout
  • D. all of above

  Correct Answer: page orientation

• Question # 29: A new presentation can be created from
  • A. Blank Presentation
  • B. From Existing Presentation
  • C. From Design Template
  • D. All of the above

  Correct Answer: All of the above

• Question # 30: To enter a new paragraph into a document, press the ________ key.
  • A. CTRL
  • B. ALT
  • C. ESC
  • D. ENTER

  Correct Answer: ENTER

• Question # 31: in ms-excel, sqr (x) finds:
  • A. square of x
  • B. 2 raised to power x
  • C. square root of x
  • D. none of these

  Correct Answer: none of these

• Question # 32: The selected design tamplate can be applied–
  • A. To selected slides
  • B. To all the slides
  • C. To all the new presentation you create
  • D. All of above

  Correct Answer: All of above

• Question # 33: which of the shortcut key is used to activate spelling & grammar check in ms word 2010-
  • A. f7
  • B. f5
  • C. f9
  • D. shift+f7

  Correct Answer: f7

• Question # 34: _________ refers to moving away paragraph from left, right, or both margins.
  • A. Line spacing
  • B. Alignment
  • C. Indenting
  • D. Bulleted and Numbered list

  Correct Answer: Indenting

• Question # 35: which of the following is not a ms-powerpoint slide translation effect?
  • A. wipe right
  • B. dissolve
  • C. wedge
  • D. fly in

  Correct Answer: fly in