WorksheetsBonus Excel
Total questions: 28
Worksheet time: 13mins
* is a symbol for:
Multiplication
Addition
Subtraction
Dividing
A simple formula always start with :
+
=
-
*
What is a multiplication formula for MS Excel using the picture ?
=1Ax1B
=B1*G1
=C3xD3
=B4*C4
Which is NOT a term used in Excel?
Workbook
Worksheet
Cell
Document
Excel file is saved as a ____________
Document
workbook
worksheets
Presentation
A vertical line of cells
Maximum
Minimum
Column
Formulas
Which one is a correct cell address?
A1
1A
A
1
What is the Sum formula?
Sum( )
Sum( )=
=Sum( )
=( )Sum
The sum of all numbers divided by the amount of numbers.
Maximun
Minimum
Median
Average
What does the > logical operator do?
Less than
Not equal to
More than or euqal to
More than
>=10 what does this logical operator mean?
More than or equal to 10
Not equal to 10
More than 10
Less than or equal 10
When using Formulas and Functions and using text within them, you need to write them in between " "
TRUE
FALSE
