Data Analytics - Excel Formulas Exam Questions with Complete Solutions Latest Version 2024

Data Analytics - Excel Formulas Exam Questions with Complete Solutions Latest Version 2024 HLOOKUP - Answers Performs a horizontal lookup by searching for a value in the TOP row of the table and returning the value in the same column based on the index number INDEX - Answers Returns either the value or the reference to the value from a table or range TRANSPOSE - Answers Returns a transposed range of cells VLOOKUP - Answers Performs a vertical lookup by searching for a value in the first column of a table and returning the value in the same row in the index number position XLOOKUP - Answers Performs a lookup (either vertical or horizontal) CONCAT - Answers Used to join 2 or more strings together FIND - Answers Returns the location of a substring in a string (case-sensitive) LEFT - Answers Extract a substring from a string, starting from the LEFT-most character LEN - Answers Returns the LENgth of a specified string LOWER - Answers Converts all letters in a specified string to LOWER case MID - Answers Extracts a substring from a string (starting at any position) NUMBERVALUE - Answers Returns a text to a number specifying the decimal and group separators PROPER - Answers Sets the first character in each word to uppercase and the rest to lowercase REPLACE - Answers REPLACEs a sequence of characters in a string with another set of characters RIGHT - Answers Extracts a substring from a string starting with the RIGHT-most character SEARCH - Answers Returns the location of a substring in a string TRIM - Answers Returns a text value with the leading and trailing spaces removed UPPER - Answers Convert all text to UPPERcase VALUE - Answers Converts a text value that represents a number to its numerical VALUE DATE - Answers Returns the serial date value for a date DATEDIF - Answers Returns the DIFference between two DATE values, based on the interval specified DAY - Answers Returns the day of the month (a number from 1 to 31) given a date value DAYS - Answers Returns the number of days between two dates HOUR - Answers Returns the hours (a number from 0-23) from a time value MINUTE - Answers Returns the minutes (a number from 0 to 59) from a time value MONTH - Answers Returns the month (a number from 1 to 12) given a date value NOW - Answers Returns the current system date and time SECOND - Answers Returns the seconds (a number from 0 to 59) from a time value TIME - Answers Returns a decimal number given an hour, minute, and second value TODAY - Answers Returns the current system date WEEKDAY - Answers Returns a number representing the day of the week, given a date value WEEKNUM - Answers Returns the week number for a date YEAR - Answers Returns a four-digit year ( a number from 1900 to 9999) given a date value CEILING - Answers Returns a number rounded UP based on a multiple of significance FLOOR - Answers Returns a number rounded down based on a multiple of significance INT - Answers Returns the integer portion of a number RAND - Answers Returns a random number that is greater than or equal to 0 and less than 1 RANDBETWEEN - Answers Returns a random number that is between a bottom and top range ROUND - Answers Returns a number to a specified number of digits ROUNDDOWN - Answers Returns a number rounded DOWN to a specified number of digits ROUNDUP - Answers Returns a number UP to a specified number of digits SIGN - Answers Returns the sign of a number SUBTOTAL - Answers Returns the subtotal of the numbers in a column in a list or database SUM - Answers Adds all numbers in a range of cells SUMIF - Answers Adds all numbers in a range of cells, based on one criteria