Navigate Worksheets [Arrow Keys] Navigate by one cell at a time in any direction [Page Down]/[Page Up] Move one screen down/ up [Alt]+[Page Down]/[Page Up] Move one screen right/ left [Tab]/[Shift]+[Tab] Move one cell to the right/ to the left in a worksheet [Ctrl]+[Arrow Keys] Move to the edge of next data region (cells…
COUNTA is an excel formula that is used to count, the number of cells in a range that have values or data in a given/selected range. It can be used to count numbers/texts in columns, rows or in multiple selected cells. Formula: =COUNTA(Value1,Value2,…) Below are examples of the simple usage of the COUNTA formula. In Formula Bar, you will…
COUNT is an excel formula that is used, as suggestive it can be, to count, the number of cells in a range that have numbers in a given/selected range. It can be used to count numbers in columns, rows or in multiple selected cells. Formula: =COUNT(Value1,Value2,…) Below are examples of the simple usage of the COUNT formula.…
SUM is an excel formula that is used for addition of values in given/selected cells. It can be used to add numbers in a columns, rows or in multiple selected cells. Formula: =SUM(Cell1,Cell2,…) Below are examples of the simple usage of the SUM formula. In Formula Bar, you will be able to see the SUM formula…