1. What does =CONCAT do?
A: Joins cells together if they contain letters.B: Joins cells together if they contain numbers and letters.C: Joins cells together, independent of the content in the cell.D: Removes whitespace.
2. In a VLOOKUP formula what will cause a #SPILL error?
A: If you reference a cell that has leading whitespace.B: If you fail to specify a lookup value in the first parameter.C: If a circular reference is made inside a table.D:#SPILL errors are not generated in VLOOKUP.
3. What is the keyboard shortcut to apply a filter?
A: CTRL + Shift + LB: Link Transit ExtensionC: Long Term EvolutionD: CTRL + Alt + F
4. What does the second parameter in an =IF function specify?
A: The logical test.B: What Excel should do if the logical test proves false.C: What Excel should do if the logical test proves true.D: The level of specificity.
5. How can you specify what Excel should do if it does not find a value using VLOOKUP?
A: Wrap the VLOOKUP in an =IFERROR function.B: Select TRUE in the last parameter of the VLOOKUP.C: Enclose the VLOOKUP in an =CATCH function.D: As of Excel 2019, this is not possible.
6. How do you calculate the difference between two dates?
A: =DATEBETWEENB: =DATEDIFC: =TIMEELAPSED: =IFDATEDIF
7. How can you store leading 0s in a cell?
A: Ensure the data type is set to Number.B: Store the file in a csv.C: Use the data type StringD: Ensure the data type is set to Text.
8. Which function performs a logical test, then sums numbers if the logical test is true?
A: =IFTHENSUMB: =SUMWHEREC: =TOTALIFD: =SUMIF
9. Which of these functions does not exist?
A: =CHITESTB: =XLOOKUPC: =LOGIFD: =HLOOKUP
10. Which function checks the length of a cell and returns the text "Super Easy CRM" if it is over 5 characters long and "Super Easy PA" if it is not?
A: =IF(LEN(C5)=5,"Super Easy CRM","Super Easy PA")B: =IF(COUNT(C5)>5,"Super Easy CRM","Super Easy PA")C: =IF(LEN(C5)>5,"Super Easy CRM","Super Easy PA")D: =IF(CHARLEN(C5)>5,"Super Easy CRM","Super Easy PA")