Basics of Spreadsheet

Answer

A spreadsheet is a large sheet having data and information arranged in rows and columns. It is useful for entering, editing, analysing, and storing data, and it supports arithmetic operations, sorting…

Answer

MS Excel 2007 is a spreadsheet application and part of the Microsoft Office suite. It is used for working with data in rows and columns, doing calculations, sorting data, and preparing reports.

Answer

A workbook is an Excel file that can hold many worksheets. It acts like a container for related sheets in one file.

Answer

A worksheet is a grid of columns and rows contained within a workbook. Columns are shown by letters and rows by numbers, and data is entered into the cells formed by their intersections.

Answer

A cell is the intersection of a column and a row. Each cell has a unique cell address made of the column letter and row number, such as A8.

Answer

Cell A1 is the default active cell when an Excel worksheet is opened. The active cell has a darker border than other cells, so it is easy to identify where typing will begin.

Answer

By default, three worksheets are included in each workbook.

Answer

Main spreadsheet features include AutoSum, List AutoFill, AutoFill, AutoShapes toolbar, Wizard, Drag and Drop, Charts, PivotTable, and Shortcut Menus. These features help with calculation, formatting,…