10 Questions
Addition of two strings is called ________________.
concatenation
You can format data using the ______________ option.
formatting
_________ error is displayed if you use an invalid operator.
syntax
__________ formula is used to calculate the values from cell A3:D3.
SUM
A formula is made of _________ and _____________.
functions, operators
__________ function calculates the average of the cell values.
average
You have to press _______ key to edit the cell contents after selecting the cell.
F12
_____________ are pre-defined formulae that perform specific calculations.
functions
Write the formula of the following functions.
- Adding values from cell D1 to D5 = _____________________
=SUM(D1:D5)
Write the formulas of the following functions. Counts the cell values A5 to A10 =______________________
=COUNT(A5:A10)
Test your knowledge of Excel formulas and functions with this quiz! From basic arithmetic operations to pre-defined formulae, this quiz covers various aspects of using formulas in Excel. See how well you know about formatting data, editing cell contents, and calculating values in Excel.
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free