All categories

3 years ago

Text that does not fit in a cell

1 answer:

3 0

To make all wrapped text visibly, do the following to manually adjust the row height:Select the cell or range for which you want to adjust the row height.On the Home tab, in the Cells group, click Format.Under Cell Size , do one of the following: To automatically adjust the row height, click AutoFit Row Height.

You might be interested in

If you have cable internet service, what protocol is used between the head end connection and the cable company's network

julsineya [31]

The answer would be (DOCSIS). :)

Have a blessed day and hope this helps!

7 0

3 years ago

Why would an online survey of 2,000 visitors to your college’s Web site be of little use in assessing the neighboring community’

musickatia [10]

Answer: the sample is not representative of the community.

Explanation:

Online surveys or surveys in general are made to obtain relevant information about a particular issue. If samples are not representative of that issue, they end up having little use.

4 0

3 years ago

Output each floating-point value with two digits after the decimal point, which can be achieved as follows:

sdas [7]

Answer:

The modified program in Python is as follows:

import math

paint_colors = {'red': 35,'blue': 25,'green': 23}

wall_height = int(input('Enter wall height (feet):\n'))

wall_width = int(input('Enter wall width (feet):\n'))

area = wall_height*wall_width

print('Wall area:',area,'square feet')

paint_needed = area/350.0

print('Paint needed: {:.2f} gallons'.format(paint_needed))

print('Cans needed:',round(paint_needed),'can(s)')

color = input("Choose a color to paint the wall: ")

print("Cost of purchasing", color, "paint: $",paint_colors[color])

Explanation:

The italicized are given from the question [unchanged]

import math

paint_colors = {'red': 35,'blue': 25,'green': 23}

wall_height = int(input('Enter wall height (feet):\n'))

This gets input for width

wall_width = int(input('Enter wall width (feet):\n'))

Calculate the wall area

area = wall_height*wall_width

Print the calculated wall area

print('Wall area:',area,'square feet')

Calculate the amount of paint needed

paint_needed = area/350.0

Print the amount of paint needed to 2 decimal places

print('Paint needed: {:.2f} gallons'.format(paint_needed))

Print the amount of can needed to nearest integer

print('Cans needed:',round(paint_needed),'can(s)')

Prompt user for color of paint [here, we assume the user input is correct]

color = input("Choose a color to paint the wall: ")

Prints the corresponding amount for the color

print("Cost of purchasing", color, "paint: $",paint_colors[color])

3 0

2 years ago

Import java.awt.GridLayout;

Vikki [24]

Answer:

public class ConversionCalculator extends JFrame {

private JLabel inch_Label, meter_Label, cm_Label, yard_Label;

private JButton clear, calculate, exit;

private JTextField inch_tf, cm_tf, meters_tf, yards_tf;

public ConversionCalculator()

{

exitButtonHandler exitB;

clearButtonHandler clearB;

calcButtonHandler calcB;

setTitle("Conversion Calculator");

setSize(600,200);

setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

//The first layout we use will be 1 row with three columns

setLayout(new GridLayout(1,3));

//initialize all the components

inch_Label = new JLabel("Inches");

meter_Label = new JLabel("Meters");

cm_Label = new JLabel("Centimeters");

yard_Label = new JLabel("Yards");

clear = new JButton("Clear");

calculate = new JButton("Calculate");

exit = new JButton("Exit");

inch_tf = new JTextField("0.00");

cm_tf = new JTextField("0.00");

meters_tf = new JTextField("0.00");

yards_tf = new JTextField("0.00");

JPanel panel1 = new JPanel();

panel1.setLayout(new GridLayout(2,2));

JPanel panel2 = new JPanel();

panel2.setLayout(new GridLayout(2,2));

JPanel panel3 = new JPanel();

panel3.setLayout(new GridLayout(3,1));

panel1.add(cm_Label);

panel1.add(cm_tf);

panel1.add(meter_Label);

panel1.add(meters_tf);

panel2.add(inch_Label);

panel2.add(inch_tf);

panel2.add(yard_Label);

panel2.add(yards_tf);

panel3.add(clear);

panel3.add(calculate);

panel3.add(exit);

add(panel1);

add(panel2);

add(panel3);

exitB = new exitButtonHandler();

exit.addActionListener(exitB);

clearB = new clearButtonHandler();

clear.addActionListener(clearB);

calcB = new calcButtonHandler();

calculate.addActionListener(calcB);

setVisible(true);

}

//public static void main(String[] args)

// {

// new ConversionCalculator();

//}

private class exitButtonHandler implements ActionListener

{

public void actionPerformed(ActionEvent e)

{

//exits program

System.exit(0);

}

private class clearButtonHandler implements ActionListener

{

public void actionPerformed(ActionEvent e)

{

//clear button sets all text fields to 0

inch_tf.setText("0.00");

meters_tf.setText("0.00");

yards_tf.setText("0.00");

cm_tf.setText("0.00");

}

private class calcButtonHandler implements ActionListener

{

public void actionPerformed(ActionEvent e)

{

double inches, yards, meters, cms;

DecimalFormat df = new DecimalFormat("0.00");

//parse strings in textbox into doubles

inches = Double.parseDouble(inch_tf.getText());

yards = Double.parseDouble(yards_tf.getText());

meters = Double.parseDouble(meters_tf.getText());

cms = Double.parseDouble(cm_tf.getText());

//we check which value has been tampered with and base our conversion off this

//because of this it is important that the user clears, or else it will do inch conversion

if(inches != 0.00)

{

cms = inches * 2.54;

meters = cms / 100;

yards = inches / 36;

cm_tf.setText(df.format(cms));

meters_tf.setText(df.format(meters));

yards_tf.setText(df.format(yards));

}

else if(yards != 0.00)

{

inches = yards / 36;

cms = inches * 2.54;

meters = cms / 100;

cm_tf.setText(df.format(cms));

meters_tf.setText(df.format(meters));

inch_tf.setText(df.format(inches));

}

else if(meters != 0.00)

{

cms = meters * 100;

inches = cms / 2.54;

yards = inches / 36;

cm_tf.setText(df.format(cms));

inch_tf.setText(df.format(inches));

yards_tf.setText(df.format(yards));

}

else if(cms != 0.00)

{

inches = cms / 2.54;

yards = inches / 36;

meters = cms / 100;

meters_tf.setText(df.format(meters));

inch_tf.setText(df.format(inches));

yards_tf.setText(df.format(yards));

}

Explanation:

Inside the action performed method, pass the strings in text box.
check if the value has been modified then do the relevant conversions inside the conditional statement.
When the user clears, it will not do to the inch conversion.

8 0

3 years ago

The assignment operator has left-to-right-to-left associativity, which means that the value of the expression to the left of the

postnew [5]

Answer:

The given statement is false statement.

Explanation .

The assignment is assigning the value to the variable or we can say that it will also be used to initialize the variable The "=" is the symbol of the assignment operator.

For example

int r=90, The value of variable 90 is assigned to 90.

The associativity, of assignment, is always right to left which means The right-hand side is firstly evaluated then it will be assigned in left-hand side variable or expression.

4 0

3 years ago