Excel for Beginners Course: Formulas and basic functions

1. Frage 1 von 18

   What character must every Excel formula start with?

   • A$
   • B=
   • C#
   • D+
   Antwort anzeigen

   Antwort: B. =

   Excel formulas always begin with the equal sign (=).

2. Frage 2 von 18

   Which operator multiplies two numbers in a formula?

   • A&
   • B*
   • C^
   • Dx
   Antwort anzeigen

   Antwort: B. *

   Excel uses the asterisk (*) to multiply. The ^ sign raises a number to a power and & joins text.

3. Frage 3 von 18

   What does the formula =4+6*2 return?

   • A14
   • B16
   • C20
   • D12
   Antwort anzeigen

   Antwort: B. 16

   Excel multiplies before it adds: 6*2 = 12, then 4 + 12 = 16.

4. Frage 4 von 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

   • A29
   • B4
   • C21
   • D29.5
   Antwort anzeigen

   Antwort: A. 29

   SUM adds every number in B2:B5: 8 + 6 + 7 + 8 = 29 hours worked on Monday.

5. Frage 5 von 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

   • A29.5
   • B5
   • C28.5
   • D29
   Antwort anzeigen

   Antwort: A. 29.5

   B2:F2 is Ana's row: 8 + 7.5 + 8 + 0 + 6 = 29.5 hours.

6. Frage 6 von 18

   You select the empty cell under a column of numbers. Which keyboard shortcut inserts a SUM formula with AutoSum?

   • AShift+F11
   • BCtrl+1
   • CCtrl+S
   • DAlt+=
   Antwort anzeigen

   Antwort: D. Alt+=

   Alt+= is the AutoSum shortcut. You can also select AutoSum on the Home tab or the Formulas tab and press Enter.

7. Frage 7 von 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

   • A7.5
   • B30.5
   • C8
   • D7
   Antwort anzeigen

   Antwort: 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. Frage 8 von 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

   • A0
   • B4
   • C6
   • D8
   Antwort anzeigen

   Antwort: 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. Frage 9 von 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

   • A5
   • B4
   • C29.5
   • D3
   Antwort anzeigen

   Antwort: B. 4

   COUNT counts only cells that contain numbers. Empty cells are not counted, so the answer is 4.

10. Frage 10 von 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

    • A7.375
    • B29.5
    • C7.5
    • D5.9
    Antwort anzeigen

    Antwort: 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. Frage 11 von 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

    • A7.375
    • B6
    • C29.5
    • D5.9
    Antwort anzeigen

    Antwort: D. 5.9

    AVERAGE includes cells that contain zero. It divides 29.5 by 5 numbers, giving 5.9.

12. Frage 12 von 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

    • A5
    • B4
    • C19
    • D25
    Antwort anzeigen

    Antwort: A. 5

    COUNTIF counts the cells in the range that match the criteria. There are 5 cells that contain A.

13. Frage 13 von 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

    • A3
    • B1
    • C5
    • D4
    Antwort anzeigen

    Antwort: D. 4

    COUNTA counts cells that are not empty, whether they hold text or numbers. E5 is empty, so the answer is 4.

14. Frage 14 von 18

    In the sheet below, what does =SUM(A2:C2) return?

    	A	B	C
    1	Mon	Tue	Wed
    2	8	N/A	7

    • A8
    • B#VALUE!
    • C0
    • D15
    Antwort anzeigen

    Antwort: D. 15

    SUM ignores text in the cells it refers to, so it adds only 8 and 7 and returns 15.

15. Frage 15 von 18

    In the sheet below, what does =A2+B2+C2 return?

    	A	B	C
    1	Mon	Tue	Wed
    2	8	N/A	7

    • A15
    • B0
    • CN/A
    • D#VALUE!
    Antwort anzeigen

    Antwort: 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. Frage 16 von 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

    • A2
    • B4
    • C3
    • D1
    Antwort anzeigen

    Antwort: 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. Frage 17 von 18

    What does =ROUND(1234.567,-2) return?

    • A1235
    • B1200
    • C1300
    • D1234.57
    Antwort anzeigen

    Antwort: 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. Frage 18 von 18

    In the sheet below, C2 is empty. What does =B2/C2 return?

    	A	B	C
    1	Punkt	Cost	Units
    2	Gloves	84

    • A#DIV/0!
    • B#VALUE!
    • C84
    • D0
    Antwort anzeigen

    Antwort: 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.

Tastatur: 1–4 zum Antworten, Eingabetaste für die nächste Frage.