Microsoft Excel Functions Quiz

What does the UPPER function in Excel do?

• Counts the number of uppercase letters in a text string

• Converts all letters in a text string to lowercase

• Deletes all uppercase letters in a text string

• Converts all letters in a text string to uppercase

How is the UPPER function used in Excel?

• Convert all letters in a text string to lowercase

• Count the number of characters in a text string

• Convert all letters in a text string to uppercase

• Change the font size of a text string

Explain the purpose of the LOWER function in Excel.

• To convert all letters in a specified text to lowercase.

• To insert a new row in the spreadsheet

• To change the font size of a specified text

• To calculate the sum of a range of cells

Provide an example of using the LOWER function in Excel.

• UPPER(A1)

• PROPER(A1)

• LOWER(A1)

• TRIM(A1)

What is the MID function used for in Excel?

• To calculate the average of a range of cells

• To create a pivot table

• To extract a specific number of characters from a text string

• To convert a value from radians to degrees

How do you extract a specific number of characters using the MID function in Excel?

• =SUM("apple",2,3)

• =MID("apple",2,3)

• =PROPER("apple",2,3)

• =LOWER("apple",2,3)

Describe the functionality of the PROPER function in Excel.

• It removes all punctuation from the text

• It converts all letters to uppercase

• It converts all letters to lowercase

• It converts the first letter of each word in a text to uppercase and the rest to lowercase.

Give an example of how the PROPER function can be used in Excel.

• PROPER(A1)

• CONCATENATE(A1, B1)

• LOWER(A1)

• UPPER(A1)

What is the purpose of the HYPERLINK function in Excel?

• To insert a new row in the spreadsheet

• To calculate the average of a range of cells

• To create a clickable link to a specific location, file, or web page.

• To change the font style of a cell

How do you create a hyperlink to a website using the HYPERLINK function in Excel?

• =HYPERLINK("http://www.example.com", "Click here")

• =LINKTOURL("http://www.example.com")

• =WEBSITEURL("http://www.example.com")

• =URLLINK("http://www.example.com")