STS Office Assistant Past Paper 01 03 2020 MCQs

STS Office Assistant Past Paper 01 03 2020 MCQs for preparation. ( MCQs PPSC OTS )

How many paragraphs are there in the Lahore Resolution?

  1. 2
  2. 5
  3. 3
  4. 7

Which one is the most suitable reason to use Macro in MS Office (Word, Excel, PPT, etc) ?

  1. To Record Mouse Move
  2. To Record Sound
  3. To automate repetative tasks
  4. None

To go to a specific location in a document, we use:

  1. Macro
  2. Bookmark
  3. HTML
  4. WWW
  5. None of these

synonym of prone

  1. Liable
  2. Inclined
  3. Attracted
  4. Sure

What is gutter margin in MS word ?

  1. Margin that is added to the Left margin when printing
  2. Margin that is added to the binding side of page when printing
  3. Margin that is added to the right margin when printing
  4. none of these

How many characters can be typed in a single cell in Excel ?

  1. 256
  2. 1024
  3. 32767
  4. 65535

computer is free from tiresome and board room we call it

  1. programmability
  2. versatility
  3. diligence
  4. reliability

Which city connects two continents?

  1. Hawaii
  2. Tbilisi
  3. Sydney
  4. Istanbul

What is the maximum font size you can apply for any character in Ms Word?

  1. 1638
  2. 1636
  3. 1645
  4. 1600

Minim and maximum font size in MS Word :

  1. 8-72
  2. 6-60
  3. 12-50
  4. 8-96

Which of these key are used to apply outline border to the selected cell in MS Excel?

  1. CTRL+SHIFT+ %
  2. CTRL+SHIFT+ &
  3. CTRL+SHIFT+ ~
  4. CTRL+SHIFT+ $

Office 365 is now the most popular cloud application in the world. But when did it debut?

  1. 2011
  2. 2010
  3. 2008
  4. None

Which feature is used to make selected sentence to All Captital Letters or All Small Letters ?

  1. Change case
  2. Change letter
  3. Change sentence
  4. Change word

What type of chart will you use to compare performance of sales of two products ?

  1. Pie Chart
  2. Line Chart
  3. Column Chart
  4. None

A feature that displays only the data in column (s) according to specified criteria

  1. Filtering
  2. Sorting
  3. Formula
  4. None

Which of following is not a valid data type in MS Excel ?

  1. Number
  2. character
  3. label
  4. Date/Time

The parliament of Srilanka is called:

  1. Federal Congress
  2. People’s Congress
  3. Parliament
  4. National Congress

To insert Page Break we press:

  1. Ctrl + Tab
  2. Ctrl + Enter
  3. Ctrl + Alt
  4. Ctrl + Shift

Which of the following is not a worksheet design criterion?

  1. Efficiency
  2. Aditibility
  3. Description
  4. Clarity

You want to track the progress of the stock market on a daily basis. Which type of chart should you use?

  1. Pie chart
  2. Row chart
  3. Line chart
  4. Column chart

What do you call a single point on a computer screen

  1. Cell
  2. Element
  3. Pixel
  4. Point

The only land locked country in Southeast Asia is___?

  1. North korea
  2. China
  3. Vietnam
  4. Loas

Which of the following countries embroidery was added to UNESCO cultural heritage list?

  1. Iran
  2. Pakistan
  3. Palestine
  4. Iraq
  5. Afghanistan

Which key is used to enter the current date in Excel?

  1. Ctrl+:
  2. Ctrl+Shift:
  3. Ctrl+;
  4. None of these

In MS Office a feature that saves the document automatically after certain intervals is called :

  1. Save
  2. Save As
  3. Auto save
  4. None of the above

Which one is an INPUT device?

  1. Floppy Disk
  2. Mouse
  3. Monitor
  4. Speakers

Getting data from a cell located in a different sheet is called

  1. Accessing
  2. Referencing
  3. Updating
  4. none

Put the top back ___ the bottle

  1. on
  2. of
  3. to
  4. with

The kitchen was infested —– ants

  1. with
  2. by
  3. to
  4. in

What type of chart is useful for comparing values over categories?

  1. Line Chart
  2. Column Chart
  3. Pie Chart
  4. None

Which of the following is the fastest?

  1. CPU
  2. magnetic tapes and disks
  3. video terminal
  4. sensors, mechanical controllers

What is a way for me to keep all my data organized in google drive .

  1. Name your documents
  2. Place documents and form in folder
  3. Color code your folders
  4. All

which google app for education allows me to customize and collect different types of data and view in a spreadsheet .

  1. google slide
  2. Google Docs
  3. Google forms
  4. Google sheets

John the ripper is a tool to

  1. Crack passwords
  2. Grab web banner
  3. Do nothing
  4. None

GAFE stands for

  1. Google Apps for Education
  2. Google Apps for Expirements
  3. Google Add for Education
  4. None

Which of the following is not of the merge process?

  1. Preview the merge results
  2. Format a main document
  3. Edit a data source
  4. Identify the main document

Which is the relatively most secure cipher

  1. OTP
  2. Vernam
  3. Real fence
  4. Caesar

In chart wizard, term data series refers to

  1. A chart legend
  2. A collection of chart data markers
  3. A data label
  4. None

In chart wizard, term data categories refers to

  1. A chart plot area
  2. A horizontal axis
  3. The data range that supply chart data
  4. None

When you want to insert a blank embedded excel object in a word document you can

  1. Click the object command on the insert menu
  2. Click the office links button on the standard toolbar
  3. Click the create worksheet button on the formatting toolbar
  4. Click the import excel command on the file menu

Excel worksheet cells work very similarly to what common element of the windows graphical user interface

  1. Option buttons
  2. List boxes
  3. Text boxes
  4. Combo boxes

Which of the following options is not located in the Page Setup dialog box?

  1. Page Break Preview
  2. Page Orientation
  3. Margins
  4. Headers and Footers

Which of the following is a correct order of precedence in formula calculation?

  1. Multiplication and division exponentiation positive and negative values
  2. Multiplication and division, positive and negative values, addition and subtraction
  3. Addition and subtraction, positive and negative values, exponentiation
  4. None

Rounding errors can occur

  1. When you use multiplication, division, or exponentiation in a formula
  2. When you use addition and subtraction in a formula
  3. Because excel uses hidden decimal places in computation
  4. When you show the results of formulas with different decimal places that the calculated results

A Function inside another Function in called

  1. Text function
  2. Sum function
  3. Round function
  4. Nested function

When you link data maintained in an excel workbook to a word document

  1. The word document contains a copy of the actual data
  2. The word document must contain a hyperlink
  3. The word document contains a reference to the original source application
  4. The word document cannot be edit

What type of chart is good for single series of data ? Column Chart Line Chart

  1. Pie Chart
  2. Line Chart
  3. Column Chart
  4. None

Which of the following formulas MS-Excel 2016 will not be able to calculate? =SUM (AI: A5)*.5, =SUM (Sales)-A3, =SUM( AI: A5)/(10-10), =SUM(AI:A5)-10

  1. =SUM (AI: A5)*.5
  2. =SUM (Sales)-A3
  3. =SUM( AI: A5)/(10-10)
  4. =SUM(AI:A5)-10

What are inserted as cross-reference in Word ?

  1. Word fields
  2. Objects
  4. Placeholders

Leave a comment