SET 3 - GCC TBC English 40 WPM Important Objective Questions and Answers

Nitin Walthare
0

SET 3 GCC TBC English 40 wpm Important Objectives Questions and Answers

In this article, I give you the Most Important GCC TBC English 40 WPM Important Objective Questions and Answers

This is SET 3 of Important Objective Questions.

GCC TBC Most Important Objective Questions PDF

1. Delete Sheet Command is given in ………….. Tab - Cells group.

A. File          B. View          C. Home          D. Tools

2. Hyperlink is used to create a link to the sheet.

A. TRUE           B. FALSE

3. ………….function makes the text given in the brackets converted into capital cases and inserted in the cell.

A. =Upper ( )           B. =Capital ()           C. =Lower ()           D. =Case ()

4. We can see the cell address of the selected cell in the ' Name box' in Worksheet.

A. True           B. False

5. To make a Cell reference absolute ………………. Symbols is used.

A. ^          B. ?          C. *          D. $

6. …………. Can be used for different mathematical calculations in Excel.

A. Autofill          B. Text          C. Mid          D. Formula

7. For example using the = Min ( B4:B10) formula, we get the smallest number in cell B4 to B10.

A. True          B. False

8. A formula in Excel always has to start with (fx).

A. TRUE         B. FALSE

9. Justify is one of the types of Alignment in MS-EXCEL.

A. True           B. False

10. With the text orientation Option we can rotate text in the cell.

A. True           B. False

11. Sort and Filter commands in Home Tab are also available in ….. Tab.

A. Insert          B. Page Layout          C. Data          D. View

12. In Worksheet ……………… option is used to see data on rows based on the specific condition.

A. Forms           B. Sort          C. Labels           D. Filter

13. Below the worksheet area, we get ………….

A. Name Box           B. Tabs           C. Formula Bar            D. Sheet Tabs

14. Hard Copy is the ………..

A. soft copy

B. Printed Version of worksheet

C. Both A & B

D. None of the above

15. In Worksheet XFD is the Heading of ……………

A. Column            B. Row           C. Cell            D. None of the above

16. In Spreadsheet, to prepare a graph on the basis of given data, ……… command is used in Insert Tab Group.

A. Filters           B. Forms           C. Charts           D. Pivot Tables

17. __________Function converts the number into nearest integer.

A. if()            B. Min()          C. Round()          D. int()

18. MS-Excel is …………… type of Application Software.

A. Word Processor

B. Spreadsheet

C. Image Editor 

D. Presentation Maker

19. In Worksheet 'C' Column and Row 7th that particular Cell will be recognized as ……………. Cell Reference.

A. C7           B. 7C             C. C*7             D. C+7

20. Functions means inbuilt formula basically available in ………………..

A. MS-Word           B. MS-Excel           C. MS-Powerpoint           D. None of the above

GCC TBC Complete Theory Video Course

Also Read -

If you like this article about GCC TBC 40 WPM Important Objective Questions and Answers, consider sharing the article with friends.

Post a Comment

0 Comments
* Please Don't Spam Here. All the Comments are Reviewed by Admin.
Post a Comment (0)