Basic
-
Sql, Basic Grammar
SQL Grammer _ BASIC SELECT – extracts data from a database UPDATE – updates data in a database DELETE – deletes data from a database INSERT INTO – inserts new data into a database CREATE DATABASE – creates a new database ALTER DATABASE – modifies a database CREATE TABLE – creates a new table ALTER TABLE – modifies a table DROP TABLE – deletes…
-
Basic Excel Functions
EXCEL FUNCTIONS_Basic AND Returns “TRUE” or “FALSE” based on two or more conditions. =AND(B2=”Fire”;C2>70) =IF(AND(B10=”Fire”;C10>70);”Yes”;”No”) AVERAGE Calculates the average =AVERAGE(B2:E2) AVERAGEIF Calculates the average of a range based on a true or false condition. =AVERAGEIF(range, criteria, [average_range]) AVERAGEIFS The average of a range based on one or more true or false condition. =AVERAGEIFS(average_range, criteria_range1, criteria1, …) CONCAT To link something together. =CONCAT(A2,” “,A3) =CONCAT(A2,”and”,A3) …