Funciones en Excel

What is a function in Excel?

• A cell reference

• A predefined formula that performs calculations

• A type of chart

• A data validation rule

Answer explanation

A function in Excel is a predefined formula that performs calculations, allowing users to automate tasks and analyze data efficiently.

Which of the following is NOT a common function in Excel?

• SUM

• AVERAGE

• CONCATENATE

• COUNT

Answer explanation

CONCATENATE is less common than SUM, AVERAGE, and COUNT, which are frequently used for numerical calculations. CONCATENATE is used for joining text strings, making it less essential in typical data analysis tasks.

What symbol should be used at the beginning of each function?

• #

• $

• &

• =

Answer explanation

The correct symbol to use at the beginning of each function is '='. This indicates the start of a formula or function in many programming languages and spreadsheet applications.

In the syntax of Excel functions, the arguments are enclosed within:

• Square brackets [ ]

• Braces { }

• Parentheses ( )

• Angle brackets

Answer explanation

In Excel functions, arguments are enclosed within parentheses ( ). This is the standard syntax for defining function parameters, making parentheses the correct choice over other options like square brackets or braces.

Which function would you use to find the highest value in a range of cells?

• HIGHER

• MAXIMUM

• UPPER

• MAX

Answer explanation

The correct function to find the highest value in a range of cells is MAX. The other options, HIGHER, MAXIMUM, and UPPER, are not valid functions for this purpose in spreadsheet applications.

What does the AVERAGE function do?

• Finds the median value

• Calculates the sum of all values

• Determines the most frequent value

• Calculates the arithmetic mean

Answer explanation

The AVERAGE function calculates the arithmetic mean of a set of values by summing them and dividing by the count of values. This distinguishes it from finding the median or mode.

How are multiple arguments separated in a function?

• Semicolon

• Comma

• Colon

• Period

Answer explanation

In programming, multiple arguments in a function are separated by a comma. This allows the function to distinguish between different inputs. Therefore, the correct answer is 'Comma'.

Which of these is NOT a way to access the AutoSum function?

• Formulas Tab

• Home Tab

• Keyboard shortcut Alt+=

• Insert Tab

Answer explanation

The AutoSum function can be accessed via the Formulas Tab, Home Tab, and the keyboard shortcut Alt+=. However, it is not found in the Insert Tab, making it the correct answer.

What does the COUNT function do?

• Counts cells with numeric data

• Counts all non-empty cells

• Counts cells with text data

• Counts cells with formulas

Answer explanation

The COUNT function specifically counts only the cells that contain numeric data, making 'Counts cells with numeric data' the correct choice. Other options refer to different functions like COUNTA or COUNTIF.

What function would you use to count cells that contain any type of data?

• COUNT

• COUNTA

• SUM

• COUNTIF

Answer explanation

The COUNTA function counts all non-empty cells, including those with text, numbers, or errors. In contrast, COUNT only counts cells with numeric data. Therefore, COUNTA is the correct choice for counting any type of data.