1. How do you apply an AutoFilter?
1. Data > Sort & Filter > Filter 2. Orb > Filter 3. Formula > Sort & Filter > Filter 4. None of the above
2. Which of the following are the correct characteristic groups for a good spreadsheet design?
1. Column text, dark background, none required information shown 2. Clear entries, clear fonts, columns/rows labelled 3. Fonts clouded, clear entries, not understandable 4. Important headings highlighted, clear entries, columns/rows not labelled
3. You would use conditional formatting to?
1. Make selected cells standout if they meet a condition 2. Make your spreadsheet look pretty 3. Highlight errors in formulas and formatting 4. Make your spreadsheet entries all look the same
4. What would you use the Scenario Manager for?
1. Mocking up Scenarios based on changes to inputs 2. Managing how cells with formulas interact with each other 3. Changing the way data within your spreadsheet is filtered 4. None of the above
5. Conditional formulas allow you to?
1. Interpret the data in your spreadsheet 2. Perform calculations and display the results in another cell or cells 3. Apply more than one condition 4. More than one of the above
6. What features/options are stated to be used within the spreadsheet to make sure that specific areas of information are assigned to the correct headings?
1. Dark fill and dark text 2. Merge and centre 3. Graphs and shapes 4. Fill and border options
7. When using a colour sort what happens?
1. Excel will sort all rows based on the visual spectrum 2. Excel will group all selected colours together while leaving the rest of the rows stay in their relative order 3. Excel will hide all other rows which don't have the selected colour 4. None of the above
8. How could you generate more accurate and beneficial information from your spreadsheet?
1. By changing the formulas in the spreadsheet you have constructed 2. By deleting the data you feel is not necessary to the outputs of your spreadsheet 3. By adding extra data that can be utilised in the form of additional tables 4. More than one of the above
9. Conditional formatting can change?
1. Cell background colour 2. Text decoration 3. Text colour 4. All of the above
10. How could you change the outputs of your spreadsheet without using the Scenario Manager?
1. By deleting the inputs you used initially 2. By changing the formulas that have been used in the spreadsheet 3. By changing the input values of the spreadsheet temporarily 4. All of the above
11. If a spreadsheet held student names and their favourite sports, when defining a new name, what would be a suitable and correctly formatted name?
1. David, Stevens, favSport, football 2. Stevens, David, football, favSport 3. David_Stevens_favSport_Football 4. David_favSport, Football
12. How could you generate a summary of data that has been produced by constructing a Scenario?
1. By using the summary function available through the Scenario Manager 2. By printing the data that you have held within the spreadsheet 3. By constructing another table that can break down the information you need to show 4. None of the above
13. Which of the following advantages does Advanced Filtering have over the AutoFilter?
1. Can perform an OR filter over multiple fields 2. It can perform a colour sort 3. It's quicker to set up 4. It is easier to understand
14. What would you need to click on to define a name to a cell?
1. Formulas, define name, apply name 2. Apply name, define name 3. Define name, formulas, apply name 4. Formulas, new name, apply name
15. What function is used to apply conditions to a spreadsheet?
1. Condition function 2. If function 3. What function 4. Apply condition function
16. Which of the following is the correct setup for an Advanced Filter for A > 50 OR B > 50?
