Himachal Pradesh JOA IT 817 - Free Online Practice Test

1. Key combination used to insert a new line character in a cell in MS-Excel?

Computer

A. Alt+Enter B. Enter C. Shift+Enter D. Ctrl+Enter

2. An array formula can be entered in a cell in MS-Excel by pressing:

Computer

A. Ctrl+Enter B. Ctrl+Alt+Enter C. Ctrl+Shift+Enter D. Shift+Enter

3. Value of the array formula {=SUM(A1:D1*A2:D2)} for data {5,4,8,2} and {2,2,3,1}?

Computer

A. 64 B. 36 C. 43 D. 55

4. Value of =LARGE(A1:E2,1)+LARGE(A1:E2,2) for the given table?

Computer

A. 14 B. 16 C. 15 D. 12

5. Which feature is NOT found in MS-Excel?

Computer

A. split a cell B. conditional formatting C. merge adjacent cells D. insert row

6. Option to split full names into first and last names in MS-Excel?

Computer

A. Text to Columns B. Consolidate C. Columns to Text D. Ungroup

7. Option to restrict the value of a cell from a list of values?

Computer

A. Consolidate B. Filter C. Freeze Panes D. Data Validation

8. If A1 contains 10% and A2 contains 5%, what is =A1*A2?

Computer

A. 0.05 B. 0.005 C. 0.5 D. 5

9. Formula to round A1 to the nearest multiple of 10?

Computer

A. ROUND(#REF!,10) B. ROUND(#REF!,1) C. ROUND(#REF!,-10) D. ROUND(#REF!,-1)

10. Feature used to highlight marks if they are below 10?

Computer

A. Format Painter B. Data Validation C. Format Cells D. Conditional Formatting