Exam 14: Computational Engineering Tools: Electronic Spreadsheets

Which of the following Excel functions will correctly calculate the cosine of the value in cell A1?

You can use Excel's build-in function in VBA.

In VBA, the End Sub statement ends the subroutine.

Which of the following Excel functions will calculate the mean value of the data in cells A1 through A9?

In VBA, the statement Range("A1,A6").Activate will

Which of the following Excel functions will correctly calculate the square root of the value in cell A1?

Which is the correct way to enter the following mathematical operation into Excel?

A worksheet is a spreadsheet file that you create and save whereas a workbook represents the rows and columns where you input information.

If you were to type the following into a cell, what would be the result in Excel?

The Excel functions are grouped into various categories, including mathematical and trigonometric, engineering, statistical, financial, and logical functions.

An array of numbers, variables, or mathematical terms is known as a

A physical variable that possesses both magnitude and direction is known as a

In VBA, the statement Cells(1, 1) = "x values" will write

In Excel, functions that allow you to test various conditions when programming formulas to analyze data are known as

A number of cells that are selected simultaneously is called a

The Excel formula =MMULT(A1:C3, E1:E3) will calculate

A simple way to learn about the VBA's object-oriented commands and syntax is by using the Record Macro option.

In a spreadsheet, the _________ contains the name of the current active workbook.

Which of the following is the correct entry for a relative cell reference?

Visual Basic for Applications (VBA) is a programming language that allows you to use Excel more effectively.