In this article, I give you the Most Important GCC TBC English 40 WPM Important Objective Questions and Answers.
This is SET 6 of Important Objective Questions.
1. Formulas with Absolute refereces always _________.
A. Refer to same cells, regardless of the location of the formula
B. Refer to different cells
C. Produce Zero as the default
D. None of these
2. Group of selected cell is called as ___________.
A. Cell Range B. Row C. Column Width D. Table
3. In the Worksheet the Heading of the last Column is ____________.
A. XFD B. ZFD C. ZZZ D. ZXY
4. 'C' column and Row 7th In Worksheet, that particular Cell will be recognized as
A. c+7 B. 7c C. c*7 D. C7
5. To use goto function ____________
A. By selecting ranges using the F5 key
B. Find & Select --> Go To
C. Both A & B
D. None of these
6. With _______ Function, current System Date gets inserted in the cell
A. =Date() B. =Setdate() C. =Currentdate() D. =Today()
7. In Ms-Excel 2010 there are ………………… rows in one Worksheet.
A. 15,000 B. 16,384 C. 20,000 D. 10,48576
8. To start Excel, we have to click START Button on the Taskbar of Desktop.
A. True B. False
9. Selected text can be colored with -------------- command in Font Group of Home Tab.
A. Font B. Paragraph C. Text-color D. Drawing
10. Each row in Excel has given one …………
A. Number B. Character C. Picture D. Icon
11. With _____Function, We get the average of values in Range.
A. Sum B. Min C. Average D. Max
12. Shortcut key for Help in Excel is
A. F1 B. F2 C. F3 D. F4
13. Selected Single Cell in Worksheet is called as __________.
A. Bordered Cell B. Active Cell C. Main Cell D. None
14. Ascending-Descending are types of ………..
A. Indent B. Alignment C. Sorting D. All of the above
15. In the Worksheet, the process of giving specific formatting to data that match the specific condition Is called as ___________.
A. Conditional Formatting
B. Auto format
C. Table Format
D. Quick Format
16. Excel file Extension XLSX means ____________.
A. Microsoft Excel Workbook
B. Microsoft Excel Template
C. Web Page
D. Microsoft Office Workplace
17. _________ collection is called a Workbook.
A. Worknote-Book B. Work Document C. Chart Book D. Worksheet
18. Help option is available in _______ Menu.
A. Insert B. File C. View D. Tools
19. Ascending Sorting means ________ Sorting.
A. A to Z B. Z to A C. Both A & B D. None of the above
20. In a Worksheet, Actual Data is entered in __________ .
A. Column B. Row C. Line D. Cell
Also Read -
If you like this article about GCC TBC 40 WPM Important Objective Questions and Answers, consider sharing the article with friends.