![]() ![]() This can be helpful if you want to assign scores or grades based on certain conditions.įor example: =IF(F2>=75,”Pass”,IF(F2>=65,”Conditional”,”Fail”)) Nested functions are functions within a function.īy nesting an IF function within an existing IF function, you can test more than one conditions (e.g. Hide/unhide information in your spreadsheet.Save the spreadsheet and name it: Excel Intermediate Practice 1 Advanced MS Excel Practical Excercise With AnswerĪfter completing the instructions in this booklet, you will be able to: Use the AutoFill handle to add this equation to Cells B7 through G7Īlign all of the text Centered, in the middle of the cells Use the AutoFill handle to fill down that equation to G6 In Cell G2 create the equation: =Sum(A2:F2) ![]() Use the AutoFill handle to add Tuesday through Saturday Use AutoFill with labels, data and formulas.Intermediate Microsoft Excel Worksheet: Practice 1 ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |