WorksheetsExit slip 1 (12B, D, E)
Total questions: 10
Worksheet time: 5mins
Which formula correctly adds the values in cells A1 and A2?
A1 + A2
=A1 + A2
SUM(A1,A2)
=ADD(A1+A2)
What symbol must be typed before writing any Excel formula?
+
:
=
$
Which formula subtracts the value in B1 from A1?
=A1 - B1
=A1 + B1
A1 - B1
=SUB(A1,B1)
Which formula multiplies the values in cells A1 and A2?
=A1 x A2
=A1 * A2
=A1 . A2
=MULT(A1,A2)
Which function correctly finds the total of cells A1 to A5?
=ADD(A1:A5)
=TOTAL(A1:A5)
=SUM(A1:A5)
=A1+A5
Which Excel feature allows you to restrict what a user can enter in a cell (e.g. only numbers or a list)?
Conditional Formatting
Data Validation
Filters
Sorting
Which feature changes the cell color automatically based on a condition?
Cell Styles
Data Validation
Conditional Formatting
Borders
Which option is used to add lines around cells in a table?
Fill Color
Font Color
Borders
Conditional Formatting
What does Data Validation with a drop-down list do?
Changes cell color
Adds borders to cells
Allows the user to choose from predefined values
Automatically sums numbers
Which tool is used to color the background of a cell?
Font Color
Fill Color
Conditional Formatting
Borders
