Microsoft Excel MCQ Question and Answer

Microsoft Excel MCQ Question and Answer
201. In Excel you can use the drag and drop method to
  • Copy cel contents
  • Delete cells contents
  • Add cell contents
  • All of above
Show Answer
202. In Excel to balance your checkbook, your best method is
  • Copy your check amounts into excel so that you'll have a neat printout to work on
  • Use Excel to check your arithmetic
  • Downloads the Checkbook register templates from Templates on Microsoft Office Online
  • All of above
Show Answer
203. In Excel which formula can add the all the numeric values in a range of cells, ignoring those which are not numeric, and place the resulting a difference cell
  • Count
  • Average
  • Sum
  • None of above
Show Answer
204. In Excel to name a constant, you use the ................... dialog box
  • Create names
  • Define name
  • Paste name
  • Format cells
Show Answer
205. In Excel to cancel the marquee, press
  • Ctrl + End
  • End
  • Esc
  • Shift + Esc
Show Answer
206. In Excel the function caculates depreciation at the same amount each year over an asset's useful life
  • DB (fixed-declining balance)
  • SLN (straight line)
  • Single Accounting
  • Double Accounting
Show Answer
207. In Excel to center wrksheet titles across a rage of cell, you must
  • Select the cells containing the title text and use the fill handle to center the text across a range fo cells
  • Widen the columns
  • Select the cells containing the title text and use the fill handle to center the text
  • Widen the column
Show Answer
208. In Excel when integration Ms-Word and Excel Word is usually the
  • Server
  • Source
  • Client
  • None
Show Answer
209. In Excel charts tips can
  • Shw the formatting of a data label
  • Show the name f a data series
  • Show the value of data point
  • Both (B) and (C)
Show Answer
210. In Excel the Name box
  • shows the location of the previously active cell
  • Appears the left of the formula bar
  • Appears below the status bar
  • Appears below the menu bar
Show Answer
Questions and Answers for Competitive Exams Various Entrance Test