Excel

Question 1

whats a cell reference?

Answer 1

the unique label of a cell consisting of a letter and a number. for example, the cell located at the intersection of Row D and column 10 has the cell reference D10

Question 2

whats the active cell?

Answer 2

the cell which has been currently selected by the user

Question 3

what does the formula bar do?

Answer 3

shows the active cell contents

Question 4

what is a constant in excel?

Answer 4

an entry that the spreadsheet does not change, for example, test marks, names, dates, etc.

Question 5

what is a formula in excel?

Answer 5

a combination of numeric constants, arithmetic operators, cell references, and functions that returns the result of a calculation

Question 6

whats the difference between an absolute and relative reference?

Answer 6

if the cell reference has $ signs in front of the row and column designation, it is considered an absolute reference and the cell reference remains unchanged throughout all copy/paste operations e.g $B$10

a relative reference, on the other hand, adjusts during the copy operations and is specified without the $ signs

Question 7

whats a mixed reference?

Answer 7

uses a single $ sign to make the column or the row absolute, leaving the other as relative. for example F$6