QUESTIONS AND CORRECT ANSWERS
GRADED A+
● line chart. Answer: compare an item over time, shows trends in data
● column charts. Answer: compare different (or same) categories over
time
● Stacked column charts. Answer: column chart but with columns
broken into subcategories
● Date formatted as general. Answer: date(left)
time (right)
allows for math on dates, fraction of days
● today(. Answer: insert current date
● Now(. Answer: insert current time
● Weekday(. Answer: day of the week
, ● weeknum(. Answer: week of the year
● month(. Answer: month of the year
● year(. Answer: what year
● hour(. Answer: pull out hour
● Minute(. Answer: pull out minute
● Seconds(. Answer: pull out seconds
● Text in excel. Answer: text for users
excel is string of characters
● len(. Answer: how many characters in a cell including all symbols and
spaces
● Search(. Answer: find words/ phrases or characters in cells
● left(. Answer: # characters starting from the left