Basic Functions in Excel

What function in Excel adds all the numbers in a range of cells?

• Sum

• Count

• Max

• Average

Which keyboard shortcut can be used to quickly navigate to the bottom of a large spreadsheet in Excel?

• Ctrl + Up Arrow

• Ctrl + Right Arrow

• Ctrl + Down Arrow

• Ctrl + Left Arrow

What does the MAX function in Excel return?

• The average of a range

• The highest number in a range

• The count of numbers in a range

• The lowest number in a range

What is the purpose of the COUNT function in Excel?

• Adds all the numbers in a range

• Returns the highest number in a range

• Counts the number of cells with numbers in a range

• Calculates the average of a range

Which function in Excel counts cells with both numerical and text-based content?

• CountA

• Sum

• Average

• Max

What does the AVERAGE function in Excel do?

• Calculates the average of a range

• Adds all the numbers in a range

• Counts the number of cells with numbers in a range

• Returns the highest number in a range

Which function in Excel returns the smallest number in a range?

• Min

• Max

• Average

• Count

What is the purpose of the COUNTA function in Excel?

• Counts the number of cells with numbers in a range

• Counts cells with both numerical and text-based content

• Returns the highest number in a range

• Calculates the average of a range

What is the correct way to start a formula in Excel?

• By typing the formula directly in the cell

• By pressing Enter key

• By clicking on the Home tab

• By using the formula bar

When we write a formula in Excel we must always start with a ____ sign

• +

• /

• =

• *