24S1 ITA Topic 2 Excel Quiz

What are these called?

• Rows
• Cells
• Columns
• Letters

What are these called?

• Rows
• Cells
• Columns
• Letters

What is this called?

• Formula
• Cell
• Worksheet
• Label

What category should you choose to turn the number to $527.84

• Number

• Currency

• Date

• Accounting

Which type from the Custom Category allows you to hide the value from display?

• ;;;
• :::
• General
• !!!

What is the value of cell A14 when you drag the green square to it as shown in the image?

• 7
• 6
• 56
• Nothing

What is this known as?

• Cell reference
• Formula
• Value
• Active cell

What is the result of this calculation?

• 25
• 75
• 100
• 125

Which of the followings is not a correct formula to use SUM in Excel?

• =SUM(B3:B9)
• =SUM(B3,B9)

• =SUM(B3)

• SUM(B3:B9)

What would be a correct formula to rank a set of values in DESCENDING order in Excel?

• =RANK(B3, (B3:B9), 1)
• =RANK(B3, (B3:B9))
• =RANK(B3, (B3:B9), 0)
• =RANK(B3, (B3:B9), A)