Information Technology Quiz – 59

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. 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 details

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

3. “Qtr 1, Qtr 2, Qtr 2” is an example of?
(A) Function
(B) Formula
(C) Series
(D) Syntax

4. You can edit existing excel data by pressing, which of the following key?
(A) F1
(B) F2
(C) F3
(D) F4

5. The cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is?
(A) G1 – G10
(B) G10
(C) B1; G10
(D) B1:G10

6. A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of events that will do this?
(A) Go to File >> Save As – Excel worksheet
(B) Right-click on the spreadsheet tab and select “Delete”
(C) Right-click on the spreadsheet and select – Entire column
(D) All of the above

7. What feature enables you to adjust or back solve the value in a cell to reach a desired outcome in a formula?
(A) Goal seek
(B) Forecasting
(C) Scenario summary report
(D) Trend line

8. What term describes a background that appears as a grainy, non-smooth surface?
(A) Gradient
(B) Solid
(C) Texture
(D) Pattern

9. Excel is a?
(A) Graphic program
(B) Word processor
(C) A spreadsheet
(D) All of the above

10. To create an interactive pivot table for web, you use a a Microsoft office web component called?
(A) HTML
(B) Pivot table field list
(C) Pivot table list
(D) Pivot table report