ITES CLASS IX

LibreOffice Calc is primarily used for:

• Writing text documents

• Creating and managing spreadsheets

• Designing presentations

• Drawing diagrams

In Calc, which symbol is used to start a formula?

• #

• &

• =

• @

What is the intersection of a row and a column called in Calc?

• Field

• Chart

• Cell

• Table

Which function in Calc adds all the values in a selected range of cells?

• =SUM

• =ADD

• =TOTAL

• =AVERAGE

Which Calc function is used to find the average of a range of cells?

• =COUNT

• =SUM

• =ADD

• =AVERAGE

To quickly add values in cells from A1 to A5, which formula would you use?

• =ADD(A1:A5)

• =AVERAGE(A1:A5)

• =SUM(A1:A5)

• =TOTAL(A1:A5)

What is the shortcut key to save a spreadsheet in Calc?

• Ctrl + C

• Ctrl + V

• Ctrl + S

• Ctrl + Z

Which of the following options allows you to create a chart in Calc?

• Insert > Picture

• Format > Cells

• Insert > Chart

• Tools > Options

In Calc, what does the function =MAX(A1:A10) do?

• Adds all values in cells A1 to A10

• Finds the smallest value in cells A1 to A10

• Finds the largest value in cells A1 to A10

• Averages the values in cells A1 to A10

In Calc, which feature allows you to automatically fill cells with a sequence of values?

• Format Cells

• AutoFill

• Conditional Formatting

• AutoFilter