Answer: =

Explanation:

In Excel, all formulas typically start with an equals sign (=). This is the way to indicate that you are entering a formula into a cell rather than just a plain value. When you begin a formula with an equals sign, Excel knows that it should evaluate the contents of the cell as a formula and perform the necessary calculations.

Answer: *

Explanation:

The multiplication arithmetic operator in Excel is represented by option (2) "*". The asterisk ("") symbol is used as the multiplication operator in Excel formulas. For example, if you want to multiply the value in cell A1 by the value in cell B1, you would use the formula "=A1B1". Option (1) "^" represents exponentiation, option (3) "/" represents division, option (4) "X" is not a standard operator in Excel, and option (5) "None of these" is incorrect as the correct answer is option (2) "*".

Answer: a formula which will add values in the range Excel guesses you want to add

Explanation:

Using the AutoSum button will replace the selected cell with option (4) a formula that will add values in the range Excel guesses you want to add. The AutoSum button in Excel is a shortcut for quickly inserting a formula to calculate the sum of a range of cells. When you click the AutoSum button, Excel will automatically determine the range of cells it believes you want to add based on the adjacent cells, and it will insert a sum formula in the selected cell. The inserted formula will typically be something like "=SUM(A1:A10)", where A1:A10 represents the range of cells Excel guesses you want to add.

Answer: All of above

Explanation:

Hyperlinks can indeed be created using various elements. The correct option is (4) All of the above. Hyperlinks can be applied to text, allowing users to click on the linked text to navigate to a different location, such as a webpage or another location within the same document. Additionally, hyperlinks can be associated with drawing objects, such as shapes or lines. When users click on the drawing object with a hyperlink, they can be directed to a specific location or perform a specific action.

Answer: Freeze panes command on the window menu

Explanation:

To hold row and column titles in place so that they do not scroll when you scroll a worksheet in Excel, you should click the (2) Freeze panes command on the window menu.

Answer: Transpose

Explanation:

The function that displays row data in a column or column data in a row is (3) Transpose. The Transpose function in Excel allows you to switch the orientation of data from rows to columns or from columns to rows. It takes a range of cells as input and returns a transposed array of that range. To use the Transpose function, follow these steps: Select the destination range where you want the transposed data to appear. Type "=TRANSPOSE(" and then select the range of cells you want to transpose. Close the function with a closing parenthesis ")" and press Enter. The Transpose function will convert the data from rows to columns or columns to rows, depending on the orientation of the original range. Options (1) Hyperlink, (2) Index, (4) Rows, and (5) None of these do not perform the specific task of transposing data in Excel. So, the correct answer is (3) Transpose.

Answer: The autosum button

Explanation:

To add up a series of numbers in a spreadsheet application, the button you typically click is (1) The autosum button. The autosum button is designed to automatically calculate the sum of a range of selected cells. It is commonly represented by a sigma symbol (?) and is usually located on the toolbar or ribbon of the spreadsheet application. By selecting the range of numbers you want to add and then clicking the autosum button, the application will insert a sum formula that calculates the total of the selected cells. Therefore, the correct option is (1) The autosum button.

Answer: Formula bar

Explanation:

The correct answer is option (2) Formula bar. The Formula bar in Excel displays the contents of the active cell. When you click on a cell, the Formula bar will show the value or formula entered in that cell. You can also directly edit the contents of the cell by typing in the Formula bar.

Answer: A 2-dimensional column chart

Explanation:

Using the F11 shortcut key to create a chart on a chart sheet in Excel creates option (2) a 2-dimensional column chart. When you press the F11 key in Excel, it automatically creates a chart based on the data in the active range on a new chart sheet. By default, the chart created using the F11 shortcut key is a 2-dimensional column chart. Therefore, the correct answer is option (2) A 2-dimensional column chart.

Answer: =A1+A2

Explanation:

The correct formula to add two cells A1 and A2 together is option (1) =A1+A2. In Excel, you use the plus sign (+) as the addition operator to perform arithmetic operations. By using this operator, you can add the values of two cells together.