Recent Lessons

Show all results for ""

12 Questions

1 Views

Excel Formulas Creation

Choose a study mode

Play Quiz

Study Flashcards

Spaced Repetition

Chat to Lesson

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

What character always starts a formula in Excel?

Minus sign (-)
Ampersand (&)
Plus sign (+)
Equal sign (=) (correct)

What is the correct step to create a formula in Excel after selecting a cell?

Type the asterisk sign (*)
Type the equal sign (=) (correct)
Type the plus sign (+)
Type the minus sign (-)

What is the formula to calculate the sum of 1 and 1 in Excel?

$=1-1$
$=1*1$
$=1+1$ (correct)
$1=+1$

What is communicated by reference(value) in Excel?

$A1(2)$ (C) Signup and view all the answers

Which arithmetic operator is used to subtract in Excel?

$-$ (A) Signup and view all the answers

What is the result of the formula $=A1-B2$ in Excel, based on the given values?

$274$ (D) Signup and view all the answers

What is the purpose of typing values into cells in Excel before using them in formulas?

To provide input for calculations (A) Signup and view all the answers

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 (D) Signup and view all the answers

What does the formula $=SUM(A1:A5)$ represent in Excel?

Adds values from cell A1 to A5 together (A) Signup and view all the answers

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 (B) Signup and view all the answers

What happens if you type a formula directly without clicking on cells in Excel?

The formula will be executed using default cell references (B) Signup and view all the answers

What is communicated by reference(value) example A2(320) in Excel?

The value of cell A2 as 320 (B) Signup and view all the answers