Top 550+ Solved Microsoft Excel (MS Excel) MCQ Questions Answer
Q. In Excel one want to track the progress of the stock market on a daily basis. Which type of chart should one use?
a. Pie chart
b. Row chart
c. Line chart
d. Column chart
Q. In Excel without using the mouse or the arrowkeys, what is the fastest way of getting to cell A1 in a spreadsheet?
a. Press Ctrl +Home
b. Press Home
c. Press Shift + Home
d. Press Alt + Home
Q. Which of the following methods cannot be used to edit the contents of a cell In Excel?
a. Press the Alt key
b. Clicking the formula bar
c. Pressing the F2 key
d. Double clicking the cell
Q. In Excel if you begin typing an entry into a cell and then realize that you don’t want your entry placed into a cell, you
a. Press the Erase key
b. Press Esc
c. Press the Enter button
d. Press the Edit Formula button
Q. In Excel default style for new data keyed in a new workbook is
a. Comma
b. Currency
c. Normal
d. Per cent
Q. In Excel LEN function does what?
a. Compares the content in two cells
b. Counts the numbers of characters in a cell
c. Deletes extra space in text
d. All of above
Q. In Excel this function converts miles to kilometers, kilograms to pounds, and so on
a. Convert
b. Product
c. Change
d. All of above
Q. In Excel you can use the drag and drop method to
a. Copy cell contents
b. Delete cells contents
c. Add cell contents
d. All of above
Q. In Excel to balance your checkbook, your best method is
a. Copy your check amounts into Excel so that you’ll have a neat printout to work on
b. Use Excel to check your arithmetic
c. Download the Checkbook register templates from Templates on Microsoft Office Online
d. All of above
Q. In Excel which formula can add the all thenumeric values in a range of cells, ignoring those which are not numeric, and place the resulting a difference cell
a. Count
b. Average
c. Sum
d. None of above
Q. In Excel to name a constant, you use the…… dialog box
a. Create name
b. Define name
c. Paste name
d. Format cells
Q. In Excel the function calculates depreciation at the same amount each year over an asset’s useful life
a. DB (fixed-declining balance)
b. SLN (straight line)
c. DDB (double-declining)
d. All of above
Q. In Excel the following is not an underline option in the format cells dialog box
a. Double
b. Single Engineering
c. Single Accounting
d. Double Accounting
Q. In Excel to center worksheet titles across a range of cell, you must
a. Select the cells containing the title text and use the fill handle to center the text across a range of cells
b. Widen the columns
c. Select the cells containing the title text and use the fill handle to center the text across a range of cells
d. Widen the column