Scribd
Upload
150 views4 pages

Excel Basic Formulas and Functions - Quizizz

The document is a worksheet for an Excel Basic Formulas and Functions class, containing 20 questions to assess understanding of operators, formulas, and functions. It includes multiple-choice questions on topics such as the definition of operators, complex formulas, order of operations, and cell references. The worksheet is designed for a 10-minute completion time and includes spaces for the student's name, class, date, and instructor's name.

Uploaded by

win win myo
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
150 views4 pages

Excel Basic Formulas and Functions - Quizizz

The document is a worksheet for an Excel Basic Formulas and Functions class, containing 20 questions to assess understanding of operators, formulas, and functions. It includes multiple-choice questions on topics such as the definition of operators, complex formulas, order of operations, and cell references. The worksheet is designed for a 10-minute completion time and includes spaces for the student's name, class, date, and instructor's name.

Uploaded by

win win myo
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Worksheets Name

Excel Basic Formulas and Functions


Class
Total questions: 20
Worksheet time: 10mins
Date
Instructor name: M yo

1. Define the following operator: +

a) Subtraction b) Addition

c) Multiplication d) Division

2. Define the following operator: -

a) Subtraction b) Addition

c) Multiplication d) Division

3. Define the following operator: /

a) Division b) Subtraction

c) Addition d) Multiplication

4. Define the following operator: *

a) Subtraction b) Addition

c) Multiplication d) Division

5. A symbol used to tell the formula what type of calculation should be done is a(n)

a) operand b) operator

c) function d) formula

6. The values or data used in the formula are called

a) operators b) operands

c) functions d) formulas
7. Which of the following formulas is a complex formula?

a) =3*2*5 b) =20*(2*5)

c) =C4/C5 d) =10*6-2

8. This is a way to point to a cell location on the spreadsheet

a) cell reference b) format painter

c) complex formula d) simple formula

9. Which of the following is a valid formula?

a) =C3-C4 b) (D5*F5)

c) =F15 d) F2/F3

10. Which of the following is a simple formula?

a) =10+B1*C1 b) =D3+40-F3

c) =50-(C3-D13) d) =G11/20+2

11. Using the correct order of operations, what does this formula equal? =10/(10-5)*6

a) -24 b) .3333

c) .83 d) 12

12. In this formula, which calculation would be performed first? =4*5-(10+54)

a) 10 + 54 b) 4 * 5

c) It is unknown d) 5-(10+54)

13. What is the best formula for finding the total value for cells F17 through F22?

a) SUM(F17:F22) b) =F17+F18+F19+F20+F21+F22

c) =SUM(F17:F22) d) =(F17:F22)
14.

Which one is the Formula Bar?

a) C b) B

c) A d) D

15. Which formula contains a cell reference?

a) =567+89 b) =H34

c) =D5/2 d) =65-34

16. What is the argument in this formula? =AVERAGE(C13:F11)

a) C13 b) (C13:F11)

c) F11 d) AVERAGE

17.

Which formula would you enter to return the number 45.1?

a) =SUM(A2:B5) b) =AVERAGE(A2:B5)

c) =MIN(A2:B5) d) =MAX(A2:B5)

18. Clicking on a cell will show its contents in the Formula Bar.

a) True b) False
19. When using a cell reference, you no longer have to update a formula when the value in a cell
changes.

a) False b) True

20.

Cell A1 contains the formula "=10+D2". If you copied A1 to B3, what would be the formula in B3?

a) =10+B3 b) =10+E4

c) =10+B4 d) =10+E3

You might also like