Computer MCQ Questions with answers

WhatsApp Facebook 🖤 Twitter

Here Important Computer MCQ questions are added which are frequently asked in almost all the examinations. You can check the correct answer of any question on clicking the show answer button. The Correct answer will be displayed below. You can share any question with your friends on whatsapp by tapping Share button.

Learn Computer mcqs in hindi here.

📊 Computer
Q. Each excel file is called a workbook because
  • (A) It can contain text and data
  • (B) It can create charts
  • (C) It can contain many sheets including worksheets and chart sheets
  • (D) It can be modified
💬 Discuss
✅ Correct Answer: (C) It can contain many sheets including worksheets and chart sheets
📊 Computer
Q. Which among the following is true regarding charts in Excel 2016?
  • (A) It has many charts including Bar charts, line graphs and pie charts
  • (B) It has Line graphs and pie charts only
  • (C) It only provides line graphs
  • (D) It has Bar charts and line graphs only
💬 Discuss
✅ Correct Answer: (A) It has many charts including Bar charts, line graphs and pie charts
📊 Computer
Q. How are data organized in a spreadsheet?
  • (A) Lines and spaces
  • (B) Layers and planes
  • (C) Rows and columns
  • (D) Height and width
💬 Discuss
✅ Correct Answer: (C) Rows and columns
📊 Computer
Q. What does the LOOKUP function do?
  • (A) Looks up text that contain ‘UP’
  • (B) Finds irrelevant records
  • (C) Used to look in a single row or column and find a value from the same position in a second row or column
  • (D) All of above
💬 Discuss
✅ Correct Answer: (C) Used to look in a single row or column and find a value from the same position in a second row or column
📊 Computer
Q. Which of the following is a correct order of precedence in a formula calculation?
  • (A) Multiplication and division, subtraction, exponential positive and negative value
  • (B) Addition and subtraction, positive and negative values, exponentiation
  • (C) Multiplication and division, positive and negative values, addition and subtraction
  • (D) None of above
💬 Discuss
✅ Correct Answer: (D) None of above
📊 Computer
Q. A function inside another function is called a _______ function.
  • (A) Round
  • (B) Nested
  • (C) Sum
  • (D) Text
💬 Discuss
✅ Correct Answer: (B) Nested
📊 Computer
Q. Which of the following will set text in selected cells to italics?
  • (A) Using the Tools – Wizard – Web Form menu item
  • (B) Pressing Ctrl + I on the keyboard
  • (C) Using the Format – Cells – Font menu item
  • (D) Both (a) and (c)
💬 Discuss
✅ Correct Answer: (D) Both (a) and (c)
📊 Computer
Q. Microsoft Office is a __________.
  • (A) Shareware
  • (B) Public-domain software
  • (C) Open source software
  • (D) An application suite
💬 Discuss
✅ Correct Answer: (D) An application suite
📊 Computer
Q. The valid format of MS Word is __________.
  • (A) .doc
  • (B) .jpeg
  • (C) .exe
  • (D) .png
💬 Discuss
✅ Correct Answer: (A) .doc
📊 Computer
Q. Unlike Filters queries can be saved as ________ in a database.
  • (A) Filters
  • (B) Objects
  • (C) Database
  • (D) Any of the above
💬 Discuss
✅ Correct Answer: (B) Objects

Explanation:

Unlike filters, which are used to display specific data temporarily, queries can be saved as objects in a database. These saved query objects allow users to execute the same query multiple times without having to recreate it each time. Queries stored as objects are reusable and can be easily accessed and modified when necessary.

  • (A) Filters are temporary and are not saved as objects.
  • (C) Database refers to the entire collection of data, not a specific saved query.
  • (D) Any of the above is incorrect because only queries are saved as objects.

Jump to

Tags: Computer mcqs, important mcqs of Computer, Computer important Computer mcqs, mcqs on Computer, important mcqs on Computer, mcqs of Computer

Attempt 350+ Quizzes on Computer

📱 Download Our App

Learn MCQs on the go with our easy-to-use Android app

Get it on Google Play

📚 Select Subject

Click on any subject to explore thousands of MCQs and start practicing