BASIC EXCEL - 5

Quiz
•
Computers
•
KG
•
Hard
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
Similar Resources on Wayground
15 questions
kiểm tra lớp 5

Quiz
•
1st - 12th Grade
13 questions
Microsoft Word 2016 Tables

Quiz
•
8th - 12th Grade
10 questions
Latihan Soal TIK Kelas 8

Quiz
•
8th Grade
15 questions
Excel Functions and Formatting Quiz

Quiz
•
5th Grade
15 questions
Microsoft Excel Quiz

Quiz
•
KG
10 questions
BASIC EXCEL - 4

Quiz
•
KG
10 questions
Ôn tập CĐ E1

Quiz
•
8th Grade
10 questions
Excel Functions Quiz

Quiz
•
10th Grade
Popular Resources on Wayground
15 questions
Hersheys' Travels Quiz (AM)

Quiz
•
6th - 8th Grade
20 questions
PBIS-HGMS

Quiz
•
6th - 8th Grade
30 questions
Lufkin Road Middle School Student Handbook & Policies Assessment

Quiz
•
7th Grade
20 questions
Multiplication Facts

Quiz
•
3rd Grade
17 questions
MIXED Factoring Review

Quiz
•
KG - University
10 questions
Laws of Exponents

Quiz
•
9th Grade
10 questions
Characterization

Quiz
•
3rd - 7th Grade
10 questions
Multiply Fractions

Quiz
•
6th Grade