Excel Essentials: Mastering the Basics

What function in Excel gives you the sum of a range of cells?

• `=AVERAGE()`

• `=SUM()`

• `=TOTAL()`

• `=ADD()`

How do you start a basic formula in Excel?

• +

• =

• @

• %

Which function would you use to find the highest number in a series of numbers in Excel?

• `=MAX()`

• `=HIGH()`

• `=UPPER()`

• `=TOP()`

What is the correct syntax for referencing cell A1 in another formula in Excel?

• A1

• #A1

• $A$1

• &A1

Which of the following functions would you use to calculate the average value of a range of cells?

• `=SUM()`

• `=AVERAGE()`

• `=MEAN()`

• `=TOTAL()`

How can you copy the formula from one cell to another without changing the cell references?

• Drag the fill handle

• Use the copy and paste feature

• Use absolute cell references

• All of the above

What symbol is used to make a cell reference absolute in a formula?

• #

• $

• &

• %

Which function can be used to count the number of cells in a range that contain numbers?

• `=COUNT()`

• `=NUMBERCOUNT()`

• `=COUNTNUMS()`

• `=COUNTNUMBERS()`

What does the function `=IF()` do in Excel?

• Checks whether a condition is met, and returns one value if true and another value if false

• Increments the value of a cell by a fixed number

• Integrates a cell into a formula

• Identifies the font style in a cell

What is the result of the formula `=ROUND(2.15, 1)` in Excel?

• 2

• 2.1

• 2.2

• 2.15