You can edit existing Excel data by pressing the:________ key? A. A) F1 Key B. B) F2 Key C. C) F3 Key D. D) F4 Key Correct answer is: B. B) F2 Key 📖 Read Detailed Explanation → Computer MCQs for Competitive Exams MS Excell MCQS Leave a Comment | Umar
Default file name in MS Excel is? A. A) Document 1 B. B) Workbook 1 C. C) Book1 D. D) Worksheet Correct answer is: C. C) Book1 📖 Read Detailed Explanation → Computer MCQs for Competitive Exams MS Excell MCQS Leave a Comment | Umar
To insert chart in MS Excel, which shortcut key used? A. A) Alt+F1 B. B) F2 C. C) F3 D. D) F4 Correct answer is: A. A) Alt+F1 📖 Read Detailed Explanation → Computer MCQs for Competitive Exams MS Excell MCQS Leave a Comment | Umar
Which of these key are used in ms excel to insert current time In workbook. A. A) Ctrl + Shift + ; B. B) Ctrl+! C. C) Ctrl+* D. D) None of these Correct answer is: A. A) Ctrl + Shift + ; 📖 Read Detailed Explanation → Computer MCQs for Competitive Exams MS Excell MCQS Leave a Comment | Umar
When you insert an Excel file into a word document, the data are? A. A) Hyperlinked B. B) placed in a word table C. C) linked D. D) embedded Correct answer is: C. C) linked 📖 Read Detailed Explanation → Computer MCQs for Competitive Exams MS Excell MCQS Leave a Comment | Umar
What is the intersection of a column and row called in Excel? A. A) A cell B. B) A range C. C) A column header D. D) A row header Correct answer is: A. A) A cell 📖 Read Detailed Explanation → Computer MCQs for Competitive Exams MS Excell MCQS Leave a Comment | Umar
Which function displays row data into column or column data into row? A. Transpose B. Pivot C. Filter D. Sort Correct answer is: A. Transpose 📖 Read Detailed Explanation → Computer Science MCQS Past Paper Computer Operator in Revenue Department Leave a Comment | Umar
With which of the following all formulas in excel starts ? A. A) / B. B) * C. C) $ D. D) = Correct answer is: D. D) = 📖 Read Detailed Explanation → Computer Science MCQS Computer System MCQS Leave a Comment | Umar
In MS Excel, you have a list of sales data in column A, and you need to find the second highest unique value in this list. Which of the following formulas will correctly return the second highest unique value? A. A =LARGE(A:A, 2) B. B =LARGE(UNIQUE(A:A), 2) C. C =INDEX(SORT(UNIQUE(A:A), , -1), 2) D. D =SMALL(UNIQUE(A:A), 2) Correct answer is: C. C =INDEX(SORT(UNIQUE(A:A), , -1), 2) 📖 Read Detailed Explanation → Computer Science MCQS Computer System MCQS Leave a Comment | Umar
A. A =LARGE(A:A, 2) B. B =LARGE(UNIQUE(A:A), 2) C. C =INDEX(SORT(UNIQUE(A:A), , -1), 2) D. D =SMALL(UNIQUE(A:A), 2)
Test item cannot discriminate low achievers and high achievers when its value is lower than? A. nswer is = C B. 1 C. 0.30 D. None Correct answer is: C. 0.30 📖 Read Detailed Explanation → Assessment and Evaluation MCQs Pedagogy MCQs Leave a Comment | Umar
Test item discriminates 100% when its value for discrimination is? A. A. 0.30 – 1 B. B. 1 C. C. 0.30 D. D. None Correct answer is: B. B. 1 📖 Read Detailed Explanation → Assessment and Evaluation MCQs Pedagogy MCQs Leave a Comment | Umar
Discrimination power of an item is acceptable when its value ranges from? A. A. 0.30 – 1 B. B. 1 C. C. 0.30 D. D. None Correct answer is: A. A. 0.30 – 1 📖 Read Detailed Explanation → Assessment and Evaluation MCQs Pedagogy MCQs Leave a Comment | Umar
Which of the following part of a processor contains the hardware necessary to perform all the operations required by a computer? A. a) Controller B. b) Registers C. c) Cache D. d) Data path Correct answer is: D. d) Data path 📖 Read Detailed Explanation → Computer Science MCQS Computer System MCQS Leave a Comment | Umar
Which of the following is not a type of computer code? A. a) EDIC B. b) ASCII C. c) BCD D. d) EBCDIC Correct answer is: A. a) EDIC 📖 Read Detailed Explanation → Computer Science MCQS Computer System MCQS Leave a Comment | Umar
Which of the following monitor looks like a television and are normally used with non-portable computer systems? A. a) LED B. b) LCD C. c) CRT D. d) Flat Panel Monitors Correct answer is: C. c) CRT 📖 Read Detailed Explanation → Computer Science MCQS Computer System MCQS Leave a Comment | Umar
Which of the following unit is responsible for converting the data received from the user into a computer understandable format? A. a) Output Unit B. b) Input Unit C. c) Memory Unit D. d) Arithmetic & Logic Unit Correct answer is: B. b) Input Unit 📖 Read Detailed Explanation → Computer Science MCQS Computer System MCQS Leave a Comment | Umar
Which of the following is the smallest unit of data in a computer? A. a) Bit B. b) KB C. c) Nibble D. d) Byte Correct answer is: A. a) Bit 📖 Read Detailed Explanation → Computer Science MCQS Computer System MCQS Leave a Comment | Umar
Which of the following is not a characteristic of a computer? A. a) Versatility B. b) Accuracy C. c) Diligence D. d) I.Q. Correct answer is: D. d) I.Q. 📖 Read Detailed Explanation → Computer Science MCQS Computer System MCQS Leave a Comment | Umar
Which of the following is the brain of the computer? A. a) Central Processing Unit B. b) Memory C. c) Arithmetic and Logic unit D. d) Control unit Correct answer is: A. a) Central Processing Unit 📖 Read Detailed Explanation → Computer Science MCQS Computer System MCQS Leave a Comment | Umar
Which of the following computer language is written in binary codes only? A. a) pascal B. b) machine language C. c) C D. d) C# Correct answer is: B. b) machine language 📖 Read Detailed Explanation → Computer Science MCQS Computer System MCQS Leave a Comment | Umar
What is the full form of CPU? A. a) Computer Processing Unit B. b) Computer Principle Unit C. c) Central Processing Unit D. d) Control Processing Unit Correct answer is: C. c) Central Processing Unit 📖 Read Detailed Explanation → Computer Science MCQS Computer System MCQS Leave a Comment | Umar
A. a) Computer Processing Unit B. b) Computer Principle Unit C. c) Central Processing Unit D. d) Control Processing Unit
Test item is very easy when value of faculty index/ difficulty level is higher than? A. 30-70 % B. 70 % C. 30% D. None Correct answer is: B. 70 % 📖 Read Detailed Explanation → Assessment and Evaluation MCQs Pedagogy MCQs Leave a Comment | Umar
Test item is acceptable which its faculty index /difficulty level ranges from? A. 30-70% B. 70 % C. 30% D. None Correct answer is: A. 30-70% 📖 Read Detailed Explanation → Assessment and Evaluation MCQs Pedagogy MCQs Leave a Comment | Umar
High and low achievers are sorted out by? A. Ease or difficulty B. Discrimination power C. Objectivity D. Reliability Correct answer is: B. Discrimination power 📖 Read Detailed Explanation → Assessment and Evaluation MCQs Pedagogy MCQs Leave a Comment | Umar
Facility index of an item determines? A. Ease or difficulty B. Discrimination power C. Objectivity D. Reliability Correct answer is: A. Ease or difficulty 📖 Read Detailed Explanation → Assessment and Evaluation MCQs Pedagogy MCQs Leave a Comment | Umar