Microsoft Excel 2013 Intermediate Course – Course Assessment Answers

Posted on by

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