Excel Application Quiz

What function is used to sum values in Excel?

• IF

• SUM

• AVERAGE

• COUNT

Which of the following is a way to input data into Excel?

• Typing directly into a cell

• Using a calculator

• Copying from a website

• Drawing on the screen

What does the AVERAGE function do in Excel?

• Counts the number of entries

• Calculates the total sum

• Determines the maximum value

• Finds the average of a range of numbers

In Excel, what does the IF function help to determine?

• A condition based on a logical test

• The average score

• The total number of entries

• The highest score

What is the purpose of a gradebook in Excel?

• To create charts

• To record student grades

• To format text

• To input data only

Which formula would you use to calculate the average of scores in cells B2 to D2?

• =IF(B2:D2)

• =COUNT(B2:D2)

• =AVERAGE(B2:D2)

• =SUM(B2:D2)

What type of chart can be created in Excel to visualize data?

• Cell format

• Formula bar

• Text box

• Bar chart

What is the first step in creating a gradebook for 10 students?

• Use the IF function

• Create a chart

• Create a table

• Fill in the scores

If a student's average score is 80, what formula would you use to check if they pass (assuming passing is 75)?

• =IF(A2<75, 'Pass', 'Fail')

• =IF(A2>=75, 'Pass', 'Fail')

• =IF(A2=75, 'Pass', 'Fail')

• =IF(A2>75, 'Fail', 'Pass')

What is the purpose of formatting data in Excel?

• To delete unnecessary data

• To make data easier to read

• To add more data

• To change the font style