Spreadsheet Management | MCQs

Explanation

AutoSum is a fast, easy way to add up multiple values in Excel.

You can access the AutoSum command from either the Home tab or the Formulas tab,

but there is a keyboard shortcut that makes it even faster: Alt + =. 

Explanation

Manual calculation mode means that Excel will only recalculate all open workbooks when we request it by pressing F9.

Explanation

Excel is a spreadsheet programme

Explanation

Explanation

A range is identified by the cell references of the cells in the upper left and lower right corners of the range.

These two references are separated by a colon ( : ) which tells Excel to include all the cells between these start and end points.

Explanation

• The title bar in MS Excel displays the name of the workbook
• ***
• in the Excel program.
• Click the File tab.
• Click Open.
• Press Ctrl + O to quickly display the Open tab of the Backstage view.
  
  

Explanation

Referred to as a cell pointer, current cell, or selected cell, an active cell is a rectangular box that highlights the cell in a spreadsheet.

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.