Question about Microsoft Excel for PC

1 Answer

Thank you! For some reason I was using a colon instead of the operand between the numbers. Thanks again.

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Hot-Shot:

    An expert who has answered 20 questions.

    Corporal:

    An expert that hasĀ over 10 points.

    Mayor:

    An expert whose answer gotĀ voted for 2 times.

  • Contributor
  • 56 Answers

Hello,

You can use a colon to find a function over a group of cells. For example "=AVERAGE(D1:D10)" would find the average of the values within cells D1 through D10.

Hope that Helps

Posted on Jun 11, 2008

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

How ifix a fatal error


Below is a listing of the more commonly experienced processor exceptions ranging from 00 to 0F.

00 = Divide Fault
Occurs if division by zero is attempted or if the result of the operation does not fit in the destination operand.

02=NMI interrupt
Interrupt 2 is reserved for the hardware Non-Maskable-Interrupt condition. No exceptions trap through interrupt 2.

04=Overflow trap
Occurs after an INTRO instruction has executed and the OF bit is set to 1.

05=Bounds Check fault
The array Index is out of range

06=Invalid Opcode fault
This error can be caused by one of the below conditions.

  1. Processor attempting to decode a bit pattern that does not correspond to any legal computer instruction.
  2. Processor attempts to execute an instruction that contains invalid operands.
  3. Processor attempts to execute a protected-mode instruction while running in virtual 8086 mode.
  4. Processor attempts to execute a LOCK prefix with an instruction that cannot be locked.

07=Copressor not available fault.
This error can occur if no math coprocessor is present. This error can also occur when the math coprocessor is used and a task switch is executed.

08=Double Fault.
This error occurs when processing an exception triggers a second exception.

09(OD)=Copressor Segment Overrun.
Floating point operand is outside the segment.

10(0Ah/0A)=Invalid Task State Segment Fault
Can be caused by a number of possibilities as Task State Segment contains a number of descriptors.

11(0Bh)=Not Present Fault
The Not Present interrupt allows the operating system to implement virtual memory through the segmentation mechanism. 0B fault occurs when this segment is not available.

12(0Ch)=Stack Fault
Occurs when instruction refers to memory beyond the limit of the stack segment.

13(Odh)=General Protection Fault
Caused by any condition that is not covered by any of the other processor exceptions. The exception indicates that this program has been corrupted in memory generally resulting in the immediate termination of the program.

14(Oeh)=Page Fault
Occurs when a paging protection rule is violated (when the retrieve fails, data retrieved is invalid or the code that issued the fault broke the protection rule for the processor).

16(10h)=Coprocessor error fault
Occurs when an unmasked floating-point exception has signaled a previous instruction.

17(11h)=Alignment Check Fault
Only used on 80486 computers. Caused when code executing at ring privilege 3 attempts to access a word operand that is not divisible by four, or a long real or temp real whose address is not divisible by eight.



Find out the reason of Fatal Error if that is due to Software related then go in safe mode and uninstall the software recently installed or udate them/patch them. or if the same is related to hardware then unplug the recently added hardware,


please vote



Aug 21, 2011 | Computers & Internet

2 Answers

What are the formulas in grading the grades uisng microsoft excel


Formulas are used to specify calculations based on values in designated cells. Excel supports basic calculations as well as statistical, trigonometric and other specialized functions.

Formulas used in Excel must follow a certain syntax.

  1. All formulas begin with an equals sign (=).
  2. Some formulas use operands such as +,-, *,/ for addition, subtraction, multiplication or division.
    For example, the formula =A1+A2+A3 would add the contents of cells A1, A2 and A3.
  3. Other formulas refer to different functions such as SUM, AVERAGE and others.
    For example, the formula =SUM(A1:A3) would add the contents for the range A1 through A3.
  4. Formulas can be combined with operands.
    For example, the formula =10*SUM(A1:A3) would add the contents cells A1 through A3 and multiply them by 10.
  5. Functions can be nested within each other.
    For example, the formula =SQRT(10*SUM(A1:A3)) would take the square root of ten times the sum of cells A1 through A3. When functions are nested, it is important that the number of left parentheses match the number of right parentheses.

Aug 19, 2011 | Microsoft EXCEL 2004 for Mac

1 Answer

The colon between the numbers on the clock, example 8:00 won't stop blinking even after I set the clock and hit the clock button again.


Sometimes the correct procedure for setting the clock is to press the CLOCK or TIME OF DAY button, then enter the time on the keyboard, then press the START button instead.

Otherwise, as long as you can enter a cooking time and your oven operates normally, then don't worry about it. On some models it is normal for the colon on the clock display to blink all the time.

Good luck.

May 11, 2011 | Microwave Ovens

1 Answer

Using the numbers 3,3,8,8, and the operations +,-,/,*, you have to bring the amswer as 24?


Hi there,

Since you did not specify having to use all four numbers and/or all four operands why not go with :

8 * 3 = 24

If you had specified the above, I would have to say it was copied wrong as there is one to many operands to use.

Example: 3+3-8/8 = 6 We still have the '*' left over. you would need five numbers to use four operands. You see? It doesn't quite mesh with the question.

Mike

And please don't rate this.

Jan 05, 2011 | Puzzle Massey Ferguson Tractor

1 Answer

Surface works but clock wont come on to reset oven. it is brand new


Hi and welcome to FixYa. I am Kelly. Since you did not include a model number the only remedy I foresee at the moment without voiding your warranty is to schedule a warranty service call. You can contact them at this number: 1-800-424-2047 Your clock should be working and this is a valid warranty complaint. There are several things I could ask you to do but at this point all of them would be cause for voiding your warranty due to attempted repairs by un-qualified technicians. The clock should reset to 12:00 each time there is a power loss. You can try turning off the main circuit breaker for 10 minutes and then turning it back on after pushing it hard to off first. If the clock does not at least have a colon in it or... flashes 12:00 you have a valid warranty complaint. If all you see is a flashing colon.. push CLOCK then set the time and push CLOCK again. This should set your clock. To ensure your warranty stays valid do NOT attempt to do anything else. Make the call for warranty service using the number above.

Thanks for choosing FixYa,

Kelly

Oct 16, 2010 | Kenmore Kitchen Ranges

1 Answer

For some reason, I can no longer type a colon. I can type a semi colon ;, but shifting does not give me a colon. Can you help?


Has it always been like this? or you noticed it recently? The thing is, sometimes the characters on the keyboard are not where they're mentioned. So check all the other keys while holding down the 'Shift'. I am sure you will find your 'colon' under a bracket or a number.

Oct 18, 2009 | Dell SK8110 Keyboard

1 Answer

Change day but not date on Timex Expedition


HI..
HERE IS STEPS FOR SETTING OF YOUR WATCH... STEP3 EXPLAINS THE SETTING OF DAY,DATE.....
  • Step 1 Push in the lower right button until you see the seconds flash. Press the upper right button to run the seconds display down to zero. Push the bottom left button to get into the mode to set the hours. Press the top right button to scroll through the numbers. Watch that you choose a.m. or p.m. correctly.
  • Step 2 Press the bottom left button to get into the mode to set the minutes. Again, push the top right button to scroll through the numbers until you reach the correct time.
  • Step 3 Repeat the process from Step 2 four times to set the month, date and day of the week and to change to military time if you wish. Push the bottom right button to save your settings. You'll notice the colon between the numbers will start to flash.
  • THANK YOU
  • Jul 28, 2009 | Timex Expedition Outdoor Athletics Watch...

    1 Answer

    Text Message Failure


    I simply uninstalled some Applications Softwares I downloaded from the internet. After which the problem was solved. I was able to send sms yet again. I later installed the Softwares I had uninstalled and my phone is back to normal.

    Mar 02, 2008 | HP iPAQ hw6515 Pocket PC

    Not finding what you are looking for?
    Microsoft Excel for PC Logo

    Related Topics:

    62 people viewed this question

    Ask a Question

    Usually answered in minutes!

    Top Microsoft Computers & Internet Experts

    micky dee

    Level 3 Expert

    2642 Answers

    Les Dickinson
    Les Dickinson

    Level 3 Expert

    18357 Answers

    Brian Sullivan
    Brian Sullivan

    Level 3 Expert

    27725 Answers

    Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

    Answer questions

    Manuals & User Guides

    Loading...