Application Development - Excel

Which function is used to find the smallest value in a range of cells?

• MAX

• MIN

• AVERAGE

• SUM

Which function would you use to combine the contents of two or more cells?

• CONCATENATE

• INDEX

• VLOOKUP

• IF

What is the purpose of the VLOOKUP function?

• To lookup and retrieve data from any column in a table.

• To count the number of cells that meet a criterion.

• To sum a range of cells.

• To find the average of a range of cells.

Which Excel function would you use to assign a specific name to a cell or range of cells?

• NamingFunction

• DefineName

• CELL

• RangeFunction

Which function returns the position of a value in a given range?

• INDEX

• VLOOKUP

• RANK

• IF

What does the IF function do?

• It checks a condition and returns one value if true and another if false.

• It sums up a range of cells.

• It finds the maximum value in a range.

• It averages a range of cells.

Which of the following is used to automatically change the formatting of cells based on their values?

• ConditionalFormatting

• DataValidation

• CustomFormatting

• CellStyles

How do you insert a picture into an Excel worksheet?

• Use the VLOOKUP function.

• Use the INDEX function.

• Insert>Picture

• Use the IF function.

Which function returns the sum of a range of cells?

• MAX

• SUM

• AVERAGE

• RANK

Which function can be used to determine the position of a specific value in a one-dimensional range?

• INDEX

• VLOOKUP

• CONCATENATE

• IF