
Comp1 Final Exam (Part 2)
Quiz
•
Computers
•
University
•
Practice Problem
•
Hard
Junice Ilagan
Used 3+ times
FREE Resource
Enhance your content in a minute
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

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
Already have an account?
Similar Resources on Wayground
53 questions
Modules 1-2
Quiz
•
University
50 questions
Test 4
Quiz
•
University
50 questions
Kiến thức về xử lý mảng 1 chiều trong C++
Quiz
•
University
50 questions
ict 1-50
Quiz
•
University
50 questions
PENGUKURAN DAN PENYAMBUNGAN FIBER OPTIK
Quiz
•
University
50 questions
ICT 151-200
Quiz
•
University
50 questions
kuis Jaringan Internet
Quiz
•
9th Grade - University
53 questions
System Analysis and Design (Prelim Exam)
Quiz
•
University
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
54 questions
Analyzing Line Graphs & Tables
Quiz
•
4th Grade
22 questions
fractions
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade
