Excel functions

Quiz
•
9th Grade
•
Hard
tahani morsil
Used 65+ times
FREE Resource
11 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Cell orientation allows you to :
change cell contents from number to text
color the text under condition
change the direction of the text
change the appearance of the cell
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
to count any fields containing numbers we use:
countIF function
counta function
count function
countIFs function
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
to add the contents of a certain field, we:
write the cell reference of each number seperated by a plus sign
write the sum function with cell references seperated by a plus sign
start with equal sign then use the sum funtion with the plus
start with equal sign, sum function containing the first cell address and the last.
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
to find out how many persons are there in a certain field, the following function is applied
average(--:--)
count(--:--)
counta(--;--)
counta(--:--)
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
I need to find the sum of salaries for those who live in "dubai"
=sumif(a:a12,dubai,d1:d)
=sumif(a1;a12,"dubai,d1;d12)
=sumif(a1:12,"dubai",d1:12)
=sum(a1:a12,"dubai",d1:d12)
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
a company needs to highlight with red the salaries more than 8000 drh
it should use the bucket filler
it should use the highlighter
it should use the conditional formatting
it uses the (A) button on top of the home tab
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
the structure of countif is:
contif(criteria,range of cells)
countif(range of cells, criteria, range of cells)
countif(range of cells, criteria)
Create a free account and access millions of resources
Similar Resources on Wayground
10 questions
Microsoft Excel Domain 2

Quiz
•
9th Grade
10 questions
HÀM SUMIF

Quiz
•
9th Grade
10 questions
Excel 2019 Formulas and Functions

Quiz
•
8th - 12th Grade
8 questions
BÀI 10a. SỬ DỤNG HÀM COUNTIF

Quiz
•
9th Grade
10 questions
BÀI 11A. SỬ DỤNG HÀM SUMIF

Quiz
•
9th Grade - University
10 questions
Câu hỏi về hàm SUMIF trong Excel

Quiz
•
9th Grade - University
10 questions
bài kt 15 phút l9

Quiz
•
9th Grade
10 questions
Bài 10A: Sử dụng hàm COUNTIF

Quiz
•
9th Grade - University
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