Changing Text Case in Microsoft Excel

Changing Text Case in Microsoft Excel

Assessment

Interactive Video

Other, Social Studies

KG - University

Hard

Created by

Quizizz Content

FREE Resource

This video tutorial demonstrates how to change text case in Microsoft Excel using formulas. It covers converting text to lowercase, uppercase, and proper case. The tutorial explains how to use the LOWER, UPPER, and PROPER functions, and how to paste values to replace formulas with editable text. Although Excel lacks a sentence case function, the video provides a workaround by manually adjusting capital letters.

Read more

2 questions

Show all answers

1.

OPEN ENDED QUESTION

3 mins • 1 pt

Is there a built-in formula for sentence case in Microsoft Excel?

Evaluate responses using AI:

OFF

2.

OPEN ENDED QUESTION

3 mins • 1 pt

What does the 'proper' function do in Excel?

Evaluate responses using AI:

OFF