Operating Systems & MS Office

JKSSB Assistant Training Officer (Handicrafts & Handlooms) · Basic Concepts of Computers · 335 practice questions with answers and explanations: 213 Easy, 120 Medium, 2 Hard.

Sample questions

Sample Easy question 1

In MS Word, margins and page orientation are set on the:

  1. Mailings tab
  2. Review tab
  3. View tab
  4. Layout tab
Show answer

Answer: D. Page setup options are on the Layout tab.

Sample Easy question 2

In MS Excel, a collection of worksheets is called a:

  1. Database
  2. Table
  3. Worksheet
  4. Workbook
Show answer

Answer: D. An Excel file is a workbook.

Sample Easy question 3

In MS Excel, the cell in column C and row 5 is addressed as:

  1. C-5
  2. CR5
  3. 5C
  4. C5
Show answer

Answer: D. Excel addresses cells as column letter then row number.

Sample Medium question 4

If A1 holds 49, the formula =IF(A1>=50,"Pass","Fail") returns:

  1. Pass
  2. Fail
  3. 49
  4. TRUE
Show answer

Answer: B. The condition A1>=50 is false for 49.

Sample Medium question 5

If A1 holds 69, the formula =IF(A1>=50,"Pass","Fail") returns:

  1. Fail
  2. TRUE
  3. Pass
  4. 69
Show answer

Answer: C. The condition A1>=50 is true for 69.

Sample Medium question 6

The formula =LEN("Accounts") returns:

  1. 7
  2. 10
  3. 8
  4. 9
Show answer

Answer: C. LEN counts the characters in the text, including spaces.

Sample Hard question 7

Which of the following statements is NOT correct about MS Word?

  1. A paragraph style can be applied only to one paragraph in a document and cannot be reused
  2. Mail Merge combines a main document with a data source such as a list of names
  3. Format Painter copies formatting from selected text to other text
  4. Changing the definition of a style updates every paragraph that uses that style
Show answer

Answer: A. Styles are meant to be reused. Redefining a style updates all text that uses it, which is why the first statement is incorrect.

Sample Hard question 8

Which of the following statements is NOT correct about cell references in MS Excel?

  1. A relative reference such as A1 changes when the formula is copied
  2. A mixed reference such as A$1 keeps the row fixed
  3. Pressing F4 while editing a reference cycles between reference types
  4. An absolute reference such as $A$1 changes automatically when the formula is copied to another cell
Show answer

Answer: D. An absolute reference ($A$1) stays fixed when the formula is copied; that is its purpose.

More Basic Concepts of Computers topics for JKSSB Assistant Training Officer (Handicrafts & Handlooms)

Related articles