Question: 3 worksheets minimum required 2 basic formulas in your worksheet using cell references with no errors. Example: = B 4 * C 4 , C
worksheets minimum required
basic formulas in your worksheet using cell references with no errors.
Example: BC CD
Adjust row height and column width so that all datatext can be seen.
Merge and Center the title of your business.
Use wrap text on 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 absolute andor mixed cell references with no errors.
Include of the following simple functions with no errors. SUM, AVERAGE, MEDIAN, MIN, MAX, COUNT, COUNTA, TODAY, NOW
Include of the following functions with no errors: IF VLOOKUP, PMT XLOOKUP, SUMPRODUCT
Include of the following functions with no errors: TEXTJOIN, CONCAT, LEFT, RIGHT, MID, LEN, PROPER, UPPER, LOWER
Include of the following functions with no errors: SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS, COUNTIF, COUNTIFS, IFS
Create 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 formulas in your table with no errors. These are different formulas from the above formulasfunctions listed above
Use a total row in your table with SUM, AVERAGE, MAX, MIN pick one
Sparklines
Freeze a row
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
