Navigate

Question Detail

Which types of charts can excel produce ?

  • Line graphs and pie charts only
  • Bar charts, line graphs and pie charts
  • Bar charts and line graphs only
  • Only line graphs

Answer: Option B

Similar Questions :

1. To create an interactive Pivot Table for the web, you use a Microsoft Office Web component called ?

  • HTML
  • Pivot Table Field List
  • Pivot Table Report
  • Pivot Table List

Answer: Option C

2. When you press Ctrl + X after selecting some cells in Excel, what will happen then

  • The cell content of selected cells disappear from cell and stored in clipboard
  • The selected cells are deleted and cells are shifted up
  • The selected cells are deleted and the cells are shifted left
  • The cells selected are marked for cutting

Answer: Option D

3. Which function calculates your monthly mortage payment ?

  • PV
  • NPER
  • PMT
  • All of above

Answer: Option C

4. Auto calculate feature provides a quick way to view the results of an arithmetic operation on a range of cells.

  • True
  • False

Answer: Option A

5. In Excel Worksheet how can you show or hide the gridlines ?

  • Click Gridline tool on Forms toolbar
  • Go to Tools -> Options -> View tab and mark or remove the check box named Gridline
  • Both of above
  • None of above

Answer: Option C

Read more from - MS Excel Questions Answers