Font size
WorksheetsG6. Unit 6.4/6.5/6.6
Total questions: 27
Worksheet time: 16mins
III.Identify the layout:
Title and Content
Title Slide
Blank
III.Identify the layout:
Title Slide
Blank
Title and Content
Blank
Title and Content
Title Slide
IV.Name the icons:
New Slide
Audio
Slide Show
Excel
PowerPoint
IV.Name the icons:
New Slide
Audio
Slide Show
Excel
PowerPoint
IV.Name the icons:
New Slide
Audio
Slide Show
Excel
PowerPoint
IV.Name the icons:
New Slide
Audio
Slide Show
Excel
PowerPoint
IV.Name the icons:
New Slide
Audio
Slide Show
Excel
PowerPoint
Sort A to Z
Format as Table
Sort Z to A
Filter
Format as Table
Sort A to Z
Sort Z to A
Filter
Format as Table
Sort A to Z
Sort Z to A
Filter
Format as Table
Sort A to Z
Sort Z to A
Filter
a. How many records are there in the above table?
5
6
4
7
b. How many fields are there in the above table?
7
6
5
3
c. Identify the key field.
Tetle
Book ID
Genre
d. If you sort the table by Pages (ascending), which Book title will come first?
Ocean Secrets
History Heroes
Fun with Words
If you sort by Title (Z–A), which Book ID will appear first?
B204
B203
B206
B201
a. Identify the field which is:
i.Sorted:
Order ID
Category
Product
a. Identify the field which is:
ii.Filtered:
Product
Category
Order ID
a. Identify the field which is:
iii. Key field:
Product
Category
Order ID
(a)
b. What type of sorting is applied? (a)
(a)
3. Identify the icon: (a)
1. Write the IF formula Mr. Ali should type in cell C4.
=if (B4= “Yes”, “Overdue”, “Available”)
=if (B5= “Yes”, “Available”, “Overdue”)
=if (B4= “Yes”, “Available”, “Overdue”)
2. The value in B5 is "No". What will cell C5 display after the formula is applied?
Available
Overdue
3. Mr. Ali changes B4 from "Yes" to "No". Will cell C4 update automatically? Explain why.
No, it did not update automatically whenever a reference cell changed.
Yes, whenever a reference cell changes, it will update automatically
