Warriors of Excel

Which Excel function is used to create a line chart?

• =CHART()

• Insert Tab > Line Chart

• =LINEGRAPH()

• Data Tab > Graph

What is the primary purpose of the VLOOKUP function?

• To look up vertical data in a range

• To find and replace data

• To create pivot tables

• To calculate totals

Which function would you use to combine text and date in one cell?

• CONCATENATE

• TEXT

• & (ampersand)

• All of the above

How can you sort data in Excel?

• Home Tab > Sort

• Data Tab > Sort

• Insert Tab > Sort

• File Tab > Sort

Which logical function checks if a condition is TRUE or FALSE?

• AND

• IF

• OR

• NOT

What type of chart is best for showing trends over time?

• Bar Chart

• Pie Chart

• Line Chart

• Scatter Chart

What is the purpose of a PivotTable?

• To calculate averages

• To organize and summarize data

• To create graphs

• To lookup values

Which formula counts the number of cells in a range that meet a specific condition?

• =COUNTIF()

• =IF()

• =SUMIF()

• =COUNTA()

How do you update a PivotTable after changing the data source?

• Right-click and choose "Refresh"

• Create a new PivotTable

• Reapply the filter

• Save the workbook

Which function would you use to calculate the difference between two dates?

• =DATEDIF()

• =DATE()

• =TODAY()

• =NOW()