Y<span>ou will know when a spreadsheet object is active in a Word document </span>t<span>he Word icon in the taskbar is selected. The ribbon of Word will provide you with the Microsoft Excel features to be used for editing. These include charts, conditional formatting, and formulas.</span>
Answer:
/*
I don't know what language you're using, so I'll write it in javascript which is usually legible enough.
*/
console.log(buildSequence(30));
function buildSequence(maxVal){
maxVal = Math.abs(maxVal);
var n, list = [];
for(n = 1; n < maxVal; n++){
/*
to check for odd numbers, we only need to know if the last bit
is a 1 or 0:
*/
if(n & 1){ // <-- note the binary &, as opposed to the logical &&
list[list.length] = n;
}else{
list[list.length] = -n;
}
}
return list.implode(',');
}
Answer:
WITH deptsalary AS (
SELECT dept, SUM(salary)
FROM emp
GROUP BY dept)
SELCT *
FROM deptsalary
Explanation:
deptsalary is temporary table.
dept and its respective sum of salary is to be displayed
Answer:
import java.util.Scanner;
public class num8 {
public static void main(String[] args) {
Scanner in = new Scanner(System.in);
System.out.println("Enter the mass");
double mass = in.nextDouble();
double weight = calWeight(mass);
System.out.println("The weigth is "+weight);
}
static double calWeight(double mass){
double weight = mass*9.80665; // assume a = accelation due to gravity = 9.80665N
if(weight>500){
System.out.println("Too Heavy");
}
else if(weight<100){
System.out.println("Too Light");
}
return weight;
}
}
Explanation:
- Using Java programming language
- The main method is created to request and store a variable, mass in kilogram. The main method call calWeight() and passes the value for mass
- A method calWeight() is created that calculates the weight in newtons (mass * 9.8).
- The method checks if the weight is greater than 500 (prints too heavy) if less than 100(prints to light)
- Returns the weight
