Excel and PowerPoint Functions and Features

The formula =Eğer(E4>70;"GEÇTİ";"KALDI") checks if E4 is greater than 70 and returns "GEÇTİ" if true, otherwise "KALDI". To create a chart from a data table, use the Insert-Chart option. The Insert/Chart command adds a chart to the workbook. In PowerPoint, to change the current slide layout, use the Format/Slide Layout menu. The Insert menu does not include options for adding a row, chart, or link, making "none" the correct choice. The shortcut for the "Refresh All" button in the Data menu is not specified. The command that displays all slides simultaneously is found under View/Slide Sorter. The equivalent of =B4+B5+B6+B7 is =SUM(B4:B7). To add a worksheet, use Insert/Worksheet. The formula =SUM(A1:A3;A7) expands to A1+A2+A3+A7. The default background pattern and font styles in PowerPoint are called Design.