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 component displays the contents of the active cell?
(A) Name box
(B) Formula bar
(C) Menu bar
(D) Status bar
Explanation: Accounting style shows negative numbers in parenthesis.
4. The process of identifying specific rows and columns so that certain columns and rows are always visible on the screen is called?
(A) Freezing
(B) Locking
(C) Selecting
(D) Fixing
Explanation: When user freeze panes can fix specified rows and columns so that they are always visible on the screen.
5. When users create two or four separate windows containing part of the spreadsheet that can be viewed, users have created?
(A) Sections
(B) Panes
(C) Views
(D) Sub sheets
Explanation: If the user split-window into two or four parts user have created panes. The concept of sections, views, and sub sheets does not exist in Excel.
6. To keep specific rows and columns from scrolling off the screen user first must position the cell pointer?
(A) To the right of the column, the user wants to remain on the screen
(B) Below the row, the user wants to remain on the screen
(C) On the row, you want to remain on the screen
(D) Both below and right of the row and column user want to remain on the screen
(D) Both below and right of the row and column user want to remain on the screen
Explanation: To freeze some rows and columns users need to position below the rows and right the columns user want them to freeze. Excel will draw freeze lines on the top and left edge of the active cells.
7. If the user wanted to sort an employee file so that they would be listed alphabetically by last name and first name within individual zip codes (smallest to largest), which of the following would be the correct order of the sort?
(A) Zipcodes (ascending), then last name (ascending), then first name (ascending)
(B) Last name (ascending), then first name (ascending), then zip codes (descending)
(C) Last name (descending), then first name (descending), then zip codes (ascending)
(D) Zipcodes (descending), then last name (descending), then first name (descending)
(A) Zipcodes (ascending), then last name (ascending), then first name (ascending)
Explanation: Because the list should be arranged alphabetically from smallest to largest within individual zip codes the should be sorted by zip codes (ascending) then by the last name and then by first name all ascending.
8. If the user requires more than two conditions or if the user wants to analyze a list using Excel 2003’s database functions, the user must define which filter?
(A) Auto filter
(B) Update filter
(C) Advantage filter
(D) Advanced criteria filter
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 […]
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 […]
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 […]
Be the first to comment