NEW
Font size
WorksheetsMS Excel - Formulas & Functions (1)
Total questions: 21
Worksheet time: 21mins
A formula in Excel always starts with which symbol?
+
=
#
@
What does AutoSum do?
Adds numbers in a range
Multiplies numbers
Deletes numbers
Formats numbers
Which of these is a correct formula?
A1 + B1
A1 = B1
=A1 + B1
A1 += B1
Which function is used to find the biggest number?
SUM
MIN
AVERAGE
MAX
What is the purpose of the MAX function?
To find the smallest number
To find the largest number
To add numbers
To divide numbers
In the formula =SUM(A1:A5), A1:A5 is the ____.
Range
Answer
Shortcut
Chart
Where can you find AutoSum in Excel?
Insert Tab
View Tab
Home Tab → Editing
Page Layout
What is the fill handle used for?
To copy a formula
To delete a cell
To change colour
To insert a picture
Which formula will give the total of cells C3 to F3?
=TOTAL(C3-F3)
=ADD(C3:F3)
=SUM(C3-F3)
=SUM(C3:F3)
Which one is a correct function?
SUM{ }
SUM]
SUM( )
SUM<>
What is the first step to use AutoSum?
Click on the cell where the result will appear
Select the range
Press Enter
Open File Tab
Which of the following is a function for smallest value?
SUM
AVERAGE
MIN
MAX
Which key combination is used to copy a formula?
Ctrl + C
Ctrl + V
Ctrl + X
Ctrl + Z
What happens when you change data in a formula?
Excel deletes the formula
Excel does not update
Nothing changes
Excel automatically updates the result
Which one is NOT a common Excel function?
SUM
AVERAGE
REMOVE
MAX
Which function finds the average of numbers?
AVG
AVERAGE
MIN
DIVIDE
The AutoSum symbol looks like:
√
Σ
#
%
In =MAX(B2:B6), B2:B6 is the:
Function
Result
Range
Chart
Which formula will add A2 and B2?
=A2 + B2
A2 + B2
=ADD(A2,B2)
=A2 x B2
The fill handle is found at the:
Top-left of the cell
Bottom-right of the cell
Bottom-left of the sheet
Top-right of the sheet
AutoSum in found in which tab?
Insert
Formulas
Data
View
