Question

a data analyst at a symphony orchestra uses a spreadsheet to keep track of how many concerts require more than 80 musicians. they use a spreadsheet tool to change how cells appear when values equal 80 or more. what tool are they using?

Answer 1

The data analyst is likely using a spreadsheet tool with conditional formatting, which allows them to specify how cells should appear based on the values they contain. With conditional formatting, they can set a rule that specifies how cells should be formatted when they contain a value of 80 or more. For example, they could specify that cells with a value of 80 or more should be highlighted in a particular color, or that the text in those cells should be bolded or italicized. This can be a useful way to quickly and easily identify cells that meet certain criteria within a spreadsheet.