Pariksha Corner

Saturday, January 25, 2020

The MSExcel 2010 worksheet in the following figure contains large quantities ofsales amount data for different regions. Which of the following options will helpyou rearrange the data to identify the order in which the regions made salesfrom highest to lowest?

January 25, 2020 |

Computer Awareness, KPTCL Assistant Exam (Mescom) SLOT-3 2017, MS Excel, UnSolved

The MSExcel 2010 worksheet in the following figure contains large quantities of sales amount data for different regions. Which of the following options will help you rearrange the data to identify the order in which the regions made sales from highest to lowest?

AAutofill

BFiltering

CArranging

DSorting

View Answer

You want to calculate the total amount of sales made by the various categoriesof automobile loans offered by your bank. Which of the following excel formulawould you use in cell B8 shown by the red highlighted box to calculate the totalamount of sales made by various categories of automobile loans?

January 25, 2020 |

Computer Awareness, KPTCL Assistant Exam (Mescom) SLOT-3 2017, MS Excel, UnSolved

You want to calculate the total amount of sales made by the various categories of automobile loans offered by your bank. Which of the following excel formula would you use in cell B8 shown by the red highlighted box to calculate the total amount of sales made by various categories of automobile loans?

Aa. =TOTAL(B4:B7)

Bb. =AVG(A4*B4:A7*B7)

Cc. =SIGMA(A4:A7)

Dd. =SUM(B4:B7)

View Answer

Fill in the blank with the appropriate word to reflect the correct meaning of the sentence.
She _______ a taxi to move around Mumbai.

January 25, 2020 |

KPTCL Assistant Exam (Mescom) SLOT-3 2017, Selecting Words, UnSolved, Verbal Ability

Fill in the blank with the appropriate word to reflect the correct meaning of the sentence.
She _______ a taxi to move around Mumbai.

Ahired

Baired

Chaired

Dhiyed

View Answer

Fill in the blank with the appropriate preposition.
I should return from Delhi _________ Saturday evening.

January 25, 2020 |

KPTCL Assistant Exam (Mescom) SLOT-3 2017, Selecting Words, UnSolved, Verbal Ability

Fill in the blank with the appropriate preposition.
I should return from Delhi _________ Saturday evening.

Aby

Bover

Cat

Din

View Answer

Identify the type of adjective in the given sentence.
He asked for some water.

January 25, 2020 |

KPTCL Assistant Exam (Mescom) SLOT-3 2017, Selecting Words, UnSolved, Verbal Ability

Identify the type of adjective in the given sentence.
He asked for some water.

AAdjective of Quality

BAdjective of Quantity

CAdjective of Number

DInterrogative Adjective

View Answer

Fill in the blank with the correct adverb, based on the instructions given in brackets.
She left her dog ___________ (Adverb of Place)

January 25, 2020 |

KPTCL Assistant Exam (Mescom) SLOT-3 2017, Selecting Words, UnSolved, Verbal Ability

Fill in the blank with the correct adverb, based on the instructions given in brackets.
She left her dog ___________ (Adverb of Place)

Ahappily

Bangrily

Cdownstairs

Dalways

View Answer

Fill in the blank with the appropriate collective noun.
A ___________ of judges are discussing his case.

January 25, 2020 |

KPTCL Assistant Exam (Mescom) SLOT-3 2017, Selecting Words, UnSolved, Verbal Ability

Fill in the blank with the appropriate collective noun.
A ___________ of judges are discussing his case.

Agroup

Bbench

Cteam

Dnumber

View Answer