Quiz 1 Excel

What function would you use to add a range of numbers?

• SUM

• AVERAGE

• COUNT

• MAXIMUM

How do you count the number of cells that contain numbers in a range?

• Count the cells manually by checking each one.

• Use the SUM function, e.g., =SUM(A1:A10).

• Use the AVERAGE function, e.g., =AVERAGE(A1:A10).

• Use the COUNT function, e.g., =COUNT(A1:A10).

Which function calculates the average of a set of values?

• average

• sum

• mode

• median

What function would you use to find the smallest number in a range?

• SUM

• MIN

• AVERAGE

• MAX

How does the IF function work in Excel?

• The IF function works by evaluating a condition and returning specified values based on whether the condition is TRUE or FALSE.

• The IF function only works with numerical values.

• The IF function can only return text values.

• The IF function does not evaluate conditions.

What is a nested IF function and when would you use it?

• A nested IF function is used to evaluate multiple conditions in a single formula.

• A nested IF function is a type of data validation tool.

• A nested IF function can only evaluate two conditions at a time.

• A nested IF function is used to format text in Excel.

How do you perform a vertical lookup in a table?

• Use the VLOOKUP function with the syntax VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]).

• Apply the INDEX function to retrieve data from a specific row and column.

• Use the HLOOKUP function with the syntax HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup]).

• Utilize the MATCH function to find the position of a value in a row.

What is the purpose of the HLOOKUP function?

• To find the maximum value in a column.

• To look up a value in the first row and return a corresponding value from a specified row.

• To count the number of cells in a row.

• To sort values in ascending order.

How can you sum values based on a specific condition?

• Use the AVERAGE function in Excel

• Apply the COUNT function in SQL

• Use conditional functions like SUMIF in Excel or conditional aggregation in SQL.

• Utilize the CONCATENATE function in Excel

What function counts the number of cells that meet a single criterion?

• COUNTIF

• COUNT

• SUMIF

• AVERAGEIF