Excel day 1

Which of the following is the correct syntax for the SUM function?

• =SUM(A1; A5)

• =SUM(A1:A5)

Which Excel function can be used to find the average of a range of values?  

• A) =SUM()

• B) =AVERAGE()

• C) =MEAN()

What does the Fill function in Excel help with?  

• A) Create charts automatically

• B) Copy a value or a sequence to adjacent cells

Which function is used to split text from one cell into multiple cells?  

• A) =SPLIT()

• B) =TEXTTOCOLUMNS()

What does the Transpose function do?  

• A) Combines data from multiple rows into one row

• B) Converts rows to columns or columns to rows

What is the purpose of the Sort & Filter function in Excel?  

• A) Add numbers in a column

• B) Sort data alphabetically or numerically and filter specific data

How can you create a drop-down list in Excel?  

• A) Through data validation

• B) With the SUM function

 What feature does Quick Analysis in Excel provide?  

• A) Instantly creating charts, conditional formatting, and totals

• B) Copying formatting between cells

Which Excel tool allows you to summarize data dynamically with rows and columns?  

• A) PivotTable

• B) Chart

  Which function would you use to count the number of cells in a range that contain numbers?  

• A) =COUNTIF()

• B) =COUNTA()

• C) =COUNT()