Question: 3 worksheets minimum required 2 basic formulas in your worksheet using cell references with no errors. Example: = B 4 * C 4 , C

3 worksheets minimum required
2 basic formulas in your worksheet using cell references with no errors.
Example: =B4*C4, C5/D5
Adjust row height and column width so that all data/text can be seen.
Merge and Center the title of your business.
Use wrap text on 2-word headings.
Use centering in the middle of a cell.
Apply number formats. (ex: Accounting or currency, percent, comma, decimal places)
Header and Footer. (Your name, sheet name, file name, date, time, file path)
Sheet tabs with names. Colors on the sheet tabs.
Landscape orientation.
Fit the worksheet to one page.
Set to print with gridlines.
Include 2 absolute and/or mixed cell references with no errors.
Include 5 of the following simple functions with no errors. SUM, AVERAGE, MEDIAN, MIN, MAX, COUNT, COUNTA, TODAY, NOW
Include 3 of the following functions with no errors: IF, VLOOKUP, PMT, XLOOKUP, SUMPRODUCT
Include 4 of the following functions with no errors: TEXTJOIN, CONCAT, LEFT, RIGHT, MID, LEN, PROPER, UPPER, LOWER
Include 3 of the following functions with no errors: SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS, COUNTIF, COUNTIFS, IFS
Create 2 of the following charts: Column, Bar, Line, or Pie. You can choose any other of your choice.
Have a chart on the same sheet as your data. Have another chart on a new chart sheet.
Add chart elements: Chart title, axis title, data labels, explode a pie slice, and legend.
Add a chart style and color.
Add a table.
Add a table name.
Add a table style.
Sort your table.
Filter your table.
Use 2 formulas in your table with no errors. (These are different formulas from the above formulas/functions listed above).
Use a total row in your table with SUM, AVERAGE, MAX, MIN (pick one)
Sparklines
Freeze a row
3 worksheets minimum required 2 basic formulas in

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!