Question: There are functions designed to format and modify text.
Answer Choices: A. True B. False
Answer: A. True
Question: Which of the following is not a good choice to more easily view your data?
Answer Choices: A. Hiding columns B. Using the split‑screen option C. Deleting your data D. Freezing panes
Answer: C. Deleting your data
Question: Which of the following is not a valid Excel function?
Answer Choices: A. =average(1,2,3) B. =sum(1,2,3) C. =max(1+3) D. All answers are correct
Answer: D. All answers are correct (each listed formula is valid)
Question: Your worksheet contains a price in cell A5, and many formulas refer to that price. How would you refer to that price in the formulas?
Answer Choices: A. $A5 B. A$5 C. $A$5 D. A5
Answer: C. $A$5
Question: Entering =MIN(1,2,3,4) into Excel will return a value of 4.
Answer Choices: A. True B. False
Answer: B. False
Question: Which of the following would result in an increasing series?
Answer Choices: A. Excel only does decreasing series B. Drag the fill handle down C. Drag the fill handle left D. Drag the fill handle up
Answer: B. Drag the fill handle down
Question: What are the tabs located at the bottom left of an Excel file called?
Answer Choices: A. Worksheets B. Workbooks C. Databases D. All of the above
Answer: A. Worksheets
Question: Excel can sort by multiple variables at the same time.
Answer Choices: A. True B. False
Answer: A. True
Question: All highlighted data are formatted as a table in Excel.
Answer Choices: A. True B. False
Answer: B. False
Question: Excel function arguments have to be entered in a specific order.
Answer Choices: A. True B. False
Answer: A. True
Question: Why is it important to be proficient at graphing (charting) data?
Answer Choices: A. Charts are always pretty B. Charts are always impressive C. Charts can effectively express information to a wide audience D. All of the above
Answer: C. Charts can effectively express information to a wide audience
Question: What creates one big cell out of several selected cells?
Answer Choices: A. Highlighting cells B. Merging and centering cells C. Deleting cells D. Formatting cells
Answer: B. Merging and centering cells
Question: The ribbon contains grouped command buttons.
Answer Choices: A. True B. False
Answer: A. True
Question: What are some different ways to add more information (more than two variables) to a scatter chart?
Answer Choices: A. Use visually appealing color schemes B. Plots can only display two dimensions C. Create a three‑dimensional plot D. Create a four‑dimensional plot
Answer: C. Create a three‑dimensional plot
Question: Optional arguments inside an Excel function are denoted by what symbol?
Answer Choices: A. quotations B. () C. square brackets [] D. None of the above
Answer: C. square brackets []
Question: In Excel, the rows are typically referred to as a ______.
Answer Choices: A. records B. fields C. information D. knowledge
Answer: A. records
Question: COUNTIF and FIND can both be used to count the number of people in a given department.
Answer Choices: A. True B. False
Answer: A. True