Operating Systems & MS Office

J&K Bank PO · Computer Aptitude · 314 practice questions with answers and explanations: 202 Easy, 110 Medium, 2 Hard.

Sample questions

Sample Easy question 1

In Windows, the shortcut key to lock the computer is:

  1. Alt + Tab
  2. Win + L
  3. Win + D
  4. F2
Show answer

Answer: B. Win + L is used to lock the computer.

Sample Easy question 2

In Windows, the shortcut key to open File Explorer is:

  1. Alt + Tab
  2. Win + E
  3. Win + I
  4. F5
Show answer

Answer: B. Win + E is used to open File Explorer.

Sample Easy question 3

In Windows, the shortcut key to switch between the open programs is:

  1. F2
  2. Win + R
  3. Alt + Tab
  4. PrtScn
Show answer

Answer: C. Alt + Tab is used to switch between the open programs.

Sample Medium question 4

Cell B2 contains 1042. What does =IF(B2>=900,"High",IF(B2>=200,"Medium","Low")) return?

  1. #VALUE!
  2. High
  3. Low
  4. Medium
Show answer

Answer: B. 1042 is at least 900, so the result is High.

Sample Medium question 5

Cell B2 contains 1162. What does =IF(B2>=900,"High",IF(B2>=200,"Medium","Low")) return?

  1. High
  2. Low
  3. #VALUE!
  4. Medium
Show answer

Answer: A. 1162 is at least 900, so the result is High.

Sample Medium question 6

Cell B2 contains 1412. What does =IF(B2>=500,"High",IF(B2>=300,"Medium","Low")) return?

  1. #VALUE!
  2. Low
  3. High
  4. Medium
Show answer

Answer: C. 1412 is at least 500, so the result is High.

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 Computer Aptitude topics for J&K Bank PO

Related articles