Top 1000+ Solved Important Computer MCQs For Competitive Exams part-1 MCQ Questions Answer
Q. Where can you set the shedding color for a range of cells in Excel?
a. Choose required color form Patterns tab of Format Cells dialog box
b. Choose required color on Fill color tool in Formatting toolbar
c. Choose required color on Fill Color tool in Drawing toolbar
d. All of these
e. None of these
Q. You can set Page Border in Excel from:
a. From Border tab in Format Cells dialog box
b. From Border tool in Formatting toolbar
c. From Line Style tool in Drawing toolbar
d. You cannot set page border in Excel
e. None of these
Q. When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply :
a. use = if ( ) function to format the required numbers red
b. Apply Conditional Formatting Command on Format Menu
c. Select the cells that contain number between 0 and 100 then click Red color on Text Color tool
d. All of these
e. None of these
Q. You can check the conditions against…….. when applying conditional formatting :
a. Cell value
b. Formula
c. Alignment
d. Both (a) and (b)
e. None of these
Q. Which of the following is invalid statement?
a. Sheet tabs can be colored
b. Some picture can be applied as a background of a sheet
c. You can set the column width automatically fit the amount of text
d. The width of a row and be specified manually or fit automatically
e. None of these
Q. What function displays row data in a column or column data in a row?
a. Hyperlink
b. Index
c. Transpose
d. Rows
e. None of these
Q. When you insert an Excel file into a word document, the data are :
a. Hyperlinked
b. Placed in a word table
c. Linked
d. Embedded
e. None of these
Q. Except for the……….function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result :
a. IF
b. AND
c. OR
d. NOT
e. None of these
Q. Macros are “run” or executed from the…………..menu.
a. Insert
b. Format
c. Tools
d. Data
e. None of these
Q. You can open the consolidate dialog box byt choosing consolidate from the…….menu.
a. Insert
b. Format
c. Tools
d. Data
e. None of these
Q. Each excel file is called a workbook because :
a. It can contain text and data
b. It can be modified
c. It can contain many sheets including worksheets and chart sheets
d. You have to work hard to create it
e. None of these
Q. Which types of charts can excel produce?
a. Line graphs and pie charts only
b. Only line graphs
c. Bar charts, line graphs and pie charts
d. Bar charts and line graphs only
e. None of these
Q. How are data organized in a spreadsheet?
a. Lines and spaces
b. Layers and planes
c. Rows and Columns
d. Height and width
e. None of these
Q. What does the VLOOKUP function do?
a. Looks up text that contain ‘v’
b. Checks whether text is the same in one cell as in the next
c. Finds related records
d. All of these
e. None of these
Q. Gridlines :
a. May be turned off for display but turned on for printing
b. May be turned on or off or printing
c. The be turned off for display and printing
d. All of these
e. None of these