Spreadsheet Sheet1

Terms related to MS Excel and useful shortcuts

1) A Spreadsheet is an electronic software mostly used for numeric data.

2) A Spreadsheet is software with many rows and columns.

3) By default a workbook contains one sheet in MS Excel 2016.

4) A Spreadsheet consists of 1048576 rows and 16384 columns.

5) Visicalc, Lotus 1-2-3 and VP Planner are examples of Spreadsheet software.

6) Spreadsheets are used to prepare Calendar, timetable, Attendance register, math tables,  Marks list, Employee’s database etc.

7) A cell is an intersection of a column and a row.

8) A selected cell or a cell with dark border around it is called an active cell.

9) In a Spreadsheet rows are labeled as numbers. Ex 1,2,3, ………… 1048576.

10) In a Spreadsheet columns are labeled as alphabets. Ex A, B, C, ………… AA,AB, ……XFD

11) A Formula bar is used for calculation and applying in-built functions.

12) In MS Excel a formula or a function will begin with a “=” (or) “+” symbol.

13) By default, the row height is 15 points and column width is 8.43 characters, which corresponds to 64 pixels.

14) Three types of data can be entered in MS - Excel worksheet, namely text, numbers and formulas.

15) When we enter numbers in a cell, they are automatically right aligned and text is left aligned.

16) The Fill Handle is a small black square at the lower right corner of an active cell.

17) MS Excel is an application program to make calculation in the computer.

18) If the data in a spreadsheet is changed, the computer automatically does all recalculation.

19) In an Excel the cell J20 means column J and row 20.

20) C5 cell means 3 rd Column and 5 th Row.

21) The file extension for a Excel sheet is .xlsx(newer versions after MS Office 2007) or .xls(older versions before MS Office 2003)

22) A range is a group of contiguous cells, which forms the shape of a rectangle. It can be as small as a single cell or as big as an entire worksheet.