Final Exam – Microsoft Excel Beginner to Advanced (Apr 18- May 25)

Test Summary

0 of 31 Questions completed

Questions:

You have already completed the test before. Hence you can not start it again.

Test is loading…

You must sign in or sign up to start the test.

You must first complete the following:

Results

Test complete. Results are being recorded.

Results

0 of 31 Questions answered correctly

Your time:

You have reached 0 of 0 point(s), (0)

Current
Review
Answered
Correct
Incorrect

Question 1 of 31

1. Question
1. Where is the formula bar located in an Excel spreadsheet?
- Near the top of the spreadsheet
- At the bottom of a spreadsheet
- In the Home tab ribbon
- In the Data tab ribbon
Correct

Incorrect
Question 2 of 31

2. Question
2. Look at the image below. What is the name of the selected area?
- Tab
- Group
- Command
- Ribbon
Correct

Incorrect
Question 3 of 31

3. Question
3. What is the name of the cell selected in the image below?
- Cell H12
- Cell E3
- Cell D4
- Cell A3
Correct

Incorrect
Question 4 of 31

4. Question
4. Finish the sentence: To select a column, you must click on one of the _____ at the top of the sheet.
- numbers
- rows
- letters
- formula bars
Correct

Incorrect
Question 5 of 31

5. Question
5. What’s the difference between using the Cut command and using the Copy command?
- The Cut command allows you to paste, the Copy command does not allow you to paste
- The Cut command is used to remove cells or items and the Copy command allows you to bring them back to your sheet
- The Cut command allows you to move cells or columns while the Copy command allows you to duplicate cells or columns
- The Cut command and the Copy command can actually be used interchangeably
Correct

Incorrect
Question 6 of 31

6. Question
6. Why would you need to use the Format Painter?
- To copy the formatting from an area on your sheet and apply that formatting to another area on your sheet
- To color the background of your cells
- To use the "Paint" option in Excel
- To change how your sheet appears
Correct

Incorrect
Question 7 of 31

7. Question
7. Which of the following commands would you use to change the font color of your cells?
Correct

Incorrect
Question 8 of 31

8. Question
8. TRUE or FALSE

Once you hide a column, you won’t be able to unhide it.
- True
- False
Correct

Incorrect
Question 9 of 31

9. Question
9. Look at the table below. What is the name of the function inside the red circle?
- Filter
- Sort
- Search
- Group
Correct

Incorrect
Question 10 of 31

10. Question
10. What is one alternative to hiding columns or rows?
- Grouping
- Sorting
- Filtering
- Searching
Correct

Incorrect
Question 11 of 31

11. Question
11. Finish the sentence: You always start a formula with a _____.
- smile
- equal sign
- range
- name
Correct

Incorrect
Question 12 of 31

12. Question
12. Finish the sentence: When working with a table and formulas, always start with ______.
- an equal sign
- an AutoSUM formula
- the Auto-Fill handle
- the first entry at the top of the table
Correct

Incorrect
Question 13 of 31

13. Question
13. Which of the following is considered an Operator?
- C3
- Column D
- =SUM(D4:D5)
- +
Correct

Incorrect
Question 14 of 31

14. Question
14. Which of the following formulas uses a Constant?
- =SUM(D4:D17)
- =AVERAGE(D8,D9)
- =C14+C15
- =A4-100
Correct

Incorrect
Question 15 of 31

15. Question
15. Why would you want to use the Auto-Fill Handle?
- To copy and apply the formula from one cell to the rest of the table
- To replace the content of the cells in the rest of the table
- To create new formulas for every cell in the rest of the table
- To apply the formatting from one area of the sheet to the other
Correct

Incorrect
Question 16 of 31

16. Question
16. What is the difference between the COUNT formula and the COUNTA formula?
- The COUNT formula can count cells that are not empty, the COUNTA formula only counts cells with numbers
- The COUNTA formula can count cells that are not empty, the COUNT formula only counts cells with numbers
- The COUNT formula can count cells with letters and numbers; the COUNTA only counts cells with numbers
- They can both be used interchangeably at all times
Correct

Incorrect
Question 17 of 31

17. Question
17. What functionality allows you to include a dropdown option in your cells, such as the example provided below?
- IFERROR formula
- Data Validation
- Conditional Formatting
- Text to Columns
Correct

Incorrect
Question 18 of 31

18. Question
18. How many parts are included in the arguments for the LEFT and RIGHT formulas?
- 1
- 2
- 3
- 4
Correct

Incorrect
Question 19 of 31

19. Question
19. What does a CONCATENATE formula do?
- It helps you split the content of one cell into multiple cells
- It helps you find errors in formulas
- It helps you arrange your table in a certain way
- It helps combine the content of multiple cells into a single cell
Correct

Incorrect
Question 20 of 31

20. Question
20. True or False: One of the benefits of formatting your data as a Table is that you can create one formula and it will automatically be applied to the rest of the table without the need of an Autofill Handle.
- True
- False
Correct

Incorrect
Question 21 of 31

21. Question
21. True or False: There is a SUMIF formula and a SUMIFS formula.
- True
- False
Correct

Incorrect
Question 22 of 31

22. Question
22. Look at the picture below. Which column would you click on first to begin this formula: =AVERAGEIFS(
- Column A
- Column C
- Column E
- Column F
Correct

Incorrect
Question 23 of 31

23. Question
23. How many parts are included in the argument for an IFERROR formula?
- 1
- 2
- 3
- 4
Correct

Incorrect
Question 24 of 31

24. Question
True or False

24. A Pivot Table automatically updates data when there is a change in the original table source.
- True
- False
Correct

Incorrect
Question 25 of 31

25. Question
25. For best results in a Pivot Chart, how many fields should be included in the Row area?
- 1 or 2
- At least 3
- More than 5
- None
Correct

Incorrect
Question 26 of 31

26. Question
26. Which is the default table layout for Pivot Tables?
- Pivot Chart Layout
- Compact Form Layout
- Outline Form Layout
- Tabular Form Layout
Correct

Incorrect
Question 27 of 31

27. Question
27. Let’s assume you want to transfer the model numbers from a specific table to a table you’re currently working on. What would be the best formula to use?
- AND formula
- VLOOKUP formula
- YEARFRAC formula
- IF formula
Correct

Incorrect
Question 28 of 31

28. Question
28. How many parts does the argument of a VLOOKUP formula have?
- 1
- 2
- 3
- 4
Correct

Incorrect
Question 29 of 31

29. Question
True or False

29. The AND and OR formulas are considered logical formulas.
- True
- False
Correct

Incorrect
Question 30 of 31

30. Question
30. Which of the following statements is considered a condition, or logical statement in an IF formula?
- =IF(15+2,
- =IF(C2>H1,
- =IF(10,
- =IF(D:D,
Correct

Incorrect
Question 31 of 31

31. Question
31. What type of formula is an IF formula?
- A logical formula
- A text formula
- An AND or OR formula
- A Summary formula
Correct

Incorrect