Basic Computer Knowledge :: Ms Excel For IBPS Mains Question And Answers


1. To move to the previous worksheet, press

A. Shift + Tab B. Ctrl + PgUp
C. Ctrl + PgDn D. Alt + PgUp

2. You can add a hyperlink to your worksheet by pressing

A. Alt + K B. Ctrl + H
C. Ctrl + K D. Ctrl + Shift + K

3. To open the Format Cells dialog box, press

A. Alt + 1 B. Ctrl + 1
C. Ctrl + Shift + 1 D. F1

4. All macro keyboard shortcuts include the ….. key

A. Alt B. Ctrl
C. F11 D. Shift

5. Tab scrolling buttons

A. Allow you to view a different worksheet B. Allow you to view additional worksheet row down
C. Allow you to view additional sheet tabs D. Allow you to view additional worksheet columns to the right

6. What Pivot Table toolbar button updates the data in a Pivot Table or Pivot Chart report if the source data chas changed

A. Format Report B. Pivot Table
C. Refresh Data D. Show Detail

7. What is an expression that tells how the numbers in a determined set of cells are to be calculated?

A. Formula B. Field
C. Data D. Query Correct Answer:  

8. “Qtr 1, Qtr 2, Qtr 3” is an example of a

A. Formula B. Function
C. Series D. Syntax

9. You can edit existing Excel data by pressing the

A. F1 key B. F2 key
C. F3 key D. F4 key

10. 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. B1.G10
C. B1;G10 D. B1:G10



Related Topics

abbreviations
Keyboard Shortcuts
Computer Model Paper 9
Basics of Computers
LIC AAO Exam Computer
Computer Knowledge Bank






Who are all can get the advantages from this Ms Excel For IBPS Mains Question and Answers section?

Those are all planning for any competitive examinations can use this segment to enhance their abilities.