BG-3

Q1. To display the save as dialog box, press

A. F2

B. F3

C. F5

D. F12

Q2. The default file extension of MS-Excel is

A. xlr

B. xls

C. exe

D. exl

Q3. To displays the Find and Replace dialog box, with the Find tab selected press

A. Alt + F

B. Tab + F

C. Esc + F

D. Ctrl + F

Q4. Pre-defined and built in formulas in Excel are known as

A. Autosheets

B. Charts

C. Functions

D. Tables

Q5. Which function displays row data in a column or column data in a row?

A. Rows

B. Transpose

C. Hyperlink

D. Index

Q6. _____ creates a chart of the data in the current range.

A. Alt + F1

B. Ctrl + F1

C. Ctrl + Alt + F1

D. Esc + F1

Q7. # VALUE! Refers to ___

A. Font value

B. Error in value

C. Subscript of the number value

D. Addition of value

Q8. Which of the following function used to adds the values in the function argument or the values in the all references in the argument?

A. ADD

B. TOTAL

C. SUM

D. All of the above

Q9. Press _____ to undo in MS excel.

A. Ctrl + C

B. Ctrl + U

C. Ctrl + X

D. Ctrl + Z

Q10. ______ moves to the previous cell in a worksheet or the previous option in a dialog box.

A. Alt + Tab

B. Ctrl + Tab

C. Esc + Tab

D. Shift + Tab