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
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
233. In Excel Status indicators are located on the
- Verticall Scroll bar
- Horizontal scroll bar
- Formula bar
- Standard toolbar
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
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
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
237. An excel workbook is a collection of
- Workbooks
- Worksheets
- Charts
- Worksheets and charts
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
240. In Excel Status indiators are located on the
- Vertical scrollbar
- Horizontal Scroll bar
- Formula bar
- Formatting toolbar