MS Excel Quiz

1. 1. Which part of Microsoft excel shows in the picture and area where we can enter or edit text?

• Name Box

• Formula Bar

• Title Bar

• Column Header

2. 2. Part of Microsoft Excel that is located at the bottom of the spreadsheet.

• Workbook

• Sheets

• Worksheet Tabs

• Blank Sheets

3.  The LIS Coordinator of Kaytitinga Integrated School wants to get the total number of their enrollment using MS Excel, choose the appropriate formula to get the total number of enrollment in KIS from Grade 7 to Grade 12 that can be found in cells A3 to F3.

• A3+F3

• =A3+F3

• =SUM(A3+F3)

• =SUM(A3:F3)

4. Cherry is a Grade 11 student; She managed her budget by using MS Excel to monitor her expenditures. She has the total expenses of food in E4 and total expenses of transportation in F4. Compute the total daily expenses of Cherry.

• =E4+F4

• E4+F4

• =SUM(E4+F4)

• SUM(E4:F4)

5.  Starbuko Juice performed a survey to their customers after their launch week, they used MS Excel to easily retrieve the result. They want to know the average taste that the 20 customers supply in P1 to P20, identify the correct formula to get the average.

• =AVERAGE(P1-P20)

• =AVERAGE(P1;P20)

• =AVERAGE(P1:P20)

• =AVERAGE(P1+P20)