Question

An example of mixed referencing is

a. $A$1+$B2 b. $A$1+$B$2 c. A1+B1$ d. All of the above ​

Answer 1

Answer:

answer is a. $A$1+$B2

______________________________

KNOW MORE

Mixed reference in excel is a type of cell reference which is different from the other two absolute and relative, in mixed cell reference we only refer to the column of the cell or the row of the cell, for example in cell A1 if we want to refer to only A column the mixed reference would be $A1, to do this we need to press F4 on the cell two times.

_____________________________

Striking the F4 key multiple times helps in changing the position of the dollar sign. It is also to be noted that mixed

reference cannot be pasted into a Table. We can only create an absolute or relative reference in a table. We can use the excel shortcut ALT+36 or Shift+4 key for inserting the dollar sign in Excel.

hope it helps you

Answer 2

Calc is the spreadsheet component of OpenOffice.org (OOo). You can enter data (usually numerical) in a spreadsheet and then manipulate this data to produce certain results.