Quiz- Yves Steven Lin Salamatin powerpoint

a

1. tekhnologic EXCEL > YVES STEVEN LIN BUENO SALAMATIN 10-HYACINTH

2. tekhnologic >  How can you insert a new row in Excel? A C Press Ctrl + I B D Select the row you want to insert below and click on “Insert” in the menu Use the toolbar at the top of the screen Right-click and select “Insert Row”

3. tekhnologic A B . xlsx C . xlsm D What is the default file extension of an Excel workbook? > .csv . xls

4.  Which function can be used to find the highest value in a range of cells in Excel? A C MAX B D AVERAGE COUNT SUM

5. How can you format numbers as currency in Excel? A C Right-click and select “Currency Format” Press Ctrl + $ B Use the toolbar at the top of the screen D Select the cells you want to format and click on “Currency” in the Number Format menu

6. How can you sort data in Excel in ascending order? A Right-click and select “Sort Ascending” C Press Ctrl + A B D Use the toolbar at the top of the screen Select the column you want to sort and click on “Sort A to Z” in the Sort & Filter menu

7. tekhnologic A SUM B AVERAGE C COUNT D MAX Which function in Excel can be used to find the average of a range of cells? > E MIN F MEDIAN

8. tekhnologic A Right-click and select “Insert Comment” B Use the toolbar at the top of the screen C Press Ctrl + C D Select the cell and click on “Insert Comment” in the menu How can you insert a comment in a cell in Excel? > E Insert > Comment option F Format > Comment option

9. tekhnologic A To calculate the total sum of a range of cells B To find the highest value in a range of cells C To count the number of cells that meet a certain criteria D To multiply values in a range of cells  What is the purpose of the COUNTIF function in Excel? > E To divide values in a range of cells F To calculate the average of a range of cells

10. tekhnologic A Right-click on the column header and select “Hide Column” B Use the toolbar at the top of the screen C Press Ctrl + H D Select the column and click on “Hide” in the menu   How can you hide a column in Excel? > E Format > Hide option F View > Hide option

11. tekhnologic A SUM B AVERAGE C ROUND D COUNT Which function in Excel can be used to round a number to a specified number of decimal places? > E MIN F MAX G MEDIAN H COUNTIF

12. tekhnologic A Right-click and select “Insert Column” B Use the toolbar at the top of the screen C Press Ctrl + N D Select an existing column and click on “Insert” in the menu How can you insert a new column in Excel? > E Insert > Column option F Format > Column option G View > Column option H Edit > Column option

13. tekhnologic A To calculate a mathematical expression B To combine text strings from multiple cells into one cell C To determine if a condition is true or false D To handle errors or display a custom message when an error occurs What is the purpose of the IFERROR function in Excel? > E To calculate the average of a range of cells F To find the highest value in a specified range G To count the number of cells that meet a certain criteria H To round a number to a specified number of decimal places

14. VERY GOOD