CCC LibreOffice Calc Online Test | 100 Important MCQs Practice

Which LibreOffice application is used to create spreadsheets?

What is the default file extension of a LibreOffice Calc file?

The intersection of a row and a column is called?

Which symbol is used to begin a formula in Calc?

Which function is used to add the values of selected cells?

Which function calculates the average of selected numbers?

Which function returns the highest value in a range?

Which function returns the lowest value in a range?

Which function counts only numeric cells?

Which function counts all non-empty cells?

Which function returns today's current date?

Which function returns the current date and time?

How many rows are available in LibreOffice Calc (default)?

How many columns are available in LibreOffice Calc?

The first cell of a worksheet is identified as?

Which key is used to edit the active cell?

Which shortcut key saves the spreadsheet?

Which shortcut key creates a new spreadsheet?

Which shortcut key opens an existing spreadsheet?

Which shortcut key prints the spreadsheet?

Which shortcut key opens the Find dialog?

Which chart is best suited to show parts of a whole?

Which chart is commonly used to show trends over time?

Which option is used to insert a new worksheet?

Which feature automatically fills a series such as 1, 2, 3 or Jan, Feb, Mar?

A cell reference that changes automatically when copied is called?

Which symbol is used for an absolute cell reference?

Which of the following is an example of an absolute cell reference?

Which cell reference changes only the row or only the column?

Which function is used to find the largest value in a range?

Which function is used to find the smallest value in a range?

Which function returns the square root of a number?

Which function rounds a number to a specified number of digits?

Which function returns the absolute (positive) value of a number?

Which function joins two or more text strings together?

Which function is used to test a condition?

The IF() function returns?

Which feature arranges data in ascending or descending order?

Which feature displays only records that meet a condition?

Which menu is used to freeze rows or columns?

Freezing rows is useful because it?

Which option restricts the type of data entered into a cell?

Conditional Formatting is used to?

Which chart compares values across different categories?

Which chart is best for showing percentages of a whole?

Which feature removes duplicate records from a data range?

Which key edits the contents of the active cell?

Which shortcut key selects all cells in the worksheet?

Which option combines multiple selected cells into one?

Which shortcut key recalculates the worksheet?

Which function adds values only if a specified condition is met?

Which function counts cells that satisfy a condition?

Which function searches vertically in a table?

Which function searches horizontally in a table?

Which function returns the current date?

Which function returns the current date and time?

Which feature displays only records matching specified criteria?

Which menu contains the AutoFilter option?

Goal Seek is used to?

Which feature allows copying only selected attributes such as values or formats?

Which keyboard shortcut opens the Paste Special dialog?

Which feature protects a worksheet from unauthorized editing?

Which menu is used to protect a sheet?

What is a named range in Calc?

Which feature highlights cells automatically based on rules?

Which menu is used to create a chart?

Which chart is best for showing trends over time?

Which chart is best for comparing quantities across categories?

Which chart is useful for showing the relationship between two numeric variables?

Which option defines the range of cells to be printed?

Which menu is used to set the print area?

Which feature repeats selected rows or columns on every printed page?

Which view allows you to see how the worksheet will look when printed?

Which shortcut key opens the Print dialog?

Which shortcut key closes the current spreadsheet?

Which feature is used to summarize large amounts of data in Calc?

What is the main purpose of a Pivot Table?

Which menu is generally used to create a Pivot Table in LibreOffice Calc?

Which feature combines data from multiple ranges into one summary?

Which tool is used to find the optimal value by changing multiple variables?

Goal Seek changes how many input cells at a time?

Which error is displayed when a formula attempts to divide by zero?

Which error appears when a formula contains an unrecognized function name?

Which error indicates an invalid cell reference?

Which function returns the number of characters in a text string?

Which function returns the leftmost characters from a text string?

Which function returns the rightmost characters from a text string?

Which function removes extra spaces from text?

Which function converts text to uppercase?

Which function converts text to lowercase?

Which function converts the first letter of each word to uppercase?

Which function returns the length of a text string?

Which file extension is the default for LibreOffice Calc spreadsheets?

Which option is used to rename a worksheet?

Which shortcut key inserts the current date into a cell?

Which shortcut key inserts the current time into a cell?

Which feature allows one worksheet to reference data from another worksheet?

Which symbol is used to separate the sheet name from the cell reference?

Which option is used to protect an entire spreadsheet document with a password?

Which feature automatically updates formulas when referenced cell values change?