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
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
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
204. In Excel to name a constant, you use the ................... dialog box
- Create names
- Define name
- Paste name
- Format cells
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
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
208. In Excel when integration Ms-Word and Excel Word is usually the
- Server
- Source
- Client
- None
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)
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