Comp1 Final Exam (Part 2)

What MS Excel function that will display the lowest value from a given range?

• Average

• Count

• Max

• Min

In the crime analysis report, the incident counts are stored in cells B2 to B31 for each day of the month. To find the total number of incidents reported in a month, which Excel formula should you use?

• =MIN(B2:B31)

• =MAX(B2:B31)

• =SUM(B2:B31)

• =AVERAGE(B2:B31)

Your team is collaborating on a budget report, and you want to ensure precision in the calculations. Which element of the spreadsheet interface should you primarily rely on for accurate data input and editing?

• Taskbar

• Tool Bar

• Formula Bar

• Sheet tab

In a spreadsheet, which term describes the point where a row and a column intersect, requiring analysis?

• Grid point

• Cell

• Node

• Junction

Which feature, located in the lower left corner of the screen, identifies each open worksheet in a spreadsheet program?

• Ribbon

• Workspace

• Navigator

• Sheet Tab

What symbol is used for inputting a formula in MS-Excel 2019?

• Fx

• = (equal sign)

• - (dash sign)

• : (semicolon)

To calculate the average response time for emergency calls, the response times are listed in cells D2 to D50. Which Excel formula should you apply?

• =MAX(D2:D50)

• =AVERAGE(D2:D50)

• =SUM(D2:D50)

• =MIN(D2:D50)

MS Excel function that will display the highest value from the given range?

• Average

• Count

• Max

• Min

Your team is preparing a presentation that requires visually appealing representations of data trends. What feature within a spreadsheet application allows you to create these visual representations?

• Chart

• Diagram Tool

• Grapher

• Visualizer

You need to organize a large dataset by arranging information alphabetically. Which process in a spreadsheet application would be most suitable for this task?

• Filtering

• Grouping

• Sorting

• Aligning