MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 520 Mcqs, each offering curated multiple-choice questions to sharpen your 8th Class knowledge and support exam preparation. Choose a topic below to get started.
| 101. |
If you do not put an equal to (=) before a formula, _______. |
| A. | ###### is displayed in the cell |
| B. | #REF! is displayed in the cell |
| C. | The formula is displayed as it is in the cell |
| D. | The formula is still executed and its results are displayed in the cell |
| Answer» D. The formula is still executed and its results are displayed in the cell | |
| 102. |
Which of the following is CORRECT with respect to MS-Excel? |
| A. | SORT function is used to find the square root of a number. |
| B. | A formula always begins with a + (plus) sign. |
| C. | Mixed referencing can be used only when both row and column are fixed. |
| D. | The formula given in one sheet of a workbook can be linked to other worksheet. |
| Answer» E. | |
| 103. |
If a range A1:A5 named MARKS contains numbers 5, 10, 15, 20 and 25 respectively, then what would be the result of the following function? =AVERAGE(MARKS, 60) |
| A. | 30 |
| B. | 22.5 |
| C. | 60 |
| D. | 15 |
| Answer» C. 60 | |
| 104. |
For absolute cell referencing, always place a ________ sign within the cell addresses in the formula. |
| A. | $ |
| B. | # |
| C. | % |
| D. | & |
| Answer» B. # | |
| 105. |
__________ is NOT a function in MS-Excel. |
| A. | SUM |
| B. | ADD |
| C. | MAX |
| D. | SQRT |
| Answer» C. MAX | |
| 106. |
is________. |
| A. | The AutoCorrect button |
| B. | The AutoFormat button |
| C. | The AutoSum button |
| D. | The Conditional Format button |
| Answer» D. The Conditional Format button | |
| 107. |
Current date and time in a cell can be entered using the formula __________. |
| A. | |
| B. | =NOW () |
| C. | |
| D. | =CURRENTTIME () |
| Answer» C. | |
| 108. |
Which of the following statements is/are true? Statement A: Adobe Page Mill is used to automate the whole process of site design and implementation. Statement B: Inline style mixes the content with presentation. |
| A. | Statement A is correct |
| B. | Statement B is correct |
| C. | Both statements A and B are correct |
| D. | Neither statement A nor statement B is correct |
| E. | None of these |
| Answer» D. Neither statement A nor statement B is correct | |
| 109. |
Match the following: A B 1. Red (i) #FFFFFF 2. Parrot green (ii) #FFFF00 3. Yellow (iii) #FF00FF 4. Pink (iv) #FF0000 #00FF00 |
| A. | 1\[\to \]iii, 2\[\to \]i, 3\[\to \]iv, 4\[\to \]ii |
| B. | 1\[\to \]iv, 2\[\to \]v, 3\[\to \]i, 4\[\to \]ii |
| C. | 1\[\to \]ii, 2\[\to \]iii, 3\[\to \]iv, 4\[\to \]v |
| D. | 1\[\to \]iv, 2\[\to \]v, 3\[\to \]ii, 4\[\to \]iii |
| E. | None of these |
| Answer» E. None of these | |
| 110. |
Which of the following statements is/are true? Statement A: #C0C0C0 is the hexadecimal value of grey colour. Statement B: #00FFFF is the hexadecimal value of sky blue colour. |
| A. | Statement A is correct |
| B. | Statement B is correct |
| C. | Both statements A and B are correct |
| D. | Neither statement A nor statement B is correct |
| E. | None of these |
| Answer» D. Neither statement A nor statement B is correct | |
| 111. |
HTML allows changing background colour. Which one of the following attributes of tag is used to change the background colour of a Web page? |
| A. | background color |
| B. | bg color |
| C. | background |
| D. | bg _color |
| E. | None of these |
| Answer» C. background | |
| 112. |
Which one of the following HTML tags allows inserting horizontal line? |
| A. | <hrl> |
| B. | <hr> |
| C. | <hl> |
| D. | <hlr> |
| E. | None of these |
| Answer» C. <hl> | |
| 113. |
John wants to use WordArt in his document. But he is not able to search Insert WordArt button. In which of the following locations Insert WordArt button exists? |
| A. | Pages |
| B. | Illustration |
| C. | Link group |
| D. | Text group |
| E. | None of these |
| Answer» E. None of these | |
| 114. |
Which one of the following is the correct step to open Find and Replace dialog box? |
| A. | View \[\to \]Insert \[\to \]Find |
| B. | Insert \[\to \]Find \[\to \]Replace |
| C. | Office button \[\to \]Find and Replace |
| D. | Home tab \[\to \]Editing group \[\to \]Find and Replace |
| E. | None of these |
| Answer» E. None of these | |
| 115. |
You can move the cursor in table by using _________. |
| A. | Arrow key |
| B. | Tab key |
| C. | Mouse |
| D. | All of these |
| E. | None of these |
| Answer» B. Tab key | |
| 116. |
The shortcut key for spell check is _______. |
| A. | F7 |
| B. | F6 |
| C. | F5 |
| D. | F4 |
| E. | None of these |
| Answer» B. F6 | |
| 117. |
The given image is found in ________. |
| A. | cells group |
| B. | style group |
| C. | formula group |
| D. | editing group |
| E. | None of these |
| Answer» B. style group | |
| 118. |
Under which group of the Home tab of the Ribbon did you find the ?Conditional Formatting?? |
| A. | Styles group |
| B. | Formula group |
| C. | Cells group |
| D. | Editing group |
| E. | None of these |
| Answer» B. Formula group | |
| 119. |
Number formatting allows you to change the property of a value in a cell to_____. |
| A. | Fraction |
| B. | Time |
| C. | Text |
| D. | All of these |
| E. | None of these |
| Answer» E. None of these | |
| 120. |
Match the following: A B 1. Column (i) Is used to retrieve a single value from a column of a list. 2. Quattro Pro (ii) Is used to estimate the population variance. 3. DGET (iii) Is used to count the non- blank cells in a column 4. DVAR (iv) Contains notebook (v) It is a chart type |
| A. | 1\[\to \]v, 2\[\to \]iv, 3\[\to \]i, 4\[\to \]ii |
| B. | 1\[\to \]iv, 2\[\to \]v, 3\[\to \]i, 4\[\to \]ii |
| C. | 1\[\to \]ii, 2\[\to \]iii, 3\[\to \]iv, 4\[\to \]v |
| D. | 1\[\to \]ii, 2\[\to \]iv, 3\[\to \]i, 4\[\to \]v |
| E. | None of these |
| Answer» B. 1\[\to \]iv, 2\[\to \]v, 3\[\to \]i, 4\[\to \]ii | |
| 121. |
MS-Excel enables you to perform complex calculations easily. Which of the following calculations you can perform in Excel sheet? |
| A. | Average |
| B. | Sum |
| C. | Count |
| D. | All of these |
| E. | None of these |
| Answer» E. None of these | |
| 122. |
Steve is working on excel sheet. He wants to add pie chart in his sheet. Which one of the following steps Steve needs to performs to open Chart Wizard? |
| A. | Insert \[\to \] Picture \[\to \]Chart |
| B. | Insert \[\to \]Chart |
| C. | View \[\to \]Chart |
| D. | Review \[\to \]Chart |
| E. | None of these |
| Answer» C. View \[\to \]Chart | |
| 123. |
What is the correct path to start MS-Access? |
| A. | Start\[\to \]Programs\[\to \]Microsoft Office\[\to \] MS\[\to \]Access |
| B. | Start\[\to \]Programs\[\to \]Accessories\[\to \]MS-Access |
| C. | Start \[\to \] Run \[\to \]MS-Access |
| D. | Start\[\to \] Accessories\[\to \]Microsoft Office\[\to \] MS-Access |
| Answer» B. Start\[\to \]Programs\[\to \]Accessories\[\to \]MS-Access | |
| 124. |
Which of the following is NOT true about primary key? |
| A. | Primary key field can have a character value. |
| B. | Primary key field helps to check redundancy of data. |
| C. | Primary key field can have a null value. |
| D. | Primary key field can have zero value. |
| Answer» D. Primary key field can have zero value. | |
| 125. |
Which icon of the standard tool bar will you click, to switch on to Data sheet view from Design view? |
| A. | |
| B. | |
| C. | |
| D. | |
| Answer» C. | |
| 126. |
Which icon will you click on to switch to design view from Datasheet view? |
| A. | |
| B. | |
| C. | |
| D. | |
| Answer» B. | |
| 127. |
Which of these icons should you click to delete a column from the table? |
| A. | |
| B. | |
| C. | |
| D. | |
| Answer» C. | |
| 128. |
The ___ icon helps you insert a new row into the table. |
| A. | |
| B. | |
| C. | |
| D. | |
| Answer» D. | |
| 129. |
Which icon will you choose to delete a row from a table? |
| A. | |
| B. | |
| C. | |
| D. | |
| Answer» E. | |
| 130. |
Which of these icons will you click to insert a new column? |
| A. | |
| B. | |
| C. | |
| D. | |
| Answer» B. | |
| 131. |
Which of the following displays sample tables? |
| A. | Blank Access database |
| B. | Table wizard |
| C. | Both (a) and |
| D. | Neither (b) nor |
| Answer» C. Both (a) and | |
| 132. |
Which of the following statements is/are false? |
| A. | Macros are small, user - written programs to automate repetitive tasks. |
| B. | Forms are the printouts of the Access files. |
| C. | Queries interrelates two or more tables. |
| D. | All of these |
| Answer» C. Queries interrelates two or more tables. | |
| 133. |
The printouts of the Access database are called ________. |
| A. | pages |
| B. | reports |
| C. | forms |
| D. | tables |
| Answer» C. forms | |
| 134. |
When an Access file is saved, what file format does it take? |
| A. | .MDB |
| B. | .PST |
| C. | .RLS |
| D. | .ODP |
| Answer» B. .PST | |
| 135. |
Which objects of MS Access interconnects two or more tables of Access? |
| A. | Reports |
| B. | Macros |
| C. | Pages |
| D. | Query |
| Answer» E. | |
| 136. |
Which of these objects provides the accessibility of data through internet? |
| A. | Reports |
| B. | Macros |
| C. | Pages |
| D. | Query |
| Answer» D. Query | |
| 137. |
Two or more columns which are set as primary keys are called __________ primary keys. |
| A. | unique |
| B. | report |
| C. | form |
| D. | composite |
| Answer» E. | |
| 138. |
Which of the following options will you choose to design the format of your table and the data types? |
| A. | Data view sheet |
| B. | Design view |
| C. | Primary key |
| D. | Forms |
| Answer» C. Primary key | |
| 139. |
Which of these icons will help you enter the data into a table? |
| A. | Data sheet view sheet |
| B. | Design view |
| C. | Primary key |
| D. | Forms |
| Answer» B. Design view | |
| 140. |
What was the initial code name of MS-Access? |
| A. | Omega |
| B. | Cirrus |
| C. | Deco |
| D. | Boston |
| Answer» C. Deco | |
| 141. |
The icon of the field indicates that r |
| A. | this field is the primary key with a unique value. |
| B. | you are currently entering data into this row or field. |
| C. | you are deleting the field. |
| D. | you are inserting a new column into the table. |
| Answer» B. you are currently entering data into this row or field. | |
| 142. |
Which of the following data types is used for lengthy text and numbers? |
| A. | Text |
| B. | Memo |
| C. | Currency |
| D. | Numbers |
| Answer» C. Currency | |
| 143. |
Which one of the following is NOT a valid MS-Access field data type? |
| A. | Number |
| B. | Memo |
| C. | Text |
| D. | Character |
| Answer» E. | |
| 144. |
Which of the following characters cannot be used while naming a file in MS-Access? |
| A. | [] |
| B. | ? |
| C. | - (dash) |
| D. | , (comma) |
| Answer» B. ? | |
| 145. |
What is the DEFAULT SIZE of text data type in MS-Access? |
| A. | 20 |
| B. | 255 |
| C. | 50 |
| D. | 256 |
| Answer» D. 256 | |
| 146. |
What is the shortcut key that helps you insert the current date in access? |
| A. | Ctrl + semicolon |
| B. | Alt + semicolon |
| C. | Shift + semicolon |
| D. | Semicolon |
| Answer» B. Alt + semicolon | |
| 147. |
Which of the following is a popular software that supports DBMS? |
| A. | MS-Access |
| B. | MS-Word |
| C. | MS-Excel |
| D. | MS-Paint |
| Answer» B. MS-Word | |
| 148. |
What is the program that enables you to create, access and manage a database called? |
| A. | Database |
| B. | Data structure |
| C. | Operating system |
| D. | Database Management System |
| Answer» E. | |
| 149. |
Which of the following is NOT a type of ROM? |
| A. | Mask ROM |
| B. | Mega ROM |
| C. | PROM |
| D. | EPROM |
| Answer» C. PROM | |
| 150. |
What is the full form of PCMCIA in Computers Science? |
| A. | Portable Card Memory for Computers International Association |
| B. | Personal Computer Multimedia Card International Association |
| C. | Personal Computer Memory Card International Association |
| D. | Personal Card Memory of Computers International Association |
| Answer» D. Personal Card Memory of Computers International Association | |