Excel Skills Quiz Take our Excel Skills Quiz. Answer all 20 questions and we will email your results to you. There is only one correct answer for each of the multiple choice questions. Good Luck! Step 1 of 5 20% Which character starts and Excel formula?*@=/None of the aboveQ2: Excel always calculates a formula from left to right.TrueFalseI don't knowQ3: Which key is used to select Non-Contiguous cells?*ShiftALTCtrlNone of the above.I don't know.Q4: Which key is used to select Contiguous cells?*ShiftALTCtrlNone of the above.I don't know.Q5: By default what referencing does Excel apply to formulas?*RelativeAbsoluteSelectiveNone of the above.I don't know. Q6: Which functions are the Statistical Functions?*Count, Sum, MaximumCountA, Count, CountBlankRound, SumA, AverageNone of the above.I don't know.Q7: What symbol denotes Absolute Cell Referencing in a formula?*#=$+I don't know.Q8: When would you use Absolute Cell Referencing?*When more than one cell is included in the formula.When a cell reference is to remain unchanged when a formula is copied.When entering a numeric value into a cell.Never, it is now used in Excel.I don't know.Q8: What values can not be used in a Custom Fill List?*Months of the YearDays of the WeekWords followed by numbersLetters followed by numbersI don't know.Q9: What is a Nested IF function?*An IF function used with a Nest function.An IF function contained within the True or False argument of an IF function.It is a statistical function used to total a range of numbers.None of the aboveI don't knowQ10: How does a VLOOKUP function return a value?*By finding a matching value in the first column of a look up table.By finding the column and row values of a look up table.By finding the value in the numbered position of a list of values.None of the aboveI don't know Q11: What benefits do Defined Names provide?*Give a range of cells a relevant name.Provide Absolute Cell Referencing in formulas.Provide a name for a constant value in a formaula.All of the aboveI don't knowQ12: What feature has Sparklines, Data Bars, Colour Scales and Icon Sets?*ChartingPivot TablesPivot ChartsConditional FormattingI don't knowQ13: What is Goal Seek?*Advanced FilteringPivot TablesA feature to find the input value needed to achieve the desired result in a formula.Formula creation.I don't knowQ14: What is the purpose of a Pivot Table?*It extracts trends and significant patterns from a large, detailed data set.It provides an easy way to tabulate significant information and change the emphasis of the information through grouping and statistics.To provide analysis of a data set.All of the above.I don't knowQ15: What level of protection prevents sheets from being added and removed?*Cell and formula protectionWorksheet protectionWorkbook protectionFile protectionI don't know Q16: You have a list of sales for your business broken down by the state in which the sale occurred. You have been asked to total, average and count all the sales which occurred in your home state. Which functions would you use to do this?*DSum, DCount, DAverageSumIFS, CountIFS, AverageIFSCountIF, SumIF, AverageIFAll of the above.I don't knowQ17: You have been asked to set up a spreadsheet that your colleagues will use to enter the jobs they do and the time they spend on each job. Your colleagues will return the spreadsheet to you at the end of each week and you are to collate the answers into one spreadsheet. What Excel features would you use to ensure data integrity and facilitate the quick consolidation of the data?*Data Validation, Data ConsolidationData Protection, Data TablesGroup and Outlining, Pivot TablesInformation Functions, ScenariosI don't knowQ18: You have been asked to use Excel to determine the commission rate to apply to each sales reps commission payment at the end of the month. There are 3 commission rates depending on how much is sold. Which function would you use to do this?*HLookupVLookupIFDSumI don't knowQ19: What is the greatest challenge or challenges you face when using Excel?*Q20: What would you like to learn about in Excel that would make your job easier?* Name First Last Email * Don't worry we will never sell, trade or share your details. We hate SPAM!CompanyPosition/Role Keep me up to date on Excel Courses and Tips Quiz Date PhoneThis field is for validation purposes and should be left unchanged.