Preguntas sobre Excel

What is the name of the bar where you can see and edit the content of a cell?

• Formula bar

• Taskbar

• Menu bar

• Toolbar

What does cell A1 mean in Excel?

• The first column of the sheet

• The first row of the sheet

• The cell located in the first column and the first row

• The first sheet of the spreadsheet

How can you select multiple cells?

• Clicking on each cell while holding down the Ctrl key

• Clicking on a cell and then pressing Ctrl + A

• Clicking on a cell and pressing the F2 key

• Clicking on a cell and then pressing Ctrl + C

What does the function `SUM()` do in Excel?

• Sums the selected cells

• Calculates the average of the selected values

• Sums all values in a row

• Multiplies the selected values

How do you change the format of a number to appear as currency?

• Select the cells and choose 'Number Format' -> 'Currency'

• Use the function `CURRENCY()`

• Write the currency symbol before the number

• Select the cells and choose 'Cell Format' -> 'Text'

Which of the following formulas will return the largest value from a set of cells?

• `AVERAGE()`

• `MAX()`

• `MIN()`

• `IF()`

What function can you use to look up a value in a table and return an associated value?

• `VLOOKUP()`

• `IF()`

• `SUM()`

• `CONCATENATE()`

How is the `IF()` function used in Excel?

• To sum values based on conditions

• To count how many times a value repeats

• To perform a logical comparison and return a value if true or false

• To look up data within a table

How do you insert a chart in Excel?

• Select the data and then click the 'Insert Chart' button

• Use the function `CHART()`

• Type the command in the formula bar

• Right-click on the cells and select 'Insert Chart'

What do you do when you click the 'Insert Chart' button?

• You use the function `GRAPH()`,

• You write the command in the formula bar,

• Right-click on the cells and select 'Insert Chart'