Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.
Give this quiz to my class
Q 1/12
Score 0
Jennifer is calculating her GPA. If she uses "=(A1+A2+A3+A4)/4", this is an example of which type of entry?
30
values
labels
formulas
Q 2/12
Score 0
Sandra is creating a formula to subtract the values in cells B4 and C4. Which formula should she use?
30
=B4/C4
=B4-C4
=B4+C4
12 questions
Q.
Jennifer is calculating her GPA. If she uses "=(A1+A2+A3+A4)/4", this is an example of which type of entry?
1
30 sec
Q.
Sandra is creating a formula to subtract the values in cells B4 and C4. Which formula should she use?
2
30 sec
Q.
When copying values in Microsoft Excel, which feature automatically adjusts cell references for the new copy location?
3
30 sec
Q.
What do you call it when you reference cells in other sheets in a workbook formula using the sheet name as the reference rather than the cell address?
4
30 sec
Q.
Tyler created a monthly sales workbook that contains the formula =SUM(Sales). "Sales" is an example of a(n):
5
30 sec
Q.
How is a cell reference in a formula and its corresponding location in a worksheet identified?
6
30 sec
Q.
What type of formula cell reference instructs Microsoft Excel to keep the cell reference constant in the formula as it copies it to the destination area?
7
30 sec
Q.
Sandra is creating a formula to multiply the values in cells B4 and C4. Which formula should she use?
8
30 sec
Q.
Gabriel needs to create a formula that does not change when it is copied to cell B2. Which formula should he create?
9
30 sec
Q.
Tyler created a monthly sales workbook that contains the formula =(January!B3). "January" is an example of a(n):
10
30 sec
Q.
What method is the MOST EFFICIENT way to copy five separate formulas to adjacent cells simultaneously?
11
30 sec
Q.
Joshua created a budget workbook that contains the formula =(Summary!B3). "Summary" is an example of a(n):
