SC_EX16_2b_BryanMatamoros_Report_1 - Shelly Cashman Excel 2016 Module 2 SAM Project 1b Bryan Matamoros SUBMISSION#1 | SCORE IS 100 OUT OF 100 1 Lizzy is

SC_EX16_2b_BryanMatamoros_Report_1 - Shelly Cashman Excel...

• 6
• 83% (6) 5 out of 6 people found this document helpful

This preview shows page 1 - 2 out of 6 pages.

Shelly Cashman Excel 2016 Module 2: SAM Project 1b Bryan Matamoros GE ver. 5.42 1.5/5Change the workbook theme.2.5/5Change the width of a column.Change the row height.3.5/5Create a formula using a function.Copy a formula into a range.4.5/5Set the number format for a range of cells.5.5/5Change the fill color of a range.6. Apply a Top and Thick Bottom Border cell border to the range A8:E8.5/5Add a border to a range of cells.7.5/5Create a formula using a function.Copy a formula into a range.8.5/5Create a formula using a function.Copy a formula into a range.9.6/6Create a formula using a function.Copy a formula into a range.10.6/6Create a formula.Copy a formula into a range.11.6/6Apply a conditional formatting rule.12.6/6Change the orientation of a worksheet.Set the margins of a worksheet.13.6/6Add a header to the workbook.14. Set the range A1:E21 as the Print Area. 6/6 Set print area for a worksheet. 15. 6/6 Check spelling and grammar. 16.6/6Update a value in a cell.Use Flash Fill to fill a range of values.17.6/6Set the number format for a range of cells.18. Format the date value in cell B11 using the Short Date (e.g., 4/13/2016) number format.6/6 Set the number format for a cell. SUBMISSION #1 | SCORE IS: 100 OUT OF 100