ICT- Spreadsheet Concepts 0.0 / 5 ? ICTSpreadsheetsASAQA Created by: TOPHAMSCreated on: 25-02-17 14:10 What is a Function? They represent standard routines to perform common tasks. They use reserved words 1 of 16 What is Formulae? A Mathematical expression entered onto a spreadsheet cell, whose value is automatically calculated and entered 2 of 16 What is Relative Referencing? The formula changes when it is copied to other cells 3 of 16 What is Absolute Referencing? The formula remains exactly the same when it is copied to other cells 4 of 16 What is Conditional Formatting? Used to automatically highlight specific data 5 of 16 Give 3 examples of Form Controls Spinners, drop down boxes, buttons (Can run macros) 6 of 16 What do Graphs allow developers to do? Show patterns and trends 7 of 16 What does a What-If allow developers to do? look at different scenarios without creating a real life model 8 of 16 What do Worksheets allow a developer to do? allows different sets of data to be recorded (e.g. sales each month) 9 of 16 What does Recalculation allow developers to do? allows values to be changed without re-creating the entire model 10 of 16 What does Protection allow developers to do? Keeping certain information confidential 11 of 16 What is a Workbook? A Spreadsheet Document 12 of 16 What is a Worksheet? One page (section) of the Workbook 13 of 16 What are Rows? Cells going across Horizontally 14 of 16 What are Columns? Cells going down Vertically 15 of 16 What is a Cell? Where Rows and Columns meet 16 of 16
Comments
No comments have yet been made