Computer (Part-5)

Total Questions: 50

1. The_______()function in Microsoft Excel is used to count the number of cells that contain a given number in a list of arguments. [S.S.C. Online Graduation Level (T-I) 22.08.2017 (Shift-III)]

Correct Answer: (b) COUNT
Solution:The COUNT function in Microsoft Excel is used to count the number of cells that contain the given numbers in a list of arguments.

2. What is the keyboard shortcut to add a new row above a given row in Microsoft Excel? [S.S.C. Online CHSL (T-I) 12.08.2021 (Shift-II)]

Correct Answer: (d) Alt+I+R
Solution:
Alt + I + R:
This shortcut activates the "Insert" menu and then selects the "Rows" option, resulting in a new row inserted above the active cell's row. 

3. Microsoft excel is also called_______ . [S.S.C. Online MTS (T-I) 9.10.2017 (Shift-I)]

Correct Answer: (c) Spreadsheet
Solution:Microsoft Excel is a spreadsheet application in the Microsoft Office suite. A spreadsheet is an accounting program for the computer. Spreadsheets are primarily used to work with numbers and test. Spreadsheets can help organize information, such as alphabetizing a list of names or ordering records and calculate and analyse information using mathematical formulas.

4. Which of the following symbols must be used before a formula in a Microsoft Excel sheet? [S.S.C. Online CHSL (T-I) 16.10.2020 (Shift-II)]

Correct Answer: (b) =
Solution:In a Microsoft Excel sheet, every formula must begin with an equals sign (=).
When you type an equals sign in a cell and then enter a combination of values, cell references, operators, and functions, Excel interprets that entry as a formula and calculates the result. If you forget the equals sign, Excel will treat your entry as plain text.

5. In Microsoft Word, ________is a position we set for placing and aligning test on a page. [S.S.C. Online CHSL (T-I) 15.03.2018 (Shift-II)]

Correct Answer: (d) Tab stop
Solution:In Microsoft Word, a tab stop is a position we set to position and align text on a page. The Standard Toolbar provides tools for standard tasks such as saving, printing, cutting, copying, pasting, etc. The Formatting Toolbar provides the user with tools for formatting like Bold, Italic, Underline etc. The View button gives the user options to switch between Normal, Web Layout, Print Layout, Outline and Reading View.

6. In Microsoft Word, under character formatting _______ decides the appearance of our characters. [S.S.C. Online CHSL (T-I) 6.03.2018 (Shift-II)]

Correct Answer: (d) Font
Solution:Character formatting in Microsoft Word is what we can apply to any character or group of characters. It has the following options-

1. Font This defines the shape of our characters.
2. Font Style We can make characters stand out by making them bold, italicized or both.
3. Size It increases decreases the size of the characters.
4. Underline-Through this option we can underline a specific text to draw attention to it.
Effects-Effects let you apply or remove character formats.

7. In which year was the first ever version of Microsoft Word-Word 1.0 launched? [S.S.C. Online CHSL (T-I) 16.04.2021 (Shift-I)]

Correct Answer: (a) 1983
Solution:Microsoft Word, word-processor software launched in 1983 by the Microsoft Corporation. Software developers Richard Brodie and Charles Simonyi joined the Microsoft team in 1981, and in 1983 they released Multi-Tool Word for computers that ran a version of the UNIX operating system (OS). Later that year, the program was rewritten to run on personal computers (PCs), such as the IBM PC, under Microsoft's version of DOS (disk operating system). or MS DOS, and was renamed Microsoft Word.

8. In which year was Microsoft's Windows operating system first introduced? [S.S.C. Online CHSL (T-I) 15.04.2011 (Shift-II)]

Correct Answer: (d) 1985
Solution:In 1985. Microsoft's operating system was first introduced. The earliest version of windows MS-DOS was the Microsoft disk operating system, which was the character-based operating system used in many computers but didn't succeed.

9. Which of the following keyboard shortcuts will you press to minimise all programs on a computer screen and display the desktop? [S.S.C. Online CHSL (T-I) 04.08.2021 (Shift-II)]

Correct Answer: (c) Windows + D
Solution:

The keyboard shortcut to minimize all programs on a computer screen and display the desktop in Windows is: Windows key + D

  1. Press and hold the Windows key (usually located between the Ctrl and Alt keys on the left side of your keyboard, often with the Windows logo on it). 
  2. While holding the Windows key, press the D key.

This action will instantly minimize all open windows and show your desktop. Pressing Windows key + D again will restore all the previously minimized windows.

10. Where is the taskbar in the default setting of Microsoft Windows? [S.S.C. Online MTS (T-I) 10.10.2017 (Shift-I)]

Correct Answer: (b) at the bottom of the screen
Solution:

In the default setting of Microsoft Windows, the taskbar is located at the bottom edge of the screen.   

This has been the standard placement for the taskbar in Windows for a long time, providing easy access to the Start button, pinned applications, currently running programs, and the system tray (notification area) on the right side.  

While users can customize the taskbar's location to the top, left, or right edges of the screen through the Windows settings, the bottom is the default and most common position.