Ml1 Final Exam Part1 Day1
10 Questions
| Total Attempts: 69
Each question is 4 points.
Questions and Answers
- 1.How do you format a cell for currency?
- A.
Format --> Font
- B.
Right click menu --> Clear Contents...
- C.
Right click menu --> Format Cell...
- D.
Tools--> Options
- 2.The following formula =D12*4%
- A.
Finds what is 4% of the the value in D12
- B.
Divides the value in cell D12 by 4
- C.
Multiplies the value in cell D12 by 4
- D.
Finds the value in cell D12 as 12 multiplied by 4
- 3.If A5 = 1, then the following formula =A5^2 + 2*A5 will produce?
- A.
0
- B.
3
- C.
5
- D.
4
- 4.2.45% as a decimal is
- A.
2.45
- B.
0.245
- C.
0.0245
- D.
24.5
- 5.The volume of a cube is s3. What would be an Excel formula to to find the volume of cube whose side value is placed in cell D3.
- A.
=B3*D3
- B.
=D3*3
- C.
=D3^3
- D.
=D3*D3
- 6.What function counts the average value of the items in a list?
- A.
AVERAGE
- B.
SUM
- C.
IF
- D.
MEDIAN
- 7.What function adds up the values in the highlighted cells?
- A.
Count
- B.
Sum
- C.
If
- D.
Average
- 8.What is the symbol for auto-sum?
- A.
∏
- B.
A
- C.
X
- D.
Σ
- 9.What is the keystroke to reveal all formulas?
- A.
Alt &
- B.
Ctrl x
- C.
Shift F7
- D.
Control ~
- 10.Which menu allows you to change the page orientation (Portrait/Landscape)?
- A.
Edit
- B.
Format
- C.
File
- D.
Tools
This final will cover Section 1, 2 and 3 and Unit 7.
Questions: 39 | Attempts: 165 | Last updated: Mar 18, 2022
-
Sample QuestionWhich word means "winner"?
ML1 Mid-Term Exam Part I (Fall-2010)
Questions: 10 | Attempts: 256 | Last updated: Mar 20, 2022
-
Sample QuestionThe keyboard command to undo a previous action is:
This is chapter 7 final study guide for biology
Questions: 10 | Attempts: 47 | Last updated: Mar 17, 2022
-
Sample QuestionWhich of the following are produced by reactions tha take place in the thylakoids and are consumed by reactions in the stroma?
Back to top