BASIC EXCEL - 5

BASIC EXCEL - 5

KG

10 Qs

quiz-placeholder

Similar activities

Ôn tập CĐ E1

Ôn tập CĐ E1

8th Grade

10 Qs

FINAL REVIEW BASICX EXCEL - 2

FINAL REVIEW BASICX EXCEL - 2

KG

12 Qs

Excel Functions Quiz

Excel Functions Quiz

10th Grade

10 Qs

Excel Week 7

Excel Week 7

10th Grade

15 Qs

Excel

Excel

7th Grade

15 Qs

Spreadsheets L4

Spreadsheets L4

9th Grade

15 Qs

MOAC Excel 2016 Lesson 09

MOAC Excel 2016 Lesson 09

9th - 12th Grade

10 Qs

SQL JOIN, Order By, Group By

SQL JOIN, Order By, Group By

12th Grade

15 Qs

BASIC EXCEL - 5

BASIC EXCEL - 5

Assessment

Quiz

Computers

KG

Hard

Created by

José Estrada

Used 14+ times

FREE Resource

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

It is one of the widely used references in MS-Excel because it is related to column and row.

Relative

Absolute

Mixed

None of the above

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Types of references that do not allow them to be modified at the time of copying since they remain fixed regardless of the number of times they are copied.

Mixed

Absolut

References

None of the above

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

This type of reference is a type of combination of the other two references in which the row or column can be locked.

Absolut

Mixed

Relative

None of the above

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the correct example of a mixed column reference?

=A2 + A10

=A2 + A$10

=A2 + $A10

=A2 + $A$10

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

To sort by criteria, in which tab we can find the Sort command.

Home

Insert

Date

View

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Can we sort by custom criteria within the spreadsheet?

True

False

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Mention the steps to add levels within a data order.

Insert - Sort and filter - Sort - Add level - Insert field

Data - Sort and filter - Filter - Add level - Insert field

Data - Sort and filter - Sort - Add level - Insert field

None of the above

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?