Microsoft Excel MCQ Question and Answer

Microsoft Excel MCQ Question and Answer
231. In excel which of these is a quick way to copy formatting from a selected cell to two other cells on the same worksheet ?
  • use Ctrl to select all three cells, then click the paste button on the standard toolbar
  • Copy the selected cell, then select the other two cells, click style on the format menu, then click modify
  • Click format painter on the Formatting toolbar twice then click in each cell you want to copy the formatting to
  • All of above
Show Answer
232. To edit data in an embedded Excel worksheet object in a word document
  • Use Ctrl to selet all three cells, then click the paste button on the standard toolbar
  • Copy the selected cell, then select the other two cells, click style on the format menu then, click modify
  • Click format painter on the Formatting toolbar twice then click in e ach cell you want to copy the formatting to
  • All of above
Show Answer
233. In Excel Status indicators are located on the
  • Verticall Scroll bar
  • Horizontal scroll bar
  • Formula bar
  • Standard toolbar
Show Answer
234. In Excel Rounding errors can occur.
  • When you use multiplication, dividion, or exponentiation in a formula
  • When you use addition and subtraction in a formula
  • Because excel uses hidden decimal places in computation
  • When you shows the results of formulas with different decimal places that the calculated results
Show Answer
235. In Excel one can copy data or formulas
  • With copy , paste and cut commands on the edit menu
  • With commands on ta shortcut menu
  • With buttons on the standard toolbars
  • All of the above
Show Answer
236. In Excel you cannot link excel worksheet data to a word document
  • With the right drag method
  • With a hyperlink
  • With the copy and paste special commands
  • With the copy and paste buttons on the standard toolbar
Show Answer
237. An excel workbook is a collection of
  • Workbooks
  • Worksheets
  • Charts
  • Worksheets and charts
Show Answer
238. Excel files have a default extension of
  • Xls
  • Xlw
  • Wk1
  • 123
Show Answer
239. In Excel one can use the format painter mutiple times before one turn it off by
  • You can use the format painter button only one time when you clik it
  • Double clicking the format painter button
  • Pressing the Ctrl key and clicking the for mat painter button
  • Pressing the Alt key and clicking the format painter button
Show Answer
240. In Excel Status indiators are located on the
  • Vertical scrollbar
  • Horizontal Scroll bar
  • Formula bar
  • Formatting toolbar
Show Answer
Questions and Answers for Competitive Exams Various Entrance Test