Quiz 1: Excel

Given the image shown, if cell B2 is copied and pasted (standard paste) into C3, what will appear in cell C3?

• 1

• 3

• 2

• 8

Given the image shown, if cell B2 is copied and pasted (standard paste) into C3, what formula will be in cell C3?

• =A$1

• =A$2

• =B$1

• =B$2

Given the image shown, if cell B2 is copied and pasted (standard paste) into C3, what formula will be in cell C3?

• =A1 + B2

• =B1 + B2

• =B1 + B3

• =B2 + B3

Given the image shown, if cell B2 is copied and pasted (standard paste) into C3, what formula will be in cell C3?

• =$A$1+B3

• =$A$1+B2

• =$A1+$B1

• =$A$1+B1

Given the image shown, if cell B2 is copied and pasted (standard paste) into C3, what will appear in cell C3?

• 1

• 2

• 3

• 4

Given the image shown, if cell B2 is copied and pasted (standard paste) into C3, what will appear in cell C3?

• 3

• 10

• 5

• 12

Given the image shown, what is the column rule for the first formula entry, A$1?

• always column A

• one column left

• same column

• one column right

Given the image shown, what is the column rule for the second formula entry, $C5?

• always column C

• one column left

• same column

• one column right