Excel for Beginners Course: Formulas and basic functions

اختبار موضوعي بلا وقت محدد: 18 سؤالًا عن Formulas and basic functions، مع شرح بعد كل إجابة. تُخلط الأسئلة والإجابات في كل مرة.

دورة
كندا
عدد الأسئلة: 100
تمت المراجعة في 13 أكتوبر 2026
تم التحقق من الحقائق في 13 أكتوبر 2026

ابدأ بالدروسExcel for Beginners Course: Lessons: نحو 120 دقيقة من القراءة. كل أسئلة الاختبار مشروحة في الدروس.

اختبار الموضوع 3: Formulas and basic functions

السؤال 1 من 18
What character must every Excel formula start with?
- $
- =
- #
- +
أظهر الإجابة
الإجابة: B. =
Excel formulas always begin with the equal sign (=).
السؤال 2 من 18
Which operator multiplies two numbers in a formula?
- &
- *
- ^
- x
أظهر الإجابة
الإجابة: B. *
Excel uses the asterisk (*) to multiply. The ^ sign raises a number to a power and & joins text.
السؤال 3 من 18
What does the formula =4+6*2 return?
- 14
- 16
- 20
- 12
أظهر الإجابة
الإجابة: B. 16
Excel multiplies before it adds: 6*2 = 12, then 4 + 12 = 16.
السؤال 4 من 18
In the timesheet below, what does =SUM(B2:B5) return?
A B C D E F
1 Employee Mon Tue Wed Thu Fri
2 Ana 8 7.5 8 0 6
3 Ben 6 8 8 8 4
4 Chen 7 7 7.5 8
5 Dana 8 8 8 8 8
- 29
- 4
- 21
- 29.5
أظهر الإجابة
الإجابة: A. 29
SUM adds every number in B2:B5: 8 + 6 + 7 + 8 = 29 hours worked on Monday.
السؤال 5 من 18
In the timesheet below, what does =SUM(B2:F2) return?
A B C D E F
1 Employee Mon Tue Wed Thu Fri
2 Ana 8 7.5 8 0 6
3 Ben 6 8 8 8 4
4 Chen 7 7 7.5 8
5 Dana 8 8 8 8 8
- 29.5
- 5
- 28.5
- 29
أظهر الإجابة
الإجابة: A. 29.5
B2:F2 is Ana's row: 8 + 7.5 + 8 + 0 + 6 = 29.5 hours.
السؤال 6 من 18
You select the empty cell under a column of numbers. Which keyboard shortcut inserts a SUM formula with AutoSum?
- Shift+F11
- Ctrl+1
- Ctrl+S
- Alt+=
أظهر الإجابة
الإجابة: D. Alt+=
Alt+= is the AutoSum shortcut. You can also select AutoSum on the Home tab or the Formulas tab and press Enter.
السؤال 7 من 18
In the timesheet below, what does =MAX(C2:C5) return?
A B C D E F
1 Employee Mon Tue Wed Thu Fri
2 Ana 8 7.5 8 0 6
3 Ben 6 8 8 8 4
4 Chen 7 7 7.5 8
5 Dana 8 8 8 8 8
- 7.5
- 30.5
- 8
- 7
أظهر الإجابة
الإجابة: C. 8
MAX returns the largest number in the range. The Tuesday hours are 7.5, 8, 7 and 8, so the largest is 8.
السؤال 8 من 18
In the timesheet below, what does =MIN(F2:F5) return?
A B C D E F
1 Employee Mon Tue Wed Thu Fri
2 Ana 8 7.5 8 0 6
3 Ben 6 8 8 8 4
4 Chen 7 7 7.5 8
5 Dana 8 8 8 8 8
- 0
- 4
- 6
- 8
أظهر الإجابة
الإجابة: B. 4
MIN returns the smallest number in the range. Friday's hours are 6, 4, 8 and 8, so the smallest is 4.
السؤال 9 من 18
In the timesheet below, cell D4 is empty. What does =COUNT(B4:F4) return?
A B C D E F
1 Employee Mon Tue Wed Thu Fri
2 Ana 8 7.5 8 0 6
3 Ben 6 8 8 8 4
4 Chen 7 7 7.5 8
5 Dana 8 8 8 8 8
- 5
- 4
- 29.5
- 3
أظهر الإجابة
الإجابة: B. 4
COUNT counts only cells that contain numbers. Empty cells are not counted, so the answer is 4.
السؤال 10 من 18
In the timesheet below, cell D4 is empty. What does =AVERAGE(B4:F4) return?
A B C D E F
1 Employee Mon Tue Wed Thu Fri
2 Ana 8 7.5 8 0 6
3 Ben 6 8 8 8 4
4 Chen 7 7 7.5 8
5 Dana 8 8 8 8 8
- 7.375
- 29.5
- 7.5
- 5.9
أظهر الإجابة
الإجابة: A. 7.375
AVERAGE ignores empty cells. It adds 7 + 7 + 7.5 + 8 = 29.5 and divides by 4 numbers, giving 7.375.
السؤال 11 من 18
In the timesheet below, Ana has 0 hours on Thursday. What does =AVERAGE(B2:F2) return?
A B C D E F
1 Employee Mon Tue Wed Thu Fri
2 Ana 8 7.5 8 0 6
3 Ben 6 8 8 8 4
4 Chen 7 7 7.5 8
5 Dana 8 8 8 8 8
- 7.375
- 6
- 29.5
- 5.9
أظهر الإجابة
الإجابة: D. 5.9
AVERAGE includes cells that contain zero. It divides 29.5 by 5 numbers, giving 5.9.
السؤال 12 من 18
In the attendance sheet below, P means present and A means absent. What does =COUNTIF(B2:F6,"A") return?
A B C D E F
1 Name Mon Tue Wed Thu Fri
2 Amrit P P A P P
3 Bella P A A P P
4 Carlos P P P P P
5 Divya A P P P
6 Erin P P P A P
- 5
- 4
- 19
- 25
أظهر الإجابة
الإجابة: A. 5
COUNTIF counts the cells in the range that match the criteria. There are 5 cells that contain A.
السؤال 13 من 18
In the attendance sheet below, Divya's Thursday cell (E5) is empty. What does =COUNTA(B5:F5) return?
A B C D E F
1 Name Mon Tue Wed Thu Fri
2 Amrit P P A P P
3 Bella P A A P P
4 Carlos P P P P P
5 Divya A P P P
6 Erin P P P A P
- 3
- 1
- 5
- 4
أظهر الإجابة
الإجابة: D. 4
COUNTA counts cells that are not empty, whether they hold text or numbers. E5 is empty, so the answer is 4.
السؤال 14 من 18
In the sheet below, what does =SUM(A2:C2) return?
A B C
1 Mon Tue Wed
2 8 N/A 7
- 8
- #VALUE!
- 0
- 15
أظهر الإجابة
الإجابة: D. 15
SUM ignores text in the cells it refers to, so it adds only 8 and 7 and returns 15.
السؤال 15 من 18
In the sheet below, what does =A2+B2+C2 return?
A B C
1 Mon Tue Wed
2 8 N/A 7
- 15
- 0
- N/A
- #VALUE!
أظهر الإجابة
الإجابة: D. #VALUE!
When you add cells with + and one of them holds text, Excel returns the #VALUE! error. SUM would ignore the text instead.
السؤال 16 من 18
In the sheet below, C2 contains =IF(B2>=32,"Full","Part") and is copied down to C5. How many cells in C2:C5 show "Full"?
A B C
1 Employee Hours Status
2 Ana 29.5
3 Ben 34
4 Chen 31.5
5 Dana 40
- 2
- 4
- 3
- 1
أظهر الإجابة
الإجابة: A. 2
IF shows "Full" only when the hours are 32 or more. Ben (34) and Dana (40) meet the test, so 2 cells show "Full".
السؤال 17 من 18
What does =ROUND(1234.567,-2) return?
- 1235
- 1200
- 1300
- 1234.57
أظهر الإجابة
الإجابة: B. 1200
A negative num_digits rounds to the left of the decimal point. -2 rounds to the nearest hundred, so the result is 1200.
السؤال 18 من 18
In the sheet below, C2 is empty. What does =B2/C2 return?
A B C
1 Item Cost Units
2 Gloves 84
- #DIV/0!
- #VALUE!
- 84
- 0
أظهر الإجابة
الإجابة: A. #DIV/0!
Excel shows #DIV/0! when a number is divided by zero or by an empty cell. A formula like =IF(C2,B2/C2,0) avoids the error.

	A	B	C	D	E	F
1	Employee	Mon	Tue	Wed	Thu	Fri
2	Ana	8	7.5	8	0	6
3	Ben	6	8	8	8	4
4	Chen	7	7		7.5	8
5	Dana	8	8	8	8	8

	A	B	C	D	E	F
1	Name	Mon	Tue	Wed	Thu	Fri
2	Amrit	P	P	A	P	P
3	Bella	P	A	A	P	P
4	Carlos	P	P	P	P	P
5	Divya	A	P	P		P
6	Erin	P	P	P	A	P

	A	B	C
1	Item	Cost	Units
2	Gloves	84

اختبار الموضوع 3: Formulas and basic functions

اختبارات ذات صلة