TAMU ISTM 210 Exam 2 Excel with Verified Solutions

TAMU ISTM 210 Exam 2 Excel with Verified Solutions Pie chart compare parts of a whole line chart compare an item over time, shows trends in data column charts compare different (or same) categories over time Stacked column charts column chart but with columns broken into subcategories Date formatted as general date(left) time (right) allows for math on dates, fraction of days today( insert current date Now( insert current time Weekday( day of the week weeknum( week of the year month( month of the year year( what year hour( pull out hour Minute( pull out minute Seconds( pull out seconds Text in excel text for users excel is string of characters len( how many characters in a cell including all symbols and spaces Search( find words/ phrases or characters in cells left( # characters starting from the left right( # characters starting from right` mid( # characters between specified points upper( upper case everything lower( lower case everything