Information Technology Quiz – 37

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 for MS Excel:

1. F1 is used for?
(A) Check spelling
(B) Open the help pane
(C) Go to home tab
(D) Go to insert tab

2. ALT+Q is used for?
(A) Expand/collapse the formula bar
(B) Go to page layout
(C) Minimize the workbook window
(D) Go to “tell me what you want to do” box

3. F7 key used for?
(A) Check spelling
(B) Open the file tab menu
(C) Go to data tab
(D) Open the insert tab

4. F9 key used for?
(A) To calculate all worksheets in all open workbooks
(B) Create a bar chart based on selected separated sheet
(C) Create a bar chart based on selected same sheet
(D) Search in spreadsheet

5. SHIFT+F9 is used for?
(A) Show or hide the ribbon
(B) Turn key tips on/off
(C) Calculate all worksheets in all open workbooks
(D) Calculated active worksheets

6. ALT or F10 key is used for?
(A) Turn key tips on or off
(B) Show or hide the ribbon
(C) Open the help pane
(D) Minimize the workbook window

7. CTRL+F1 is used for?
(A) Go to help tab
(B) Show or hide the ribbon
(C) Switch between open windows
(D) Insert a function

8. CTRL+SHIFT+U is used for?
(A) Search in spreadsheet
(B) Create, run, edit or delete a macro
(C) Expand or collapse the formula bar
(D) None of these

9. CTRL+F9 is used for?
(A) Close file tab
(B) Open file tab
(C) Maximize the workbook window
(D) Minimize the workbook window

10. F11 key is used for?
(A) Create a bar chart based on selected data (on a separated sheet)
(B) Create a bar chart based on selected data (same sheet)
(C) Switch between open window
(D) Insert a function