USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
argument
|
|
|
criterion
|
|
|
table
|
|
|
table array
|
Detailed explanation-1: -An array formula is a formula that can perform multiple calculations on one or more items in an array. You can think of an array as a row or column of values, or a combination of rows and columns of values. Array formulas can return either multiple results, or a single result.
Detailed explanation-2: -A text value (also called a “text string") is one of Excel’s primary content types. Other types of content include numbers, dates, times, and Boolean values. As data is entered into a worksheet, Excel makes a “best guess” on the type of content it is, and formats the value automatically.
Detailed explanation-3: -An array in Excel is a structure that holds a collection of values. Arrays can be mapped perfectly to ranges in a spreadsheet, which is why they are so important in Excel. An array can be thought of as a row of values, a column of values, or a combination of rows and columns with values.
Detailed explanation-4: -Elements of Microsoft Excel formulas Constants-numbers or text values that you enter directly in a formula, like =2*3. Cell references-reference to a cell containing the value you want to use in your Excel formula, e.g. =SUM(A1, A2, B5) .