WEBVTT

1
00:00:07.466 --> 00:00:10.133
In this
video, we will learn how to use cell

2
00:00:10.200 --> 00:00:13.466
A1 for the workbook
and for each worksheet.

3
00:00:14.400 --> 00:00:18.866
Cell A1 should be used to give instructions
and useful information

4
00:00:18.866 --> 00:00:22.666
about the whole workbook
and about each individual worksheet.

5
00:00:23.866 --> 00:00:26.733
To save time, I've already prepared
my text for each one.

6
00:00:28.266 --> 00:00:30.266
At the moment I'm on the index page.

7
00:00:30.400 --> 00:00:34.533
I'm going to click in Cell
A1 and for the index page

8
00:00:34.533 --> 00:00:37.466
this should give information
about the whole workbook

9
00:00:37.600 --> 00:00:40.666
and how to navigate it.

10
00:00:40.800 --> 00:00:43.066
I've taken some text
which I'm going to copy

11
00:00:43.066 --> 00:00:45.200
and paste into my cell.

12
00:00:47.333 --> 00:00:49.533
So I'm going to hit control V to paste,

13
00:00:50.600 --> 00:00:53.400
and first of all,
let's look at some formatting issues.

14
00:00:54.533 --> 00:00:58.466
The first problem is
that the text is spilling out of the cell.

15
00:00:59.133 --> 00:01:01.466
To correct that, I can either right click

16
00:01:01.800 --> 00:01:05.000
or in the home menu go to cells and format

17
00:01:06.000 --> 00:01:08.133
and go down to format cells.

18
00:01:11.066 --> 00:01:13.400
The second tab is alignment

19
00:01:14.266 --> 00:01:19.333
and in the text control section of that,
I have a box that says wrap text.

20
00:01:19.333 --> 00:01:22.200
I want to check that box
and then click okay.

21
00:01:24.133 --> 00:01:25.600
That's automatically resized

22
00:01:25.600 --> 00:01:28.333
the box and now the text is wrapped.

23
00:01:28.933 --> 00:01:32.266
I would also like to put
in some formatting for that.

24
00:01:32.600 --> 00:01:36.533
I'm going to give it
some background colour.

25
00:01:36.533 --> 00:01:38.866
I may check the contrast of that
in a later video.

26
00:01:40.000 --> 00:01:42.266
So the text I've used for cell one

27
00:01:42.266 --> 00:01:44.866
for the index page is

28
00:01:45.400 --> 00:01:48.866
this workbook will guide you
through the Dragon assistive software

29
00:01:48.866 --> 00:01:52.933
testing for a website and producing
an action plan for remediation.

30
00:01:53.933 --> 00:01:57.533
So it's describing the purpose of the workbook.

31
00:01:57.533 --> 00:02:01.600
There are four sheets in this workbook,
including this index sheet.

32
00:02:02.600 --> 00:02:04.733
That information will orient the user

33
00:02:04.800 --> 00:02:07.666
so that they have an understanding
of how the workbook is set up.

34
00:02:08.933 --> 00:02:10.800
Hyperlinks are provided below,

35
00:02:10.800 --> 00:02:13.200
beginning in cell A2.

36
00:02:14.133 --> 00:02:16.800
Giving an indication of where
things begin,

37
00:02:16.800 --> 00:02:19.200
using the cell reference, is really important.

38
00:02:20.666 --> 00:02:22.866
Now let's go to the Dragon tests sheet.

39
00:02:24.733 --> 00:02:27.600
So I'm going to copy and paste

40
00:02:27.600 --> 00:02:29.266
my cell one information in there.

41
00:02:29.266 --> 00:02:31.600
I'm going to this time right click

42
00:02:32.933 --> 00:02:35.733
and go to format cells.

43
00:02:35.733 --> 00:02:38.800
I will already be on the alignment tab
because it keeps it

44
00:02:38.800 --> 00:02:41.333
where you last left off,

45
00:02:41.400 --> 00:02:42.666
and I'll wrap the cell.

46
00:02:43.333 --> 00:02:46.933
Again, I'm going to put some
background colour on that.

47
00:02:46.933 --> 00:02:52.200
I haven't created this sheet yet,
but the information in cell A1 says:

48
00:02:52.533 --> 00:02:56.066
This sheet will guide you
through the tests required for Dragon.

49
00:02:56.466 --> 00:03:01.600
For each test, select pass, fail,
not applicable or not tested.

50
00:03:02.333 --> 00:03:05.733
If the test fails,
make notes about the fail.

51
00:03:05.733 --> 00:03:08.733
I may reword that slightly later,
but for now that will do.

52
00:03:09.466 --> 00:03:12.733
I'm going to do the
same for my summary sheet.

53
00:03:14.066 --> 00:03:16.733
I'm going to copy and paste it in.

54
00:03:16.733 --> 00:03:20.200
This time, I'm going to use my keyboard
to change the alignment,

55
00:03:20.200 --> 00:03:23.533
so I'm going to hit the alt key,
H for home,

56
00:03:24.600 --> 00:03:26.666
O for format,

57
00:03:26.666 --> 00:03:29.266
and E for format cells.

58
00:03:30.600 --> 00:03:34.466
I'm going to tab through the options
until I get to wrap text.

59
00:03:34.466 --> 00:03:37.800
The focus isn't very strong,
but I'm going to use the spacebar

60
00:03:38.466 --> 00:03:41.200
to check the box saying wrap text.

61
00:03:41.200 --> 00:03:44.533
I'm going to keep going until I get to the
okay button and hit enter.

62
00:03:46.333 --> 00:03:49.133
I could do the same with my keyboard
to apply that colour fill.

63
00:03:50.000 --> 00:03:52.266
I'm going to go to the H button

64
00:03:52.266 --> 00:03:54.600
and H again and

65
00:03:58.266 --> 00:04:00.133
select my colour.

66
00:04:00.133 --> 00:04:02.400
I did that using
a mixture of tab and arrows.

67
00:04:04.000 --> 00:04:08.266
This one says: This sheet provides a
summary of your Dragon testing results.

68
00:04:08.533 --> 00:04:11.933
It gives an overview of how many passes
and fails you have identified.

69
00:04:12.800 --> 00:04:16.400
Once I've created the sheet for this,
the table of information,

70
00:04:16.400 --> 00:04:20.000
I will also then add in
which cell the information begins in.

71
00:04:21.133 --> 00:04:24.200
Finally, my action plan.

72
00:04:24.200 --> 00:04:27.666
One way of repeating the formatting
is to click in a cell

73
00:04:28.066 --> 00:04:31.066
and click the format painter

74
00:04:31.066 --> 00:04:35.000
and then click on the cell
that you want to apply that to,

75
00:04:35.266 --> 00:04:38.000
and that's now formatted my cell
to match the other ones.

76
00:04:38.000 --> 00:04:40.733
So that's four different ways
you have of formatting that cell.

77
00:04:41.933 --> 00:04:43.800
In this one I've put:
This sheet is for you

78
00:04:43.800 --> 00:04:48.066
to formulate your action plan to remediate
the issues you have identified.

79
00:04:48.466 --> 00:04:52.000
Please fill in the form below to indicate
what you are planning to do

80
00:04:52.066 --> 00:04:54.333
and when it will be completed.

81
00:04:54.333 --> 00:04:58.266
And again, I will say
which cell that table begins in.

82
00:04:58.733 --> 00:05:03.000
So that's how you can use cell
A1 to give important information

83
00:05:03.000 --> 00:05:06.200
and to orient
your reader, particularly useful

84
00:05:06.200 --> 00:05:08.066
for those who use screen readers.