Hojas de Cálculo Calc

What is the purpose of a spreadsheet?

• To bake cookies

• To organize and analyze data

• To build a house

• To write a novel

Explain the difference between a relative reference and an absolute reference in a formula.

• Relative reference and absolute reference are the same thing.

• Relative reference changes when the formula is copied to another cell, while absolute reference changes based on the value of the cell.

• Relative reference changes when the formula is copied to another cell, while absolute reference remains constant.

• Relative reference remains constant, while absolute reference changes when the formula is copied to another cell.

How can you create a new spreadsheet in Hojas de Cálculo Calc?

• Go to 'File' and then select 'New' and 'Spreadsheet'

• Press 'Ctrl + N' to create a new spreadsheet

• Click on 'Edit' and then select 'New' and 'Spreadsheet'

• Go to 'View' and then select 'New' and 'Spreadsheet'

What are some common formatting options for cells in a spreadsheet?

• Italic, strikethrough, font type, cell alignment

• Highlight, underline, font style, cell padding

• Text color, cell border style, font weight, cell merge

• Bold, italic, underline, font size, font color, cell background color, borders, and number formatting

What is the function of the SUM formula in a spreadsheet?

• To add up the values in a range of cells.

• To sort the values in a range of cells.

• To multiply the values in a range of cells.

• To find the average of the values in a range of cells.

Explain the difference between a function and a formula in a spreadsheet.

• A function is a predefined operation, while a formula is a user-defined calculation.

• A function is used for text manipulation, while a formula is used for numerical calculations.

• A function is a user-defined calculation, while a formula is a predefined operation.

• A function and a formula are the same thing.

How can you use the IF function to create a conditional statement in a spreadsheet?

• By using the SUM function

• By entering random values

• By deleting the entire spreadsheet

• By specifying a logical test, the value to return if the test is true, and the value to return if the test is false.

What are some basic mathematical functions that can be used in a spreadsheet?

• Square root, exponentiation, logarithm, sine

• Average, maximum, minimum, total

• Addition, subtraction, multiplication, division, SUM, AVERAGE, MAX, MIN

• Subtraction, division, multiplication, addition

Describe the process of using the autofill feature in a spreadsheet.

• Double click on the cell to autofill the adjacent cells

• Press the spacebar to activate the autofill feature

• Use the copy and paste function to autofill the adjacent cells

• Select the cell or range of cells containing the data you want to autofill, then click and drag the small square in the bottom right corner of the selection to fill the adjacent cells with the same data or a series of data.

How can you use the VLOOKUP function to search for specific data in a spreadsheet?

• By entering the specific data to search for in the first argument, specifying the range of cells to search in the second argument, and indicating the column number where the data is located in the third argument.

• By specifying the range of cells to search in the first argument

• By entering the specific data to search for in the last argument

• By indicating the row number where the data is located in the third argument