NEW
Font size
WorksheetsExcel Revision
Total questions: 12
Worksheet time: 6mins
How will you correctly write a formula in cell C5 for year-to-date profits that you can drag across for the next four months?
Use =C2-C3
Use =B2-B3
Use =B4+C4
Use =C4+B5
You want to get the percentage increase in profits from January to February. If you use the formula shown below, what value will be returned?
10
29
0.33
0.5
The most effective way to add up five different cells in a row is to
type each cell location and type a plus sign in between each
use the SUM function
use the TOTAL function
click on each cell and type a plus sign in between each
Date entries are numbers and by default they
line up on the right side of the cell
are structured as day/month/year
include dashes
line up on the left side of the cell
You have received a worksheet from a coworker who told you there are a number of comments you need to review. How do you first know there are comments in the worksheet?
The cell is highlighted with a border.
Look at the Comments sheet.
The row or column will be highlighted.
There is a little triangle in the upper right-hand corner of the cell.
What is the basis of using formulas in Excel?
Formulas are usually based on functions.
Formulas are usually based on location.
Formulas are usually based on using an equal sign.
Formulas are usually based on equations.
Suppose a cell contains the formula =(E3*$H$2) * E3. The variable $H$2 is a(n) _____ reference.
bad
mixed
absolute
relative
Where can you find the command for Excel to calculate the MAX value into cell G2?
by selecting the AutoSum button (∑) at the top left of the ribbon
by selecting the Insert function (ꝭꭓ) at the top right of the ribbon
by right-clicking in cell G2 beneath Max in cell G1
by selecting the arrow under the AutoSum button (∑) at the top left of the ribbon
Pat wants to copy a formula into an adjacent cell. Which action should she take?
Right-click the mouse button.
Hold down the left mouse button on the fill handle and drag to the right.
Drag the fill handle and move to the right.
Right-click the mouse button.
What is the best formula for adding together five adjacent values in a column?
=Out()
=Total()
=ADD()
=Sum()
Which formula would you enter in cell J3 to derive a meaningful value?
=COUNTA(ALL)
`=COUNT(J2:J6)
=CountA(j2:j6)
=COUNT(A2:F13)
You want to keep columns A and B visible while you scroll through your other worksheet data. How will you do this?
Position the active cell as C1, go to Freeze Panes on the View tab of the ribbon, and then select Freeze Panes.
Position the active cell as B1, go to Freeze Panes on the View tab of the ribbon, and then select Freeze Top Row.
Position the active cell as B1, go to Freeze Panes on the View tab of the ribbon, and then select Freeze Panes.
