BasicExcel Please enable JavaScript in your browser to complete this form.Please enable JavaScript in your browser to complete this form.Name *FirstLastEmail *Q1. What does a cell reference like A1 represent? *Column A onlyRow 1 onlyIntersection of column A and row 1A formulaQ2. Which formula correctly adds values in cells A1 through A10? *=ADD(A1:A10)=SUM(A1:A10)=TOTAL(A1:A10)=PLUS(A1:A10)Q3. What is the shortcut to copy in Excel? *Ctrl + XCtrl + VCtrl + CCtrl + PQ4. What does “Freeze Panes” do? *Locks cells from editingKeeps rows/columns visible while scrollingHides columnsProtects the workbookQ5. What is the file extension for Excel workbooks? *.docx.xlsx.csv.pptxQ6. What does the formula =AVERAGE(A1:A5) do? *Finds the largest valueAdds valuesCalculates the meanCounts cellsQ7. Which formula counts only numeric values?=COUNT(A1:A10)=COUNTA(A1:A10)=COUNTIF(A1:A10)=SUM(A1:A10) a if do? Q8. What does =IF(A1>10,"Yes","No") do? *Adds valuesReturns Yes if A1 > 10, otherwise NoCounts cellsFormats textQ9. Which function looks up a value vertically?HLOOKUPVLOOKUPLOOKUPXINDEXQ10. What does =MAX(A1:A10) return? *Smallest valueAverageLargest valueCountWhat is a Pivot Table used for? *Formatting CellsWriting FormulasSummarizing and analyzing dataPrinting ReportsWhat does Condiditional Formatting do? *Deletes DataApplies formatting based on rulesLocks cellsCreates chartsWrite a formula to add cells B1 thru B5 (Include the "=" in your answer) *Write a formula to return “Pass” if A1 is greater than 70, otherwise “Fail”. (Include the "=" in your answer) *Submit Quiz