ICT Mid-semester Exam

ICT Mid-semester Exam

7th Grade

64 Qs

quiz-placeholder

Similar activities

UAS TIK SMT 1 KELAS 7

UAS TIK SMT 1 KELAS 7

7th Grade

60 Qs

Introduction to Spreadsheets

Introduction to Spreadsheets

7th Grade - Professional Development

60 Qs

Post Tes Word & Excel

Post Tes Word & Excel

7th Grade

60 Qs

INFO EXAMEN VALLARTA

INFO EXAMEN VALLARTA

1st - 12th Grade

60 Qs

CHỦ ĐỀ E - BÀI 1,2

CHỦ ĐỀ E - BÀI 1,2

7th Grade

59 Qs

Keycode Semester Test

Keycode Semester Test

7th Grade - University

60 Qs

ICDL Module 1 - Computer & Online Essentials QRG 1

ICDL Module 1 - Computer & Online Essentials QRG 1

7th Grade

61 Qs

Year 8 Patricks - IT Assessment

Year 8 Patricks - IT Assessment

7th - 9th Grade

60 Qs

ICT Mid-semester Exam

ICT Mid-semester Exam

Assessment

Quiz

Computers

7th Grade

Hard

Created by

Mohammad Anwar

Used 1+ times

FREE Resource

64 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What function would you use to find the average of a range of cells?

=SUM()

=AVERAGE()

=COUNT()

=MAX()

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following formats can you apply to a cell in Excel?

Currency

Percentage

Date

All of the above

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the correct formula to calculate the total price if the unit price is in cell A1 and the quantity is in cell B1?

=A1 + B1

=A1 * B1

=A1 - B1

=A1 / B1

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which chart type would be best for showing the relationship between two variables?

Pie Chart

Line Chart

Bar Chart

Scatter Plot

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

To apply a filter on your data in Excel, you would go to which tab?

Home

Data

Insert

View

6.

OPEN ENDED QUESTION

3 mins • 1 pt

The formula to calculate the percentage increase is _________.

Evaluate responses using AI:

OFF

7.

FILL IN THE BLANK QUESTION

30 sec • 1 pt

To create a new worksheet in Excel, you click on the _________ icon.

Create a free account and access millions of resources

Create resources
Host any resource
Get auto-graded reports
or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?