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.
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
Also Read -
If you like this article about GCC TBC 40 WPM Important Objective Questions and Answers, consider sharing the article with friends.