**Microsoft Excel 2013 Intermediate Course**

This Course Assessment will now enable you to review your learning so you can determine your knowledge and understanding of the following area: Microsoft Excel 2013 – Intermediate Course

You will be assessed on the following outcomes:

- Inserting Comments
- Workbook Views, Zoom and Freeze
- Printing; Headers, Footers and Margins
- Basic Formulas and Functions
- Cell References
- Finding Errors; New Excel Functions
- Multiple Workbooks and Windows; Comparing Workbooks
- Go to; Find and Replace Options
- Applying, Clearing and Managing Rules
- Chart Types
- Basic Formatting
- Selecting Data, Positioning and Printing Charts
- Saving Workbooks; PDF and CSV Formats
- Sorting
- Filtering
- Tables
- VLOOKUP
- Text Function
- Date and Time Functions
- Logical Functions
- Quick Analysis Tool
- Adding and Formatting Shapes, Picture, Clip Art, WordArt and SmartArt
- Protecting Worksheets

To effectively use this website to answer your alison questions with ease, checkout this short tutorial I put together to help you in the video below.https://www.youtube.com/watch?v=Dw2UxUpf7Ng

1. True or false – The VLOOKUP function in Excel 2013 always looks for the specified “lookup value” in the leftmost column of a table.

True

False

**Ans: True**

2. True or false – When inviting people to share an Excel 2013 workbook on SkyDrive the access options are “Can edit” and “Can view”.

True

False

**Ans: False**

3. True or false – In Excel 2013 a cell name can only be used in the worksheet in which it is defined.

True

False

**Ans: False**

4. True or false – In Excel 2013 a pie chart is used to show proportions of a whole.

True

False

**Ans: True**

5. Which of these is NOT one of the standard Text Filters in Excel 2013? Choose one.

Does Not Contain…

Contains…

Sounds Like…

Ends With…

**Ans: Sounds Like…**

6. I have a workbook open in Excel 2013. It has 4 worksheet tabs. If I select the 3rd tab and click the “New sheet” button, where will the new sheet appear? Choose one.

At the end of the sheets

To the left of the 3rd sheet

To the right of the 3rd sheet

At the start of the sheets

**Ans: To the left of the 3rd sheet**

7. Which of the following is NOT one of the options in the Excel 2013 Find and Replace dialog? Choose one.

Look in Text

Look in Comments

Look in Formulas

Look in Values

**Ans: Look in Text**

8. On which tab in Excel 2013 would you find the Charts group? Choose one.

Insert

Home

View

Data

**Ans: Insert**

9. Which of the following could be used to concatenate numbers to a string? Choose one.

Text Function

Logical Function

Date and Time Function

VLOOKUPText Function

**Ans: Text Function**

10. True or false – In Excel 2013 it is possible to move a worksheet to another open workbook but not to copy it there.

True

False

**Ans: False**

11. What are the different types of logical functions? Choose four.

EQUAL

XOR

OR

AND

NOT

**Ans: XOR, OR, AND, NOT**

12. How does Excel 2013 store dates? Choose one.

As the number of minutes since the Gregorian Calendar came into universal use

In the local long date format relative to January 1, 1900

As the number of days since January 1, 1900

As the number of seconds since June 14, 1864

**Ans: As the number of days since January 1, 1900**

13. Which of the following is NOT a Table Style Option in Excel 2013? Choose one.

Total Row

Header Row

Filter Button

Total Column

**Ans: Total Column**

14. True or false – For any selection of worksheet cells in Excel 2013 it is only possible to apply a single conditional formatting rule.

True

False

**Ans: False**

15. Which of these is a Format Style for a conditional formatting rule in Excel 2013? Choose one.

Graphic

Data Bar

Gauge

5-Color Scale

**Ans: Data Bar**

16. When using the IF logical function in Excel 2013 the first argument is the logical test to perform. Which of these is the second argument? Choose one.

A second (optional) logical test to perform.

The value of the function if the logical test is true.

The value of the function if the logical test is invalid.

The value of the function if the logical test is false.

**Ans: The value of the function if the logical test is true.**

17. True or false – If you specify when saving a workbook that a password is needed to modify the workbook in future, Excel 2013 will automatically recommend when users try to open the workbook subsequently that it is opened in Read-only mode.

True

False

**Ans: False**

18. When a chart is selected in Excel 2013 two additional tabs are available on the ribbon. These are the Chart Tools tabs. One is the Design tab. Which of these is the other one? Choose one.

Chart Data tab

Format tab

Layout tab

Content tab

**Ans: Format tab**

19. True or false – Filtering in Excel is used to sort information in a sequence.

True

False

**Ans: False**

20. True or false – By default in Excel 2013 all cells in a workbook are unlocked.

True

False

**Ans: False**

21. Which of the following is described as a mini toolbar used for the easy analysis of data? Choose one.

Trust Center

Quick Analysis Tool

Footer

Page Layout View

**Ans: Quick Analysis Tool**

22. You have automatic calculation turned off in Excel 2013. On which tab will you find the “Calculate Now” button? Choose one.

Insert

Data

Formulas

Home

**Ans: Formulas**

23. The contents of cell A2 in an Excel 2013 worksheet is 10. The contents of cell B2 is 5. If the formula in cell C2 is “=A2/B2-1” what is the value in C2? Choose one.

14

1

2.5

6

**Ans: 1**

24. True or false – Protected workbook stop other uses editing, deleting or moving data.

True

False

**Ans: True**

25. What are the three main options for viewing worksheets? Choose three.

Top Down View

Page Layout View

Page Break View

Normal View

**Ans: Page Layout View, Page Break View, Normal View**

***ADDITIONAL UPDATE (27/08/2022)**

26. True or false – The Sort dialog in Excel 2013 enables you to define a sort with 1 or more levels.

True

False

**Ans: True**

27. True or false – Performing a Find in Excel 2013 always applies to a single worksheet. If you need to search a whole workbook you need to repeat it for each worksheet.

True

False

**Ans: False**

28. True or false – In Excel 2013 it is not possible to put a border around a chart title.

True

False

**Ans: False**

29. The contents of cell A2 in an Excel 2013 worksheet is 10. The contents of cell B2 is 5. If the formula in cell C2 is “=A2/B2-1” what is the value in C2? Choose one.

6

2.5

14

1

**Ans: 1**

30. You have automatic calculation turned off in Excel 2013. On which tab will you find the “Calculate Now” button? Choose one.

Formulas

Insert

Data

Home

**Ans: Formulas**

31. Fill in the blank. The two tabs under Chart Tools are the design tab and the ________ tab.

**Ans: format**

32. When a chart is selected in Excel 2013 two additional tabs are available on the ribbon. These are the Chart Tools tabs. One is the Design tab. Which of these is the other one? Choose one.

Format tab

Layout tab

Content tab

Chart Data tab

**Ans: Format tab**

33. When a SmartArt object is selected on a worksheet in Excel 2013 two additional “SmartArt Tools” tabs are available on the ribbon. One of them is Design. Which of these is the other? Choose one.

Insert tab

Review tab

Format tab

Layout tab

**Ans: Format tab**

34. True or false – In Excel 2013 it is possible to define custom properties for a workbook.

True

False

**Ans: True**

35. I have a workbook open in Excel 2013. It has 4 worksheet tabs. If I select the 3rd tab and click the “New sheet” button, where will the new sheet appear? Choose one.

At the end of the sheets

At the start of the sheets

To the right of the 3rd sheet

To the left of the 3rd sheet

**Ans: To the left of the 3rd sheet**

***ADDITIONAL UPDATE (5/02/2023)**

36. Which of the following functions is used to provide a vertical lookup of data in a worksheet? Choose one.

LOOKUP

VLOOKUP

VERT

HLOOKUP

**Ans: VLOOKUP**

37. True or false – The Sort dialog in Excel 2013 enables you to define a sort with 1 or more levels.

True

False

**Ans: True**

38. True or false – In Excel 2013 it is possible to move a worksheet to another open workbook but not to copy it there.

False

True

**Ans: False**

39. True or false – Protected workbook stop other uses editing, deleting or moving data.

True

False

**Ans: True**

40. You have automatic calculation turned off in Excel 2013. On which tab will you find the “Calculate Now” button? Choose one.

Home

Formulas

Data

Insert

**Ans: Formulas**

41. True or false – When inviting people to share an Excel 2013 workbook on SkyDrive the access options are “Can edit” and “Can view”.

True

False

**Ans: False**

42. True or false – By default in Excel 2013 all cells in a workbook are unlocked.

True

False

**Ans: False**

43. True or false – In Excel 2013 it is not possible to put a border around a chart title.

True

False

**Ans: False**

44. When using the IF logical function in Excel 2013 the first argument is the logical test to perform. Which of these is the second argument? Choose one.

A second (optional) logical test to perform.

The value of the function if the logical test is true.

The value of the function if the logical test is invalid.

The value of the function if the logical test is false.

**Ans: The value of the function if the logical test is true.**

45. True or false – Filtering in Excel is used to sort information in a sequence.

True

False

**Ans: False**

46. When a SmartArt object is selected on a worksheet in Excel 2013 two additional “SmartArt Tools” tabs are available on the ribbon. One of them is Design. Which of these is the other? Choose one.

Layout tab

Format tab

Review tab

Insert tab

**Ans: Format tab**

47. True or false – In Excel 2013 a pie chart is used to show proportions of a whole.

True

False

**Ans: True**

48. The contents of cell A2 in an Excel 2013 worksheet is 10. The contents of cell B2 is 5. If the formula in cell C2 is “=A2/B2-1” what is the value in C2? Choose one.

2.5

14

1

6

**Ans: 1**

49. True or false – In Excel 2013 a cell name can only be used in the worksheet in which it is defined.

True

False

**Ans: False**

50. In Excel 2013 which of these is the standard file name extension for an Excel 97-2003 workbook? Choose one.

xltx

xlm

xlsx

xls

**Ans: xls**

51. True or false – The VLOOKUP function in Excel 2013 always looks for the specified “lookup value” in the leftmost column of a table.

True

False

**Ans: True**

52. True or false – When saving a workbook in PDF format in Excel 2013 it is necessary to save each worksheet as a separate PDF file.

True

False

**Ans: False**

53. When a chart is selected in Excel 2013 two additional tabs are available on the ribbon. These are the Chart Tools tabs. One is the Design tab. Which of these is the other one? Choose one.

Content tab

Layout tab

Format tab

Chart Data tab

**Ans: Format tab**