Search Header Logo

Comp1 Final Exam (Part 2)

Authored by Junice Ilagan

Computers

University

Used 3+ times

Comp1 Final Exam (Part 2)
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

50 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

Average

Count

Max

Min

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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)

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

Grid point

Cell

Node

Junction

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

Ribbon

Workspace

Navigator

Sheet Tab

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

Fx

= (equal sign)

- (dash sign)

: (semicolon)

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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)

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?