answersLogoWhite

0

📱

Microsoft Excel

Excel is a spreadsheet application developed and distributed by Microsoft Corporation for computers using the Microsoft Windows and Mac OS X operating systems. It features graphing tools, chart wizards, calculations, formatting options, and pivot tables.

9,788 Questions

In excel 2007 if cell A1 contains the number 12345 is there a formula to multiply the digits 1 x 2 x 3 x 4 x 5?

=VALUE(LEFT(A1,1))*VALUE(MID(A1,2,1))*VALUE(MID(A1,3,1))*VALUE(MID(A1,4,1))*VALUE(RIGHT(A1,1))

VALUE - Converts a string to an integer

LEFT - Starts from the left and selects 1 character

MID - Starts at the second position and selects 1 character

RIGHT - Starts from the right and slects 1 character

You also could use VALUE(MID(A1,1,1) for the first value and VALUE(MID(A1,5,1) for the last value.

Who is the father of the electronic spreadsheet?

Dan Bricklin and Bob Frankston jointly invented the first spreadsheet program, which was Visicalc. Normally Dan Bricklin is the one of them that is considered to be the father of the electronic spreadsheet.

Excel stores it's documents as files called?

They are spreadsheet files and Excel refers to them as workbooks.

Why is agoraphobia harder to treat?

Treating agoraphobia is more difficult than other phobias because there are often so many fears involved

What is the best way to be alert and focussed for an allnighter?

I have a high tolerance for caffeine, so personally I have to take extra measures. I can't say what is best for all or even most people. I drink a 5hr energy, approximately at midnight, with a good solid meal. This helps elongate and mitigate the effects of the drink, but you won't get drowsy from eating either. Now start your studies. When you're thirsty drink water, when you're not thirsty sip on a soda or coffee. I feel coffee keeps me more alert because of the warming effect. If you start to feel drained and ready to pass out, get some fresh air and walk around for 10 minutes or so. Around 7 you should have a hearty breakfast and simple sugars like orange juice.

If you used the Excel formula SUM(A2A4) what will be calculated?

The values in cells A2, A3 & A4 will be added together - and the result displayed in the cell that contains the 'sum' formula.

When do you use the PMT function in Excel?

The PMT function returns the payment amount for a loan based on an interest rate and a constant payment schedule.

The syntax for the PMT function is: PMT(interest_rate, number_payments, PV, FV, Type)

interest_rate = interest rate for the loan.

number_payments = number of payments for the loan.

PV = present value or principal of the loan.

FV (optional) = Future value or the loan amount outstanding after all payments have been made. If this parameter is omitted, the PMT function assumes a FV value of 0.

Type (optional) = Indicates when the payments are due. Type can be one of the following values:

-- 0 = Payments are due at the end of the period. (default)

-- 1 = Payments are due at the beginning of the period.

If the Type parameter is omitted, the PMT function assumes a Type value of 0.

EXAMPLE:

Find the monthly payment for a $6,400 loan at an annual rate of 8.25%. The loan is paid off in 2 years (ie: 2 x 12). All payments are made at the beginning of the period.

=PMT(8.25%/12, 2*12, 6400, 0, 1)

What is the purpose of filters in a database?

Filters in database reduce down the records you see, by finding ones that meet certain criteria. So if you had a list of people and their date of birth you could impose a filter to just show ones born after a certain date. If you had a list of companies and their profits or losses you could use a filter to show just the ones that made a profit. If you had a list of products you could show ones that were of a particular category. Filtering does not delete records, it just shows ones that meet certain criteria. The filters can be turned off so you see all the records again.

From where could one purchase an A2 jacket?

Flight Jacket is a website that lets you purchase flying clothes online. The A-2 jacket is currently available and is priced at $379 with a variety of sizes and three different shades of brown.

How do you differentiate the password to open from password to modify?

This question is not clear. You can set whatever passwords you like. Passwords to open documents and modify documents can be the same or different. You need to remember them to be able to use them.

What is a Ctrl key short cut used for?

The ctrl key is an abbreviation for the control key. it simply allows you to preform a ton of different operations that are recognized by windows as well as the applications. is allows for more flexibility as well

examples:

ctrl+c --> copy whatever is selected to the clipboard

ctrl+x --> copy and then delete selected

ctrl+v --> Paste the content in the clipboard

ctrl+a --> select all

ctrl+z --> undo

Is it true that Text is truncated when the cell that it resides in is not wide enough to display all of it in Excel?

This will only happen if there is something in the next cell. If the next cell is empty the text in the cell will seem to spill into it. If there is something in that cell, then you will only see text in the first cell up to the width of that cell. The full text is still contained within the cell, so it is not lost. To see it in full, you would widen out the column that the cell is in.

How do you use the worksheet function to fill the selected cell with Y if cell B4 is greater than cell B3 and N if cell B4 is less than cell B3?

Note that your question does not specify what happens if B4 is equal to B3, so the following assumes it is left blank:

=IF(B4>B3,"Y",IF(B4<B3,"N",""))

If Y is for greater or equal to:

=IF(B4>=B3,"Y","N")

If it is N for equal to and Y is only for greater than:

=IF(B4>B3,"Y","N")

How do you insert branula?

Firsly, choose the correct branula size for the patient.( normally we used pink colour of branula)

Requirement materials:

-IV giving set

-Drip stand

-IV Normal Saline 0.9 (depend on doctor order)

-Torniquet

-Normal saline with transox fix

-Alcohol swab (minimum 3)

-micropone and scissor

-kidney dish

-5cc syringe for flushing

-Tegaderm/hyperfix/elastic plaster

-disposable glove

-proctective sheet

-Clinical waste bag (yellow bag)

-Non clinical waste bag

Which function is used to randomize number in Excel?

There is a RAND function which can generate random numbers. The RANDBETWEEN function can generate numbers between a lower and upper limit.

There is a RAND function which can generate random numbers. The RANDBETWEEN function can generate numbers between a lower and upper limit.

There is a RAND function which can generate random numbers. The RANDBETWEEN function can generate numbers between a lower and upper limit.

There is a RAND function which can generate random numbers. The RANDBETWEEN function can generate numbers between a lower and upper limit.

There is a RAND function which can generate random numbers. The RANDBETWEEN function can generate numbers between a lower and upper limit.

There is a RAND function which can generate random numbers. The RANDBETWEEN function can generate numbers between a lower and upper limit.

There is a RAND function which can generate random numbers. The RANDBETWEEN function can generate numbers between a lower and upper limit.

There is a RAND function which can generate random numbers. The RANDBETWEEN function can generate numbers between a lower and upper limit.

There is a RAND function which can generate random numbers. The RANDBETWEEN function can generate numbers between a lower and upper limit.

There is a RAND function which can generate random numbers. The RANDBETWEEN function can generate numbers between a lower and upper limit.

There is a RAND function which can generate random numbers. The RANDBETWEEN function can generate numbers between a lower and upper limit.

What will be printed when you click the OK button Excel 2010?

Normally the whole set of data in the worksheet or the current chart sheet or the selected print area if one has been set.

What the formula plastic film gsm calculation?

PET : Thickness 12 mic X Pet Film density 1.4 = 16.80 GSMBOPP : Thickness 20 mic X BOPP Film Density 0.91 = 18.20 GSM

What are the disadvantages of mail merge?

The only one I can really think of is that it can be used a scam.

You send a letter to each person on a road with around 50 people on it. Each letter has their names,addresses and other information about them saying that if they pay £5 they can be entered in a draw when really your making lots of money for something which you'll never do.

What is the answers to the cells r us worksheet?

The Cella R Us worksheet answers can not be obtained online. Course books will have to be studies to locate the answers.