All categories

3 years ago

What are ways to enter formula in Excel? Check all that apply

Computers and Technology

2 answers:

Zinaida [17]3 years ago

8 0

Answer:

In excel there are a number of ways to enter the formula.

Here I am gonna explain you one that way which is simplest.

Explanation:

For e.g. You are applying the formula of Sum of all the possible values:

i) In first step, hover the cursor on a position which you wan to make the cell active.

ii) In second step, type the equal sign =, Then type SUM in capital letters.

iii) Now selection the range of the cell which you want to make sum.

iv) After selection, press the ENTER key to get answer.

Note: Don't forget to put small brackets in the range of cells.

alexdok [17]3 years ago

3 0

Select cell C2.
Type = (equal sign).
Select cell A2 in the worksheet by using the mouse or the keyboard. This action places the cell reference A2 in the formula in the cell. ...
Type * (Shift+8 on the top row of the keyboard).
Select cell B2 in the worksheet by using the mouse or the keyboard. ...
Press Enter.!!!!!

Hope it helps

You might be interested in

Use the __________ to measure small amount of liguid

o-na [289]

The volumetric flask is use to measure

8 0

3 years ago

Find the error in the following pseudocode. Module main () Call raiseToPower (2, 1.5) End Module Module raiseToPower (Real value

Nataliya [291]

Answer:

Call raiseToPower (2, 1.5) '

raiseToPower (Real value, Integer power)

Explanation:

To solve this, first organize the pseudo code,

1) main ()

2) Call raiseToPower (2, 1.5)

3) End Module

4) Module

5) raiseToPower (Real value, Integer power)

6) Declare Real result

7) Set result=value^power

8) Display result

9) End Module

The first three lines in pseudo code are representing the main module. While lines 4-9 shows the definition of module that is being called in main function.

If we look at the raiseToPower definition at line5, we can see that it is requiring any real value for the base number. However, for power, it defines only integers.

But, in the main function, 1.5 is placed as a power that is not an integer. Therefore, this is the error in pseudo code. It should be changed to any integer.

Alternatively, change the integer power to real power to avoid this error.

8 0

3 years ago

In python please:

Oksana_A [137]

Answer:

declare a list and loop through to get the total sales

Explanation:

input_string = input("Enter sales: ")

userList = input_string.split()

print("user list is ", userList)

print("Calculating total of the sales")

sum = 0

for num in userList:

sum += int(num)

print("Total sales= ", sum)

7 0

4 years ago

How to convert meters to centimeters in c programming

mote1985 [20]

Answer:

Input

Enter length in centimeter = 1000

Output

Length in meter = 10 m

Length in kilometer = 0.01 km

Explanation:

hope this helps

5 0

3 years ago

True or False

krek1111 [17]

True or False
1. Phishing is the act of sending multiple emails to multiple users in hope of having
2. Spoofing is the act of obtaining unauthorized access to data from a computer
network.
3. Extortion is the act of using the internet to threaten or damage someone's
reputation to extort money or anything else of value.
4. In late 2014, LimeWire was raided for the second time due to years of pirating
movies, music, games, books and other software.
5. Electronic harassment is also referred to as cyberbullying.
6. Non-delivery of service is the act of devising a scheme wherein a culprit posts an
item or service for sale over the internet, and once the transactions have been done, does not
give the item or service.
7. Encryption is the process of converting raw to data code.
8. In piracy, trackers are used to identify IP addresses currently sharing a pirated
file.
9. Wager Gambling is the act of betting on any sports event over the internet.
10. Most email services today have spam or bulk folder that automatically puts
these suspicious emails to that folder.

7 0

3 years ago