80 likes | 176 Views
Lesson Objectives. Explain the format of spreadsheet exam questions. Be able to add header, footers and automated filenames. Successfully complete an exam question using formulae and functions. Starter - Anagrams. Tic Of Nun. Function. Starter - Anagrams. Sheared Pets. Spreadsheet.
E N D
Lesson Objectives • Explain the format of spreadsheet exam questions. • Be able to add header, footers and automated filenames. • Successfully complete an exam question using formulae and functions.
Starter - Anagrams Tic Of Nun Function
Starter - Anagrams Sheared Pets Spreadsheet
Starter - Anagrams Rave Age Average
Starter - Anagrams Ram Foul Formula
Exam Practice • In the exam you are likely to be asked: • Put your name or a title in the header/footer. • Put an automated filename and path in the header/footer • Put an automated date in the header/footer. • Put page numbers in the header/footer. • Your teacher will now demonstrate how to do this.
Task • Follow the instruction sheet you have been given. • If you get stuck, Persevere! • How can you find out what to do for yourself before asking for help? • This isn't because your teacher is lazy…it will help you remember how to do it!
Plenary • Copy and paste the formulae from the following cells into an email and send it to your teacher. • B6 • I6 • K6 • L6 • J22 • B22