To assign a name to input into a formula with another variable (ex: Chicago, 200), you can highlight the columns you want categorized, - hit formula tab, - then create from selection - Now, 200 should be categorized as Chicago in the little finders window in the top left corner of the workbook.

🎲 Try a Random Question  |  Total Questions in Quiz: 113  |  🧠 Study this quiz with Flashcards
This question is part of a full practice quiz:
Harvard Spreadsheet Modeling — practice the complete quiz, review flashcards, or try a random question.


1. To assign a name to input into a formula with another variable (ex: Chicago, 200), you can highlight the columns you want categorized, - hit formula tab, - then create from selection - Now, 200 should be categorized as Chicago in the little finders window in the top left corner of the workbook.