NEW
Font size
WorksheetsPengenalan Microsoft Excel
Total questions: 20
Worksheet time: 20mins
What is the main function of Microsoft Excel?
Create presentations
Process numerical data
Create animations
Edit videos
What is the default file extension of Microsoft Excel?
.docx
.xlsx
.pptx
The SUM() function in Microsoft Excel is used to:
Count data
Sum values in a range
Round numbers
Sort data
To insert a function in Excel, you can use the shortcut key:
Alt + F1
Ctrl + F
Shift + F11
Alt + =
What is the use of the IF() function?
Sum numbers in a range
Compare two values
Create logical statements
Combine text
What is the name of the small box in the upper left that shows the active location?
Toolbar
Name Box
Formula Bar
Ribbon
The keyboard shortcut to save an Excel file is:
Ctrl + S
Ctrl + P
Ctrl + Z
Ctrl + O
To print an Excel file, you can use the shortcut:
Ctrl + C
Ctrl + P
Ctrl + X
Ctrl + Z
The function of COUNT() is:
Count the number of characters in a cell
Count the number of cells containing numbers
Count the number of vowels
Add numbers in a range
What is the name of the main tab that contains options like 'Home,' 'Insert,' and 'Page Layout'?
Ribbon
Menu Bar
Status Bar
Toolbar
The VLOOKUP() function is used to:
Search for a value in a specific column
Round numbers up
Combine text
Create a pivot table
The shortcut to copy cell content is:
Ctrl + V
Ctrl + X
Ctrl + C
Ctrl + Z
To combine the contents of several cells into one, you can use the function:
CONCATENATE()
SPLIT()
JOIN()
TEXT()
What is the use of the 'Freeze Panes' feature?
Freeze the Excel file
Create a chart
Lock rows or columns to remain visible while scrolling
Automatically save the file
The shortcut to add a new row is:
Ctrl + N
Ctrl + ;
Ctrl + Shift + +
Ctrl + Tab
What is the use of the AVERAGE() function?
Count numbers
Calculate the average value
Find the largest number
Sort data
What happens when you press the Ctrl + Z key?
Delete data
Undo the last command
Redo the last command
Save the document
What is the function of PivotTable in Excel?
Create a dynamic table to analyze data
Add rows to a table
Round numbers
Convert data to a chart
What is the use of the TRIM() function?
Change uppercase letters to lowercase
Remove extra spaces in text
Count letters
Combine two texts
To insert a chart in Excel, you can use the tab:
Data
Insert
Home
View
