Information Technology Quiz – 67

information technology

Dear Aspirants,

Daily IT Quiz is the basic part of the Himachal GK. It is helpful to increase your knowledge based on information technology. It is a series of Himachal Gk MCQs. You can also play our weekly quiz and download all quizzes PDF as well.

1. An Excel Workbook is a collection of …….?
(A) Workbooks
(B) Worksheets
(C) Charts
(D) Worksheets and Charts

2. What do you mean by a Workspace?
(A) Group of Columns
(B) Group of Worksheets
(C) Group of Rows
(D) Group of Workbooks

3. MS-EXCEL is based on ……….?
(A) WINDOWS
(B) DOS
(C) UNIX
(D) OS/2

4. In EXCEL, you can sum a large range of data by simply selecting a tool button called …..?
(A) AutoFill
(B) Auto correct
(C) Auto sum
(D) Auto format

5. To select an entire column in MS-EXCEL, press?
(A) CTRL + C
(B) CTRL + Arrow key
(C) CTRL + S
(D) None of the above

6. To return the remainder after a number is divided by a divisor in EXCEL we use the function?
(A) ROUND ()
(B) FACT ()
(C) MOD ()
(D) DIV ()

7. Which function is not available in the Consolidate dialog box?
(A) Pmt
(B) Average
(C) Max
(D) Sum

8. Which is not the function of the “Edit, Clear” command?
(A) Delete contents
(B) Delete notes
(C) Delete cells
(D) Delete formats

9. Microsoft Excel is powerful………..?
(A) Word processing package
(B) Spreadsheet package
(C) Communication S/W Package
(D) DBMS package

10. How do you rearrange the data in ascending or descending order?
(A) Data, Sort
(B) Data, Form
(C) Data, Table
(D) Data Subtotals

Be the first to comment

Leave a Reply

Your email address will not be published.


*


This site uses Akismet to reduce spam. Learn how your comment data is processed.