Information Technology Quiz – 86

Dear Aspirants,

Information Technology 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. A function inside another function is called?
(A) Nested function
(B) Round function
(C) Sum function
(D) Text function

2. How should you print a selected area of a worksheet, if you want to print a different area next time?
(A) On the File menu, point to point area, and then click set print area
(B) On the File menu, click Print, and then click selection under print what
(C) On the view menu, click custom views, then click add
(D) All of the above

3. Your German supplier still invoices for parts in Deutsche marks. How can you have Excel convert those sums to Euros?
(A) On the inset menu, click the symbol and from the currency symbols subset, select the Euro sign
(B) On the inset menu, click add-ins, and select the Euro currency tools checkbox
(C) Apply selected background-color
(D) All of the above

4. Which function calculates your monthly mortgage payment?
(A) PMT (payments)
(B) NPER (number of periods)
(C) PV (present value)
(D) All of the above

5. If you are working in English (US), Chinese or Japanese, Excel 2002 can speak data as you enter it, to help you verify accuracy. How do you activate this feature?
(A) Point to speech on the tools menu, and then click show text to speech toolbar
(B) Click validation on data menu
(C) Point to speech on the tools menu, then click speech recognition
(D) All of the above

6. Which of the following methods cannot be used to enter data in a cell?
(A) Pressing an arrow key
(B) Pressing the tab key
(C) Pressing the Esc key
(D) Clicking the enter button to the formula bar

7. Which of the following will not set text in selected cells to italics?
(A) Pressing ctrl + l on the keyboard
(B) Using the tools >> wizard >> web from menu item
(C) Using the format >> cells >> font menu item
(D) None of the above

8. Which of the following methods cannot be used to edit the content of cell?
(A) Pressing the alt key
(B) Clicking the formula bar
(C) Pressing F2
(D) Double clicking the cell

9. Which of the following is not an option in the spelling dialog box?
(A) Edit
(B) Ignore
(C) Ignore all
(D) Change

10. You can quickly change the appearance of your work by choosing the auto-format from which of the following menu?
(A) Edit
(B) View
(C) Ignore all
(D) Tools