COUNTAvalue1 value2 Counts non-blank cells. How a functions algorithm can affect the resulting value. COUNTvalue1value2 Determines the number of cells in a range that contain numbers.
The MOD function - Returns only the remainder of a division operation.
Shortcut keys particulars keys edit the active cell f2 create a chart f11 insert cell comment shift f2 function dialogue box shift f3 insert a new worksheet shift f11 name manager dialogue box ctrl f3 visual basic editor alt f11 macro dialogue box alt f8 hide the selected columns ctrl 0 unhide the columns ctrl shift 0 hide the selected rows ctrl 9 unhide the rows ctrl shift 9 select all cells with comment ctrl shift o ms excel 1192013 28. PowerPoint Presentation Last modified by. This function is used to adds all the values within a cell range. Here is a list of most frequently used mathematical formulas in excel.