KKCOMPUTERINFO

  kkcomputerinfo scan

  TIPS TO INSERT A SERIAL NUMBER IN AN EXCEL SHEET USING A COMAND AND TRICKS             To insert a serial number (SL NO) in an Excel sheet using a command, you can use a simple formula. Here’s how you can do it: Open Excel and navigate to the cell where you want to start your serial numbers (e.g., A1).   Enter the Formula : In cell A1, type 1 to start the numbering. In cell A2, type the formula =A1 + 1 . This will add 1 to the value above.   AutoFill the Series : Click on the small square at the bottom-right corner of cell A2 (the fill handle). Drag it down to fill the cells below with sequential numbers as you desired. 1       =A1+1                 TRICKS   TO INSERT...

  Here are some tips for using Excel formulas: All formulas start with an equal sign (=) To refer to a cell, enter the column letter followed by the row number. For example, B2 refers to the cell at the intersection of column B and row 2.           The formula bar shows the formula you enter in a cell. You can see it whenever that cell is selected. Here are some basic Excel formulas you can use for common tasks: 1. SUM Adds a range of numbers. =SUM(A1:A10) 2. AVERAGE Calculates the average of a range of numbers. =AVERAGE(B1:B10) 3. COUNT Counts the number of cells that contain numbers. =COUNT(C1:C10) 4. MAX Finds the maximum value in a range. =MAX(D1:D10) 5. MIN Finds the minimum value in a range. =MIN(E1:E10) 6. IF Performs a logical test and returns one value for TRUE and another for FALSE. =IF(F1 > 10, "Yes", "No") 7. CONCATENATE (or &) Joins two or more strings together. =CONCATENATE(G1, " ", H1) =G1 & " " & H1 8...

  ·       Some important tips to learn Power Point ·        Steps: To open M.S. Power Point click on start click on program Click on MS Power Point   ·        Steps: If you want to insert a slide (To insert a slide) Roll up the Insert menu and choose the New Slide option Choose the Auto Layout option ·       Steps: To insert date and time Select the insert menu Select the date and time option Then click on the style you like   ·       Steps: Slide Show (To show the slide) Select live menu Select Slide Show or press F5 go to slide sorter Add slide transitions to slides Click on a preset animation that will affect the written text   ·          Steps: To change the colour, layout, background and design temperate of slide Select the format menu choose a slide layout choose background choose slide co...

kkcomputerinfo.blogspot.com      Some important tips to learn Windows by KKCOMPUTERinfo   Steps:                  To Set the Background of the Desktop Right click the mouse on an empty space on the desktop ·         Select the property and click on it ·        Click on the type of background you want .     Click on the Apply button .      Click the OK button Steps: To Specify a Text in Screen Saver ·         Select 3-D text from the screen saver ·         Click on Settings button ·         Display and decorate your text with the different types of keys provided   ·        Steps: To change ICONS/Background scheme ·         Right click on an empty space of the Desktop. ·         Select the pro...