Latest Data Entry Operator / Computer Operator Jobs MCQs Sample Paper 2015-16 Complete Computer Science Syllabus for District and Session Courts Jobs NTS PPSC FPSC SPSC KPPSC Jobs MCQs Paper Must Prepare Now

  1. What does the VLOOKUP function do?
  1. Looks up text that contain ‘v’
  2. Checks whether text is the same in one cell as in the next
  3. Finds related records
  4. All of above
  1. Gridlines
  1. May be turned off for display but turned on for printing
  2. May be turned on or off for printing
  3. The be turned off for display and printing
  4. a, b and c
  1. You can print only an embedded chart by
  1. Moving the chart to a chart sheet before you print.
  2. Formatting the chart before you print
  3. Selecting the chart before you print
  4. a and c
  1. Which of the following is a correct order of precedence in a formula calculation?
  1. Multiplication and division, exponential positive and negative value
  2. Multiplication and division, positive and negative values, addition and subtraction
  3. Addition and subtraction, positive and negative values, exponentiation
  4. None of above
  1. A function inside another function is called a ….. function.
  1. Nested
  2. Round
  3. Sum
  4. Text
  1. How should you print a selected area of a worksheet, if you’ll want to print a different area next time?
  1. On the file menu, point to print area, and then click set print area.
  2. On the file menu, click print, and then click selection under print what
  3. On the view menu, click custom views, then click add
  4. All of above