Sail E0 Webinar

Computer Aptitude

MS EXCEL MCQs

Ms Excel

Total Questions : 506 | Page 6 of 51 pages
Question 51. To activate the previous cell in a pre-selected range, press
  1.    The Alt key
  2.    The Tab key
  3.    The Enter key
  4.    None of the above
 Discuss Question
Answer: Option D. -> None of the above
Question 52. Which button do you click to add up a series of numbers?
  1.    The autosum button
  2.    The Formula button
  3.    The quicktotal button
  4.    The total button
 Discuss Question
Answer: Option A. -> The autosum button
Question 53. When the formula bar is active, you can see
  1.    The edit formula button
  2.    The cancel button
  3.    The enter button
  4.    All of the above
 Discuss Question
Answer: Option D. -> All of the above
Question 54. To copy formatting from one area in a worksheet and apply it to another area you would use:
  1.    The Edit > Copy Format and Edit>Paste Format commands form the menu
  2.    The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu
  3.    There is no way to copy and apply formatting in Excel – You have to do it manually
  4.    The Format Painter button on the standard toolbar
 Discuss Question
Answer: Option D. -> The Format Painter button on the standard toolbar
Question 55. In a worksheet you can select
  1.    The entire worksheet
  2.    Rows
  3.    Columns
  4.    All of the above
 Discuss Question
Answer: Option D. -> All of the above
Question 56. When you link data maintained in an excel workbook to a word document
  1.    The word document cannot be edit
  2.    The word document contains a reference to the original source application
  3.    The word document must contain a hyperlink
  4.    The word document contains a copy of the actual data
 Discuss Question
Answer: Option B. -> The word document contains a reference to the original source application
Question 57. Which area in an excel window allows entering values and formulas
  1.    Title bar
  2.    Menu bar
  3.    Formula bar
  4.    Standard toolbar
 Discuss Question
Answer: Option C. -> Formula bar
Question 58. To edit in an embedded excel worksheet object in a word document
  1.    Use the excel menu bar and toolbars inside the word application
  2.    Edit the hyperlink
  3.    Edit the data in a excel source application
  4.    Use the word menu bar and toolbars
 Discuss Question
Answer: Option A. -> Use the excel menu bar and toolbars inside the word application
Question 59. To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the
  1.    Unfreeze panes command on the window menu
  2.    Freeze panes command on the window menu
  3.    Hold titles command on the edit menu
  4.    Split command on the window menu
 Discuss Question
Answer: Option B. -> Freeze panes command on the window menu
Question 60. To create a formula, you can use:
  1.    Values but not cell references
  2.    Cell references but not values
  3.    Values or cell references although not both at the same time
  4.    Value and cell references
 Discuss Question
Answer: Option D. -> Value and cell references

Latest Videos

Latest Test Papers