NEW
Font size
WorksheetsINFORMATIKA KELAS XII 2
Total questions: 25
Worksheet time: 25mins
What function is used in Excel to calculate the average of data?
SUM
MAX
MIN
AVERAGE
How to correctly delete data in an Excel worksheet?
Right-click and select "Delete"
Press the "Esc" key
Select "Insert"
Press the "F1" key
What is the function of the formula =SUM(D1:D12) in Microsoft Excel?
Calculating the average of data
Summing data from D1 to D12
Finding the maximum value
Counting the number of rows
What is the correct step to use the Copy and Paste feature in Excel?
Select the data, press Ctrl+X, then Ctrl+V at the destination
Select the data, press Ctrl+P, then Ctrl+S at the destination
Select the data, press Ctrl+C, then Ctrl+V at the destination
Select the data, press Ctrl+Z, then Ctrl+Y at the destination
What function is used to find the maximum value in Excel?
MIN
SUM
MAX
AVERAGE
What is the difference between SUM and AVERAGE in Microsoft Excel?
SUM for average, AVERAGE for total
SUM for total, AVERAGE for average
SUM for maximum, AVERAGE for minimum
SUM for minimum, AVERAGE for maximum
What is the function of the formula =MIN(B1:B12)?
Calculate the total data
Find the minimum value from B1 to B12
Calculate the average data
Find the maximum value from B1 to B12
What is the function of the formula =SUM(C3:C8)?
Calculating the average of the data
Summing the data from C3 to C8
Finding the maximum value
Counting the number of rows
What is the function of the formula =AVERAGE(A2:C10)?
Calculate the total data from A2 to C10
Calculate the average of the data from A2 to C10
Find the maximum value from A2 to C10
Find the minimum value from A2 to C10
What character is used for addition in Microsoft Excel?
*
+
-
/
What feature is used to organize data in Excel?
Graph
Table
Formula
Filter
To make accurate decisions in data processing, what does Excel provide?
Complete features
Simple features
Limited features
Manual features
The first step in using Microsoft Excel to organize data is?
Creating a table
Inputting data
Creating a chart
Using functions
Why is it important to save files regularly in Microsoft Excel?
To avoid data loss
To create graphs
To calculate data
To input data
How to input data into Microsoft Excel?
Input data into the table
Delete data from the table
Change the color of the table
Save the file without data
Why is it important to use the correct formula in Excel?
So that data can be processed correctly
So that the file can be saved
So that the table becomes colored
So that data can be deleted
If you want to calculate the total data, what formula should be used?
SUM
AVERAGE
FILTER
CHART
The second step in using Microsoft Excel is?
Inputting data into the table
Creating a chart
Using functions
Saving the file
How to make the right decisions with data in Excel?
By understanding Microsoft Excel material
By deleting data
By changing the color of the table
By adding random data
Why are graphs important in data processing in Excel?
To visualize data
To delete data
To change table colors
To save files
What is the function of the formula =COUNTIF(A1:A10, ">5") in Microsoft Excel?
Find the minimum value from A1 to A10
Calculate the average of data greater than 5
Find the maximum value from A1 to A10
Count the number of data points greater than 5
What function is used to concatenate text in Excel?
AVERAGE
SUM
TEXTJOIN
CONCATENATE
Which of the following is not a type of chart available in Excel?
Line Chart
Bar Chart
Text Chart
Pie Chart
What is meant by the VLOOKUP function in Excel?
Adds all values in a single column
Calculates the average of the existing data
Displays a chart of the selected data
Searches for a value in the first column and returns a value from another column
How do you sort data in Excel?
By changing the cell color
By using the Sort feature
By deleting unnecessary data
By using the Filter feature
