ITBA

• hyperlinks allow users to navigate freely towards the next part of you workbook
• 2 main ways on how to insert or add a hyperlink. true

  1. through the use of hyperlink function to insert link to your cell content.
  2. with the use of the link feature of excel.
• true

  link feature is available under the insert tab, under the links group.
• charts and graphs are visual representation of data, often times used for better understanding of the data in excel.
• True

  charts and graphs help you visualize your data in a way that creates maximum impact on your audience.
• True

  charts and graphs can be found under the insert tab, under the charts group.
• a dialog box will appear asking you the type of chart you want to apply or insert.
• PivotTable are the most essential features of excel, which allows you to extract significantly large, detailed data sets.
• true

  PivotTable is a powerful tool to calculate, summarize, and analyze data that lets you see comparison, patterns, and a trends in your data.
• concatenate joins several text string into one strings
• ampersand & may also used to join text strings together
• true

  spacing between quotation mark is important
• true

  LEFT, RIGHT, and MID are text extraction
• left returns the first character or characters in a text string or cell, based on the number of characters you specify.
• true

  if you don't corporate a character then the first character only remain
• right returns the last character or characters in a text string, based on the number of characters you specify.
• mid returns a specific number of character or characters from a text string, starting at the position you specify, based on the number of characters you specify.
• true

  len is a text function
• len returns the number of characters in a text string
• true

  LOWER, UPPER and PROPER are a text- formatting function
• lower converts all text string to lowercase format.
• upper convert text to uppercase
• proper capitalize the first letter in a text string and any other first letter in the text or words that follow. converts all other letters to lowercase letters.
• true

  rept is a text function
• rept repeats text a given number of times.
• true

  trim is a text function
• trim removes all spaces from text except for single spaces between words.
• true

  substitute is also a text string
• true

  substitute substitutes new text for old text in a text string.
• use substitute when you want to replace specific text in a text string. use replace when you want to replace any text that occurs in a specific location in a text string.
• true

  replace is a text function
• replace replaces part of a text string, based on the number of characters you specify, with a different text string.
• true

  value is a text function
• value converts a text string that represents a number to a number.
• true

  spaces are counted
• in substitute the instance number is a must because hahanapin yung pinakauna
• true find is a text function
• find locates one text string within a second text string or cell, and returns the number of the starting position of the first text string from the first character of the cell or second text string
• true

  find is a case-sensitive function
• true

  search is a text function