WorksheetsQuiz Jaringan Komputer
Total questions: 26
Worksheet time: 13mins
What is meant by a LAN network?
A network that connects computers over a very large area such as a country or continent
A network that connects computers in a limited area such as a building or office
A network that connects personal devices like smartphones and laptops over short distances
A network that connects several cities within a metropolitan area
The type of computer network that connects several LANs in one city is called...
WAN
PAN
MAN
CAN
What hardware is typically needed to build a LAN?
Cables, switches, routers
Satellites and antennas
Printers and scanners
Modems and smartphones
What is the main function of a computer network in sharing hardware?
Reducing the number of computers used
Sharing resources like printers and hard drives among network users
Limiting internet access
Increasing the size of data files
The computer network that has the widest range and usually connects computers in various countries or continents is...
LAN
MAN
WAN
PAN
The smallest unit in computer data size that only has values of 0 and 1 is called...
Byte
Bit
Kilobyte
Megabyte
If 1 kilobyte (KB) is equal to 1024 bytes, how many bytes are in 3 KB?
3000 bytes
3072 bytes
2048 bytes
1024 bytes
How do you open the Microsoft Excel application on a computer?
Right-click on the desktop and select 'New'
Click the Microsoft Excel icon on the Start menu or desktop
Open a browser and type www.microsoft.com
Press Ctrl + C on the keyboard
Besides Microsoft Excel, what other popular spreadsheet software is there?
Microsoft Word
Google Sheets
Adobe Photoshop
VLC Media Player
Which icon is typically used to open the Microsoft Excel application?
Icon with the letter 'W' in blue
Icon with the letter 'E' in green
Icon with a camera image
Icon with the letter 'P' in red
To open a data file that has already been saved in Microsoft Excel, what is the first step you should take?
Create a new file
Click the 'File' menu and select 'Open'
Click the printer icon
Close the Excel application
In Microsoft Excel, to add a border to a table, which icon should you use?
Paintbrush
Border (icon with a box and border)
Bold (bold text)
Fill Color (paint bucket)
What function is used to sum numbers in a range in Excel?
AVERAGE
SUM
MAX
MIN
What function is used to sum numbers in a range in Excel?
AVERAGE
SUM
MAX
MIN
If you want to find the average of numbers in cells A1 to A5, the correct formula is...
=SUM(A1:A5)
=MAX(A1:A5)
=AVERAGE(A1:A5)
=MIN(A1:A5)
What function is used to find the largest value from a set of data in Excel?
MIN
MAX
SUM
AVERAGE
If you want to find the smallest value from data in cells B1 to B10, the correct formula is...
=MIN(B1:B10)
=MAX(B1:B10)
=SUM(B1:B10)
=AVERAGE(B1:B10)
The correct formula to sum values from cells C1 to C4 is...
=SUM(C1:C4)
=SUM(C1+C4)
=SUM(C1-C4)
=SUM(C1;C4)
The first step to open a new document in Microsoft Excel is...
Click the 'File' menu and select 'New'
Click the 'Edit' menu and select 'New'
Click the 'View' menu and select 'New'
Click the 'Help' menu and select 'New'
After selecting the 'File' and 'New' menu, what usually must you do to open a new document?
Select a blank template (Blank workbook)
Save the old document
Close the Excel application
Open an existing document
Besides through the 'File' menu, a quick way to open a new document in Microsoft Excel is by pressing the button...
Ctrl + N
Ctrl + O
Ctrl + S
Ctrl + P
How to open a new document (blank workbook) in Microsoft Excel?
Click File > Open > select an existing file
Click File > New > select Blank workbook
Click Edit > New > select Blank workbook
Click View > New > select Blank workbook
How to correctly open the Microsoft Excel application on a computer?
Click the Start button, select All Programs, then click Microsoft Excel
Right-click on the desktop and select 'New'
Open a browser and type www.microsoft.com
Press Ctrl + S on the keyboard
The first correct step to save data in Microsoft Excel is...
Click the File menu, then select Save or Save As
Click the Edit menu, then select Copy
Click the View menu, then select Zoom
Click the Insert menu, then select Table
Which of the following statements is the main benefit of a computer network?
Facilitates communication and data sharing among users in a network
Reduces the number of computers used in one office
Makes computers slower in data processing
Eliminates the need for hardware in computers
Which device is commonly used to connect multiple computers in a network?
Printer
Switch
Monitor
Keyboard
