Final Exam - Introduction to Excel for Beginners (May 1 - May 22)

Test Summary

0 of 20 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 20 Questions answered correctly

Your time:

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

Current
Review
Answered
Correct
Incorrect

Question 1 of 20

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 20

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 20

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 20

4. Question
4. Look at the image below. What is the name of the little gray lines that appear in a spreadsheet?
- Columns
- Data
- Rows
- Gridlines
Correct

Incorrect
Question 5 of 20

5. Question
5. 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 6 of 20

6. Question
6. 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 7 of 20

7. Question
7. 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 8 of 20

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

Incorrect
Question 9 of 20

9. Question
9. TRUE or FALSE

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

Incorrect
Question 10 of 20

10. Question
10. TRUE or FALSE

You can can always use the Undo command after deleting a sheet.
- True
- False
Correct

Incorrect
Question 11 of 20

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

Incorrect
Question 12 of 20

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

Incorrect
Question 13 of 20

13. Question
13. TRUE OR FALSE

In Excel there is a command that allows you to quickly remove duplicate values.
- True
- False
Correct

Incorrect
Question 14 of 20

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

Incorrect
Question 15 of 20

15. Question
15. 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 16 of 20

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

Incorrect
Question 17 of 20

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

Incorrect
Question 18 of 20

18. Question
18. What is wrong with the following formula?

SUM(B2:B20)
- There is a colon inside the argument when it should be a colon instead
- You can't do a SUM formula with the given range
- The equal sign is missing
- A period is missing at the end of the formula
Correct

Incorrect
Question 19 of 20

19. Question
19. 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 20 of 20

20. Question
20. 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