Spreadsheets - C268 Exam Questions With Correct Answers

Spreadsheets - // /




C268 Exam Questions With Correct Answers
/ // // // // //




workbook //- /
/CORRECT /


/ANSWERS(S)✔✔an /


/Excel /


/file /


/that /


/stores /


/all /


/the /


/information, //previous //calculations, //and //analyses //that //you //may //have //already //completed




worksheet //- //CORRECT //ANSWERS(S)✔✔contains //the //actual //data //and //calculations



cells //- //CORRECT //ANSWERS(S)✔✔store //individual //pieces //of //data //or //calculations



File //Menu //- //CORRECT //ANSWERS(S)✔✔menu //used //to //manipulate //workbooks



Home //- /
/CORRECT /


/ANSWERS(S)✔✔area //includes //items //used //in //formatting //the //appearance //of //data //in //cells




Insert /
/Area //- /


/CORRECT /


/ANSWERS(S)✔✔include /


/features /

,/that /
/allow /


/you /


/to /


/place //specialized //elements //into //your //workbooks, //such //as //charts, //pictures, //and //shapes




Page /
/Layout /


/Menu //- /


/CORRECT /


/ANSWERS(S)✔✔menu //items //are //used //to //format //the //appearance //of //worksheets




Formulas /
/Menu //- /


/CORRECT //ANSWERS(S)✔✔menu //items //aid //in //performing //calculations //using //Excel's //built-


in //functions



Data /
/Area //- /


/CORRECT /


/ANSWERS(S)✔✔used //to //aid //in //importing //and //working //with //large //amounts //of //data




Review /
/Menu //- /


/CORRECT /


/ANSWERS(S)✔✔menu //items //help //in //sharing //an //Excel //workbook //with //colleagues




View /
/Menu //- /


/CORRECT /


/ANSWERS(S)✔✔menu /


/items //are //used //to //change //how //a //worksheet //is //displayed //on //the //screen

,Info //portion //of //the //File //- //CORRECT //ANSWERS(S)✔✔menu //displays //information //about //the
//current //workbook //and //the //users //who //have //contributed //to //the //file




New /
/portion /


/of /


/the /


/File //- /


/CORRECT //ANSWERS(S)✔✔menu //contains //features //related //to //creating //a //new //workbook




Templates //- /
/CORRECT /


/ANSWERS(S)✔✔can /


/be /


/particularly /


/useful /


/because /


/they /


/often /


/contain //data, //formatting //and //calculations //that //relate //to //common //spreadsheet //tasks




Open //- /
/CORRECT /


/ANSWERS(S)✔✔used /


/to /


/select //


a/
/different /


/workbook /


/that /


/you /


/want /


/to /


/be /


/opened /

, /in /
/Excel /


/or //select //a //workbook //that //has //been //saves //on //Skydive //or //locally //on //your //computer




Save /
/and /


/Save /


/As /


/Functions //- /


/CORRECT /


/ANSWERS(S)✔✔allow /


/you //to //(1) //save //the //current //workbook, //(2) //save //a //copy //of //the //current //workbook //with //a


//new /


/name //or //location, //or //(3) //save //a //copy //of //the //current //workbook //as //a //different //file //type.




Print /
/Area //- /


/CORRECT //ANSWERS(S)✔✔menu //area //contains //items //related //to //printing //a //worksheet




Print /
/Area //- /


/CORRECT /


/ANSWERS(S)✔✔area /


/displays //a //preview //of //how //a //particular //worksheet //will //look //once //printed.




Share /
/Area //- //CORRECT //ANSWERS(S)✔✔area //used //make //the //workbook //available //for //colleagues




Export /
/Area //- /


/CORRECT /


/ANSWERS(S)✔✔area /


/allows /