Microsoft Excel 2016 Certification Formulas exam |23 questions and answers.

Count Counts the number of cells in a range that contain numbers MIN Displays the lowest value MAX Displays the highest value Relative A cell reference that Excel adjusts as it is copied Absolute A cell reference that stays the same when copying Row Numbered and horizontal Column Lettered and vertical Vertical Up and down Horizontal Left to right 3 things you can find in a cell... Formula, number, and text Left Displays the number of characters from left to right Right Displays the number of characters from right to left CONCATENATE Combines 2 or more cells into one SUMIF Finds the sum of a range of cells that meet a given condition AVERAGEIF Finds the average of a range of cells that meet a given condition IF Checks whether a condition is met and returns one value if true and another if false Proper Changes the first letter of each word to uppercase and all others SUM Adds the numbers in a range of cells CountIF Counts the number of cells that meet a given condition CountA Counts the number of cells that are NOT empty Greater Than >