Information Technology Quiz – 39

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.

General Program Shortcuts and moving around in a worksheet or cell for MS Excel:

1. ALT+X is used for?
(A) Go to data tab
(B) Go to the Add-ins tab
(C) Go to formulas tab
(D) Go to home tab

2. ALT+Y is used for?
(A) Show or hide ribbon
(B) Turn key tips on or off
(C) Calculate active worksheets
(D) Go to help tab

3. CTRL+Tab is used for?
(A) Switch between open workbooks
(B) Minimize the workbook window
(C) Expand or collapse the formula bar
(D) Check spelling

4. Shift+F3 is used for?
(A) Open the help pane
(B) Go to the “Tell me what you want to do box”
(C) Insert a function
(D) Go to page layout tab

5. ALT+F8 is used for?
(A) Create, run, edit or delete a macro
(B) Close a workbook
(C) Close excel
(D) Insert a new worksheet

6. ALT+F11 is used for?
(A) Undo an action
(B) Redo an action
(C) Switch to print preview
(D) Open the Microsoft Visual Basic For Application Editor

7. Left / Right arrow is used for?
(A) Go to next cell
(B) Go to the previous cell
(C) Move one cell to the left or right
(D) Go to the most bottom right used cell

8. Ctrl+ left / right arrow is used for?
(A) Insert a function
(B) Move to the farthest cell left or right in the row
(C) Move to the beginning of a worksheet
(D) Move one scree to the right or left in a worksheet

9. Up / down arrow is used for?
(A) Move one cell up or down
(B) Move to the previous or next worksheet
(C) Go to next cell
(D) Go to the previous cell

10. Ctrl + up /down arrow is used for?
(A) Go to next cell
(B) Move one cell up or down
(C) Move one cell to the left or right
(D) Move to the top or bottom cell in the column