excel class week 2

What function is used to combine the text from multiple cells into one cell in Excel?

• CONCATENATE

• COMBINE

• MERGE

• JOIN

Which Excel function is used to extract a substring from a text string based on its position?

• MID

• SUBSTRING

• EXTRACT

• SPLICE

Which function is used to return the leftmost characters from a text string in Excel?

• INITIAL

• BEGIN

• FIRST

• LEFT

What Excel function is used to return the rightmost characters from a text string?

• TRAIL

• LAST

• RIGHT

• END

Which Excel function capitalizes the first letter of each word in a text string?

• CAP

• PROPER

• INITIALCAP

• TITLECASE

Which function converts all characters in a text string to uppercase?

• UCASE

• BIGCASE

• UPPER

• MAJUSCULE

Which function converts all characters in a text string to lowercase?

• LOWER

• LCASE

• SMALLCASE

• MINUSCULE

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

• PLUS

• SUM

• ADD

• TOTAL

Which feature in Excel is used to automatically fill in data based on a pattern?

• Data Fill

• Fill Handle

• Fill Series

• AutoFill

What Excel feature guesses the desired output when you start typing in adjacent cells?

• Rapid Fill

• Flash Fill

• Smart Fill

• Quick Fill