TUTORIAL 4 - Spreadsheets

Presentation

•

Other, Education, Computers

•

University

•

Practice Problem

•

Medium

TechMan TechMan

Used 9+ times

FREE Resource

8 Slides • 15 Questions

TUTORIAL 4 -

Spreadsheets

By TechMan

Open Ended

(a) What is the formula in cell B14?

Type response here

a.) What is the formula in cell B14?

=SUM(B10:B13)

Note: =B10+B11+B12+B13 is not the best possible formula as if more rows of expenditure are added then the formula in B14 would have to be changed.

Question 1:

Open Ended

(b) What is the formula in cell B16?

Type response here

(b) What is the formula in cell B16?

=B7-B14

Question 1:

Open Ended

Type response here

=C7-C14

Question 1:

Multiple Choice

2. Cells F1, F2 and F3 in a worksheet contain the values 2, 40 and 10 respectively. What value will be displayed in a cell containing the formula =F1*F2/10+F3?

[A] 4

[B] 9

[C] 10

[D] 18

[E] 90

Multiple Choice

3. Cell C20 in a worksheet contains the formula =MIN(C2:C19). If the entire row 12 is deleted, as it contains no data, what will now be the formula in cell C19?

[A] =MIN(C2:C19)

[B] =MIN(C2:C18)

[C] =MIN(C2:C11,C13:C19)

[D] =MIN(C1:C18)

[E] =MIN(C3:C19)

Multiple Choice

Questions 4 and 5 refer to the scenario below:

A teacher has a worksheet with 200 students’ names and test marks entered in rows 2 to 201. A portion of the worksheet is shown below:

4. The selected cells (columns A and E) can be referred to as __________.

[A] an adjacent cell range

[B] contiguous cells

[C] a non-adjacent cell range

[D] relative cells

[E] absolute cells

Multiple Choice

Questions 4 and 5 refer to the scenario below:

A teacher has a worksheet with 200 students’ names and test marks entered in rows 2 to 201. A portion of the worksheet is shown below:

5. What formula should be entered into cell B202 to calculate the average Test 1 mark?

[A] =TOTAL(B2:B201)/200

[B] =AVERAGE(B1:B202)

[C] =AVERAGE(B2:B201)

[D] =TOTAL(B2+B201)/200

[E] None of the above

Open Ended

6. What is the difference between a worksheet and workbook in MS Excel?

Type response here

6. What is the difference between a worksheet and workbook in MS Excel?

- A workbook is a Microsoft Excel document. A workbook is a collection of worksheets, whereas a worksheet is an individual area or sheet for entering data

Open Ended

7. When writing formulas, why is it preferable to use cell references rather than just typing in values?

Type response here

7. When writing formulas, why is it preferable to use cell references rather than just typing in values?

- Because when an entry in a worksheet cell is changed, all formulas that use that cell are automatically updated.

- It is not necessary to change all the cells that refer to that entry manually so it is easy to update.

- It maintains data integrity as limits the number of changes to be made & so the number of possible errors.

Open Ended

8. How does clearing a column of data differ from deleting a column?

Type response here

8. How does clearing a column of data differ from deleting a column?

- Clearing a column deletes the contents of the cells in the column but does not affect the position of other cells in the workbook.

- Deleting a column removes that column of cells from the worksheet and other columns are shifted in the direction of the deleted column.

Open Ended

9. How can you create a series of even numbers from 2 to 100 in column A of your worksheet?

Type response here

9. How can you create a series of even numbers from 2 to 100 in column A of your worksheet?

Enter 2 into cell A1 and 4 into cell A2

Select cells A1 and A2

Move the mouse until the fill handle appears at the bottom right corner of cell A2

Hold down the mouse button and drag the fill handle down until 100 appears in cell A50

Multiple Choice

11. The cell C2 in the worksheet shown above contains the formula =F1*G3. When the cell C2 is copied to cell D2, the resulting formula in cell D2 is ________.

[A] =G2*H4

[B] =G1*H3

[C] =G1*G3

[D] =F1*G3

[E] =F2*G4

Multiple Choice

12. In the worksheet below, cells A1 and A2 are selected and then the fill handle dragged down column A. Cell A4 will then display ________. Similarly cell D1 is selected and the fill handle dragged down column D. Cell D3 will display ________.

Cell A4 Cell D3

[A] 12 Monday

Cell A4 Cell D3

[B] 13 Monday

Cell A4 Cell D3

[C] 13 Wednesday

Cell A4 Cell D3

[D] 15 Wednesday

[E] None of the above

Multiple Choice

13. In the worksheet shown below, the formula =SUM(B1:B5) is entered into cell B6. What will be displayed in cell B6?

[A] =SUM(B1:B5)

[B] 57

[C] 58

[D] #NAME?

[E] It is impossible to determine from the information given

Multiple Choice

14. In the worksheet shown below, which formula is entered into cell D2 to calculate the cost of fabric?

[A] =SUM(B2:C2)

[B] =B2C2

[C] =R30.00*10

[D] =B2*C2

[E] =SUM(B2*C2)

TUTORIAL 4 -

Spreadsheets

By TechMan

Show answer

Auto Play

Slide 1 / 23

SLIDE

Similar Resources on Wayground

19 questions

Solving Equations with Variables on Both Sides

Presentation

•

University

19 questions

Region 9 Phil Literature

Presentation

•

University

17 questions

Personal protective Equipment

Presentation

•

University

20 questions

Listen for emphatic expression of surprise (Agri B)

Presentation

•

University

18 questions

Teaching and Engaging Students Virtually

Presentation

•

University

18 questions

SQL AND, OR and NOT Operators

Presentation

•

University

17 questions

Unit 1 - Verb to be

Presentation

•

University

15 questions

Computers and Devices

Presentation

•

KG - University

Popular Resources on Wayground

24 questions

PBIS-HGMS Day 10

Quiz

•

6th - 8th Grade

10 questions

HCS SCI 03 Summer School Review 3

Quiz

•

3rd Grade

11 questions

Home Scope

Quiz

•

7th - 8th Grade

15 questions

HCS SCI 05 Summer School Assessment 3 Review

Quiz

•

5th Grade

35 questions

Lufkin Road Middle School Student Handbook & Policies Assessment

Quiz

•

7th Grade

18 questions

Geo 11.3 Area of Circles and Sectors

Quiz

•

9th - 11th Grade