A ________ enables you to create electronic worksheets composed of rows and columns

If you create a Recommended PivotTable on a group of data about book sales with theses columns: Discipline (i.e. Business), Area (i.e. Finance and Marketing), Units Sold, Wholesale Price, what column might Excel use as values?

A) Both Discipline and Area B) Discipline C) Units Sold D) Area

Answer the following statements true (T) or false (F)

1. When the button is clicked, the output of the following program will be ``` Private Sub btnDisplay_Click(...) Handles btnDisplay.Click Dim num As Integer = 20 DoubleIt(num) txtBox.Text = CStr(num) End Sub Sub DoubleIt(ByRef var As Integer) var = var * 2 End Sub ``` 2. The value of an argument in a calling statement can be changed by a Sub procedure only if the same name is used in the Sub procedure's parameter list. 3. Sub procedures can be individually tested before being placed into a program. 4. A value assigned to a variable in one part of a program always affects the value of the like- named variable in the other parts of the program.