Quiz - Kattlyn S. Valdez powerpoint presentation

a

1. tekhnologic Excel > KATTLYN S. VALDEZ HYACINTH

2. tekhnologic A Formula B Auto summary C Repeat c haracters D Text Which expression begins with the equal sign in Excel? >

3. tekhnologic A Ctrl+S B Ctrl+C C Ctrl+P D Ctrl+Y What is the keyboard shortcut to save an Excel spreadsheet? >

4. tekhnologic A . xlsx B . xlsm C .xls D .exls What is the file extension for Excel worbooks ? >

5. tekhnologic A Email chart B Bubble chart C Line chart D Pie chart Which of the following is NOT a valid chart type in Excel? >

6. tekhnologic A =GETDATA() B =SUMIF() C = COUNTIF () D =IFERROR() Which of the following is NOT a valid function in Excel? >

7. tekhnologic A Ctrl+S B Ctrl+I C Ctrl+E D Ctrl+P What is the shortcut to save a workbook in Excel? > E Ctrl+V F Ctrl+Z

8. tekhnologic A AVERAGE() B MEAN() C AVG() D COUNT() What is the functioning used to calculate the average in Excel? > E SUM() F MIN()

9. tekhnologic A AVERAGEIF() B MEANIF() C AVGIF() D COUNTIF() Which excel function is used to find the average of a range that meets specific criteria? > E SUM() F MINIF()

10. tekhnologic A Alt + = B Alt + F4 C Ctrl + AVE D Ctrl + Shift + A What is the keyboard shortcut to quickly insert the AVERAGE() function in Excel? > E Ctrl + Shift + A F Ctrl + A

11. tekhnologic A Right-click and select “Insert” B Press Alt+Shift+I C Press Ctrl +I D Press Ctrl+E How can you insert a new row in Excel? > E Press Ctrl+R F Press Ctrl+S G Press Ctrl+Z H Press Ctrl+P

12. tekhnologic A Right-click and select “Sort” B Press Ctrl+Z C Go to the Sort tab and select the desired sorting option D Sorting data alphabetically How do you sort data in Excel? > E Press Ctrl+S F Press Ctrl+I G Type “sort” into a cell H Press Ctrl+R

13. tekhnologic A Go to the Insert tab and select the desired chart type B Press Ctrl+C C Type “chart” into a cell D Press Ctrl+F How do you create a chart in Excel? > E Press Ctrl+F F Press Alt+Shift+C G Press Ctrl+I H Right-click and select “Create Chart”