CIS /
101
/ /
Excel
/ /
Expert
/ /
Practice
/ /
Exam 2 Questions With Correct Answers
/ // // // // //
Project //1 //Task //1 //
In /
/cell /
/C12 /
/on /
/the /
/Visitor /
/Attendance /
/worksheet, /
/use /
/structured /
/references //to //elements //of //the //table //to //calculate //the //total //average //attendance //at //all //the
//National /
/Parks. //- //CORRECT //ANSWERS(S)✔✔1. //On //the //Visitor //Attendance //worksheet, //click //cell //C12
//to //select //it.
2. /
/In /
/the /
/Formula /
/Bar /
/just /
/below /
/the /
,/ribbon /
/type, /
/=AVERAGE //then //press //Tab //on //your //keyboard //to //begin //entering //the //function //arguments.
3. /
/To /
/include /
/structured /
/references /
/in //
a/
/formula /
/or /
/function, /
/click /
/the /
/table /
/cells /
/you /
/want /
/to /
/reference //instead //of //typing //their //cell //reference. //Do //this //by //selecting //cell //range //B4:G8.
4. /
/Press /
/Enter /
/on /
/your /
/keyboard /
/to /
/complete /
/the /
/formula. /
/(Hint: /
/the /
/result /
/displayed /
/in /
/cell /
,/C12 //should //be //97614.43 //and //the //final //formula //should //read, //=AVERAGE(Attendance[[Jan]:
[June]])
Previous //Task //Mark //Completed //Show //Me //Mark //for //Review //Next //Task
Project //1 //Task //2 //
Using /
/the /
/Fill /
/Series /
/option /
/in /
/Excel, /
/extend /
/the /
/Attendance /
/table /
/to /
/include /
/the /
/remaining //months //of //the //year //July //through //December. //- //CORRECT //ANSWERS(S)✔✔1. //On
//the //Visitor //Attendance //worksheet, //click //cell //G3 //to //select //it.
2. //Drag //the //Fill //Handle //located //in //the //lower-
right //corner //of //the //cell //selection //box //to //the //to //the //right //and //drop //it //in //cell //M3.
Project //1 //Task //3 //
In //cell //F4 //on //the //Ranger-
led /
/Activities /
/worksheet, /
/add //
, a/
/formula /
/that /
/dispays /
/Yes /
/if /
/the /
/National /
/Park /
/offers /
/both /
/Youth /
/Programs /
/and /
/Astronomy /
/Programs, /
/else /
/otherwise /
/displays /
/No. /
/Populate /
/the /
/remaining //cells //in //the //column //with //the //same //formula. //- //CORRECT //ANSWERS(S)✔✔1. //On
//the //Ranger-led //Activities //worksheet, //click //cell //F4.
2. /
/In /
/the /
/Formula /
/Bar /
/just /
/below /
/the /
/ribbon /
/type, /
/=NOT //then //press //Tab //on //your //keyboard //to //begin //entering //the //function //arguments.
3. //To //the //left //of //the //Formula //Bar //click //fx //to //open //the //Function //Arguments //pop-
up //wizard.
101
/ /
Excel
/ /
Expert
/ /
Practice
/ /
Exam 2 Questions With Correct Answers
/ // // // // //
Project //1 //Task //1 //
In /
/cell /
/C12 /
/on /
/the /
/Visitor /
/Attendance /
/worksheet, /
/use /
/structured /
/references //to //elements //of //the //table //to //calculate //the //total //average //attendance //at //all //the
//National /
/Parks. //- //CORRECT //ANSWERS(S)✔✔1. //On //the //Visitor //Attendance //worksheet, //click //cell //C12
//to //select //it.
2. /
/In /
/the /
/Formula /
/Bar /
/just /
/below /
/the /
,/ribbon /
/type, /
/=AVERAGE //then //press //Tab //on //your //keyboard //to //begin //entering //the //function //arguments.
3. /
/To /
/include /
/structured /
/references /
/in //
a/
/formula /
/or /
/function, /
/click /
/the /
/table /
/cells /
/you /
/want /
/to /
/reference //instead //of //typing //their //cell //reference. //Do //this //by //selecting //cell //range //B4:G8.
4. /
/Press /
/Enter /
/on /
/your /
/keyboard /
/to /
/complete /
/the /
/formula. /
/(Hint: /
/the /
/result /
/displayed /
/in /
/cell /
,/C12 //should //be //97614.43 //and //the //final //formula //should //read, //=AVERAGE(Attendance[[Jan]:
[June]])
Previous //Task //Mark //Completed //Show //Me //Mark //for //Review //Next //Task
Project //1 //Task //2 //
Using /
/the /
/Fill /
/Series /
/option /
/in /
/Excel, /
/extend /
/the /
/Attendance /
/table /
/to /
/include /
/the /
/remaining //months //of //the //year //July //through //December. //- //CORRECT //ANSWERS(S)✔✔1. //On
//the //Visitor //Attendance //worksheet, //click //cell //G3 //to //select //it.
2. //Drag //the //Fill //Handle //located //in //the //lower-
right //corner //of //the //cell //selection //box //to //the //to //the //right //and //drop //it //in //cell //M3.
Project //1 //Task //3 //
In //cell //F4 //on //the //Ranger-
led /
/Activities /
/worksheet, /
/add //
, a/
/formula /
/that /
/dispays /
/Yes /
/if /
/the /
/National /
/Park /
/offers /
/both /
/Youth /
/Programs /
/and /
/Astronomy /
/Programs, /
/else /
/otherwise /
/displays /
/No. /
/Populate /
/the /
/remaining //cells //in //the //column //with //the //same //formula. //- //CORRECT //ANSWERS(S)✔✔1. //On
//the //Ranger-led //Activities //worksheet, //click //cell //F4.
2. /
/In /
/the /
/Formula /
/Bar /
/just /
/below /
/the /
/ribbon /
/type, /
/=NOT //then //press //Tab //on //your //keyboard //to //begin //entering //the //function //arguments.
3. //To //the //left //of //the //Formula //Bar //click //fx //to //open //the //Function //Arguments //pop-
up //wizard.
