Excel Essentials Training

Which of the following is a spreadsheet software?

• Word

• PowerPoint

• Excel

• Paint

Which symbol is used to begin a formula in Excel?

• =

• #

• \$

• @

Which Excel function is used to add numbers?

• =MIN()

• =AVG()

• =ADD()

• =SUM()

What does “cell” refer to in Excel?

• A type of font

• A block in a spreadsheet where you enter data

• A storage file

• A button on the ribbon

Which Excel formula correctly calculates the average of cells A1 to A5?

• =AVERAGE(A1\:A5)

• =SUM(A1\:A5)/5

• =AVG(A1\:A5)

Which function is used to count only numeric values in a range?

• =COUNTA()

• =COUNTIF()

• =COUNT()

• =COUNTBLANK()

What feature in Excel helps create interactive dashboards?

• Conditional Formatting

• Data Validation

• Pivot Tables

• SmartArt

Which formula returns “Pass” if A1 is 50 or higher, otherwise “Fail”?

• =IF(A1>=50,"Pass","Fail")

• =IF(A1>50,"Fail","Pass")

• =A1>=50?Pass\:Fail

• =CONDITIONAL(A1,50)

How can you apply the same formula to multiple cells quickly?

• Copy and paste

• Use AutoFill

• Manually type in each cell

• Select and drag the cell handle

What does the VLOOKUP function do?

• Finds vertical data in a table

• Visualizes charts

• Views the lookup range

• Validates lookup