WorksheetsUjian Tengah Semester Informatika
Total questions: 20
Worksheet time: 20mins
What is the main function of Microsoft Excel?
Word processor
Data and number processor
Media player
Presentation maker
What is the term for a worksheet in Excel?
Document
Slide
Worksheet
Page
What is the correct formula to sum cells A1 to A10?
=AVERAGE(A1:A10)
=COUNT(A1:A10)
=SUM(A1:A10)
=MAX(A1:A10)
What is the function of the command =MAX?
Calculate average
Sum values in cells
Find the highest value
Find the lowest value
What is meant by 'cell' in Excel?
A collection of worksheets
A row in a worksheet
The intersection of a row and a column
A chart in a worksheet
What is the function of the formula '=AVERAGE(B1:B5)'?
Sum values B1 to B5
Find the average of B1 to B5
Find the highest value B1 to B5
Find the lowest value B1 to B5
The '$' symbol in an Excel formula is used to...
Create absolute references
Create relative references
Calculate percentages
Display currency values
To filter data in Excel, you can use the feature...
Sort
Filter
PivotTable
Conditional Formatting
What is the function of the 'Conditional Formatting' feature?
Change text format
Change number format
Change cell format based on certain conditions
Create charts from data
To create a bar chart in Excel, we use the menu...
Insert
Data
Formula
Review
One of the uses of charts in data analysis is...
Making data harder to understand
Presenting data in a more visually appealing way
Calculating average data
Sorting data in ascending order
The SUMIF function in Excel is used to...
What is meant by data analysis? And why is data analysis important in decision making?
Mention 2 simple ways to present data!
Mention 3 examples of applications used in data analysis!
If you want to calculate the total sales of Product A, the formula used is...
=SUMIF(A2:A5,"Product A", B2:B5)
=SUMIF(A2:A5,"Product B", B2:B5)
=COUNTIF(A2:A5,"Product A")
=COUNTIF(A2:A5,"Product A", B2:B5,">50")
The COUNTIF function is used to count the number of cells in the range A1:A10 that contain numbers greater than 50. The formula used is...
=COUNTIF (A1:A10,".50")
=SUMIF(A1:A10,">50")
=COUNTIFS(A1,A10,">50")
=COUNTIF(A1:A10,">=50")
To find the lowest value in a range using...
=MAX
=MIN
=AVERAGE
=SUM
If the range A1:A6 contains numbers, text, and empty cells, then the formula used to find the empty cells is...
=MAX(A1:A6)
=COUNT(A1:A6)
=COUNTBLANK(A1:A6)
=SUM(A1:A6)
To round the result of SUM upwards using the formula...
=ROUND
=ROUNDUP
=ROUNDDOWN
=SUM
