10 Important computer MCQs for BANK EXAMS, SSC Exams, Police exams etc
Que 1: 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
Correct Ans: C
Que 2: 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
Correct Ans: A
Que 3: How are data organized in a spreadsheet?
(A) Lines and spaces
(B) Layers and planes
(C) Rows and columns
(D) Height and width
Correct Ans: C
Que 4: 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
Correct Ans: C
Que 5: 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
Correct Ans: D
Que 6: A function inside another function is called a _______ function.
(A) Round
(B) Nested
(C) Sum
(D) Text
Correct Ans: B
Que 7: 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)
Correct Ans: D
Que 8: Microsoft Office is a __________.
(A) Shareware
(B) Public-domain software
(C) Open source software
(D) An application suite
Correct Ans: D
Que 9: The valid format of MS Word is __________.
(A) .doc
(B) .jpeg
(C) .exe
(D) .png
Correct Ans: A
Que 10: Unlike Filters queries can be saved as ________ in a database.
(A) Filters
(B) Objects
(C) Database
(D) Any of the above
Correct Ans: B
Login to add Comments.