- Shortcut key for printing document is?
- a. ALT+P
- b. Ctrl+M
- c. Ctrl+P
- d. Ctrl+I
Explanation: Ctrl+P is the shortcut key for printing in Windows and almost all applications.
- Paste Special allows some operation where you paste to a new cell. Which of the following operations is valid?
- a. Square
- b. Percentage
- c. Goal Seek
- d. Divide
Explanation: Excel lets you divide the selected cells with the copied cells when pasting using the Paste Special function.
- What is the quickest way to select the entire worksheet?
- a. Choose edit, select all from the menu
- b. Click on the first column, press Ctrl, and then click on the last column
- c. Click on the first column, press Shift, and then click on the last column
- d. Click on the rectangle box on the upper left corner where column headings and row headings meet
Explanation: The quick way to select the entire worksheet is by clicking on the box where the row and column headings intersect.
- A numeric value can be treated as a label value if …… precedes it.
- a. Apostrophe (‘)
- b. Exclamation (!)
- c. Hash (#)
- d. Tilte (~)
Explanation: Excel treats numbers as text if an apostrophe is placed before them.
- How to display updatable current date in MS Excel?
- a. Date()
- b. Today()
- c. Now()
- d. Ctrl+;
- A function inside another function is called….
- a. Nested round function
- b. Sum function
- c. Sum function
- d. Text function
- If 10/2 is entered in a cell without applying any formats, Excel will treat this as
- a. Fraction
- b. Number
- c. Date
- d. Text
Explanation: If 10/2 is entered without any format, Excel will treat it as the 2nd of October.
- Which of the following shortcuts can be used to insert a new line in the same cell?
- a. Enter
- b. Alt+Enter
- c. Ctrl+Enter
- d. Shift+Enter
Explanation: Alt+Enter inserts a line break inside the same Excel cell.
- The chart type to visually compare values across a few categories is …?
- a. Pie
- b. Column
- c. Line
- d. Area
- A workbook is a collection of?
- a. Cells
- b. Worksheets
- c. Workspaces
- d. Projects
Answer: b. Worksheets
Explanation: A workbook contains worksheets, chart sheets, and module sheets.
- Microsoft Access is a
- a. RDBMS
- b. OODBMS
- c. ORDBMS
- d. Network Database Model
Answer: a. RDBMS
Explanation: MS Access is a Relational Database Management System.
- Which of the following is not a type of Microsoft Access Database Object?
- a. Table
- b. Form
- c. Worksheet
- d. Module
Answer: c. Worksheet
Explanation: In Access, the database objects include Tables, Queries, Forms, Reports, Macros, and Modules.
- In a relational schema, each tuple is divided into fields called
- a. Relations
- b. Domains
- c. Queries
- d. All of the above
Answer: b. Domains
Explanation: In relational terminology, tables are called relations, and fields are called attributes.
- Which of the following is not an option when printing handouts?
- a. Six slides per page
- b. Five slides per page
- c. Three slides per page
- d. Two slides per page
Answer: b. Five slides per page
- What is a motion path?
- a. A type of animation entrance effect
- b. A method of advancing slides
- c. A method of moving items on a slide
- d. All of the above
Answer: c. A method of moving items on a slide
Explanation: Motion path is a custom animation effect used to move objects on a slide.
- Communication channel is shared by all the machines on the network in
- a. Broadcast network
- b. Unicast network
- c. Multicast network
- d. None of the above
Answer: a. Broadcast network
Explanation: In a broadcast network, all nodes share the same communication channel.
- Which one of the following extends a private network across public networks?
- a. Local area network
- b. Virtual private network
- c. Enterprise private network
- d. Storage area network
Answer: b. Virtual Private Network
Explanation: VPN extends a private network over public networks.
- Which of the following memories needs refreshing?
- a. SRAM
- b. DRAM
- c. ROM
- d. All of the above
Answer: b. DRAM
Explanation: DRAM is dynamic RAM that needs refreshing periodically to retain data.
- Which of the following has a low failure rate?
- a. Mechanical devices
- b. Electronic devices
- c. Electro-mechanical devices
- d. None of the above
Answer: b. Electronic devices
Explanation: Electronic devices have lower failure rates compared to mechanical devices.
- Any data or instruction entered into the memory of a computer is considered as
- a. Storage
- b. Output
- c. Input
- d. Information
Answer: c. Input
Explanation: Data or instructions entered into a computer’s memory are considered input.
- Which of the following is not an application software package?
- a. Redhat Linux
- b. Microsoft Office
- c. Adobe PageMaker
- d. Open Office
Answer: a. Redhat Linux
Explanation: Redhat Linux is an operating system, not an application.
- What is a compiler?
- a. A compiler does a conversion line by line as the program is run
- b. A compiler converts the whole of higher level program code into machine code in one step
- c. A compiler is a general purpose language providing very efficient execution
- d. None of the above
Answer: b. A compiler converts the whole of higher level program code into machine code in one step
Explanation: A compiler processes the entire program at once.
- ASCII stands for
- a. American Stable Code for International Interchange
- b. American Standard Case for Institutional Interchange
- c. American Standard Code for Information Interchange
- d. American Standard Code for Interchange Information
Answer: c. American Standard Code for Information Interchange
- A computer virus is a
- a. Hardware
- b. Software
- c. Bacteria
- d. Freeware
Answer: b. Software
Explanation: Computer viruses are malicious software.
- The device primarily used to provide hardcopy is the
- a. CRT
- b. Computer Console
- c. Printer
- d. Card Reader
Answer: c. Printer
- …… allows us to organize our files so we can more easily find them
- a. Navigation
- b. Folder
- c. Desktop
- d. None of the above
Answer: b. Folder
- The … folder is the default place that most applications want to store data files in
- a. Start menu
- b. Recycle bin
- c. Program files
- d. My documents
Answer: d. My documents
Explanation: My Documents is the default folder for storing user files.
- ….. Tool helps to reduce the access time from disk
- a. Scandisk
- b. Disk defragmenter
- c. Backup
- d. Format
Answer: b. Disk defragmenter
Explanation: Disk defragmenter arranges fragmented files for faster access.
- Which is not true for operating system?
- a. Provides platform for programs
- b. Controls hardware
- c. Provides security
- d. It is a type of application
Answer: d. It is a type of application
- In MS Word, a quick way to make text bold is by pressing
- a. Ctrl+B
- b. Alt+B
- c. Shift+B
- d. Ctrl+Shift+B
Answer: a. Ctrl+B
- Which of the following is not a feature of the operating system?
- a. Memory management
- b. File system management
- c. Hardware interfacing
- d. None of the above
Answer: d. None of the above
Explanation: All listed options are features of an operating system.
- Which of the following memory units is the smallest?
- a. Byte
- b. Bit
- c. Kilobyte
- d. Megabyte
Answer: b. Bit
Explanation: A bit is the smallest unit of memory.
- The ‘root directory’ is located at
- a. C:
- b. C:\windows
- c. C:\Documents
- d. C:\Program Files
Answer: a. C:
Explanation: The root directory is typically the highest level of a storage device, usually marked as C:.
- Which of the following file extensions is not associated with image files?
- a. .png
- b. .jpg
- c. .bmp
- d. .txt
Answer: d. .txt
- The type of data a primary key can hold in a database is
- a. Numeric only
- b. Alphanumeric only
- c. Either numeric or alphanumeric
- d. Text only
Answer: c. Either numeric or alphanumeric
Explanation: Primary keys can hold numeric or alphanumeric values depending on the database structure.
- Which of the following is the correct HTML tag to create a hyperlink?
- a.
- b.
- c.
- d.
Answer: b.
- In HTML, which tag is used for the largest header?
- a.
- b.
- c.
- d.
Answer: b.
Explanation: is the largest header tag in HTML.
- Which of the following is used to create a table in HTML?
- a.
- b.
- c.
- d. All of the above
Answer: a.
- In CSS, which property is used to change the text color of an element?
- a. color
- b. text-color
- c. font-color
- d. background-color
Answer: a. color
- Which of the following is used to create a comment in CSS?
- a. // comment
- b. /* comment */
- c.
- d. # comment
Answer: b. /* comment */
- Which of the following is used to add a comment to a cell in Excel?
- a. Ctrl + C
- b. Shift + F2
- c. Alt + C
- d. Ctrl + F1
Answer: b. Shift + F2
- Which of the following is not a valid chart type in Excel?
- a. Bar chart
- b. Line chart
- c. Area chart
- d. Data grid chart
Answer: d. Data grid chart
- Which of the following functions will return the current time in Excel?
- a. TIME()
- b. NOW()
- c. CURRENTTIME()
- d. DATE()
Answer: b. NOW()
- What is the shortcut for inserting a new worksheet in Excel?
- a. Ctrl + N
- b. Ctrl + W
- c. Shift + F11
- d. Ctrl + F11
Answer: c. Shift + F11
- Which of the following is the correct function to calculate the average in Excel?
- a. SUM()
- b. AVERAGE()
- c. MEAN()
- d. MEDIAN()
Answer: b. AVERAGE()
- What does the "Ctrl + Z" shortcut do in most applications?
- a. Redo the previous action
- b. Undo the previous action
- c. Save the document
- d. Close the application
Answer: b. Undo the previous action
- Which of the following is a valid CSS property for setting the background color of a web page?
- a. background-color
- b. color-background
- c. bg-color
- d. background-coloration
Answer: a. background-color
- In HTML, which tag is used to create a hyperlink?
- a.
- b.
- c.
- d.
Answer: a.
- Which of the following is used to create a comment in HTML?
- a.
- b. /* comment */
- c. # comment
- d. -- comment --
Answer: a.
- Which of the following is the correct HTML tag to display an image?
- a.
- b.
- c.
- d.
Answer: a.
