Infin'IT

What does the function "SUM" do in Excel?

• Subtracts Numbers

• Divides Numbers

• Adds Up a Range of Numbers

• Multiplies Numbers

Ravi, Sharath, and Bharath are working on a spreadsheet. Which symbol is used to begin a formula in Excel?

• @

• -

• =

• +

How can you make text bold in Excel?

• Ctrl + B

• Alt + B

• Shift + B

• Ctrl + I

What is the shortcut for "Cut" in Excel?

• Ctrl + C

• Ctrl + X

• Ctrl + V

• Ctrl + Z

Which function is used to find the average of a range of numbers in Excel?

• AVG

• AVERAGE

• AVEG

• AVERAGED

What does the function "COUNTA" do in Excel?

• Counts the number of cells in a range

• Counts cells with numbers

• Counts non-empty cells in a range

• Adds up a range of numbers

How can you change the font color in Excel?

• Alt + F

• Ctrl + C

• Alt + H, then F, then C

• Ctrl + F

What is the purpose of the "AutoSum" button in Excel?

• Adds up a range of numbers

• Multiplies numbers

• Divides numbers

• Subtracts numbers

How can you format numbers as currency in Excel?

• Format Cells > Currency

• Format Cells > Number > Currency

• Format Cells > Font > Currency

• Format Cells > Alignment > Currency

Which ribbon in Excel contains the "Font" and "Alignment" options?

• Home

• Insert

• Format

• Data