Computer Knowledge Quiz October 30th 2015

The Computer Knowledge (CK) Section is covered in many banking/recruitment exams.

The following quiz helps you brush up your computer knowledge skills.

Computer Knowledge section consists of following categories: Windows, Microsoft Office (Word, Excel), Networking, Basic Hardware and Software, DBMS etc.

Topic of today’s quiz is: Microsoft Excel.

Answer the quiz wisely and remember to post your scores in the comments below. Any questions or related information is welcome.

1. In Excel default header for a worksheet is

 Your name

 The date and time

 None

 The sheet tab name

Question 1 of 10

2. In Excel this type of software is similar to an accountant’s worksheet

 Word processing

  Database

 Spreadsheets

 Graphics

Question 2 of 10

3. In Excel you can use the format painter multiple times before you turn it off by

 You can use the format painter button only one time when you click it

  Double clicking the format painter button

 Pressing the Ctrl key and clicking the format painter button

 Pressing Alt key and clicking the format painter button

Question 3 of 10

4. In Excel you can quickly change the appearance of your work by choosing Auto Format from the ……….. Menu

 Edit

 View

 Format

 Tools

Question 4 of 10

5. In Excel….. is a group of cells that form a rectangle on the screen.

 Calculation

 Formula

 Range

 Range address

Question 5 of 10

6. In Excel….. is a group of cells that form a
rectangle on the screen.

 Calculation

 Formula

 Range

 Range address

Question 6 of 10

7. In Excel following term describes explanatory
text attached to a cell

 Callout

 Comment

 Dialog

 Extension

Question 7 of 10

8. In Excel the drag and drop method of copying or moving

 Can be used between worksheets but not workbooks

 Can be used between workbooks but not worksheets

 Can be used between workbooks but not worksheets

 None

Question 8 of 10

9. In Excel 3-D reference in a formula

 Cannot be modified

 Only appears on summary worksheets

 Limits the formatting options

 Spans worksheets

Question 9 of 10

10. In Excel the auto calculate feature

 Can only add values in a range of cells

 Provides a quick way to view the results of an arithmetic operation on a range of cells

 Automatically creates formulas and adds them to a worksheet

 None of the above

Question 10 of 10

 Loading…