Excel for Beginners Course: Formulas and basic functions

Temaquiz utan tidsgräns: 18 frågor om Formulas and basic functions, med en förklaring efter varje svar. Frågor och svar blandas varje gång.

Kurs
Kanada
100 frågor
Kontrollerad 13 oktober 2026
Faktagranskad 13 oktober 2026

Börja med lektionernaExcel for Beginners Course: Lessons: cirka 120 minuters läsning. Alla provfrågor tas upp i lektionerna.

Temaquiz 3: Formulas and basic functions

Fråga 1 av 18
What character must every Excel formula start with?
- $
- =
- #
- +
Visa svar
Svar: B. =
Excel formulas always begin with the equal sign (=).
Fråga 2 av 18
Which operator multiplies two numbers in a formula?
- &
- *
- ^
- x
Visa svar
Svar: B. *
Excel uses the asterisk (*) to multiply. The ^ sign raises a number to a power and & joins text.
Fråga 3 av 18
What does the formula =4+6*2 return?
- 14
- 16
- 20
- 12
Visa svar
Svar: B. 16
Excel multiplies before it adds: 6*2 = 12, then 4 + 12 = 16.
Fråga 4 av 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
Visa svar
Svar: A. 29
SUM adds every number in B2:B5: 8 + 6 + 7 + 8 = 29 hours worked on Monday.
Fråga 5 av 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
Visa svar
Svar: A. 29.5
B2:F2 is Ana's row: 8 + 7.5 + 8 + 0 + 6 = 29.5 hours.
Fråga 6 av 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+=
Visa svar
Svar: D. Alt+=
Alt+= is the AutoSum shortcut. You can also select AutoSum on the Home tab or the Formulas tab and press Enter.
Fråga 7 av 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
Visa svar
Svar: 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.
Fråga 8 av 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
Visa svar
Svar: B. 4
MIN returns the smallest number in the range. Friday's hours are 6, 4, 8 and 8, so the smallest is 4.
Fråga 9 av 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
Visa svar
Svar: B. 4
COUNT counts only cells that contain numbers. Empty cells are not counted, so the answer is 4.
Fråga 10 av 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
Visa svar
Svar: A. 7.375
AVERAGE ignores empty cells. It adds 7 + 7 + 7.5 + 8 = 29.5 and divides by 4 numbers, giving 7.375.
Fråga 11 av 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
Visa svar
Svar: D. 5.9
AVERAGE includes cells that contain zero. It divides 29.5 by 5 numbers, giving 5.9.
Fråga 12 av 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
Visa svar
Svar: A. 5
COUNTIF counts the cells in the range that match the criteria. There are 5 cells that contain A.
Fråga 13 av 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
Visa svar
Svar: D. 4
COUNTA counts cells that are not empty, whether they hold text or numbers. E5 is empty, so the answer is 4.
Fråga 14 av 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
Visa svar
Svar: D. 15
SUM ignores text in the cells it refers to, so it adds only 8 and 7 and returns 15.
Fråga 15 av 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!
Visa svar
Svar: D. #VALUE!
When you add cells with + and one of them holds text, Excel returns the #VALUE! error. SUM would ignore the text instead.
Fråga 16 av 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
Visa svar
Svar: 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".
Fråga 17 av 18
What does =ROUND(1234.567,-2) return?
- 1235
- 1200
- 1300
- 1234.57
Visa svar
Svar: 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.
Fråga 18 av 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
Visa svar
Svar: 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

Temaquiz 3: Formulas and basic functions

Relaterade prov