Computer Productivity Tools Quiz

Which of the following options is used to paste reference to the source cells?

• Transpose

• Values

• Paste Link

• Formatting

This is the cell or range of cells on a worksheet with value(s).

• Function

• Operator

• Reference

• Constant

This is a special character that is used to specify the type of calculation.

• Operator

• Constant

• Function

• Reference

How do you insert a dynamic date and time in a cell?

• By pressing Ctrl + Shift + ;

• By typing TODAY() in the formula bar

• By pressing Ctrl + ;

• By typing NOW() in the formula bar

Which of the following operators is used to specify a range of cells?

• ;

• :

• ,

• $

What is the default number format?

• General

• Number

• Currency

• Accounting

Which of the following is NOT a merging option in Excel?

• Merge Between

• Merge & Center

• Merge Across

• Merge Cells

What is the maximum number of rows on a worksheet?

• 1,408,576

• 13,684

• 16,384

• 1,048,576

This number formats multiplies the cell value by 100.

• Accounting

• Number

• Currency

• Percentage

Which of the following table elements contains the title of each column?

• Calculated Column

• Banded Row

• Header Row

• Title Row