Multiple-Choice-Template powerpoint presentation

a

1. tekhnologic Topic(excel) > kyle Ann marquez Hyacinth

2. tekhnologic Correct >

3. tekhnologic Wrong >

4. tekhnologic Topic(excel) > kyle Ann marquez Hyacinth

5. tekhnologic A = B @ C + D $ 1. Which symbol is used to indicate a formula in Excel? >

6. tekhnologic A SUM B MAX C AVG D MIN 2. Which function is used to add up a range of cells in Excel? >

7. tekhnologic A Ctrl + S B Ctrl + C C Ctrl + V D Ctrl + P 3. Which keyboard shortcut is used to save an Excel file? >

8. tekhnologic A Page layout B Home C Insert D Data 4. Which tab in Excel contains options for formatting cells? >

9. tekhnologic A Sort B Filter C Group D PivotTable 5. Which option in Excel allows you to sort data in ascending or descending order? >

10. tekhnologic A MAX B COUNT C AVERAGE D MIN 1. Which function is used to find the largest value in a range of cells in Excel? >

11. tekhnologic A Ctrl + ; B Ctrl + Shift + : C Ctrl + D D Ctrl + Shift + ; 2. Which keyboard shortcut is used to insert the current date in Excel? >

12. tekhnologic A Pie chart B Scatter chart C Line chart D Bar chart 3. Which chart type is best suited for comparing the proportions of different categories in Excel? >

13. tekhnologic A Conditional Formatting B Goal Seek C Data Validation D AutoFill 4. Which option in Excel allows you to apply a specific format to cells based on their values? >

14. tekhnologic A COUNTIFS B SUMIFS C COUNTIF D SUMIF 1. Which function is used to count the number of cells that meet multiple criteria in Excel? >

15. tekhnologic A Ctrl + Shift + N B Alt + Shift + N C Ctrl + N D Alt + N 2. Which keyboard shortcut is used to insert a new worksheet in Excel? >

16. tekhnologic A Concatenate B Text to Columns C Flash Fill D Merge Cells 3. Which option in Excel allows you to combine data from multiple cells into one cell? >

17. tekhnologic A =SUMIF(range, criteria, sum_range ) B =SUMIF(range, sum_range , criteria) C =SUMIF( sum_range , range, criteria) D =SUMIF(criteria, sum_range , range) How do you use the SUMIF function in Excel? > E =SUMIF(criteria, range) F =SUMIF( sum_range , criteria, range) G =SUMIF(range, criteria) H =SUMIF( sum_range , range, criteria)