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
(B) Formula bar
Explanation: Formula bar displays the contents of active cell
2. To move to the previous worksheet press?
(A) Ctrl + PgUp
(B) Ctrl + PgDn
(C) Shift + tab
(D) Ctrl + tab
(A) Ctrl + PgUp
Explanation: Ctrl + PgUp moves to the previous worksheet. Similarly Ctrl + PgUp moves to the next.
3. Which of the following is used to shows negative numbers in the accounting style?
(A) Bold
(B) Brackets
(C) Parenthesis
(D) Quotes
(C) Parenthesis
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
(A) Freezing
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
(B) Panes
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
(D) Advanced criteria filter
Explanation: User can filter using advance criteria filter if more than two conditions should be tested.
9. A quick way to return to a specific area of a worksheet is to type in the______?
(A) Name box
(B) Formula bar
(C) Zoom box
(D) All of the above
(A) Name box
Explanation: user can type the cell address or range name in the “name box” to return to a specific area of a worksheet.
10. Which keyboard shortcut opens the GO to dialog box?
(A) Ctrl + B
(B) Ctrl + shift + B
(C) F2
(D) F5
(D) F5
Explanation: Pressing F5 key brings the go to dialog box.
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, 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 […]
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