Excel Formulas and Functions Basics

What is the primary purpose of using formulas in spreadsheets like Excel?

• To create charts and graphs

• To organize data alphabetically

• To calculate math problems

• To design visually appealing layouts

Which symbol is used for multiplication in Excel formulas?

• +

• -

• *

• /

What symbol must always come first when entering a formula in Excel?

• +

• -

• =

• *

If you want to add the values in cells D10 and D11 in Excel, what would the formula look like?

• D10+D11

• =D10+D11

• SUM(D10:D11)

• ADD(D10,D11)

What is the main advantage of using cell references in Excel formulas instead of directly typing numbers?

• It makes the spreadsheet look neater

• It allows for automatic recalculation when original values change

• It prevents errors in data entry

• It speeds up the initial formula creation

How can you edit an existing formula in Excel?

• Right-click the cell and select 'Edit'

• Press F2

• Double-click the cell

• Select the cell and press 'Delete'

What is the "point-and-click" method used for when creating formulas in Excel?

• To select multiple cells for formatting

• To quickly enter cell addresses into a formula

• To navigate between different worksheets

• To apply conditional formatting

What is the purpose of the "fill handle" in Excel when working with formulas?

• To change the font size of the formula

• To delete a formula from multiple cells

• To duplicate a formula to several adjacent cells

• To highlight cells containing formulas