College

In the range E9:E10, add column sparklines using data in the range B9:D10. Ungroup the sparklines, and then set the vertical axis maximum value to -15000 for cell E9 and to -60000 for cell E10.

Answer :

The exact steps may vary slightly depending on the spreadsheet program you are using, but these general instructions should help

How to add column sparklines in the range E9:E10

To add column sparklines in the range E9:E10 using data from the range B9:D10 in a spreadsheet program like Microsoft Excel or Go ogle Sheets, you can follow these steps:

Select cell E9.

Find the "Sparklines" or "Insert Sparklines" option in your spreadsheet program. This option is typically located in the "Insert" or "Data" menu.

In the "Create Sparklines" dialog box or menu that appears, you will be prompted to select the data range for the sparkline. Choose the data in the range B9:D9 for cell E9.

Once the sparkline is inserted into cell E9, select cell E10.

Again, go to the "Sparklines" or "Insert Sparklines" option and select the data range B10:D10 for cell E10.

Ensure that the sparklines in cells E9 and E10 are ungrouped, which is the default behavior in most spreadsheet programs.

To set the vertical axis maximum value to -15000 for cell E9 and to -60000 for cell E10, you'll need to adjust the axis settings for each sparkline separately.

This setting can usually be found in the "Format Sparklines" or "Sparkline Options" menu for the selected cell. Look for options related to the vertical axis and maximum value, and set them to the desired values (-15000 for E9 and -60000 for E10).

Learn more about spreadsheet program

https://brainly.com/question/4965119

#SPJ1

Final answer:

To create sparklines in Excel for cells E9:E10 using data in B9:D10, use the 'Insert'>'Sparkline' option. To ungroup the sparklines, select them and use 'Design'>'Group'>'Ungroup' under the Sparkline Tools. Set the vertical axis maximum values in E9 and E10 to -15000 and -60000 respectively using 'Axis'>'Custom Value' under 'Design' tab.

Explanation:

The student's question pertains to a particular feature in Microsoft Excel known as 'sparklines'. Sparklines are small, simple charts without axes, which are present inside a single cell in your worksheet. The aim is to visually represent data in the range B9:D10 in the cells E9:E10 with sparklines. The student also wants to adjust the vertical axis maximum value in the cells E9 and E10 to -15000 and -60000 respectively.

Step 1: Adding Sparklines: Start by selecting the cells E9:E10, head to 'Insert' tab in Excel and choose the suitable sparkline type (Line, Column, Win/Loss) under the Sparkline group. In the 'Create Sparklines' dialog box, mention the data range as B9:D10 and hit 'OK'.

Step 2: Ungroup Sparklines: Select the sparklines and go to the 'Design' tab under 'Sparkline Tools'. Click on the 'Group' option and then 'Ungroup'.

Step 3: Set Vertical Maximum Axis Values: To set the axis values, select the cell E9, go to the 'Axis' option under the 'Design' tab, choose 'Custom Value' for 'Maximum' under 'Vertical Axis Minimum Value Options' and set it as -15000. Repeat the process for cell E10 and set the maximum axis value as -60000.

Learn more about Excel Sparklines here:

https://brainly.com/question/34793727

#SPJ1