NEW
Font size
WorksheetsCOMP1 Midterm Examination
Total questions: 80
Worksheet time: 2hrs 46mins
What symbol is used for inputting a formula in MS-Excel?
+ (plus sign)
= (equal sign)
– (dash sign)
; (semicolon)
What is the MS Excel 2019 formula that you want to get the sum of the numbers in the given range using cell reference for example from B1 to G10?
=SUM(B1:G10)
=SUM(B1G10)
=SUM(B1:G10)
=SUM(B1-G10)
Using the data above, what is the correct formula to display the AVERAGE of Student 1234?
=AVE(B2:E4)
=AVERAGE(B2:E2)
=SUM(B2:E4)
=SUM(B2:B4)
What is the result if the given formula for F4 is =AVERAGE(B4:E4)?
A. 70
B. 80
C. 90
D. 95
Using the formula =AVERAGE(B2:E2), What is the result in cell F2?
A. 74.75
B. 75.00
C. 75.50
D. 75.75
Using the formula =AVERAGE(B3:E3), What is the result?
A. 85.00
B. 86.00
C. 88.25
D. 90.00
What will be the value of F1 using this formula =(A1-B1)*C1?
281
283
284
285
What will be the value of F2 using this formula =(D1-B1)*E3?
A. 1848
B. -1838
C. -1848
D. -1828
Refer to the table above. What will be the value of F3 using this formula =E10*E5?
A. 9800
B. 9801
C. 9802
D. 9803
Refer to the table above. What will be the value of F4 using this formula =E7/B1?
1.12233
1.2323
1.30134
1.31343
What will be the value of F5 using this formula =(B4*C4)*D5?
A. 62100
B. 63100
C. 64300
D. 64400
Refer to the table above. What will be the value of F6 using this formula =(A2-A3)*C2?
-1791
1791
-1792
1792
Refer to the table above. What will be the value of F8 using this formula =sum(E1:E9)?
A. 603
B. 604
C. 605
D. 606
Refer to the table above. What will be the value of F7 using this formula =count(A1:A10)?
A. 5
B. 8
C. 10
D. 12
Refer to the table above. What will be the value of F9 using this formula =average(C3:C4)?
A. 49
B. 49.5
C. 50
D. 50.5
What will be the value of F10 using this formula =max(B1:B5)?
-100
100
200
300
It uses technologies like drones, automatic license plate readers, and even facial recognition. What type of information technology are these?
Rapid Identification Systems
Surveillance and Monitoring Systems
Predictive Policing
Cellphone Technology
Which of the following best describe a cell address?
The intersection of column and row
Alphanumeric value used to identify a specific cell
It is represented by numbers
It is represented by letters
An information technology that is used for prioritizing calls and revealing which responders are best equipped to help is what type of IT used in Criminal Justice?
Computer-Aided Dispatch (CAD)
Predictive Policing
Rapid Identification
Surveillance and Monitoring Systems
Biometrics provides measurements of physiological characteristics. Which of the following is an example of biometric data?
blood sample
CCTV footage
Iris recognition
hair sample
With the use of data, criminal justice professionals can determine what response methods work best for a certain type of situation is. What data importance is this?
Crime Prevention
Response Planning
Criminal Identification
Risk Assessment
What is the importance of data in risk assessment?
Can find connections between cases
Data can reflect the truancy rates, unemployment rates, etc.
For decision making and outcomes for responding to thousands of crimes
Determining whether the criminal is likely or unlikely to pose a threat to public safety
What application software is being describe that it is capable of storing and analyzing data in a tabular form?
Database Management Software
Presentation Software
Spreadsheet Software
Word Processing Software
What is a formula in MS Excel?
It is the active cell of the current worksheet
It pertains to numbers
It is the range of cells
Expressions that tell Excel what to do with the data
When one or more than one mathematical operator, and a number of simple formulas is what kind of formula?
Cell reference
Complex Formula
Simple Formula
PEMDAS
What do you call a predefined formula in Excel?
Cell
Formula
Function
Row
Which of the following shows the importance of data in criminal justice?
A. It allows law enforcement to accomplish more with fewer resources
B. With IT tools, it enhances the reliability of investigation
C. Only A
D. A and B
Evidences gathered from the crime scene like blood samples were collected and tested. What IT tools can be used for this type of data?
DNA Testing and Analysis
Enhanced Body Cams
Computer-Aided Dispatch
Predictive Policing
What is the use of data in criminal justice when using historical data to forecast criminal activity?
Computer-Aided Dispatch
DNA Testing and Analysis
Enhanced Body Cams
Predictive Policing
Cell phone technology very important to criminal justice for what purpose?
A. Electronic document services to streamline processing
B. Searching alleged offenders cellphone for texts and other records
C. Digital footprints for the suspects whereabouts
D. All of the above
Biometrics are biological measurements or physical characteristics than can be used to identify individual. Which of the following is an example of biometrics?
Color of the eye
Fingerprint
Length of hair
Size of the body
With the use of Artificial Intelligence (AI), it matches faces to images complied within a vast database is what information technology tool used in criminal justice?
Computer-Aided Dispatch
DNA Testing and Analysis
Facial Recognition Software
VR-Base Crime Scene Reconstruction
What information technology tool that relies on the sensor and notify dispatchers in the event of firearm discharges?
CCT Camera
Drone
Gunshot Detection Systems
VR-Based Crime Scene Reconstruction
Office productivity tools are important for effective communication, data management, and analysis within the criminal justice system. What productivity tool is used to organized and analyze data including statistical analysis?
Data Analysis Software
Database Management Software
Presentation Software
Spreadsheet Software
Which of the following best describe the importance of information technology tools in criminal justice?
It can conduct advanced statistical analysis and data mining
Law enforcement professionals can efficiently document cases, generate reports and extract valuable insights from data collected.
With the use of database management software, it can access, retrieve, store and organize large amount of data
Visual aids for presentations and briefings are important role of IT in criminal justice
Aspiring forensic professionals used this for in-depth training that prepares them to navigate real-world crime scenes. What IT tool is this?
Data Recovery Systems
Gunshot Detection Systems
Social Media Monitoring Tools
VR-Based Crime Scene Reconstruction
What is the first step to create a chart in Excel?
Select the chart type
Enter data into cells
Click on the chart icon
Select the data range
How can you change the chart type after creating a chart?
Right-click the chart and select “Change Chart Type”
Double-click the chart and choose “Chart Options”
Select the chart, go to the “Design” tab, and click “Change Chart Type”
Go to the “View” tab and select “Chart Types”
If you want to analyze the relationship between two variables, such as the number of patrols and the crime rate in a specific area, which chart type would you use in Excel?
Scatter Plot
Pie Chart
Gantt Chart
Heat Map
Which Excel chart type is best for showing the cumulative increase or decrease in crime rates over a period of time?
Bar Chart
Area Chart
Pie Chart
Highlight Table
Which of the following data visualization types in Excel is most suitable for showing the proportion of different crime types within a specific jurisdiction?
Bar Chart
Scatter Plot
Pie Chart
Timeline
Which Excel chart type is best for comparing arrest records across different precincts?
Histogram
Bar Chart
Heat Map
Area Chart
What type of chart would you use in Excel to identify the peak times for crime occurrences?
Scatter Plot
Gantt Chart
Histogram
Bullet Graph
In Excel, which chart type would be the most effective for visualizing the chronological sequence of criminal incidents?
Timeline/Line Chart
Pie Chart
Area Chart
Highlight Table
When visualizing crime hotspots in specific neighborhoods, which of the following Excel charts should be used?
Gantt Chart
Scatter Plot
Heat Map
Bullet Graph
Which Excel visualization is most useful for tracking the progress of ongoing investigations by displaying project timelines and milestones?
Bullet Graph
Scatter Plot
Gantt Chart
Histogram
To create a chart with a trendline, which option should you choose?
Click on the chart, then go to “Chart Tools” and select “Add Trendline”
Right-click on the chart and select “Insert Trendline”
Go to the “Insert” tab and choose “Trendline”
Use “Chart Options” to add a trendline
How does data contribute to crime prevention strategies?
By making crime statistics more accessible to the public.
By helping identify crime patterns and trends, which can inform targeted interventions.
By ensuring all criminal cases are resolved quickly.
By increasing the number of police officers on duty.
How can data analysis improve resource allocation in the criminal justice system?
By increasing the number of administrative positions in the system.
By providing insights on where resources are most needed, such as high-crime areas or underfunded programs.
By standardizing salaries for all criminal justice professionals.
By focusing solely on increasing the number of arrests made.
Why is data important for developing criminal justice policies?
It helps create more engaging media coverage.
It provides evidence to support or refute policy decisions.
It increases the budget for law enforcement agencies.
It makes the judicial process more time-consuming.
What is the basic feature of word processors like MS Word that allows you to remove a section of text from one place in a document and insert it anywhere else in the document?
Copy and Paste
Cut and Paste
Delete Text
Delete Paragraph
If you want to change the orientation of your document from portrait to landscape, where would you go?
Page Layout
Home Tab
View Tab
Suddenly the MS Word that you are using does not display the ruler in the document that you are typing. What happened?
Your MS Word application has been infected by virus
The version of Word that you are using does not support the use of ruler
The ruler has been unchecked in the View Toolbar menu
The option has been deleted from the tab
Which of the following best describes the purpose of styles in Word?
To change the font size only
To apply consistent formatting throughout a document
To create hyperlinks
To insert images
When you apply bold formatting to text, what effect does it have on the text's appearance?
It changes the text color
It increases the font size
It makes the text darker and more prominent
It italicizes the text
If you want to quickly change the font of an entire document, which method would be most efficient?
Change the font for each paragraph individually
Select all text and change the font from the Home tab
Use the "Format Painter" on each section
Save the document and reopen it
Which of the following font attributes would you use to emphasize a word in a document?
Underline
Italics
Bold
All of the above
When editing a document, why is it important to use consistent font styles and sizes?
It makes the document look unprofessional
It enhances readability and maintains a professional appearance
It increases the file size
It has no impact on the document
What feature of MS Word that enable the user to customized the document including page numbers, date, footnotes or text for all pages?
Headers and Footers
Page Numbers
Page Margins
Page Layout
When proofreading a document, which font-related feature can help you identify potential errors?
Font Size
Spell Check
Text Highlighting
Page Numbers
How do you save a document with a new name in Microsoft Word?
Click "Save"
Click "Save As"
Press Ctrl+S
None of these
Which view in Microsoft Word is used for editing the document as it will appear when printed, including margins, headers, and footers?
Print Layout
Read Mode
Web Layout
Outline
You want to double-space the lines in a paragraph. Where can you find the option to do this?
Paragraph Group in the "Home" tab
Page Layout Tab
Insert Tab
View Tab
Which tab contains the option to change the page margins?
Layout
Home
Review
File
In which tab can you find the "Spell Check" feature?
Review
Home
Insert
References
To insert a picture or a shape into your document, which tab do you use?
Insert
Design
View
File
Which keyboard shortcut do you use to save the document you are working on?
Ctrl + N
Ctrl + C
Ctrl + S
Ctrl + P
Which keyboard shortcut cuts selected text so you can move it elsewhere?
Ctrl + C
Ctrl + X
Ctrl + Z
Ctrl + V
Which keyboard shortcut do you use to copy selected text in MS Word?
Ctrl + X
Ctrl + V
Ctrl + C
Ctrl + Z
What is the shortcut for pasting copied text?
Ctrl + X
Ctrl + P
Ctrl + V
Ctrl + C
You need to start a new paragraph in your document. What should you press on the keyboard?
Spacebar
Shift
Enter
Tab
You are creating a summary of the topics you included on your document. To avoid going back and forth on the document, you decided to split the screen of the document to have a view two parts of the document at once. Which is the best TAB of MS Word can be useful in this situation?
Format
File
Home
View
You created a document about the "Application of Computer in our Daily Lives" you decided to insert charts, picture, and shapes to add your document to communicate to your reader visually. Which is the best TAB of MS Word can be useful in this situation?
Insert
Mailing
Reference
Review
You are now finish creating and editing your document. Now, you notice that are too many pages on your document. To lessen the pages, you decided to adjust the margin and orientation of the paper. Which is the best TAB of MS Word can be useful in this situation?
Page Layout
Insert
Mailing
Review
Mary is writing a research paper; she wants to put a citation and create a bibliography. Which is the best TAB of MS Word can be useful in this situation?
References
Page Layout
Home
Format
What Geographic Information System (GIS) intended for?
To create 3D models of landscapes
To analyze and visualize spatial data
To store large databases
To perform statistical analysis
If a city planner wants to assess the impact of a new park on local traffic patterns, which GIS functions would be most useful?
Data entry
Spatial analysis
Data Visualization
Database Management
Which of the following data types is commonly used in GIS to represent geographic features?
Raster data
Vector data
Both A and B
metadata
If a GIS analyst wants to overlay multiple layers of data (e.g., population density, land use, and transportation networks), which GIS operation should they use?
Buffering
Clipping
Layering
Geocoding
If you were tasked to choose a GIS application for emergency response, what key feature will you consider?
Aesthetic design elements
Real-time data updates and alerts
Extensive historical data
Complex algorithms for data processing
