Spreadsheet Navigation | MCQs

Explanation

The Name Box normally displays the address of the "active cell" on the worksheet.

Data or Formula of the Current Active Cell can be viewed inside the Cell Contents box of the Excel Formula bar

Explanation

A cell reference or cell address is a combination of a column letter and a row number that identifies a cell on a worksheet.

For example, A1 refers to the cell at the intersection of column A and row 1; B2 refers to the second cell in column B, and so on.

Explanation

• move to the next cell in the sheet in ms excel: shift + page down
• ***
• move to the next cell in the row in ms excel: Tab
• ***
• MS Excel stands for Microsoft Excel
  

• In Excel, a Data Series is defined as a collection of related data.

   Microsoft Excel features calculation or computation capabilities, graphing tools, pivot tables etc.

• In MS Excel, automatically total a column or row of values: SUM