Answer:
havent watched it and thanks for this
Explanation:
The feature to restrict values allowed in a cell and need to create a drop-down list of values from which users can choose in the above scenario is data validation.
<h3>What is data validation?</h3>
Data validation is a term that connote the act of monitoring the truthfulness and quality of source data before one can make use of it, importing or even process data with it.
Note that The feature to restrict values allowed in a cell and need to create a drop-down list of values from which users can choose in the above scenario is data validation as it ensure that users can make their own choice.
Learn more about data validation from
brainly.com/question/27138101
#SPJ1
Answer:
1. Microsoft Excel helps data analysis through different spreadsheet queries and operations options.
2. Input data to the analysis of sales by product is required for the development of formula and extracting results.
3. The information of data source and frequency of report is required to start the work.
Explanation:
1. Microsoft Excel tool can be used to calculate the results of equipment. Obtained results can be displayed in charts and graphs from the excel.
2. Information like the quantity of sold items, remaining items are required to produce accurate, useful analysis.
Before starting assignment accounting manager will be asked the following questions.
1) Where does the input data come from?
2) Is analysis required on a daily basis or once for all provided data?
3) Is Summary is in the form of tabular data, Graphical data, or Both?
Answer:
if (pH<7.0){
neutral=0;
base=0;
acid=1;
}
else if (pH>7.0){
neutral=0;
base=1;
acid=0;
}
else if (pH==7.0){
neutral=1;
base=0;
acid=0;
}
Explanation:
As required by the question, if and else statements have been used to test the value of the pH and assign the apropriate values to the variables neutral, base and acid.
The code snippet below can be used to prompt the user to enter values for pH
<em>import java.util.Scanner;</em>
<em>public class pHTest {</em>
<em> public static void main(String[] args) {</em>
<em> Scanner scr = new Scanner(System.in);</em>
<em> System.out.println("Enter a value for the pH");</em>
<em> int neutral, base, acid;</em>
<em> double pH = scr.nextDouble();</em>
<em> if (pH<7.0){</em>
<em> neutral=0;</em>
<em> base=0;</em>
<em> acid=1;</em>
<em> }</em>
<em> else if (pH>7.0){</em>
<em> neutral=0;</em>
<em> base=1;</em>
<em> acid=0;</em>
<em> }</em>
<em> else if (pH==7.0){</em>
<em> neutral=1;</em>
<em> base=0;</em>
<em> acid=0;</em>
<em> }</em>
<em>} }</em>
