Excel 2010:Creating Cell Data

Construct cell data. This objective may include but is not limited to: using paste special (formats, formulas, values, preview icons, transpose rows and columns, operations, comments, validation, paste as a link), and cutting, moving, and select cell data This aspect of Exam 77-882 checks your ability to work with cells in a worksheet. You have to get familiar with the following, Applying AutoFill, Applying and manipulating hyperlinks, removing a hyperlink, etc.

Total 9 questions found in this category.

Submit Question   Show By Status: New Submissions   Pending   Deleted   Approved   

Question	Subject	Category
You are trying to link to the region demonstrated by cells F10 through G11 in Sheet1 from another sheet, Sheet3. You are using the cell J9 on Sheet3 as the hyperlink. Which of the following texts will you type in the 'Cell Reference" box while creating the hyperlink so that the region is linked to?	Excel 2010	Creating Cell Data
You have used the hyperlinking feature in Excel 2010 to link from one sheet of the workbook to another sheet's cell. What will happen when you click on the cell being used as the link?	Excel 2010	Creating Cell Data
Is it possible to make a hyperlink to a particular cell in another sheet in the same workbook in only a part of text of a particular cell in another sheet of the same workbook?	Excel 2010	Creating Cell Data
You have written the numbers 1,2,3 and 4 in a column from cells A1 through A4. You want to repeat this sequence from the columns B to J. You stretch the corner to the Column J. Which of the following options will allow you to copy the content but will leave the cell background colour to the default?	Excel 2010	Creating Cell Data
You have written the numbers 1 to 10 in a column and want to repeat the numbers again and again. Which of following option for the AutoFill will help you get the work done?	Excel 2010	Creating Cell Data
Which of the following is not an option for the Excel 2010's AutoFill function?	Excel 2010	Creating Cell Data
You have pasted a copied set of cells from one workbook into another using the "No Borders" paste special functions. Which borders are removed?	Excel 2010	Creating Cell Data
You have copied a set of cells and pasted it in 'trasposed' format. What has happened to the contents?	Excel 2010	Creating Cell Data
Which of the following is not a "paste special" option available in Excel 2010?	Excel 2010	Creating Cell Data

Submit Interview/Test Questions with Answers and make money from adsense revenue sharing program