All categories

1 year ago

Create a formula in the selected cell that multiplies the value in cell b2 of the current worksheet

1 answer:

3 0

To multiply two cells in Excel, use a multiplication formula like in the above example, but supply cell references instead of numbers. For example, to multiply the value in cell A2 by the value in B2, type this expression is A2*B2.

What do you under stand by Excel?

Microsoft's spreadsheet program Excel is a part of the Office family of products used for business purposes. Users can format, arrange, and compute data in a spreadsheet using Microsoft Excel.

To create formula in the selected cell follow these steps:

The PRODUCT function would be the quickest technique to multiply several cells or ranges.

Where number1, number2, etc. are numbers, cells or ranges that you want to multiply.

to multiply values in cells A2, B2 and C2, use this formula is PRODUCT(A2:C2)

To multiply the numbers in cells A2 through C2, and then multiply the result by 3, is PRODUCT(A2:C2,3)

Learn more about Excel click on this:

brainly.com/question/25863198

#SPJ4

You might be interested in

[1] Please find all the candidate keys and the primary key (or composite primary key) Candidate Key: _______________________ Pri

AVprozaik [17]

Answer:

Check the explanation

Explanation:

1. The atomic attributes can't be a primary key because the values in the respective attributes should be unique.

So, the size of the primary key should be more than one.

In order to find the candidate key, let the functional dependencies be obtained.

The functional dependencies are :

Emp_ID -> Name, DeptID, Marketing, Salary

Name -> Emp_ID

DeptID -> Emp_ID

Marketing -> Emp_ID

Course_ID -> Course Name

Course_Name -> Course_ID

Date_Completed -> Course_Name

Closure of attribute { Emp_ID, Date_Completed } is { Emp_ID, Date_Completed , Name, DeptID, Marketing, Salary, Course_Name, Course_ID}

Closure of attribute { Name , Date_Completed } is { Name, Date_Completed , Emp_ID , DeptID, Marketing, Salary, Course_Name, Course_ID}

Closure of attribute { DeptID, Date_Completed } is { DeptID, Date_Completed , Emp_ID,, Name, , Marketing, Salary, Course_Name, Course_ID}

Closure of attribute { Marketing, Date_Completed } is { Marketing, Date_Completed , Emp_ID,, Name, DeptID , Salary, Course_Name, Course_ID}.

So, the candidate keys are :

{ Emp_ID, Date_Completed }

{ Name , Date_Completed }

{ DeptID, Date_Completed }

{ Marketing, Date_Completed }

Only one candidate key can be a primary key.

So, the primary key chosen be { Emp_ID, Date_Completed }..

The functional dependencies are :

Emp_ID -> Name, DeptID, Marketing, Salary

Name -> Emp_ID

DeptID -> Emp_ID

Marketing -> Emp_ID

Course_ID -> Course Name

Course_Name -> Course_ID

Date_Completed -> Course_Name

For a relation to be in 2NF, there should be no partial dependencies in the set of functional dependencies.

The first F.D. is

Emp_ID -> Name, DeptID, Marketing, Salary

Here, Emp_ID -> Salary ( decomposition rule ). So, a prime key determining a non-prime key is a partial dependency.

So, a separate table should be made for Emp_ID -> Salary.

The tables are R1(Emp_ID, Name, DeptID, Marketing, Course_ID, Course_Name, Date_Completed)

and R2( Emp_ID , Salary)

The following dependencies violate partial dependency as a prime attribute -> prime attribute :

Name -> Emp_ID

DeptID -> Emp_ID

Marketing -> Emp_ID

The following dependencies violate partial dependency as a non-prime attribute -> non-prime attribute :

Course_ID -> Course Name

Course_Name -> Course_ID

So, no separate tables should be made.

The functional dependency Date_Completed -> Course_Name has a partial dependency as a prime attribute determines a non-prime attribute.

So, a separate table is made.

The final relational schemas that follows 2NF are :

R1(Emp_ID, Name, DeptID, Marketing, Course_ID, Course_Name, Date_Completed)

R2( Emp_ID , Salary)

R3 (Date_Completed, Course_Name, Course_ID)

For a relation to be in 3NF, the functional dependencies should not have any transitive dependencies.

The functional dependencies in R1(Emp_ID, Name, DeptID, Marketing, Date_Completed) is :

Emp_ID -> Name, DeptID, Marketing

This violates the transitive property. So, no table is created.

The functional dependencies in R2 ( Emp_ID , Salary) is :

Emp_ID -> Salary

The functional dependencies in R3 (Date_Completed, Course_Name, Course_ID) are :

Date_Completed -> Course_Name

Course_Name -> Course_ID

Here there is a transitive dependency as a non- prime attribute ( Course_Name ) is determining a non-attribute ( Course_ID ).

So, a separate table is made with the concerned attributes.

The relational schemas which support 3NF re :

R1(Emp_ID, Name, DeptID, Course_ID, Marketing, Date_Completed) with candidate key as Emp_ID.

R2 ( Emp_ID , Salary) with candidate key Emp_ID.

R3 (Date_Completed, Course_Name ) with candidate key Date_Completed.

R4 ( Course_Name, Course_ID ). with candidate keys Course_Name and Course_ID.

6 0

4 years ago

Create a game that rolls two dies (number from 1 to 6 on the side) sequentially for 10 times (use loop). If at least once out of

Alex73 [517]

Answer:

Explanation:

The following code is written in Java and loops through 10 times. Each time generating 2 random dice rolls. If the sum is 10 it breaks the loop and outputs a "You Win" statement. Otherwise, it outputs "You Lose"

import java.util.Random;

class Brainly {

public static void main(String[] args) {

UseRandom useRandom = new UseRandom();

boolean youWin = false;

for (int x = 0; x<10; x++) {

int num1 = useRandom.getRandom(6);

int num2 = useRandom.getRandom(6);

if ((num1 + num2) == 10) {

System.out.println("Number 1: " + num1);

System.out.println("Number 2: " + num2);

System.out.println("You Win");

youWin = true;

break;

}

if (youWin == false) {

System.out.println("You Lose");

}

class UseRandom{

public int getRandom(int n)

{

Random r=new Random();

int rand=r.nextInt(n);

return rand;

}}

8 0

3 years ago

Write a program that prompts the user to enter five test scores and then prints the average test score. Indicate the average tes

eduard

Answer:

I am writing the program in C++ and Python.

C++ code:

#include <iostream> // for input output functions

using namespace std; // identifies objects like cin cout

int main() //start of main() function body

{ // test scores variables are declared along with average and sum variables

double test_score1, test_score2, test_score3, test_score4, test_score5, average, sum;

cout << "Enter 5 test scores: \n"; //prompts user to enter 5 test scores

cin >> test_score1 >> test_score2 >> test_score3 >> test_score4 >> test_score5; //reads values of five test scores entered by user

sum = test_score1 + test_score2 + test_score3 + test_score4 + test_score5; // calculates the sum of the five test scores

average = sum / 5; //computes the average of five test scores

cout << "The average test score is: " << average;

//displays the computer average of the five test scores entered by the user

}

Explanation:

The program prompts the user to enter the values of 5 test scores. It the calculates the sum of all these 5 input test scores and stores the result in sum variable. In order to compute average test score the sum of these 5 test scores is divided by the total number of test scores that is 5 and the result is stored in average variable. Lastly it displays the average by displaying the value of the average stored in the average variable.

Python Program:

num=5 # total number of test scores

list=[] #list to store values of 5 test scores

for i in range(0,num): #loop to enter values of test scores

#prompts user to enter values for 5 test scores

test_scores =int(input("Enter the five test scores"))

list.append(test_scores) #appends the input test scores in the list

average=sum(list)/num #calculates sum of the values stored in list and #divides the value of sum with the total number of test scores i.e. 5

print("Average test score is: ",round(average,2))

#displays average of the five test scores rounding up to two decimal places

Explanation:

This is a small program in Python to compute average test score. If you want to take separate input for each of the five test scores you can use the following program:

#takes value for each test score seperately from user

testScore1 = int(input('Enter 1st test score: '))

testScore2 = int(input('Enter 2nd test score : '))

testScore3 = int(input('Enter 3rd test score : '))

testScore4 = int(input('Enter 4th test score : '))

testScore5 = int(input('Enter 5th test score : '))

#calculates sum of each test score

sum = (testScore1 + testScore2 + testScore3 + testScore4 + testScore5)

#method to compute average test score

def average(sum):

return sum / 5 #divide value of sum with total number of test scores

#calls average function to display average test score using print statement

print("average test score is: " , average(sum))

The programs along with their outputs is attached in the screenshots.

5 0

3 years ago

This OS was basically an upgrade to Windows 98 that was designed for home users.

matrenka [14]

Answer:

Windows ME

Explanation:

In the word Windows Me, Me stands for Milleneum. It is GUI based OS developed by Microsoft Corporation. This is the first Home computer OS and it had IE 5.5, WMP version 7, etc. 

But this was not that much successful and this was the last OS released for Windows 9X series. Though its GUI based, it still looks like DOS OS only.

The successor of this is Windows XP which became very popular and it was used by many computer users and it included windows NT Kernel.

5 0

3 years ago

CPT codes are used to report diagnoses. Answer a. True b. False

Readme [11.4K]

true hope that helps

6 0

4 years ago