Top 550+ Solved Microsoft Excel (MS Excel) MCQ Questions Answer
Q. Which of the following is not a valid data type in Excel?
a. Number
b. Character
c. Label
d. Date/Time
Q. Which elements of a worksheet can be protected from accidental modification?
a. Contents
b. Objects
c. Scenarios
d. All of the above
Q. A numeric value can be treated as label value if …… precedes it.
a. Apostrophe (‘)
b. Exclamation (!)
c. Hash (#)
d. Tilde (~)
Q. Which area in an Excel window allows entering values and formulas?
a. Title Bar
b. Menu Bar
c. Formula Bar
d. Standard Tool Bar
Q. Multiple calculations can be made in a single formula using…..
a. Standard Formulas
b. Array Formula
c. Complex Formulas
d. Smart Formula
Q. In Excel the auto fill feature
a. Extends a sequential series of data
b. Automatically adds a range of cell values
c. Applies a boarder around selected cells
d. None of above
Q. In Excel you can use the formula palette to
a. Format cells containing numbers
b. Create and edit formulas containing functions
c. Entered assumptions data
d. Copy a range of cells
Q. What excel feature can you use if you want to work with one record at a time?
a. Auto Complete
b. Auto Filter
c. Data Form
d. Sub Totals
Q. In Excel what chart object is horizontal orvertical line that extends across the plot area to make it easier to read and follow the values?
a. Category axis
b. Data marker
c. Data point
d. Gridline
Q. In Excel value used in a formula that does not change is called a
a. Cell address
b. Constant
c. Function
d. Range
Q. In Excel which elements of worksheet can be protected from accidental modification ?
a. Contents
b. Objects
c. Scenarios
d. All of above
Q. In Excel you can use the drag and drop method to
a. Copy cell contents
b. Move cell contents
c. Add cell contents
d. (A) and (B)
Q. In Excel it is acceptable ot let long text flow into adjacent cells on a worksheet when
a. Data will be entered in the adjacent cells
b. No data will be entered in the adjacent cells
c. There is nt suitable abbreviation of the text
d. There is not time to format the next
Q. In Excel how can you delete a record?
a. Delete the column from the worksheet
b. Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button
c. Select Data > Delete Record from the menu
d. Click the Delete button on the Standard toolbar