If you use the Move Chart dialog to move a chart to a new sheet, Excel creates a. worksheet with columns, rows, and cells chart sheet worksheet containing just the plot area worksheet using the name of the chart Database functions can be keyed or accessed through the Data command tab Database Function button Insert Function dialog box Arguments Help dialog box Another way to allow users to edit cells in a protected worksheet is to apply a to the cells. structure formula protection password If you intend to share a workbook and track changes, you should set workbook protection last never first after sharing In a protected Excel worksheet, users can edit data if the cell or cell ranges have been structured named locked unlocked You cannot apply protection after a workbook has been saved shared opened edited When the user enters data that violates a data validation rule, a message appears. stop warning \#VALUE \#DATA When you are finished entering a formula., you can click the button to the left of the formula bar or press the key of the same name. Enter Alt Ctrl Shift If you type a $ before a number, Excel automatically applies the number format. Comma Percent Comma [0] Currency If is enabled, you can move your mouse over each style in the Cell Styles gallery to see a preview of how that particular style would look applied to your worksheet. Formatting Mini toolbar Live Preview Page View