oo calc Basic Operations Quiz

What is the shortcut key to open a new spreadsheet in oo calc?

• Shift + S

• Ctrl + O

• Alt + A

• Ctrl + N

How can you add a new row in oo calc?

• Use the 'Format' menu to add a new row

• Right-click on the row number and select 'Insert Rows'

• Double-click on the row number

• Press the delete key

What is the function to sum a range of cells in oo calc?

• TOTAL

• COMBINE

• SUM

• ADD

Explain the difference between absolute and relative cell references in oo calc.

• Absolute cell references change based on the position of the formula

• Relative cell references always refer to a specific cell

• Absolute cell references and relative cell references are the same thing

• Absolute cell references always refer to a specific cell, while relative cell references change based on the position of the formula.

How can you change the font style in oo calc?

• Tools > Format

• Insert > Style

• Edit > Font

• Format > Character

What is the function to find the average of a range of cells in oo calc?

• AVERAGE

• SUM

• COUNT

• MAX

Explain the process to insert a chart in oo calc.

• Go to the 'Format' menu, select 'Chart' and then choose the type of chart you want to insert.

• Open a new document, go to the 'Insert' tab, and then choose the type of chart you want to insert.

• Go to the 'Insert' menu, select 'Chart' and then choose the type of chart you want to insert.

• Right-click on the spreadsheet, select 'Insert' and then choose the type of chart you want to insert.

How can you merge cells in oo calc?

• Select the cells you want to merge, right-click, and choose 'Merge Cells' from the context menu.

• Double-click on the cells

• Use the shortcut Ctrl+M

• Press the 'Merge' button on the toolbar

What is the function to find the maximum value in a range of cells in oo calc?

• MIN

• AVERAGE

• SUM

• MAX

Explain the process to apply conditional formatting in oo calc.

• Select the range of cells, go to Format > Conditional Formatting, and set the conditions and formatting options.

• Copy and paste the formatting from another cell

• Use the 'Insert' tab to apply conditional formatting

• Click on the cell and manually change the formatting