Symbol used in absolute cell reference is ______.a) $ b) = c) & d) @6. ________ loop that repeats 1 or more times.a) For b) while c) do while d) all of the above7. HTML tag for inserting image is _____________ .a) <image scr=”URL of image file” >b) <image src=”URL of image file”>c) <img scr=”URL of image file”>d) <img src=”URL of image file”>8. When we allow an end-user to control the navigation of a multimedia project, it is known as_____a) Nonlinear Multimedia b) Interactive Multimediab) Both a and b d) None9. In which of the following, a person is constantly followed/chased by another person orgroup of several people?a) Phishin b) Bullying c) Stalking d) Identity theft

In order to create an absolute cell reference, we need to add a sign before the column letter, this can be done by pressing the key after entering your cell reference.

A cell range always has the _______ symbol between the cell references.*1 point; (semicolon). (fullstop), (comma): (colon)

Question 18In spreadsheets, an absolute reference is used to lock a function array so that rows and columns don’t change if the function is copied. What symbol is used to create an absolute reference?1 pointAmpersand (&)Hash (#)Asterisk (*)Dollar sign ($)

There are two types of cell reference, absolute and relative. Select the relative cell reference.

Absolute referencingAbsolute referencing is marked by a dollar sign ($). For example, =$A$10 has absolute referencing for both the column and the row valueRelative references (which is what you normally do e.g. “=A10”) will change anytime the formula is copied and pasted. They are in relation to where the referenced cell is located. For example if you copied “=A10” to the cell to the right it would become “=B10”. With absolute referencing “=$A$10” copied to the cell to the right would remain “=$A$10”. But if you copied $A10 to the cell below, it would change to $A11 because the row value isn't an absolute reference.Absolute references will not change when you copy and paste the formula in a different cell. The cell being referenced is always the same.To easily switch between absolute and relative referencing in the formula bar, highlight the reference you want to change and press the F4 key; for example, if you want to change the absolute reference, $A$10, in your formula to a relative reference, A10, highli