1. In MS Excel, which function is used to add up the numbers in a range of cells?

• SUM

• AVG

• MAX

• MIN

2. Which keyboard shortcut in MS Excel allows you to undo your last action?

• Ctrl+C

• Ctrl+Z

• Ctrl+X

• Ctrl+V

3. What does the COUNT function in MS Excel do?

• Counts the number of cells in a range that contain numbers

• Counts the number of cells in a range that contain text

• Counts the number of cells in a range that meet a specified condition

• Counts the number of cells in a range that contain formulas

4. Which of the following is NOT a valid file extension for an MS Excel workbook?

• .xlsx

• .xls

• .docx

• .xlsm

5. Which tab in the MS Excel ribbon contains commands related to formatting cells?

• Home

• Data

• Insert

• Review

 

 

6. What does the autofill handle in MS Excel allow you to do?

• Insert pre-defined text into adjacent cells based on the pattern of existing text

• Insert formulas into adjacent cells based on the pattern of existing formulas

• Insert new columns or rows into a worksheet

• Insert predefined shapes and objects into a worksheet

7. Which function in MS Excel is used to find the average value of a range of cells?

• COUNT

• MIN

• MAX

• AVERAGE

8. Which chart type in MS Excel is best suited for comparing values across categories?

• Pie chart

• Line chart

• bar chart

• Scatter chart

9. Which keyboard shortcut in MS Excel allows you to save the current workbook?

• Ctrl+C

• Ctrl+X

• Ctrl+S

• Ctrl+V

10. Which function in MS Excel is used to find the smallest value in a range of cells?

• MIN

• AVG

• COUNT

• MAX