Financial Modelling in Excel

Please provide your name

1. What is the way in which an entire dataset can be selected dynamically?

Ctrl Home Click and drag with mouse Double-click on cell Shift Ctrl Arrows Shift Right-click on cell

2. Which one of the following statements regarding filters is NOT true?

A filter can be used to display data that meets a certain criteria The shortcut to insert a filter is Ctrl Shift L Filters can only filter for numerical values, and not for text Filtered data can be copied, pasted, deleted or printed A filter can be used to sort data ascending or descending

3. What is the shortcut for formatting a dataset as a table?

Ctrl T Ctrl X Ctrl D Ctrl L Ctrl V

4. Which one of the following statements regarding data visualisation is NOT true?

Various charts can be inserted from the Insert menu for selected data Default colours on the charts cannot be edited when charts are formatted Excel allows the user to create a combo chart from the selected data When a chart is selected, the Chart Design and Format menus will appear The Quick Layout option allows the user to choose a pre-prepared chart layout

5. Which function calculates the sum of cells that meet a certain criteria?

COUNTIFS SUM SUMPRODUCT SUBTOTAL SUMIFS

6. What is the purpose of the AND function?

Tests if at least one of the logical tests in brackets are true, and returns true Tests if something is true, does something if true, or does something else if not true Counts the number of cells that meet a certain criteria Look for a value in the first column, and returns the value in the corresponding row Tests if all of the logical tests in brackets are true, and returns true

7. Which one of the following functions is NOT a lookup function?

ISTEXT XLOOKUP INDEX&MATCH VLOOKUP HLOOKUP

8. What is the purpose of data validation in a cell or cells?

To protect the entire workbook with a password to restrict changes to the workbook To save a workbook in a format which supports the running of macros To restrict what a user can enter into a cell, for example only choose a value from a list To take away all protection from a workbook, and allow a user to edit different ranges To set a worksheet up for array calculations

9. Which one of the following functions will give today’s date as output?

DATE TODAY DAY NETWORKDAYS MONTH

10. What is the purpose of the CLEAN function?

To remove all excess spaces from the text To replace existing text with new text within a cell To divide the selected data into columns To remove all non-printable characters from the text To test if the data in the cell is stored in a text format