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

SBI Clerk Computer general
LIC AAO Exam Computer
Basic Computer Quiz
IBPS RRB Computer
Computer Model Paper 10

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.