MS Excel -05

01. B7:B9 indicates:

  • 1Cells B7 and cell B9 only
  • 2Cells B7 through B9
  • 3Cell B8 only
  • 4None of the above
Answer:- 1
Explanation:-

No explanation is given for this question Let's Discuss on Board

02. Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?

  • 1Logical
  • 2Math & Trigonometry
  • 3Statistical
  • 4Financial
Answer:- 1
Explanation:-

No explanation is given for this question Let's Discuss on Board

03. The active cell:

  • 1is defined by a bold border around the cell
  • 2Receives the data the user enters
  • 3It is the formula bar
  • 4Only A and B
Answer:- 1
Explanation:-

No explanation is given for this question Let's Discuss on Board

04. A __________ is a grid with labeled columns and rows.

  • 1Dialog box
  • 2Worksheet
  • 3Clipboard
  • 4Toolbar
Answer:- 1
Explanation:-

No explanation is given for this question Let's Discuss on Board

05. In Excel, the Fill Color button on the Formatting toolbar is used for what?

  • 1To insert a background
  • 2To add borders
  • 3To select a distribution of figures
  • 4To add shading or color to a cell range
Answer:- 1
Explanation:-

No explanation is given for this question Let's Discuss on Board

06. In Excel, a Data Series is defined as what?

  • 1A type of chart
  • 2A cell reference
  • 3A collection of related data
  • 4A division of results
Answer:- 1
Explanation:-

No explanation is given for this question Let's Discuss on Board

07. What is represented by the small, black square in the lower-right corner of an active cell or range?

  • 1Copy handle
  • 2Fill handle
  • 3Insert handle
  • 4Border
Answer:- 1
Explanation:-

No explanation is given for this question Let's Discuss on Board

08. What are the tabs that appear at the bottom of each workbook called?

  • 1Reference tabs
  • 2Position tabs
  • 3Location tabs
  • 4Sheet tabs
Answer:- 1
Explanation:-

No explanation is given for this question Let's Discuss on Board

09. The first cell in EXCEL worksheet is labeled as

  • 1AA
  • 2A1
  • 3Aa
  • 4A0
Answer:- 1
Explanation:-

No explanation is given for this question Let's Discuss on Board

10. We can save and protect the workbook by

  • 1Write Reservation Password
  • 2Protection Password
  • 3Read-only Recommended
  • 4Any of the above
Answer:- 1
Explanation:-

No explanation is given for this question Let's Discuss on Board

Page 1 Of 2
Test
Classes
E-Book