Excel 2013
Last Update Apr 22, 2024
Total Questions : 30
We are offering FREE 77-420 Microsoft exam questions. All you do is to just go and sign up. Give your details, prepare 77-420 free exam questions and then go for complete pool of Excel 2013 test questions that will help you more.
Configure page layout options.
Cell range B3:S25.
Set Print Area.
Enable the Gridlines Print option.
Formula
Find the average score of all student ids without a zero homework score.
Cell L2
Use Function AVERAGEIF
Range F7:F29
Criteria: "0"
Average_range: "Homework"
Modify the cell alignment settings.
Cell range B3:B25
Horizontal: Right (Indent)