Quiz Summary
0 of 15 Questions completed
Questions:
Information
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading…
You must sign in or sign up to start the quiz.
You must first complete the following:
Results
Results
0 of 15 Questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 point(s), (0)
Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)
Categories
- Not categorized 0%
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- Current
- Review
- Answered
- Correct
- Incorrect
-
Question 1 of 15
1. Question
How to create a workbook by using an existing template? (sorting step by step)
-
If necessary, enter a search term in the Search for online templates box and press Enter.
-
Click the template you want to use.
-
Click New.
-
Click the File tab to display the Backstage view.
-
Click Create.
View Answers:
CorrectIncorrect -
-
Question 2 of 15
2. Question
How to insert a worksheet template into a workbook. (sorting step by step)
-
Click OK.
-
Right-click any sheet tab and, on the shortcut menu that appears, click Insert.
-
In the Insert dialog box, click the tab that contains the worksheet template you want to use.
-
Click the worksheet template.
View Answers:
CorrectIncorrect -
-
Question 3 of 15
3. Question
How to save a workbook as a template? (sorting step by step)
-
Create the workbook you want to save as a template.
-
Click Save.
-
In the Backstage view, click Save As.
-
Click the Save as type arrow, and then click Excel Template.
-
Click Browse.
-
In the File name box, enter a name for the template workbook.
View Answers:
CorrectIncorrect -
-
Question 4 of 15
4. Question
How to save a workbook as a macro-enabled template? (sorting step by step)
-
Click the Save as type arrow, and then click Excel Macro-Enabled Template.
-
In the Backstage view, click Save As.
-
Create the workbook you want to save as a macro-enabled template.
-
In the File name box, enter a name for the template workbook.
-
Click Save.
-
Click Browse.
View Answers:
CorrectIncorrect -
-
Question 5 of 15
5. Question
_______________ data from one workbook to another is a quick and easy way to gather related data in one place, but there is a substantial limitation.
CorrectIncorrect -
Question 6 of 15
6. Question
You can ensure that the data in the target cell reflects any changes in the original cell by _________ a link between the two cells.
CorrectIncorrect -
Question 7 of 15
7. Question
You can ____ to a cell in another workbook by starting to create your formula, displaying the worksheet that contains the value you want to use, and then selecting the cell or cell range you want to include in the calculation.
CorrectIncorrect -
Question 8 of 15
8. Question
When you press ______ and switch back to the workbook with the target cell, the value in the formula bar shows that Excel has filled in the formula with a reference to the cell you clicked.
CorrectIncorrect -
Question 9 of 15
9. Question
How to create a link to a cell or cell range on another worksheet? (sorting step by step)
-
Select the cell or cells to include in the formula.
-
Press Enter.
-
Start creating a formula that will include a value from a cell or cell range on another worksheet.
-
Click the sheet tab of the worksheet with the cell or cell range you want to include in the formula.
View Answers:
CorrectIncorrect -
-
Question 10 of 15
10. Question
How to create a link to a cell or cell range in another workbook? (sorting step by step)
-
Switch back to the original workbook and start creating a formula that will include a value from a cell or cell range in the other workbook.
-
Display the workbook that contains the cell or cell range you want to include in the formula.
-
Select the cell or cells to include in the formula.
-
Open the workbook where you want to create the formula that references an external cell or cell range.
-
Press Enter.
-
Open the workbook that contains the cell or cell range you want to include in your formula.
-
Click the sheet tab of the worksheet with the cell or cell range you want to include in the formula.
View Answers:
CorrectIncorrect -
-
Question 11 of 15
11. Question
How to create a link to cells in an Excel table? (sorting step by step)
-
Press Enter.
-
Start creating a formula that will include a value from cells in an Excel table.
-
Click the sheet tab of the worksheet with the Excel table that contains the cells you want to include in the formula.
-
Select the cell or cells to include in the formula.
View Answers:
CorrectIncorrect -
-
Question 12 of 15
12. Question
How to open the source of a linked value? (sorting step by step)
-
In the Edit Links dialog box, click the link you want to work with.
-
On the Data tab of the ribbon, in the Connections group, click the Edit Links button.
-
Click the Open Source button.
-
Open a workbook that contains a link to an external cell or cell range.
View Answers:
CorrectIncorrect -
-
Question 13 of 15
13. Question
How to fix a link that returns an error because it references the wrong workbook? (sorting step by step)
CorrectIncorrect -
Question 14 of 15
14. Question
How to break a link? (sorting step by step)
-
In the Edit Links dialog box, click the link you want to edit.
-
In a workbook that contains a link to a cell on another worksheet or in another workbook, click the Edit Links button.
-
Click the Break Link button. When prompted, click Break Links to confirm that you want to break the link.
-
Click Close.
View Answers:
CorrectIncorrect -
-
Question 15 of 15
15. Question
CorrectIncorrect