Information Technology Quiz – 85

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. To protect a worksheet, you can choose protection and the protective sheet from which of the following menu?
(A) Edit
(B) Format
(C) Tools
(D) Data

2. You can open the highlight changes dialog box by choosing track changes from which of the following menu?
(A) Edit
(B) Insert
(C) Format
(D) Tools

3. Which of the following is not a worksheet design criterion?
(A) Efficiency
(B) Auditability
(C) Description
(D) Clarity

4. To copy cell contents using drag and drop, press the?
(A) End key
(B) Shift key
(C) Esc key
(D) None of the above

5. If you press ______, the cell accepts your typing as its contents?
(A) Enter key
(B) Ctrl + enter key
(C) Tab key
(D) Insert key

6. The autofill feature?
(A) Extends a sequential series of data
(B) Automatically adds a range of cell values
(C) Applies a border around selected cells
(D) None of the above

7. What is the keyboard shortcut (button or buttons to be pressed) for creating a chart from selected cells?
(A) F3
(B) F5
(C) F7
(D) F11

8. You can use the formula palette too?
(A) Format cells containing numbers
(B) Create and edit formulas containing functions
(C) Entered assumption data
(D) Copy a range of cells

9. What pivot table toolbar button updates the data in a pivot table or pivot chart report if the source data has changed?
(A) Format report
(B) Pivot table
(C) Refresh data
(D) Show detail

10. What is an expression that tells how the numbers in a determined set of cells are to be calculated?
(A) Formula
(B) Field
(C) Data
(D) Query correct answer