12 Questions
What character always starts a formula in Excel?
Equal sign (=)
What is the correct step to create a formula in Excel after selecting a cell?
Type the equal sign (=)
What is the formula to calculate the sum of 1 and 1 in Excel?
$=1+1$
What is communicated by reference(value) in Excel?
$A1(2)$
Which arithmetic operator is used to subtract in Excel?
$-$
What is the result of the formula $=A1-B2$ in Excel, based on the given values?
$274$
What is the purpose of typing values into cells in Excel before using them in formulas?
To provide input for calculations
What is the role of pressing enter after entering an arithmetic operation and selecting another cell or typing value in Excel?
To confirm and execute the formula
What does the formula $=SUM(A1:A5)$ represent in Excel?
Adds values from cell A1 to A5 together
What does it mean to 'claim' a cell by entering the equal sign (=) followed by a value in Excel?
To specify that it will be used in a formula
What happens if you type a formula directly without clicking on cells in Excel?
The formula will be executed using default cell references
What is communicated by reference(value) example A2(320) in Excel?
The value of cell A2 as 320
Learn how to create formulas in Excel with this step-by-step guide. Understand the syntax of Excel formulas and how to perform mathematical calculations within cells.
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free