Spreadsheet | MCQs

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

Explanation

ALT is not a valid function in MS EXCEL

'Alternate' is the full form of Alt on the keyboard of the computer.

while 

The SUM () adds individual values, cell references or ranges, or a mix of all three 

The MAX Function[1] is categorized under Excel Statistical functions. 

MIN will return the minimum value in a given list of arguments.

Explanation

To removes a sheet from workbook select the sheet, then choose Edit > Delete Sheet these options available in excel 2003 and earlier version.

In Microsoft Excel 2007 onward Choose Home > Delete > Delete Sheet on the Ribbon.

Explanation

Explanation

A cell can be edited through Press the F2 key or Click the formula bar or Double click the cell.

Explanation

Time series type is not valid for Fill Series dialog box in excel.

Explanation

Doctor’s symbol (Big Plus) indicates we that we can make selection to cell.

Explanation

In 2003 and earlier versions - From Format Cells dialog box click on Merge Cells check box

In 2007 and subsequent versions - Merge & Center icon on the Home ribbon.

Explanation

In Excel we can Find and Replace within the sheet or workbook.

Explanation

Excel sheet:

Cells: The basic unit of an Excel sheet, where data is entered. 

Rows: Horizontal lines that run across the sheet, numbered sequentially. 

Columns: Vertical lines that run down the sheet, identified by alphabetical letters. 

Workbook: A collection of one or more worksheets within a single Excel file.