Blog

What is Primary Key? What does it do? Is it different from unique identifier?

A psychiatrist is testing a drug that treats depression. He has given the drug to all his patients and all of them have experienced a decrease in depressive symptoms. Although this is interesting, his experience is limited because he does not have a:

What is relational database? How is MS Excel different from MS Access?

How is a relative cell reference different from an absolute cell reference? Give examples of each type of cell references.

Can you use the following in Excel to calculate the average of values in cells A1, B2, C2, A4? If no, re-write it to correct it. =AVERAGE(A1:B2:C2:A4)

Is there anything wrong with the following Excel function? If yes, re-write it to correct it. =SUM(X1; Y1; X2; Y2)

The following Excel worksheet shows games scores of 10 players: Write the function to calculate the total of the game scores for Player 7.

What function in Excel do you use to find the lowest of values in a cell range? Write the Excel function that gives you the lowest of values in cells X1, Y1, X2, Y2.

Can you use the following in Excel to determine the lowest of values in cells? If no, re-write it to correct it. =LOWEST(A1; B1; C1; D1)

What function in Excel do you use to find the average of values in a cell range? Write the Excel function that gives you the average of values in cells D1, E1, D2, E2.