Database&Spreadshet_GR8_4/2024

What does the function SUMIFS do in Excel?

• Sums values in a range that meet multiple criteria

• Sums values in a range that meet a single criterion

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

• None of the above

What is the feature used to link tables together in the database?

• Foreign key

• Primary key

• Attribute

• Relationship

Which function is used to find the highest value in a range in Excel?

• MAX

• MIN

• SUM

• AVERAGE

Which attribute is used to control the format of data added to a database table?

• Validation rule

• Format

• Field size

• Input mask

What does the function TRANSPOSE do in Excel?

• Converts text to uppercase

• Returns the transpose of a matrix

• Converts a column into a row or vice versa

• None of the above

What does the function COUNT do in Excel?

• Counts the number of empty cells in a range

• Counts the number of cells containing numbers in a range

• Counts the number of non-empty cells in a range

• None of the above

Which function is used to sum values in Excel?

• COUNT

• AVERAGE

• SUM

• MAX

What does the function COUNTBLANK do in Excel?

• Counts the number of non-blank cells in a range

• Counts the number of blank cells in a range

• Checks if a cell is blank

• None of the above

Which data type in Access is used to store monetary values?

• Money

• Decimal

• Currency

• Double

Which of the following is not a valid Excel data type?

• Text

• Number

• Date

• Image