EXCEL FUNCTIONS CYBERNETIK

1. What is the syntax of the SUM function in Excel?

• =SUM (range)

• =TOTAL (range)

• =COUNT (range)

• =SUMMA (range)

The IF function in Excel can be used to perform what type of calculation?

• Text processing

• Logical comparison

• Mathematical calculation

• Statistical analysis

What is the shortcut to sum cells quickly in Excel?

• ALT+S

• CTRL+S

• Alt+Shift+S

• CTRL+Shift+S

What function can be used to count how many unique values are in a range of cells in Excel?

• COUNTIF

• COUNTUNIQUE

• COUNTBLANK

• COUNT

What function in Excel is used to convert a text value to a number?

• VALUE

• INT

• NUMBER

• CONVERT

What function is used to calculate the average of a range of numbers in Excel?

• AVG

• MEAN

• MEDIAN

• MODE

What function is used to find the largest value within a range of cells in Excel?

• MAX

• MIN

• AVERAGE

• RANGE

What is the syntax of the VLOOKUP function in Excel?

• =VLOOKUP (value, table, colindex, [range])

• =VLOOKUP (table, colindex, [range], value)

• =VLOOKUP (value, colindex, table, [range])

• =VLOOKUP (table, value, colindex, [range])

Which function can be used to find the difference between two dates in Excel?

• DAYS

• DATEDIF

• DATEDIFF

• DAYDIF

What function is used to count the number of cells within a range that meet specific criteria in Excel?

• COUNT

• COUNTE

• COUNTIF

• COUNTIFF