Which formula contains a mixed cell reference?
B
Predefined formulas in Excel are called functions and can be accessed using the
Insert Function button.
True
Enter a formula in the selected cell that adds the values in cells B6:B12, do not type
individual cell references
=SUM(B6:B12)
Change the value in the selected cell to 3599, and press enter when you’re done
Specify the width of the selected column to be 40
On the home tab click the format arrow in the cell group and select column width
Select cell C3
Rename the current worksheet
Change the chart type of the selected chart to “Clustered Column”
Click Design tab and selected change chart type
Type a formula into the selected cell that will divide cell E14 by F2. F2 should be an
absolute reference. If necessary press ENTER when done
Absolute reference looks like: $F$2
=E14/$F$2
Edit the conditional formatting rule for the selected range so that the default
formatting is applied to values less that $100.00
Click Conditional formatting in the styles section (on home tab)
Select manage rules
Edit rule
Format the tab of the current worksheet to be the standard color yellow
Right click tab and select tab color
Using the order of precedence for arithmetic operators, these two formulas will
calculate the same result: =22/2*5 =22/(2*5).
False
Add primary major vertical gridlines to the selected chart
Select the plus button on the chart
Select gridlines arrow button
Select Primary Major Vertical
An absolute cell reference changes the cell references when the formula is copied to
a new location.
False
An Excel complex formula uses more than one arithmetic operator.
True
In this formula, =(A6*A8)+$D$1, cell references (A6*A8) are relative cell references.
