All categories

3 years ago

You want to divide the value in cell D3 by the value in cell E3. Which formula should you use?

Computers and Technology

2 answers:

Tom [10]3 years ago

4 0

The formula is:
=D3/E3

Arisa [49]3 years ago

4 0

Answer:

=D3/E3

Explanation:

When you need to use a formula to make a calculation in Excel, you have to determine the type of operation, the numbers involve and the cells in which they are, as the formula will be written in terms of the cell where the numbers are located. In this case, you want to divide the value in cell D3 by the value in cell E3. The first thing you need to put is the equal sign "=" that indicates that you are going to insert a formula using one or more cells. Then, you write D3 that is the numerator, the sign "/" that indicates that the operation is a division and E3 that is the denominator.

You might be interested in

Sara is a college student studying accounting. She uses a laptop daily for personal and course work. What data might Sara have o

polet [3.4K]

Answer:

Sara: Personal data

Jorge : Personal data + official data.

Wanda: Personal data + students data

Carl: Personal data + official data

Explanation:

Personal data could contain pictures, social security numbers, banking transactions details, passwords, credit card information etc.

Jorge's official data could contain information about various sources that he gets his news from. It could contain password information about his official email. And he connects to the office network, he might pose a threat to the entire network if his PC is infected.

Wanda could leak the student's information. She could also leak her social security numbers, bank details, organization's details etc.

Carl could leak company's information. He can avoid it by staying away from public networks. Installing anti-virus. He should also take great care while accessing various sites and never download harmful files over the internet.

8 0

3 years ago

Description

lapo4ka [179]

Answer:

from datetime import time, datetime, timedelta, date

for _ in iter(list, 0):

t1 = input("Please enter time one: ")

t2 = input("Please enter time two: ")

if t1.isdigit() == True and (int(t1[:2])<=23 and int(t1[2:]) <= 59)\

and t2.isdigit() == True and (int(t2[:2])<= 23 and int(t2[2:])<=59):

time_1 = time(hour=int(t1[:2]), minute=int(t1[2:]))

time_2 = time(hour= int(t2[:2]), minute=int(t2[2:]))

if time_1 > time_2:

diff = datetime. combine (date. today( ), time_1) - datetime. combine(date. today ( ), time_2)

else:

diff = datetime. combine (date. today( ), time_2) -datetime. combine(date. today ( ), time_1)

diff_list = str(diff).split(":")

del diff_list[2]

diff_t = "". join (diff_list)

print(diff_t)

break

if t1.isdigit() == False or t2.isdigit() == False:

print("Military Time Forest Required: Bad input, try again.")

continue

elif int(t1[:2])> 23 or int(t2[:2])> 23:

print("Military Tine Format Required: Hours must be between 00 and 23, try again")

continue

elif int(t1[2:])> 59 or int(t2[2:])> 59:

print("Military Tine Format Required: Minutes must be between me and 59, try again")

continue

Explanation:

The python Datetime package is used to manipulate date and time, creating immutable Datetime objects from the various python data types like integer and string. The block of code above is a conditional for-loop statement that gets two user time value inputs and prints out the difference as a string in Military forest time format.

5 0

3 years ago

CODING TIME

Fynjy0 [20]

Answer:

food_list = ['rice', 'beans','yam', 'bread', 'pasta', 'cocoa','tea']

one_more = ['meat']

extend_list = food_list + one_more

print(extend_list)

Output : ['rice', 'beans','yam', 'bread', 'pasta', 'cocoa','tea', 'meat']

food_list.append('milk')

print(food_list)

Output : ['rice', 'beans','yam', 'bread', 'pasta', 'cocoa','tea', 'milk']

food_list.insert(0, 'cake')

print(food_list)

Output : ['cake', 'rice', 'beans','yam', 'bread', 'pasta', 'cocoa','tea']

flowers = ['rose', 'hibiscus', 'lily']

flowers.remove('rose')

print(flowers)

Output : ['hibiscus', 'lily']

To remove rose using pop()

flowers.pop(0)

Explanation:

The + operator and append method adds elements to the end of an existing list item.

The insert method adds element at the specified index

Remove method deletes element by stating the name of the element to be deleted while pop deletes element using the index value of the element.

7 0

2 years ago

___________ applications help you manage and present mathematical data easily and perfectly.

elixir [45]

Answer:

Spreadsheet

Explanation:

Spreadsheet applications like Microsoft Excel, Google Sheet, etc. makes the task of managing and presenting the mathematical data quite easy and perfect. It consists of rows and columns, and in each cell, we can apply a set of formulas. Its a great data mining tool as well, where the unprocessed data is cleaned, to form a piece of information at various levels, and fed to top management. It helps in all sorts of analysis, and like statistical analysis. And it supports data visualization as well. which makes the analysis even more fruitful and easy. However, its drawback is, the set of variables cannot be more than 3. And that is where the software like Microsoft Power BI and tableau comes into the picture. And they support spreadsheets as well as various other formats.

5 0

3 years ago

Which of the following is not a SQL*Loader file?

MatroZZZ [7]

Answer:

D. Good file

Explanation:

SQL loader is responsible for loading data from files into the database. It needs the mandatory control file, bad file, log file and an optional discard file.

A. Bad file

This file shares its name with the data file and has .bad extension.

The bad file holds all the records which are rejected ( bad data ). If a bad file is not available, it is automatically created. The data is either rejected by the SQL loader or by Oracle itself. The rejected records are not placed in the data file and hence, have to be placed in the bad file.

It is mandatory to have a bad file for every data file.

B. Control file

This is a mandatory file. This is a text file needed by the SQL loader to perform the loading process.

It contains the information related to location of data, specifies the criteria for selecting data for insertion, location for inserting data, and the like.

C. Discard file

The discard file is created if the need arises. This is not a mandatory file to be present.

The data which is discarded and gets filtered out, is placed in the discard file.

The data is not inserted in the table because it does not matches the criteria for the data to be inserted.

This criteria is mentioned in the control file.

The data is discarded only due to the mismatch and not because it is rejected or is bad data.

E. Log file

This file is mandatory to the execution. In absence of log file, the loader does not proceeds with execution and gets terminated.

In the beginning of the execution, a log file must be created by the loader. This file contains all the information regarding the data loading and also the errors encountered during the loading process.

6 0

3 years ago