Term 3-Week 8:Review

What is the primary purpose of Microsoft Excel?

• Writing documents

• Managing and analyzing data

• Designing graphics

• Sending emails

Which feature in Excel allows users to arrange data in ascending or descending order?

• Filtering

• Sorting

• Data Validation

• Formatting

What is the shortcut to copy and paste in Excel?

• Ctrl + X and Ctrl + Z

• Ctrl + C and Ctrl + V

• Ctrl + A and Ctrl + S

• Ctrl + P and Ctrl + D

Which of the following is NOT a function in Excel?

• =SUM()

• =AVERAGE()

• =MULTIPLY()

• =COUNT()

What is the default file format for an Excel workbook?

• .docx

• .pptx

• .xlsx

• .jpg

What does the COUNT function do in Excel?

• Counts the number of cells that contain numbers

• Counts all empty cells in a range

• Finds the highest number in a dataset

• Finds the lowest number in a dataset

Which function is used to find the smallest value in a dataset?

• =MIN()

• =COUNT()

• =MAX()

• =SUM()

What function returns the number of empty cells in a selected range?

• =COUNTIF()

• =COUNTBLANK()

• =IF()

• =SUM()

If you want to find the highest value in a column, which function should you use?

• =MIN()

• =COUNT()

• =MAX()

• =AVERAGE()

What does the COUNTIF function do?

• Counts all blank cells in a range

• Counts cells that meet a specific condition

• Finds the average of a set of numbers

• Sorts values in ascending order