Q1: Formatting code is
- a) $
- b) #
- c) @
- d) +
Q2: What is the format applied based on user criteria is called?
- a) auto formatting
- b) conditional formatting
- c) style
- d) theme
Q3: Which of the following has highest priority in operation?
- a) +
- b) /
- c) ( )
- d) *
Q4: Pivot chart shows
- a) summarized data
- b) latest data
- c) grouping
- d) all of the above
Q5: What happens when the cell containing the date is dragged downward?
- a) auto increment by day
- b) auto increment by month
- c) auto increment by year
- d) same date will be copied
