WorksheetsComputer Productivity Tools Quiz
Total questions: 15
Worksheet time: 8mins
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
What is the maximum number of columns on a worksheet?
16,384
13,684
1,408,576
1,048,576
In which tab can you find the Text to Columns Wizard?
Data
Insert
Page Layout
View
Which of the following is NOT a printing option in Excel?
Print Selected Table
Print Selection
Print Active Sheets
Print Entire Worksheet
Type the chart type here: (a)
Type the chart type here: (a)
