UNIT11:ITIDAT0171A Operate a Spreadsheet Application (basic)

UNIT11:ITIDAT0171A Operate a Spreadsheet Application (basic)

ASSESSMENT ONE - UNIT 11

Hi Assessor Abraham here again!

In this Lesson we will look at Spreadsheets.

A spreadsheet is used for the manipulation of numeric data.

Simple right?

A spreadsheet is made up of rows and columns

Rows run from left to right on the spreadsheet grid and are identified by numbers while columns run up and down are identified by letters.

Multiple Choice

What is the purpose of spreadsheet software?

• To type letters

• for the manipulation of numeric data.

• To prepare articles

Multiple Choice

Rows run up and down in a spreadsheet.

• True

• False

Multiple Select

Choose which of the following are true about columns in a spreadsheet. There are more than one answer.

• They run from left to right

• They run up and down

• They are identified by letters

• They are identified by numbers

Multiple Select

Choose which of the following are true about rows in a spreadsheet. There are more than one answer.

• They run from left to right

• They run up and down

• They are identified by letters

• They are identified by numbers

CELLS

Cells are the intersection of rows and columns and are identified by cell addresses which contain a column letter and a row number. E.g. cell A1

Multiple Choice

In the spreadsheet above which column would you find the surnames of the persons?

• Column A

• Column B

• Column C

Multiple Choice

In the spreadsheet above which row contained the results shown for Tony Brotman?

• Row A

• Row 2

• Row 5

Multiple Choice

In the spreadsheet above which cell contains the results March for Michael Bringson?

• CELL A1

• CELL A2

• CELL E4

Moving to Various Cells

In some spreadsheets like Microsoft Excel and Google sheets we can use:

1. The arrow keys to move to various cells.   

2. CTRL + right arrow for the last column.

3. CTRL + down arrow for the last row.

4. The TAB allows you to move across a row.

5. Remember with the ENTER key you can move down the page.      

Multiple Select

Which keys can be used to move at various points within a spreadsheet?

• TAB

• ARROW KEYS

• SHIFT KEY

• ENTER KEY

Multiple Choice

Pressing the CTRL + down arrow keys we can move to the last row of the spreadsheet.

• True

• False

Multiple Choice

Jason wants to save his spreadsheet file on a flash drive. Select the correct order of the steps he should take to complete this task.

STEP 2 Choose the location of the flash drive from the drop down window and name the file

STEP 1.Click Ok or Save

STEP 3. Click on File then Save as

• STEPS: 3, 2, 1

• STEPS: 1,2, 3

• STEPS: 2, 3,1

YOU HAVE COME TO THE END OF...

ASSESSMENT ONE - UNIT 11