Excel 2010:Formatting Cells and Worksheets

This topic check your ability to work with Excel 2010 environment. You have to get familiar with creating and modifying cells, hiding and unhiding, manipulating page sateup, applying cells, merging and splitting cells, creating row and column titles, etc.

Total 18 questions found in this category.

Submit Question   Show By Status: New Submissions   Pending   Deleted   Approved   

Question	Subject	Category
Which tab will allow you to change the font style?	Excel 2010	Formatting Cells and Worksheets
Which of the following is not allowed to be configured for the font within a cell when defining a new cell style?	Excel 2010	Formatting Cells and Worksheets
Which of the following can you configure in a cell style?	Excel 2010	Formatting Cells and Worksheets
Which of the following is not a 'margin' in Excel 2010?	Excel 2010	Formatting Cells and Worksheets
You have changed the scaling from 100% to 200% in Excel 2010 before printing. How have the number of pages required to print the sheet changed?	Excel 2010	Formatting Cells and Worksheets
What are 'Landscape' and 'Portrait'?	Excel 2010	Formatting Cells and Worksheets
You want to hide rows 7 and 10. Which row should be selected first to hide?	Excel 2010	Formatting Cells and Worksheets
You have hidden the Columns D and E. Which of the following Column(s) will you select before you click the "Format" button to 'unhide' them?	Excel 2010	Formatting Cells and Worksheets
You have selected Columns D and E. You want to hide them. Which button on the Home tab in the Ribbon bar of Excel 2010 will present you with the option for the same?	Excel 2010	Formatting Cells and Worksheets
How many page orders are available for printing in Excel 2010?	Excel 2010	Formatting Cells and Worksheets
You have opened the Page Setup Window for printing the sheet. You want the Row 1 to be printed on each page. What will you enter on the "Rows to repeat at the top" box to make sure that Row number 1 appears on all pages printed.	Excel 2010	Formatting Cells and Worksheets
You print a sheet in Excel 2010. However you find that only the first page contains the titles of rows and columns. Can excel 2010 be used to print selective rows and columns on every page? If yes, on which tab will we find this functionality?	Excel 2010	Formatting Cells and Worksheets
You merged multiple cells with unique data and then used the "unmerge" function. What will happen after 'un-merging'?	Excel 2010	Formatting Cells and Worksheets
What will merge and center function do when merging more than one cells?	Excel 2010	Formatting Cells and Worksheets
You are merging cell from A25 to D25. All of the cells contain unique data. What will be the contents of the merged cells after the merge is complete?	Excel 2010	Formatting Cells and Worksheets
You want to show the numbers written in the cells of Column 'D' as 'percentage'. What keyboard shortcut will allow you to achieve the goal?	Excel 2010	Formatting Cells and Worksheets
You are currently showing the prices of items in your sheet as simple numbers and want to add the currency in front of every number. On which of the following sections of the Home tab of Excel 2010 can you do this?	Excel 2010	Formatting Cells and Worksheets
You have a column (H) in one of the sheets of your workbook which contains the costs involved of items on the list. You want to align the content of the 'H' Column cells to the right. Which tab will contain the function or tool for the same?	Excel 2010	Formatting Cells and Worksheets

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