Tekeducate2017.weebly.com



2013 Excel Lesson 10 Guided NotesUsing Formulas to Conditionally Summarize DataWhat is a conditional formula?What does the SUMIF formula calculate?What is the syntax for the SUMIF formula?What are the arguments for the SUMIF function?ArgumentExplanationRangeCriteriaSum_rangeIs it necessary to type dollar signs or commas when entering dollar amounts in the Function Arguments dialog box?Using SUMIFSIs the order of the arguments in the SUMIFS function the same as the order in the SUMIF function?Using COUNTIFWhat does the COUNTIF function do?What is the syntax for the COUNTIF function?Using COUNTIFSWhat does the COUNTIFS function do?What is the syntax for the COUNTIFS function?What does the wildcard question mark (?) do in a formula?What does the wildcard asterisk (*) do in a formula?How do you find an actual question mark or asterisk in a formula?Using AVERAGEIFWhat does the AVERAGEIF function do?Using AVERAGEIFSWhat does the AVERAGEIFS function do?Using Functions to Look Up Data in a WorkbookWhat do LOOKUP functions do?Explain the VLOOKUP function.What is table_array?If VLOOKUP returns the #N/A error value, what does that mean?What values can table_array be?The values in the _________ column of the Table_array selection must be placed in ______________sort order; otherwise, VLOOKUP might not give the correct valueIf the Range_lookup argument is ______________ or _______________, an exact or __________________ match is returned. If VLOOKUP cannot find an ______________ match, it returns the next _____________ value that is _________ than the value you specified in Lookup_value.If Range_lookup is ___________, VLOOKUP finds only an ___________ match. If an exact match is not found, the error value______________ is returned.Are range names or cell references used in VLOOKUP or HLOOKUP case sensitive?Using HLOOKUPExplain HLOOKUP.Function Syntax for VLOOKUP and HLOOKUPArgumentNotesLook_up valueTable_arrayCol_index_numRow_index_numRange_lookupAdding Conditional Logic Functions to FormulasWhat functions are used to create conditional formulas that result in a logical value, that is, True or False?Using IFExplain the IF function.Using ANDExplain the AND function.Using ORExplain the OR function.Using NOTExplain the NOT function.Using IFERRORExplain the IFERROR function.Converting Text to ColumnsWhat do you use to simple cell content into different columns?What are two delimiters that could be used to split cell content?Using LEFTExplain the LEFT functionUsing RIGHTExplain the RIGHT function.Using MIDExplain the MID function.Using TRIMWhat does the TRIM function do?Using PROPERExplain the PROPER function.Using UPPERExplain the UPPER function.Using LOWERExplain the LOWER function.Using CONCATENATEExplain the CONCATENATE function.Using FINDExplain the FIND function.Using SUBSTITUTEExplain the SUBSTITUTE function. ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download