(5) Formatting option effectively represents the information from facts of data.Īns :- Formatting means to make changes to the worksheet data in the form of changing font, its size, color and shading etc, after which the worksheet gets a professional and attractive look.
(4) Conditional Formatting is a tool in MS Excel that allows applying formats to a cell or range of cells depending on the value. (3) Cell Borders, change cell width or height, Merge cells, Align Texts, Change Orientation of text, Wrap Text etc. (2) SUM and MIN are examples of Chart Types in MS Excel. (1) New cell, row or columns, can be added by using Cut and + keys from keyboard. (5) ………… is a powerful tool of MS Excel used to have graphical representation of our data in MS Excel. (4) Which function is used to find minimum number from the given range. (3) Which are the valid types of Charts in MS Excel. (2) Which objects can be added in a worksheet?
(1) By default, each new workbook in MS Excel 2010 contains ……… number of worksheets. Option Explicitĭim Source As Worksheet: Set Source = ThisWorkbook.Worksheets("Sheet1")ĭim Destination As Worksheet: Set Destination = ThisWorkbook.Worksheets("Sheet2")ĭim Records As Object: Set Records = CreateObject("Scripting.Dictionary")ĭata = Source.Range("A1", "B" & Source.Rows().Row).Value2įor Index = LBound(Data, 1) To UBound(Data, 1)ĭestination.Cells(Records(Data(Index, 1)), 2).Value2 = Destination.Cells(Records(Data(Index, 1)), 2).Value2 & ", " & Data(Index, 2)ĭestination.Cells(Row, 1).Value2 = Data(Index, 1)ĭestination.Cells(Row, 2).PSEB Punjab Board Class 9 Computer Science Textbook Solution Chapter 4 MS Excel Part – II Exercise Questions and Answers
I'm not sure if the "Scripting.Dictionary" is available in osx, but it cant hurt to try. It should automatically open the module ready to accept code, If not you need to select it (will be named "ModuleN" where N is the next available number) from the project explorer. Once the Editor is open add a new module by selecting it from the "insert" menu in the main menu bar. To use the following code you need to add it to a new module in the VBA EditorĪ Shortcut to open the VBA Editor is Alt+F11 (for Windows) and Alt+Fn+F11 (for Mac) This will (should) generate a new sheet from your source sheet with the duplicates concatenated.
0 kommentar(er)
