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.
| 451. |
Match the MS-Excel shortcut sequences given in Column-I with their descriptions in Column-II.Column - IColumn - II(i)+ + (a)Enters the current time into the active cell.(ii)+ + (b)Copies the value from the cell above the active cell into the cell(iii)+ + (c)Displays the Insert dialog box |
| A. | (i) - (c), (ii) - (b), (iii) - (a) |
| B. | (i) - (a), (ii) - (c), (iii) - (b) |
| C. | (i) - (b), (ii) - (c), (iii) - (a) |
| D. | (i) - (a), (ii) - (b), (iii) - (c) |
| Answer» B. (i) - (a), (ii) - (c), (iii) - (b) | |
| 452. |
What would be displayed in a cell, if it contains the following formula? =IF(AND(23 < 4, 45 = 15), "Good", "Bad") |
| A. | 45 |
| B. | 23 |
| C. | Good |
| D. | Bad |
| Answer» E. | |
| 453. |
Which of the following Paste operations will switch the rows and columns from TABLE 1 into TABLE 2? |
| A. | Wrap Text |
| B. | Transpose |
| C. | Swap |
| D. | Sort |
| Answer» C. Swap | |
| 454. |
Match the following MS-Excel functions given in Column-1 with their uses in Column - IIColumn - IColumn - II(i)AVERAGE(range)(a)Returns the number rounded to the nearest odd integer.(ii)ODD(number)(b)Current date is displayed in the cell.(iii)MOD(number1, number2(c)Rounds the number1 to the digits specified in number2.(iv)ROUND(number1,number2)(d)Returns the remainder when number1 is divided by the number2.(v)TODAY( )(e)Finds the average of the given range of numbers. |
| A. | (i) - (e), (ii) - (a), (iii) - (c), (iv) - (d), (v) - (b) |
| B. | (i) - (a), (ii) - (e), (iii) - (c), (iv) - (d), (v) - (b) |
| C. | (i) - (a), (ii) - (e), (iii) - (d), (iv) - (c), (v) - (b) |
| D. | (i) - (e), (ii) - (a), (iii) - (d), (iv) - (c), (v) - (b) |
| Answer» E. | |
| 455. |
Which of the following functions are available in MS Excel? |
| A. | PRODUCT |
| B. | SUM |
| C. | AVERAGE |
| D. | All of these |
| Answer» E. | |
| 456. |
Which one of the following options allows you to edit the styles of text, numbers and pages based on conditions in MS Excel? |
| A. | Style formatting |
| B. | Conditional formatting |
| C. | Editing |
| D. | Conditional designing |
| Answer» C. Editing | |
| 457. |
_______short cut keys allow to quickly select the entire range of cells. |
| A. | CTRL + SHIFT+ * |
| B. | CTRL + SHIFT + A |
| C. | SHIFT + A |
| D. | CTRL + A |
| Answer» B. CTRL + SHIFT + A | |
| 458. |
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 |
| Answer» B. 1\[\to \]iv, 2\[\to \]v, 3\[\to \]i, 4\[\to \]ii | |
| 459. |
Under which group of the Home tab of the Ribbon do you find the ?AutoSum?? |
| A. | Formula group |
| B. | Styles group |
| C. | Cells group |
| D. | Editing group |
| Answer» E. | |
| 460. |
In MS-Access, what is the function of the primary key? |
| A. | To identify each row of a table. |
| B. | To relate tables to each other using a foreign key. |
| C. | "To maintain reference and referential integrity. |
| D. | All of the above |
| Answer» E. | |
| 461. |
In MS-Access, what defines the information of each type of detail in a record? |
| A. | Tables |
| B. | Files |
| C. | Documents |
| D. | Fields |
| Answer» E. | |
| 462. |
In MS-Access, what do the rows in. a table represent? |
| A. | fields |
| B. | records |
| C. | data |
| D. | tables |
| Answer» C. data | |
| 463. |
What is the function of freeze column option? |
| A. | Inserts a new column |
| B. | Inserts a new row |
| C. | Deletes a row |
| D. | Freezes the selected column |
| Answer» E. | |
| 464. |
Which of these menu options must be chosen to set the primary key using the menu bar? |
| A. | Shortcut menu |
| B. | Edit menu |
| C. | File menu |
| D. | Help menu |
| Answer» C. File menu | |
| 465. |
When you right click on any field of the table, you will find a menu. What is it called? |
| A. | Shortcut menu |
| B. | Edit menu |
| C. | File menu |
| D. | Help menu |
| Answer» B. Edit menu | |
| 466. |
Which of these is/are DBMS? |
| A. | MS Access |
| B. | Oracle |
| C. | Fox pro |
| D. | All of these |
| Answer» E. | |
| 467. |
___ uniquely identifies a record of the table. |
| A. | Data view sheet |
| B. | Design view |
| C. | Primary key |
| D. | Forms |
| Answer» D. Forms | |
| 468. |
The Iconindicates that |
| 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» C. you are deleting the field. | |
| 469. |
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. | |
| 470. |
___ creates tables, modifies and organizes bulk data. |
| A. | Word processor |
| B. | Presentation software |
| C. | Animation software |
| D. | Data Base Management System (DBMS) |
| Answer» E. | |
| 471. |
Which view gives more control over the table or query? |
| A. | Design view |
| B. | Datasheet view |
| C. | Both (a) and (b) |
| D. | Neither (a) nor (b) |
| Answer» B. Datasheet view | |
| 472. |
What does the given window represent? |
| A. | Design view |
| B. | Datasheet view |
| C. | Database window |
| D. | File task pane window |
| Answer» C. Database window | |
| 473. |
Which shortcut key will open the task pane in MS-Access? |
| A. | Ctrl + F1 |
| B. | Ctrl + F5 |
| C. | Shift + F1 |
| D. | Shift + F5 |
| Answer» B. Ctrl + F5 | |
| 474. |
Which program in MS-Access is used to automate a repetitive task? |
| A. | Reports |
| B. | Forms |
| C. | Macros |
| D. | Pages |
| Answer» D. Pages | |
| 475. |
What is the maximum characters a field name can contain in MS- Access? |
| A. | 32 |
| B. | 64 |
| C. | 255 |
| D. | 100 |
| Answer» C. 255 | |
| 476. |
Alt + F4 is used for which of the following functions? |
| A. | To close any current window |
| B. | To open any current window. |
| C. | To open control panel, |
| D. | All of these |
| Answer» B. To open any current window. | |
| 477. |
Which one of the following components of control panel allows changing the behaviour of the hardware? |
| A. | User Accounts |
| B. | Hardware and Sound |
| C. | Network and Internet |
| D. | Programs |
| Answer» C. Network and Internet | |
| 478. |
Match the following. Column - I Column - II (i) + (a) To insert a new frame (ii) + + (b) To create a new movie (iii) + (c) To remove a frame (iv) (d) To show/hide Timeline window (v) + (e) Test Movie |
| A. | (i) - (b), (ii) - (e), (iii) - (d), (iv) - (c), (v) - (a) |
| B. | (i) - (d), (ii) - (e), (iii) - (b), (iv) - (c), (v) - (a) |
| C. | (i) - (b), (ii) - (d), (iii) - (e), (iv) - (a), (v) - (c) |
| D. | (i) - (d), (ii) - (e), (iii) - (b), (iv) - (a), (v) - (c) |
| Answer» D. (i) - (d), (ii) - (e), (iii) - (b), (iv) - (a), (v) - (c) | |
| 479. |
Which of the following is NOT a section in the Tools panel? |
| A. | Drawing section |
| B. | Stage section |
| C. | Color section |
| D. | Selection section |
| Answer» C. Color section | |
| 480. |
Identify the given tool. |
| A. | Hand Tool |
| B. | Deco Tool |
| C. | Bone Tool |
| D. | Pencil Tool. |
| Answer» C. Bone Tool | |
| 481. |
Which of the following is the most recent version of Windows Media player released along with Windows 7? |
| A. | Windows Media Player 10 |
| B. | Windows Media Player 11 |
| C. | Windows Media Player 12 |
| D. | Windows Media Player 14 |
| Answer» D. Windows Media Player 14 | |
| 482. |
Which of the following devices are based on wearable technology? |
| A. | Smart Shirt |
| B. | Smart Watch |
| C. | Google Glasses |
| D. | All of these |
| Answer» E. | |
| 483. |
An outermost part of computer is called skin ware. Which one of the following is an example of skin ware? |
| A. | Hard disk |
| B. | RAM |
| C. | SMPS |
| D. | Cabinet of CPU |
| Answer» E. | |
| 484. |
Match the following: A B 1. Software stores in IC is an example of A. Application software 2. Cabinet of CPU B. System software 3. CD of MS Word C. Skin ware 4. Railway Reservation System D. Live ware E. Firmware |
| A. | 1 - B, 2 - A, 3 - E, 4 - DB. |
| B. | 1 - D, 2 - C, 3 - E, 4 - AC. |
| C. | 1 - B, 2 - C, 3 - D, 4 - ED. |
| D. | 1 - B, 2 - D, 3 - A, 4 - EE. |
| Answer» C. 1 - B, 2 - C, 3 - D, 4 - ED. | |
| 485. |
Which of the following is an analog computer? |
| A. | Super computer |
| B. | Speedometer |
| C. | Micro computer |
| D. | ANURAG |
| Answer» C. Micro computer | |
| 486. |
Which of the following is the best quality photo printer? |
| A. | InkJet |
| B. | Laser |
| C. | Zoom |
| D. | Dot Matrix |
| Answer» B. Laser | |
| 487. |
The ___ is a set of rules which computers use to communicate with each other across a network. |
| A. | internet |
| B. | extranet |
| C. | protocol |
| D. | packet |
| Answer» D. packet | |
| 488. |
A browser is an interactive program that permits a user to view information from the computer. Which of the following is the function of a browser? |
| A. | Connecting to the source computer whose address is specified. |
| B. | Requesting for a new page from the source. |
| C. | Receiving a new page. |
| D. | All of these |
| Answer» E. | |
| 489. |
_______ is used to specify a style for a group of elements. |
| A. | ID selector |
| B. | Class selector |
| C. | CSS comment |
| D. | All of these |
| Answer» C. CSS comment | |
| 490. |
________ is used to centrally align the contents of paragraphs within a tag. |
| A. | <q align =" center"> |
| B. | <div align=" center"> |
| C. | <div=" center"> |
| D. | <q span=" center"> |
| Answer» C. <div=" center"> | |
| 491. |
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 |
| Answer» D. Neither statement A nor statement B is correct | |
| 492. |
Link attribute of tag specifies the color of ____ links in a document. |
| A. | Visited |
| B. | Active |
| C. | Unvisited |
| D. | External |
| Answer» D. External | |
| 493. |
The tag makes text ____. |
| A. | Bold |
| B. | Inline |
| C. | Underline |
| D. | Italic |
| Answer» E. | |
| 494. |
Which of the following attributes of tag specifies the background color of the document? |
| A. | Background |
| B. | Text |
| C. | Bgcolor |
| D. | Link |
| Answer» D. Link | |
| 495. |
To display an image on a HTML page, which one of the following is the correct syntax? |
| A. | <image source = "Mylmage.gif?> |
| B. | <img src = "Mylmage.gif?> |
| C. | <image = "Mylmage.gif"> |
| D. | <img = "Mylmage.gif?> |
| Answer» C. <image = "Mylmage.gif"> | |
| 496. |
Which attribute in the image tag is used for displaying the text, if the image is not present? |
| A. | src |
| B. | bgcolor |
| C. | alt |
| D. | alternate |
| Answer» D. alternate | |
| 497. |
tag is used to change attributes of text. What are those attributes? |
| A. | Color and Size |
| B. | Size and Face |
| C. | Color, Face and Size |
| D. | Only Color |
| Answer» D. Only Color | |
| 498. |
What is the syntax to insert a paragraph? |
| A. | <P ALIGN = left/center/right> |
| B. | <HR ALIGN = left/center/right> |
| C. | <BR ALIGN = left/center/right> |
| D. | <BODY ALIGN = left/center/right> |
| Answer» B. <HR ALIGN = left/center/right> | |
| 499. |
Which one of the following is NOT a correct syntax of tag to provide background color? |
| A. | <Body bgcolor = "Red"> |
| B. | <Body bgcolor = "rgb(0,0,0)"> |
| C. | <Body bgcolor = ?#000000?> |
| D. | <Body bgcolor = "#Red#"> |
| Answer» E. | |
| 500. |
Which attribute of tag gives the thickness of the rule? |
| A. | Width |
| B. | Size |
| C. | Height |
| D. | Thick |
| Answer» C. Height | |