Information Technology Quiz – 56

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. Which of the following is invalid regarding the protection in Excel?
(A) Protect sheet
(B) Protect workbook
(C) Protect workspace
(D) All of the above

2. The trace Precedence on auditing shows?
(A) Which cells are used in current formula
(B) In which formula the current cell is used
(C) Which cells are used in this formula and in which formula this cell is used
(D) None of the above

3. The trace dependence in auditing shows?
(A) Which cells are used in current formula
(B) In which formula the current cell is used
(C) Which cells are used in this formula and in which formula this cell is used
(D) All of the above

4. The arrow created by auditing can be removed by?
(A) Click on the arrow and press delete
(B) Click on remove all arrows on formula auditing toolbar
(C) Both A & B
(D) None of these

5. Which of the following options is not available to remove arrows of formula auditing?
(A) Remove all precedent arrows
(B) Remove all dependent arrows
(C) Remove all arrows
(D) Remove all arrows for this cell

6. Excel is a good application for what if analysis. Which of the following tool help you for this?
(A) Formula auditing
(B) Research
(C) Track change
(D) Goal seek

7. Which of the following tool you will use in Excel to see what must be the value of a cell to get required result?
(A) Formula auditing
(B) Research
(C) Track change
(D) Goal seek

8. To apply goal seek command your cell pointer must be in?
(A) The changing cell whose value you need to find
(B) The result cell where formula is entered
(C) The cell where your targeted value is entered
(D) None of the above

9. Which of the following is not what if analysis tool in Excel?
(A) Goal seek
(B) Scenarios
(C) Macros
(D) None of the above

10. You can set Excel in automatic or manual calculation mode. If it is in manual mode which key you will press to update the formula values?
(A) F9
(B) F5
(C) F8
(D) F11