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.