Spreadsheet Level 5: Formulas and Functions

What is the function used to sum a range of cells in Excel?

• SUM

• MERGE

• TOTAL

• ADD

How can you reference a cell in a formula using its address?

• Right-click on the cell and choose 'Reference'

• Use the cell's color to reference it

• Select the cell and press F2

• Type the cell's address directly into the formula.

What does the VLOOKUP function do in a spreadsheet?

• It creates a new worksheet in the spreadsheet

• It searches for a value in a table and returns a corresponding value from another column.

• It calculates the sum of a range of cells

• It changes the font style of selected text

Explain the difference between absolute and relative cell references.

• Absolute cell references are always negative, while relative cell references are always positive

• Absolute cell references do not change, while relative cell references change based on the formula's position.

• Absolute cell references change, while relative cell references do not change

• Absolute cell references are used for text, while relative cell references are used for numbers

When should you use the IF function in Excel?

• When you want to change the font style of a cell

• When you want to calculate the sum of a range of cells

• When you want to insert a new row in the spreadsheet

• When you want to perform a logical test and return different values based on the result.

What is the purpose of the CONCATENATE function?

• To perform mathematical operations on strings

• To combine multiple strings into a single string

• To split a single string into multiple strings

• To convert strings into numbers

How can you calculate the average of a range of numbers in Excel?

• Use the MAX function in Excel.

• Manually add all numbers and divide by the count.

• Use the SUM function in Excel.

• Use the AVERAGE function in Excel.

What is the difference between COUNT and COUNTA functions?

• COUNT function counts cells with numbers, dates, or times; COUNTA function counts non-empty cells including text, logical values, and errors.

• COUNT function counts cells with errors; COUNTA function counts cells with logical values.

• COUNT function counts only text values; COUNTA function counts only numerical values.

• COUNT function counts cells with dates; COUNTA function counts cells with times.

Explain the purpose of the SUMIF function.

• To count values based on a single criteria

• To average values based on a single criteria

• To sum values based on a single criteria

• To multiply values based on a single criteria

How can you nest functions in Excel formulas?

• Avoid using functions within functions

• Use a single function for all calculations

• Enter one function as an argument within another function

• Combine functions in a separate cell