Excel 1A Critical Thinking Quiz
1. By giving a worksheet the title Third Quarter Sales for Fruit Spreads, what information would
the reader of the worksheet expect to see?
a. sales infomation during the summer months
b. sales information during the period July through September
c. sales information for a six-month period
2. When presenting financial information in a worksheet, why is it important to apply a double
border to a total in a column?
a. To convey to the reader that the calculations were performed on the numbers above
b. To convey to the reader that values are rounded up
c. To convey to the reader that the information is complete
3. Why is a chart a valuable method of representing data in a worksheet?
a. A chart is easier to fit on a worksheet than a table of numbers
b. Data in a chart is easier to understand than a table of numbers
c. Charts make the worksheet more attractive
4. The company president, Aaron Nwosu, requested a column chart showing monthly sales of
fruit spreads by category. What valuable business information does this chart convey to
Aaron that can be used in decision making?
a. A pattern of overall monthly sales
b. The sale of Jellies in August
c. Total sales for Preserves for September
5. In the column chart for Third Quarter Sales for Fruit Spreads, why would you use the
Switch/Row Column command?
a. To change the chart from a column chart to a bar chart
b. To analyze only sales of Spiced Chutneys
c. To change the comparative analysis of the data; for example, by month or by type of
product
6. Which month had the highest sales of Jams?
a. July
b. August
c. September
7. By looking only at the sparklines, which product had an overall upward trend in sales?
a. Jellies
, b. Jams
c. Preserves
8. Typically, what is the purpose of text values in a worksheet?
a. To provide information about number values in other worksheet cells
b. To identify the author of the worksheet
c. To identify the formulas in the worksheet
9. In this quarter, which month had the highest total product sales?
a. July
b. August
c. September
10. Why are sparklines valuable when analyzing workbook data?
a. Sparklines make a pattern more obvious
b. Sparklines add additional details about the data
c. Sparklines show the formulas used in the calculations
Excel 1B Critical Thinking Quiz
1. Which of the following calculations would require the use of an absolute cell reference?
a. Calculating the total cases of Taco Seasoning in stock
b. Calculating the percentage by which the total retail value of Ground Ginger makes up the
total for all products
c. Calculating the average monthly sales
2. What is the most efficient way to enter large amounts of numerical data into an Excel
worksheet?
a. Select the range of cells before entering the numbers
b. Select each cell, enter the number, and then select the Enter key
c. Format the cells before entering the data
3. The data in this worksheet is valid as of what date?
a. The end of the calendar year
b. The end of the first quarter
c. September 30
4. Which of the following best describes the data in this worksheet?
a. Quarterly sales report
, b. Warehouse expenses by month
c. Retail value of a specific product's inventory as of a specific date
5. How many production methods does The Easy Pantry use?
a. Three
b. Two
c. One
6. As of September 30, which product had the most cases in stock?
a. Taco Seasoning
b. Ground Ginger
c. Box Sea Salt
7. As of September 30, which product had the highest inventory valuation in terms of Total
Retail Value?
a. Box Sea Salt
b. Taco Seasoning
c. Granulated Garlic
8. Why is the range finder feature useful to verify Excel formulas?
a. Arithmetic operators display in red
b. Workbook cells included in the calculation are indicated by color and by adding a border
c. Formula errors are flagged
9. When calculating percentages, why is it valuable to increase the number of decimal places
when analyzing important financial information?
a. The data is highlighted in color
b. The data is rounded up
c. The data is more precise
10. Which product has the second lowest percent of total retail value?
a. Ground Ginger
b. Box Sea Salt
c. Ground Cinnamon
1. By giving a worksheet the title Third Quarter Sales for Fruit Spreads, what information would
the reader of the worksheet expect to see?
a. sales infomation during the summer months
b. sales information during the period July through September
c. sales information for a six-month period
2. When presenting financial information in a worksheet, why is it important to apply a double
border to a total in a column?
a. To convey to the reader that the calculations were performed on the numbers above
b. To convey to the reader that values are rounded up
c. To convey to the reader that the information is complete
3. Why is a chart a valuable method of representing data in a worksheet?
a. A chart is easier to fit on a worksheet than a table of numbers
b. Data in a chart is easier to understand than a table of numbers
c. Charts make the worksheet more attractive
4. The company president, Aaron Nwosu, requested a column chart showing monthly sales of
fruit spreads by category. What valuable business information does this chart convey to
Aaron that can be used in decision making?
a. A pattern of overall monthly sales
b. The sale of Jellies in August
c. Total sales for Preserves for September
5. In the column chart for Third Quarter Sales for Fruit Spreads, why would you use the
Switch/Row Column command?
a. To change the chart from a column chart to a bar chart
b. To analyze only sales of Spiced Chutneys
c. To change the comparative analysis of the data; for example, by month or by type of
product
6. Which month had the highest sales of Jams?
a. July
b. August
c. September
7. By looking only at the sparklines, which product had an overall upward trend in sales?
a. Jellies
, b. Jams
c. Preserves
8. Typically, what is the purpose of text values in a worksheet?
a. To provide information about number values in other worksheet cells
b. To identify the author of the worksheet
c. To identify the formulas in the worksheet
9. In this quarter, which month had the highest total product sales?
a. July
b. August
c. September
10. Why are sparklines valuable when analyzing workbook data?
a. Sparklines make a pattern more obvious
b. Sparklines add additional details about the data
c. Sparklines show the formulas used in the calculations
Excel 1B Critical Thinking Quiz
1. Which of the following calculations would require the use of an absolute cell reference?
a. Calculating the total cases of Taco Seasoning in stock
b. Calculating the percentage by which the total retail value of Ground Ginger makes up the
total for all products
c. Calculating the average monthly sales
2. What is the most efficient way to enter large amounts of numerical data into an Excel
worksheet?
a. Select the range of cells before entering the numbers
b. Select each cell, enter the number, and then select the Enter key
c. Format the cells before entering the data
3. The data in this worksheet is valid as of what date?
a. The end of the calendar year
b. The end of the first quarter
c. September 30
4. Which of the following best describes the data in this worksheet?
a. Quarterly sales report
, b. Warehouse expenses by month
c. Retail value of a specific product's inventory as of a specific date
5. How many production methods does The Easy Pantry use?
a. Three
b. Two
c. One
6. As of September 30, which product had the most cases in stock?
a. Taco Seasoning
b. Ground Ginger
c. Box Sea Salt
7. As of September 30, which product had the highest inventory valuation in terms of Total
Retail Value?
a. Box Sea Salt
b. Taco Seasoning
c. Granulated Garlic
8. Why is the range finder feature useful to verify Excel formulas?
a. Arithmetic operators display in red
b. Workbook cells included in the calculation are indicated by color and by adding a border
c. Formula errors are flagged
9. When calculating percentages, why is it valuable to increase the number of decimal places
when analyzing important financial information?
a. The data is highlighted in color
b. The data is rounded up
c. The data is more precise
10. Which product has the second lowest percent of total retail value?
a. Ground Ginger
b. Box Sea Salt
c. Ground Cinnamon
