Exploring Excel

Please provide your name

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

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

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

Filters can only filter for numerical values, and not for text A filter can be used to display data that meets a certain criteria The shortcut to insert a filter is Ctrl Shift L 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 X Ctrl D Ctrl L Ctrl T 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 Excel allows the user to create a combo chart from the selected data Default colours on the charts cannot be edited when charts are formatted 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 all of the logical tests in brackets are true, and returns true 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

7. Which one of the following functions tests if something is formatted as text?

XLOOKUP LEFT CONCAT VALUE ISTEXT

8. What is the purpose of the text-to-columns tool in Excel?

To change values in a cell within a maximum and minimum value To separate data in one column into multiple columns To save a workbook in a format which cannot be edited To allow data in columns to be visually displayed in charts To set a worksheet with large data tables up for calculations

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

DATE DAY NETWORKDAYS TODAY MONTH

10. What is the purpose of Spin Buttons?

To create a link to easily navigate to files or web pages To protect the sheet against unauthorised changes To change a value within set parameters in a linked cell To divide the selected data into columns To show a trend over time in a series of values