ENSC 26 3-3 Exam Questions With Solutions
.xlsb(.xls) Excel Binary workbook
.xlam(.xla) Excel add-in
Rows represented as number in worksheet
columns represented as letters in worksheet
Excel 2010 has 1,048,576 rows and 16,384 columns
Cell interaction of row and column that can contain string, numeric, and boolean data
Formula special type of cell entry that returns a value with start symbol = or +
Excel Object model -vocabulary identifying spreadsheet object
-set of supplied functions and methods
-enable reading and writing and interaction with its users
MS Office Object Library
, Project>Add Reference>COM>Microsoft Office 15.0 Object Library To call MS Excel in
VB, _____ should be added through the "Project" menu
Imports Excel = Microsoft.Office.Interop.Excel To start using Excel (before the form)
Public oXL As New Excel.Workbook
Public oWB As New Excel.Workbook
Public oSheet As New Excel.Worksheet To invoke Excel in Windows Form Application
(in module)
oXL.Visible = True To start Excel Appplication (button event handler)
oWB = oXL.Workbooks.Add
oSheet = oWB.Sheets.("Sheet1") To create new workbook or worksheet
oXL.UserControl = True To enable user control
oSheet.Cells(<Row>,<Column>).Value = <value>
oSheet.Range("<Cell Address>"). Value = <value> To add entry to a cell
oSheet.Cells(<Row>,<Column>.Formula = <formula>
oSheet.Range("<Cell Address>").Formula = <formula> To add formula to a cell
.xlsb(.xls) Excel Binary workbook
.xlam(.xla) Excel add-in
Rows represented as number in worksheet
columns represented as letters in worksheet
Excel 2010 has 1,048,576 rows and 16,384 columns
Cell interaction of row and column that can contain string, numeric, and boolean data
Formula special type of cell entry that returns a value with start symbol = or +
Excel Object model -vocabulary identifying spreadsheet object
-set of supplied functions and methods
-enable reading and writing and interaction with its users
MS Office Object Library
, Project>Add Reference>COM>Microsoft Office 15.0 Object Library To call MS Excel in
VB, _____ should be added through the "Project" menu
Imports Excel = Microsoft.Office.Interop.Excel To start using Excel (before the form)
Public oXL As New Excel.Workbook
Public oWB As New Excel.Workbook
Public oSheet As New Excel.Worksheet To invoke Excel in Windows Form Application
(in module)
oXL.Visible = True To start Excel Appplication (button event handler)
oWB = oXL.Workbooks.Add
oSheet = oWB.Sheets.("Sheet1") To create new workbook or worksheet
oXL.UserControl = True To enable user control
oSheet.Cells(<Row>,<Column>).Value = <value>
oSheet.Range("<Cell Address>"). Value = <value> To add entry to a cell
oSheet.Cells(<Row>,<Column>.Formula = <formula>
oSheet.Range("<Cell Address>").Formula = <formula> To add formula to a cell
