Font size
WorksheetsCIW Week 4 (excel)
Total questions: 16
Worksheet time: 8mins
The intersection of a row and a column is called a ________
sum
formula
cell
chart
A group of cells is called a ________.
cell range
multi cell
cluster
chart
Where is the fill handle located?
On the right side of the Home tab on the Ribbon
At the beginning of any formula or function
In the bottom-right corner of the selected cell
In this image, why does the value in cell G1 look slightly different from the value in the formula bar?
It’s using the Currency number format
It’s using a formula
It’s using conditional formatting
they typed it different
You can click the tabs at the bottom of a workbook to switch between ________.
formulas
worksheets
workbook
Let’s say you’re trying to find your average grade. What’s wrong with the formula shown in the image?
It should have an equals sign (=) at the beginning
It should use the COUNT function instead
There is nothing wrong with the formula
True or False: You can view a formula by double-clicking the cell that contains the formula
true
false
Which of the following is an absolute cell reference?
A2
$A$2
A:2
A,2
Which of the formulas below are valid? Select all that apply.
=R2*D2
=5B+6B
A3+100
=F2+F3+F4-53
order of operation (IN ORDER)
parentheses, exponent, addition, multiplication
parentheses, exponent, Multi/div. Addition
parentheses, exponent, Multi/div. Addition, subtraction
True or False: Excel will always tell you if there is a problem with a formula you’ve created.
true
false
In this image, which formula could you use to subtract the inventory costs from the monthly budget?
=B2-B3
=SUM(B2:B3)
=B3-B2
In the order of operations, which of the following comes first?
Operations enclosed in parentheses
Operations involving large numbers
Exponential calculations
Multiplication
True or False: In Excel, the values 75 and 75% are equivalent.
ture
false
Suppose you want to copy a formula while keeping one of the cell references locked on the same cell. Which of the following would you use?
Relative reference
Absolute reference
PivotTable
ReferenceLock
Which function can find the highest value in a cell range?
top
min
max
highest
