38 .
Discuss how the ribbon in Excel differs from other Microsoft programs.
39 .
Discuss the differences between formulas and functions. Give an example of each.
40 .
What is the benefit of the AutoFill feature in Excel?
41 .
What is the common use of the Review tab? Explain.
42 .
Why would you choose to use the function PRODUCT instead of the “*” operator? Give examples.
43 .
What are the advantages of using the SUM function?
44 .
Describe in steps the way to access the border outlines.
45 .
Describe the purpose and process of freezing panes.
46 .
Why might a business use Sheets over Excel?
47 .
Why would you use cell formatting for designing tables?
48 .
How do you create a graph in Sheets?
49 .
Why would you use the currency, accounting, and financial cell formats? Explain each one.
50 .
Describe the process of making a sales line chart.
51 .
Why would you use functions instead of formulas? Explain.
52 .
What are some of the uses of the four mathematical functions SUM, MINUS, MULTIPLY, and DIVIDE?
53 .
Describe how you could use the following concepts to create a budget that analyzes your average daily spending: formatting, creating a chart, using functions.
54 .
Why would you use conditional formatting?
55 .
What is the main difference between freezing panes in Excel compared with Sheets?
56 .
Describe the steps of hiding and then unhiding a column.