Excel practice problems
Q. For accurate analysis and calculations, all sales figures need to be converted to numerical values.
Your task is to convert these text-based sales figures into numbers.
Ans: The VALUEfunction in Excel Converts text that looks like a number into a true numeric value.
Sales Figure (number)= value(C2: C6)
Q. Your task is to analyze the categorization of products listed on its platform.
Get Sanjucta_Sutradhar’s stories in your inbox
Join Medium for free to get updates from this writer.
You have a dataset that includes Product Name and Category columns. Your goal is to convert all product names in the Category column to uppercase letters for better categorization analysis.
Ans: TheUPPER formula in Excel isused to convert all lowercase letters in a text string into uppercase (capital) letters.
values= upper(b2:b7)
Q. The dataset contains entries formatted as Movie Title - Genre, where each entry consists of a movie title followed by its genre, separated by a hyphen.
Your objective is to isolate the genre from each entry to facilitate better organization and improve user recommendations based on genre preferences.
Ans: In Excel, you can easily extract everything that occurs after a specific character, word, or symbol using theTEXTAFTER function.
Movie Genre = Trim(textafter(A2,”-”))
