Details of this Paper

computer science MCQ questions




Question;121. Which group on the Pge Lyout Rion contins;commnds used to orgnize ojects plced in the worksheet?;A.;Pge Setup;B.;Scle to Fit;C.;Sheet Options;D.;rrnge;122. Wht term refers to n Excel Chrt with;offset pieces?;A.;Exploded;B.;Shttered;C.;Seprted;D.;Detched;123. Wht two options re offered when user elects to move chrt?;A.;New Sheet or Delete Sheet;B.;New Sheet or Oject in;C.;New Sheet or New Workook;D.;New Workook or Oject in;124. Wht rion contins the commnds for creting;chrts in Excel 2010?;A.;Home;B.;Pge Lyout;C.;Insert;D.;Dt;125. y defult, how mny chrt types uttons re;offered in the Chrts group?;A.;Three;B.;Four;C.;Five;D.;Six;126. Which is tiny chrt tht provides visul representtion of dt in worksheet cell?;A.;Trendline;B.;Sprkline;C.;Dtline;D.;FlshPoint;127. Wht cn you use to esily filter pivot tles;nd cue functions interctively in worksheet?;A.;Slicer;B.;Cutter;C.;Division;D.;Sliver;128. Which Chrt Tools Rion t llows user to select from gllery of chrt styles?;A.;Style;B.;Design;C.;Lyout;D.;Formt;129. Which commnd on the Chrt Tools Rion do;you use to swp dt over the xis in chrt?;A.;Select Dt;B.;Swp Dt;C.;Switch Row/Column;D.;Switch Dt;130. Which Chrt Tools Rion t llows user to insert vrious lels on the chrt?;A.;Style;B.;Design;C.;Lyout;D.;Formt;131. Wht grphiclly represents chnges in dt series over time?;A.;Sprkline;B.;Trendline;C.;Chrtline;D.;Error r;132. Which is grphicl representtion used in sttisticl or;scientific dt to show the degree of uncertinty reltive to ech dt mrker in series?;A.;Sprkline;B.;Trendline;C.;Chrtline;D.;Error rs;133. Which Chrt Tools Rion t enles user to dd pictures, shpes, or textoxes to chrt re?;A.;Style;B.;Design;C.;Lyout;D.;Formt;134. Which Chrt Tools Rion t enles user to pply style to the selected chrt?;A.;Style;B.;Design;C.;Lyout;D.;Formt;135. Which dilog ox contins commnds to rotte;the chrt re on 3-D chrts?;A.;Formt Chrt re;B.;Chrt Styles;C.;Formt Dt Point;D.;Chrt Position;136. How would you move sheet ts to new position in the workook?;A.;Choose Move on the Home Rion;B.;Click nd drg the sheet t to the;new loction;C.;Choose Move on the Insert Rion;D.;Choose Relocte on the Quick ccess;Toolr;137. How do you move from one worksheet to nother;within the sme workook?;A.;Right-click nd choose the new;worksheet nme;B.;Open the new worksheet;C.;Click on the sheet t;D.;Ctrl + T to move to new worksheet;138. Wht commnd do you use to copy cell;formtting from one cell to nother in worksheet?;A.;Formt cell;B.;Formt Pinter;C.;Copy;D.;Cut;139. Which commnd on the Home Rion do you;use to pply order to selected cells?;A.;Underline;B.;Lines;C.;Drwing;D.;Formt Cells;140. Wht commnd do you use to pply ckground color to cells in worksheet?;A.;Drwing;B.;Fill Color;C.;orders & Shding;D.;Highlight;141. Wht commnd do you use to insert informtion;into worksheet tht will disply t the top;nd ottom edges of the printed pge?;A.;Mrgins;B.;Print titles;C.;Heder & Footer;D.;Pge Setup;142. Wht is the nme of the dilog ox tht;contins the commnds to center worksheet;on the pge oth verticlly nd horizontlly?;A.;Pge Setup;B.;Formt Cells;C.;Print Setup;D.;Formt Styles;143. How would user hide row or column from view without permnently;deleting the informtion?;A.;Choose the Dispper commnd on;the Shortcut menu;B.;Choose the Hide commnd on the;Quick ccess Toolr;C.;Choose the Show/Hide commnd on;the Home Rion;D.;Choose the Hide commnd on the;Shortcut menu;D;144. How is n exct copy of worksheet creted within the sme workook?;A.;While pointing to the sheet t;choose Copy from the Shortcut Menu;B.;Right-click the sheet t, then;choose Move or Copy from the Shortcut Menu;C.;While pointing to the Select ll;utton, choose Move or Copy from the Shortcut Menu;D.;Choose Move or Copy from the;Quick ccess Toolr;145. Which commnd on the Home Rion do you;use to temporrily hide specific vlues on worksheet sed on criterion?;A.;Find & Select;B.;Formt Cell;C.;Sort & Filter;D.;Orgnize;146. Which function do you use to insert;tody?s dte in worksheet so tht it utomticlly;updtes ech time the worksheet is opened?;A.;Tody;B.;Weekdy;C.;Dte;D.;CurrentDte;147. Which commnd do you use to remove mnul;pge reks from worksheet re?;A.;Select rek, press Delete on keyord;B.;Select Remove Pge rek from the reks;drop-down re;C.;Select rek, press ckspce on keyord;D.;Select rek, press Remove Pge rek;from Shortcut Menu;148. Wht is the nme of the technique of;entering numer once nd copying it so tht;it is entered in the sme cell on ll selected worksheets?;A.;Pushing;B.;Forcing through;C.;Drilling n entry;D.;Entry Demnd;149. Wht do you cll it when you reference;cells in other sheets in workook formul;using the sheet nme s the reference rther thn the cell ddress?;A.;Clling the Sheet;B.;Nme reference;C.;Sheet Nme;D.;Sheet Reference;150. Wht is rnge tht spns two or more sheets in workook?;A.;Wide rnge;B.;3-D rnge;C.;Workook rnge;D.;Sheet rnge


Paper#36381 | Written in 18-Jul-2015

Price : $20