REVISION(10)

1. What is the location of the consolidate feature in calc.

• Data>consolidate

• Tools >consolidate

• insert>consolidate

What are the limits for the number of rows and number of columns in a calc sheet?

• There can be a maximum of 1024 columns and 1,048,576 rows in possible in calc.

• There can be a maximum of 1024 columns and 1,048,57 rows in possible in calc

• ) There can be a maximum of 1025 columns and 1,048,576 rows in possible in calc.

What is the location for the scenarios features to be accessed?

• Insert>scenarios

• Tools>scenarios

• Data>scenarios

. Is Calc is a spreadsheet application?

• yes, it is

• no

• maybe, it is

What is the location of multiple operations on the calc interface?

• Data>multiple operations

• Tools>multiple operations

• insert>multiple operation

What is the location of the GoalSeek?

• Tools>GoalSeek

• Data>GoalSeek

• Inser>GoalSeek

What is the location of the Solver Feature?

• Data>solver

• Tools>solver

• Edit>solver

If the Sheet is protected and Prevent changes is selected then_____________________ properties cannot be changed

• scenario

• sub totals

• goal seek

Formula cell, target value and variable cell are part of the ______________ dialog box

• scenarios

• Goalseek

• Subtotals

Which of the following is not the name of a function is calc?

• Sum

• Difference

• Tonight