excel basic functions, Guías, Proyectos, Investigaciones de Aplicaciones Informáticas

¡Descarga excel basic functions y más Guías, Proyectos, Investigaciones en PDF de Aplicaciones Informáticas solo en Docsity!

BASIC FUNCTIONS EXCEL INPUT DESCRIPTION AVERAGE =AVERAGE(A2:A4) Average of the A2:A4 range suM =SUM(A2:A4) Sum of the A2:A4 range PRODUCT =PRODUCT(A2:A4) Product of the A2:A4 range SUMPRODUCT =SUMPRODUCT(A2:A4, B2:B4) Sum of the products of two ranges MAX =MAX(A2:A4) Maximum value of the A2:A4 range MIN =MIN(A2:A4) Minimum value of the the A2:A4 range POWER =POWER(AZ, 3) Value A2 to the power of 3 SQRT =SORT(A2) Square root of A2 COUNT =COUNT(A2:A4) It counts the e (numbers) in the COUNTIF =COUNTIF(A2:A4, criteria) It counts the number of items given one condition COUNTIFS e It counts the nu Mi E given two or more COUNTA COUNTA(A2:A4) It counts the number of cells with text or dates. BASIC FUNCTIONS EXCEL INPUT DESCRIPTION E ae oe co eo mece es If B5 is white and blue (at the same time) the AND =AND(B5="white”,B5="blue”) function returns TRUE. Otherwise it returns FALSE. It looks up value D1 in H9:N12 range and returns VLOOKUP =VLOOKUP(D1,H9:N12,7,FALSE) | the value from H9:N12 range that is in the column 7 (column 1 is the first column of H9:N12 range).