Question: Which of the following groups and summarizes data in a concise format of rows and columns?
Answer Choices: A. Pivot Table B. Filter C. Area Chart D. Slicer
Answer: A. Pivot Table
Question: Excel has a maximum on the number of rows/columns that can be held in a worksheet.
Answer Choices: A. True B. False
Answer: A. True
Question: Conditional formatting can be used to highlight duplicate values.
Answer Choices: A. True B. False
Answer: A. True
Question: How do you add a new worksheet into a workbook?
Answer Choices: A. Ctrl‑A B. Hit the plus at the bottom of the workbook C. Ctrl‑N D. Ctrl‑E
Answer: B. Hit the plus at the bottom of the workbook
Question: A delimiter is a character that separates the data field value.
Answer Choices: A. True B. False
Answer: A. True
Question: All versions of Excel function in the same way (all have the same procedures available).
Answer Choices: A. True B. False
Answer: B. False
Question: Freezing panes is a good way to hide portions of your data.
Answer Choices: A. True B. False
Answer: B. False
Question: Freezing panes is a good way to make sure that certain portions of your data are visible.
Answer Choices: A. True B. False
Answer: A. True
Question: Formulas using relative and absolute cell referencing typically yield the same results.
Answer Choices: A. True B. False
Answer: B. False
Question: Conditional formatting can be used to highlight duplicate values in Excel.
Answer Choices: A. True B. False
Answer: A. True