TAMU ISTM 210 Exam 2 Excel Questions with 100% Correct Answers

TAMU ISTM 210 Exam 2 Excel Questions with 100% Correct Answers Pie chart - answercompare parts of a whole line chart - answercompare an item over time, shows trends in data column charts - answercompare different (or same) categories over time Stacked column charts - answercolumn chart but with columns broken into subcategories Date formatted as general - answerdate(left) time (right) allows for math on dates, fraction of days today( - answerinsert current date Now( - answerinsert current time Weekday( - answerday of the week weeknum( - answerweek of the year month( - answermonth of the year year( - answerwhat year hour( - answerpull out hour Minute( - answerpull out minute Seconds( - answerpull out seconds Text in excel - answertext for users excel is string of characters len( - answerhow many characters in a cell including all symbols and spaces Search( - answerfind words/ phrases or characters in cells left( - answer# characters starting from the left