ICT Tutorials
  • HOME
  • INTRO & WINDOWS
    • INTRODUCTION >
      • FUNDAMENTAL OF IT
      • TYPE OF COMPUTER DEVICES
      • COMPUTER GENERATION
      • SYSTEM COMPUTER
      • TYPE OF COMPUTERS
      • NUMBERING SYSTEM
      • TYPE OF MOUSE
      • KEYBOARD
      • DATA PROCESSING
      • OPERATING SYSTEM
      • HISTORY OF COMPUTER
    • MS WINDOWS >
      • ABOUT MS WINDOWS
      • WINDOWS DESKTOP
      • Win Control Activation
  • MS OFFICE
    • ABOUT MS-OFFICE
    • MS WORD >
      • INTRO TO MS-WORD
      • FILE >
        • INFO, NEW, OPEN
        • SAVE AND SAVE AS, PRINT
        • SHARE, EXPORT, CLOSE
      • HOME >
        • CUT, COPY, PASTE, FORMAT PAI
        • FONT
        • STYLES
        • FIND, GO TO, REPLACE
      • INSERT >
        • PAGES -COVER, BLANK, BREAK
        • TABLES
        • ILLUSTRATIONS >
          • PICTURES, ONLINE PICTURE
          • SHAPES, ICONS, 3D MODELS
          • SmartArt
          • CHART, SCREENSHOT
        • LINK, BOOKMARK, CROSS-REF
        • COMMENT, HEADER/FOOTER
        • TEXTS >
          • TEXT BOX, WORDART, DROP CAP, OBJECT
        • SYMBOL
      • DRAW >
        • PENS
      • DESIGN >
        • DOC STYLES, WATERMARK
        • PHARAGRAPH
        • PAGE COLOR, BORDERS
      • LAYOUT >
        • PAGE SETUP, SPACING
        • ARRANGE OBJECTS
      • REFERENCES >
        • TABLE OF CONTENTS
      • MAILINGS >
        • ENVELOPES
      • REVIEW >
        • DOC REVIEWS
      • VIEW >
        • WEB LAYOUT, NEW WIN, SPLIT
        • SWITCH WINDOWS, MACROS
    • MS EXCEL >
      • INTRO TO MS-EXCEL
      • FILE >
        • INFO, NEW, OPEN
        • SAVE/SAVE AS, PRINT
        • SHARE, EXPORT
      • HOME >
        • ALIGNMENT >
          • CELL ALIGN, ORIENTATION
          • INDENTS, MERGE & CENTER
        • NUMBER, COND FORMAT
        • TABLE, INSERT, DELETE
        • FORMAT >
          • ROW HEIGHT, COLUMN WIDTH
          • HIDE, RENAME, MOVE OR COPY
        • PROTECT SHEET, FILL
        • SORT & FILTER, AUTOSUM
      • FORMULAS >
        • INTRO TO FORMULAS
        • MATH & TRIM >
          • ABS( ), COMBIN( )
          • SUM FUNCTIONS( )
          • COS( ), SIN( )
          • BASE( )
        • STATISTICAL >
          • AVERAGE FUNCTIONS( )
          • MAX FUNCTIONS( )
          • MIN FUNCTIONS( )
          • COUNT FUNCTIONS( )
          • MODE FUNCTIONS( )
        • ENGINEERING >
          • BIN2DEC
          • CONVERT
        • TEXT FUNCTIONS >
          • LEFT( ) RIGHT( ) MID( )
          • FIND( ) LEN( ) PROPER( )
          • TRIM( ) EXACT( ) FIXED( )
          • REPLACE, UNICHAR, UNICODE
          • CODE( ) CHAR( ) REPT( )
        • DATE & TIME FUNCTIONS >
          • TODAY( ) YEAR( ) DAYS( )
        • LOGICAL >
          • IF( ), IFERROR( )
          • IFS( ), SWITCH( )
          • AND( ), OR( )
          • IFNA( ), XOR( )
      • INSERT >
        • CHARTS, SPARKLINES
      • PAGE LAYOUT >
        • PRINT TITLES, SHEET OPTION
      • DATA >
        • GET DATA, DATA VALIDATION
        • CONSOLIDATE
      • VIEW >
        • WORKBOOK VIEWS
      • Excel Functions Exercises >
        • Exercises 1 and 2
        • Exercises 3 and 4
    • MS POWER POINT >
      • INTRO TO MS-POWERPOINT
      • FILE >
        • INFO, NEW, OPEN
        • SAVE AND SAVE AS, PRINT
        • SHARE, EXPORT, CLOSE
      • HOME >
        • NEW SLIDE, STYLES, FILL
      • INSERT >
        • PHOTO ALBUM, VIDEO, AUDIO
        • SCREEN REC, SHOT, SLIDE NUM
      • DESIGN >
        • THEMES, SLIDESIZE, FORMAT
      • TRANSITION >
        • TRANSITION, SOUND
    • MS ACCESS >
      • INTRO TO MS-ACCESS
      • FILE >
        • HOME, NEW, OPEN
    • OFFICE QUESTION & ANSWER
  • VISUAL STUDIO
    • VISUAL BASIC .NET >
      • INTRODUCTION
      • .NET FRAMEWORK
      • OPERATORS IN VB.NET
      • DATAYPES IN VB.NET
      • VB.NET KEYWORDS
      • VARIABLE AND CONST
      • INTRO TO VB.NET PLATFORM
      • INTRO TO PROGRAMMING
      • OBJECTS USAGE IN WIN-FORM
    • Python >
      • Introduction
    • C++
  • GOOGLE TIPS
    • GMAIL ACCOUNT >
      • Email Forwarding
      • Setting up Authenticator App
      • SIGNATURE SET UP
    • GOOGLE WORKSPACE
  • INVENTS
    • NEW INVENTS
  • ABOUT ME

COS, SIN FUNCTIONS

28/12/2017

0 Comments

 
COS function
I have given the formula syntax and usage of the COS function in Microsoft Excel.
 
Description
Returns the cosine of the given angle.
 
Syntax
COS(number)
 
The COS function syntax has the following arguments:
Number    Required. The angle in radians for which you want the cosine.

Remark
If the angle is in degrees, either multiply the angle by PI()/180 or use the RADIANS function to convert the angle to radians.

Q:
How to find the cosine values of 60 degrees?
Type the function as follows in the cell that you would like to get the result in:
=COS(60*PI()/180)

For more understanding, look at the screenshot please:

Picture

SIN function

I have given the formula syntax and usage of the SIN function in Microsoft Excel.
 
Description
Returns the sine of the given angle.
 
Syntax
SIN(number)
 
The SIN function syntax has the following arguments:
Number    Required. The angle in radians for which you want the sine.
 
Remark
If your argument is in degrees, multiply it by PI()/180 or use the RADIANS function to convert it to radians.
 
Q:
How to find the sine of 30 degrees?
Type the function as follows in the cell that you would like to get the result in:
=SIN(30*PI()/180)
 
For more understanding, look at the screenshot please:

Picture
0 Comments

    Archives

    December 2017

    RSS Feed

​WELCOME TO WWW.COMTEACHERS.COM and We Would Love To Have You Visit Next Time Too! FOR MOBILE USERS, TO READ THE NOTES PLEASE CLICK MENU ICON, IT SHOULD BE EITHER ON TOP LEFT OR RIGHT CORNER OF YOUR SCREEN AND THEN CLICK MENU BY MENU TO CONTINUE READINGS...
  • HOME
  • INTRO & WINDOWS
    • INTRODUCTION >
      • FUNDAMENTAL OF IT
      • TYPE OF COMPUTER DEVICES
      • COMPUTER GENERATION
      • SYSTEM COMPUTER
      • TYPE OF COMPUTERS
      • NUMBERING SYSTEM
      • TYPE OF MOUSE
      • KEYBOARD
      • DATA PROCESSING
      • OPERATING SYSTEM
      • HISTORY OF COMPUTER
    • MS WINDOWS >
      • ABOUT MS WINDOWS
      • WINDOWS DESKTOP
      • Win Control Activation
  • MS OFFICE
    • ABOUT MS-OFFICE
    • MS WORD >
      • INTRO TO MS-WORD
      • FILE >
        • INFO, NEW, OPEN
        • SAVE AND SAVE AS, PRINT
        • SHARE, EXPORT, CLOSE
      • HOME >
        • CUT, COPY, PASTE, FORMAT PAI
        • FONT
        • STYLES
        • FIND, GO TO, REPLACE
      • INSERT >
        • PAGES -COVER, BLANK, BREAK
        • TABLES
        • ILLUSTRATIONS >
          • PICTURES, ONLINE PICTURE
          • SHAPES, ICONS, 3D MODELS
          • SmartArt
          • CHART, SCREENSHOT
        • LINK, BOOKMARK, CROSS-REF
        • COMMENT, HEADER/FOOTER
        • TEXTS >
          • TEXT BOX, WORDART, DROP CAP, OBJECT
        • SYMBOL
      • DRAW >
        • PENS
      • DESIGN >
        • DOC STYLES, WATERMARK
        • PHARAGRAPH
        • PAGE COLOR, BORDERS
      • LAYOUT >
        • PAGE SETUP, SPACING
        • ARRANGE OBJECTS
      • REFERENCES >
        • TABLE OF CONTENTS
      • MAILINGS >
        • ENVELOPES
      • REVIEW >
        • DOC REVIEWS
      • VIEW >
        • WEB LAYOUT, NEW WIN, SPLIT
        • SWITCH WINDOWS, MACROS
    • MS EXCEL >
      • INTRO TO MS-EXCEL
      • FILE >
        • INFO, NEW, OPEN
        • SAVE/SAVE AS, PRINT
        • SHARE, EXPORT
      • HOME >
        • ALIGNMENT >
          • CELL ALIGN, ORIENTATION
          • INDENTS, MERGE & CENTER
        • NUMBER, COND FORMAT
        • TABLE, INSERT, DELETE
        • FORMAT >
          • ROW HEIGHT, COLUMN WIDTH
          • HIDE, RENAME, MOVE OR COPY
        • PROTECT SHEET, FILL
        • SORT & FILTER, AUTOSUM
      • FORMULAS >
        • INTRO TO FORMULAS
        • MATH & TRIM >
          • ABS( ), COMBIN( )
          • SUM FUNCTIONS( )
          • COS( ), SIN( )
          • BASE( )
        • STATISTICAL >
          • AVERAGE FUNCTIONS( )
          • MAX FUNCTIONS( )
          • MIN FUNCTIONS( )
          • COUNT FUNCTIONS( )
          • MODE FUNCTIONS( )
        • ENGINEERING >
          • BIN2DEC
          • CONVERT
        • TEXT FUNCTIONS >
          • LEFT( ) RIGHT( ) MID( )
          • FIND( ) LEN( ) PROPER( )
          • TRIM( ) EXACT( ) FIXED( )
          • REPLACE, UNICHAR, UNICODE
          • CODE( ) CHAR( ) REPT( )
        • DATE & TIME FUNCTIONS >
          • TODAY( ) YEAR( ) DAYS( )
        • LOGICAL >
          • IF( ), IFERROR( )
          • IFS( ), SWITCH( )
          • AND( ), OR( )
          • IFNA( ), XOR( )
      • INSERT >
        • CHARTS, SPARKLINES
      • PAGE LAYOUT >
        • PRINT TITLES, SHEET OPTION
      • DATA >
        • GET DATA, DATA VALIDATION
        • CONSOLIDATE
      • VIEW >
        • WORKBOOK VIEWS
      • Excel Functions Exercises >
        • Exercises 1 and 2
        • Exercises 3 and 4
    • MS POWER POINT >
      • INTRO TO MS-POWERPOINT
      • FILE >
        • INFO, NEW, OPEN
        • SAVE AND SAVE AS, PRINT
        • SHARE, EXPORT, CLOSE
      • HOME >
        • NEW SLIDE, STYLES, FILL
      • INSERT >
        • PHOTO ALBUM, VIDEO, AUDIO
        • SCREEN REC, SHOT, SLIDE NUM
      • DESIGN >
        • THEMES, SLIDESIZE, FORMAT
      • TRANSITION >
        • TRANSITION, SOUND
    • MS ACCESS >
      • INTRO TO MS-ACCESS
      • FILE >
        • HOME, NEW, OPEN
    • OFFICE QUESTION & ANSWER
  • VISUAL STUDIO
    • VISUAL BASIC .NET >
      • INTRODUCTION
      • .NET FRAMEWORK
      • OPERATORS IN VB.NET
      • DATAYPES IN VB.NET
      • VB.NET KEYWORDS
      • VARIABLE AND CONST
      • INTRO TO VB.NET PLATFORM
      • INTRO TO PROGRAMMING
      • OBJECTS USAGE IN WIN-FORM
    • Python >
      • Introduction
    • C++
  • GOOGLE TIPS
    • GMAIL ACCOUNT >
      • Email Forwarding
      • Setting up Authenticator App
      • SIGNATURE SET UP
    • GOOGLE WORKSPACE
  • INVENTS
    • NEW INVENTS
  • ABOUT ME