How to show formulas and print row and column headings in excel N6 Computer Practice Question 8B
Ashertech Exam Prep Academy
0:00 / 0:00
How to show formulas and print row and column headings in excel N6 Computer Practice Question 8B
1 851 просмотр · 6 мес. назад
Ashertech Exam Prep Academy
1,02 тыс. подписчиков
1 851 просмотр · 6 мес. назад
In this video, I show you how to complete Computer Practice N6 Question 8B using Microsoft Excel. This step-by-step tutorial covers how to open the QUESTION 8A JURASSIC ANALYSIS file, update the header to 8B, hide the required columns, display formulas, adjust column widths, save the file correctly, and print the spreadsheet according to the exam instructions.
This lesson is ideal for students preparing for the Computer Practice N6 exam and anyone looking to improve their Microsoft Excel spreadsheet skills. I explain each step clearly so you can follow along and complete the task with confidence.
In this video, you will learn how to:
Open the QUESTION 8A JURASSIC ANALYSIS spreadsheet
Change the question number in the header to 8B
Hide columns D, E, and F
Show formulas in Excel
Adjust column widths so all formulae are visible
Save the file as QUESTION 8B JURASSIC ANALYSIS
Print the spreadsheet in landscape orientation
Include row and column headings
Use the Fit Sheet on One Page option for printing
00:00 Retrieve/Open the QUESTION 8A JURASSIC ANALYSIS spreadsheet
01:55 Change the question number in the header to 8B Numbers Safely
04:53 Show formulas in Excel
06:06 Adjust column widths so all formulae are visible and printing your work
This tutorial is helpful for Computer Practice N6 spreadsheet revision, Microsoft Excel exam preparation, and practical office skills training.