STS Office Assistant Past Paper 01-03-2020

Q41: 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

=SUM (AI: A5)*.5

=SUM (Sales)-A3

=SUM( AI: A5)/(10-10)

=SUM(AI:A5)-10

Q42: synonym of prone

Liable

Inclined

Attracted

Sure

Q43: Put the top back ___ the bottle

on

of

to

with

Q44: She has cigarette ___ her lips

between

in

from

none

Q45: By nature we are humans are liable to make mistake. We are volunerable to evils and temptation and prone to ignore genral rules, ethical codes.Of people of all age groups, the youth comprising majority of population are most inclined to make mistakes. they are attempt to commit morally bad deeds. They disobey their parents, and do not feel ashmed of their misbehavior Synonym of Vulnerable is

Easy

Flexible

Weak and easily hurt

None

Q46: I leapt ___ the chance to go to France

for

to

at

about

Q47: The two sides are locked ___ a bitter dispute .

by

with

in

into

Q48: In chart wizard, term data series refers to ______?

چارٹ وزرڈ میں، اصطلاح ڈیٹا سیریز سے مراد کیا ہے؟

A chart legend

A collection of chart data markers

A data label

None

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

Option buttons

List boxes

Text boxes

Combo boxes

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

دو مصنوعات کی فروخت کی کارکردگی کا موازنہ کرنے کے لیے آپ کس قسم کا چارٹ استعمال کریں گے؟

Pie Chart

Line Chart

Column Chart

None

STS Office Assistant Past Paper 01-03-2020

Q41: 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

Explanation

Q42: synonym of prone

Explanation

Q43: Put the top back ___ the bottle

Explanation

Q44: She has cigarette ___ her lips

Explanation

Explanation

Q46: I leapt ___ the chance to go to France

Explanation

Q47: The two sides are locked ___ a bitter dispute .

Explanation

Q48: In chart wizard, term data series refers to ______?

Explanation

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

Explanation

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

Explanation