Trial Exam For Final 1 - Attempt Review

Trial exam for final 1: Attempt review https://smartlearning.must.edu.eg/mod/quiz/review.php?attempt=3220...
Started on Thursday, 17 October 2024, 8:43 PM

State Finished
Completed on Thursday, 17 October 2024, 8:46 PM
Time taken 2 mins 47 secs
Marks 4.00/261.00
Grade 0.15 out of 10.00 (1.53%)
Question 1
Incorrect
Mark 0.00 out of 1.00
Which type of distance learning involves students not being physically present for the class?
a. Synchronous learning
b. Hybrid distance education
c. Video conference 
d. Asynchronous learning
The correct answer is: Asynchronous learning
Question 2
Correct
Which of the following is an example of hardware in a computer system?
a. Operating System
b. Photoshop
c. Microsoft Word
d. Keyboard 
The correct answer is: Keyboard
Question 3
Correct
What are the options available for students in distance learning?
a. Video conferencing possibilities

b. All answers are true 
c. A more flexible timetable
d. Options to suit almost everyone's requirements
1 of 77 10/17/2024, 8:47 PM
d. Options to suit almost everyone's requirements
The correct answer is: All answers are true
Question 4
Correct
How can you unhide a row in Excel 2016?
a. Select the rows above and below the hidden row, right-click, and choose "Unhide" 
b. Click on the "Home" tab, choose "hide Row" under the "Cells" section
c. Click on the "Format" tab, choose "hide Row" under the "Visibility" section
The correct answer is: Select the rows above and below the hidden row, right-click, and choose "Unhide"
Question 5
Correct
Which quality is helpful for distance learning? Select one:
a. Carelessness
b. Perfectionism
c. Flexibility 
d. Rigidness
The correct answer is: Flexibility
Question 6
Not answered
Marked out of 1.00
E-learning is most commonly connected with activities that combine computers and..... Select one:
a. interactive networks
b. job
c. students
d. workshop
The correct answer is: interactive networks
Question 7
Not answered
2 of 77 10/17/2024, 8:47 PM
Not answered
Marked out of 1.00
What is the purpose of the "Create a copy" checkbox in the Move or Copy dialog box in Excel 2016?
a. To create a duplicate copy of the original worksheet

b. To move the original worksheet to a new location
c. To delete the original worksheet after copying
d. To rename the copied worksheet
The correct answer is: To create a duplicate copy of the original worksheet
Question 8
Not answered
Marked out of 1.00
To Show or hide the Details pane, use………………
a. ALT+shift+P
b. ALT+N
c. ALT+C
d. ALT+H
The correct answer is: ALT+shift+P
Question 9
Not answered
Marked out of 1.00
Which of the following is NOT a benefit of distance education?
a. Physical presence in the classroom

b. Flexibility
c. Interaction with the instructor and peers
d. Cost savings
The correct answer is: Physical presence in the classroom
Question 10
Not answered
Marked out of 1.00
Do all devices require an Operating System to function properly?
a. No, devices can function without an Operating System.
3 of 77 10/17/2024, 8:47 PM
a. No, devices can function without an Operating System.

b. Only smartphones require an Operating System to function.
c. Only tablets require an Operating System to function.
d. Yes, all computers, tablets and smartphones need an Operating System to function properly.
The correct answer is: Yes, all computers, tablets and smartphones need an Operating System to function properly.
Question 11
Not answered
Marked out of 1.00
In Excel 2016, which function would you use to find the highest value in a range of cells?
a. AVERAGE
b. MIN
c. SUM
d. MAX
The correct answer is: MAX
Question 12
Not answered
Marked out of 1.00
…………is the storage space in a computer where data is processed and stored
a. External memory
b. Computer memory
c. Secondary memory
d. Hard memory
The correct answer is: Computer memory
Question 13
Not answered
Marked out of 1.00
The worksheet tab color can't be changed
a. False
b. True
The correct answer is: False
4 of 77 10/17/2024, 8:47 PM
Question 14
Not answered
Marked out of 1.00
To insert column, right click on the column letter that is before the column you want to insert.
a. False
b. True
Question 15
Not answered
Marked out of 1.00
Which option should you select in the Page Setup dialog box to adjust the page orientation for printing a worksheet in Excel 2016?
a. Sheet
b. Header/Footer
c. Margins
d. Orientation
The correct answer is: Orientation
Question 16
Not answered
Marked out of 1.00
Hybrid distance education is a type of blended learning Select one:
a. True
b. False
The correct answer is: True
Question 17
Not answered
Marked out of 1.00
How do you give data to a computer?
a. By speaking to it
b. By writing it on a piece of paper
c. By shouting at it
5 of 77 10/17/2024, 8:47 PM
c. By shouting at it
d. By typing it using a keyboard
The correct answer is: By typing it using a keyboard
Question 18
Not answered
Marked out of 1.00
What is local backup?
a. Backing up data on an email account.

b. Backing up data on an external hard disk, CD, flash drives, etc.
c. Backing up of data onto several servers on the internet.
d. Backing up data on a cloud storage service.
The correct answer is: Backing up data on an external hard disk, CD, flash drives, etc.
Question 19
Not answered
Marked out of 1.00
Which of the following statements about ROM is true?
a. ROM is a non- volatile memory

b. ROM is a temporary memory
c. ROM can be modified
d. ROM contains only user-generated programs
The correct answer is: ROM is a non- volatile memory
Question 20
Not answered
Marked out of 1.00
Which of the following is a primary storage device?
a. CD/DVD
b. Hard disk drive
c. RAM
d. Flash memory
The correct answer is: RAM
6 of 77 10/17/2024, 8:47 PM
Question 21
Not answered
Marked out of 1.00
To apply a border to a range of cells in Excel 2016, which option should you select?
a. Home > Font

b. Home > Fill
c. Home > Alignment
d. Home > Borders
The correct answer is: Home > Borders
Question 22
Not answered
Marked out of 1.00
Which of the following is a special feature of a computer that enables it to perform tasks quickly?
a. Accuracy
b. Attentiveness
c. Huge storage
d. Speed
The correct answer is: Speed
Question 23
Not answered
Marked out of 1.00
In Excel 2016, which function would you use to concatenate two or more text strings into a single cell?
a. CONCAT
b. TEXT
c. FIND
d. LEN
The correct answer is: CONCAT
Question 24
Not answered
Marked out of 1.00
What is an Operating System?
7 of 77 10/17/2024, 8:47 PM
What is an Operating System?
a. It is a type of computer virus that can harm your system.

b. It is a tool used to create new hardware devices.
c. It is a type of programming language used to develop software applications.
d. It is the backbone of a computer system that controls and manages the entire operations of a computer.
The correct answer is: It is the backbone of a computer system that controls and manages the entire operations of a computer.
Question 25
Not answered
Marked out of 1.00
What is the keyboard shortcut to move to the previous cell in a row in Excel 2016?
a. Enter
b. Tab
c. Spacebar
d. Shift + Tab
The correct answer is: Shift + Tab
Question 26
Not answered
Marked out of 1.00
You can view a formula by double-clicking the cell that contains the formula.
a. False
b. True
Question 27
Not answered
Marked out of 1.00
How can you freeze the top row or leftmost column in Excel 2016?
a. Click on the "Home" tab, then select "Freeze Panes"

b. Right-click on the row or column you want to freeze, choose "Freeze Panes", then select "Freeze Top Row" or "Freeze First Column"
c. Click on the "Page Layout" tab, then select "Freeze Panes"
d. Go to the "View" tab, choose "Freeze Panes", then select "Freeze Top Row" or "Freeze First Column"
The correct answer is: Go to the "View" tab, choose "Freeze Panes", then select "Freeze Top Row" or "Freeze First Column"
8 of 77 10/17/2024, 8:47 PM
The correct answer is: Go to the "View" tab, choose "Freeze Panes", then select "Freeze Top Row" or "Freeze First Column"
Question 28
Not answered
Marked out of 1.00
You change the Windows 10 display language
a. True
b. False
Question 29
Not answered
Marked out of 1.00
Who can use Google Classroom?
a. Only after-school programs and homeschoolers

b. Only teachers and students in schools
c. Only administrators and families
d. Anyone with a personal Google account
The correct answer is: Anyone with a personal Google account
Question 30
Not answered
Marked out of 1.00
What are E-Readers?
a. A device solely for reading digital books

b. Touch-screen portable gadgets that change the way instructional content is stored, shown, and transmitted
c. A software program designed specifically for mobile devices
d. A device that allows users to access the internet, download music, make calls, and send text messages
The correct answer is: A device solely for reading digital books
Question 31
Not answered
Marked out of 1.00
You can see the cell content at......
9 of 77 10/17/2024, 8:47 PM
a. Ribbon
b. Status bar
c. Formula bar
d. Title bar
The correct answer is: Formula bar
Question 32
Not answered
Marked out of 1.00
Which Excel function returns the number of characters in a text string?
a. FIND
b. LEN
c. CONCAT
d. MID
The correct answer is: LEN
Question 33
Not answered
Marked out of 1.00
Which cloud storage service provider offers the least amount of free space?
a. None of the above

b. OneDrive
c. Drop Box
d. Google Drive
The correct answer is: Drop Box
Question 34
Not answered
Marked out of 1.00
What is the keyboard shortcut to move to the last cell in a worksheet in Excel 2016?
a. Ctrl + Shift + Home

b. Ctrl + Home
c. Ctrl + Shift + End
d. Ctrl + End
10 of 77 10/17/2024, 8:47 PM
The correct answer is: Ctrl + End
Question 35
Not answered
Marked out of 1.00
Which of the following is not an output device of a computer system?
a. Printer
b. Keyboard
c. Monitor
d. Speakers
Question 36
Not answered
Marked out of 1.00
Which of the following is an example of a secondary storage device?
a. RAM
b. Cache memory
c. CD
d. ROM
The correct answer is: CD
Question 37
Not answered
Marked out of 1.00
How do you select a single cell in Excel 2016 using the left mouse button?‫ﻛﻴﻒ ﺗﺤﺪد ﺧﻠﻴﺔ واﺣﺪة ﻓﻲ ﺑﺎﺳﺘﺨﺪام زر اﻟﻤﺎوس ا��ﻳ��؟‬
a. Click once on the cell

b. Double-click on the cell
c. Right-click on the cell
d. Drag over the cell
The correct answer is: Click once on the cell
Question 38
11 of 77 10/17/2024, 8:47 PM
Not answered
Marked out of 1.00
Which of the following is NOT a valid chart element in Excel 2016?
a. Data Legend
b. Page Number
c. Chart Title
d. Axis Labels
The correct answer is: Page Number
Question 39
Not answered
Marked out of 1.00
How do bank customers benefit from the use of computers?
a. They can no longer access their accounts remotely

b. They are not allowed to access their accounts online
c. They are required to physically visit the bank more often
d. They can conveniently access their accounts without physically going to the bank
The correct answer is: They can conveniently access their accounts without physically going to the bank
Question 40
Not answered
Marked out of 1.00
How can you determine the value of the column width or row height you want to set in Excel 2016?
a. Use the "Page Layout" tab to set the value

b. Use the "Home" tab to set the value
c. Type the value directly into the cell
d. Use the "Format Cells" dialog box to set the value
The correct answer is: Use the "Format Cells" dialog box to set the value
Question 41
Not answered
Marked out of 1.00
In Excel 2016, what is the shortcut key to select all cells in the current worksheet?
a. Ctrl + S
12 of 77 10/17/2024, 8:47 PM
a. Ctrl + S
b. Ctrl + X
c. Ctrl + C
d. Ctrl + A
The correct answer is: Ctrl + A
Question 42
Not answered
Marked out of 1.00
What is the keyboard shortcut to move to the first cell in a row in Excel 2016?
a. Ctrl+Home
b. Ctrl + End
c. Home
d. End
The correct answer is: Ctrl+Home
Question 43
Not answered
Marked out of 1.00
Which of the following is a chart type available in Excel 2016?
a. Bar
b. All answers are true
c. Line
d. Pie
Question 44
Not answered
Marked out of 1.00
How has the use of computers impacted the airline industry?
a. It has made travel easier, quicker, and more economical.

b. It has made travel easier but more expensive.
c. It has no impact on the airline industry.
d. It has made travel more difficult, slower, and expensive.
13 of 77 10/17/2024, 8:47 PM
The correct answer is: It has made travel easier, quicker, and more economical.
Question 45
Not answered
Marked out of 1.00
To write data in a new line within the cell, enter the line break by pressing, Ctrl+Enter.
a. False
b. True
Question 46
Not answered
Marked out of 1.00
E-readers are known as e-books or digital readers Select one:
a. False
b. True
Question 47
Not answered
Marked out of 1.00
What is the purpose of writing formulas in Excel 2016?
a. To perform mathematical calculations on data in cells

b. To create visual representations of data
c. To sort and filter data
d. To format cells based on specific criteria
The correct answer is: To perform mathematical calculations on data in cells
Question 48
Not answered
Marked out of 1.00
What is the purpose of the Protection tab in the Format Cells dialog box in Excel 2016?
a. To lock or hide a cell.
14 of 77 10/17/2024, 8:47 PM
a. To lock or hide a cell.

b. To specify the numerical data type, such as currency, percentage, and date.
c. To add shading and background colors to a cell.
d. To change the font formatting of a cell.
The correct answer is: To lock or hide a cell.
Question 49
Not answered
Marked out of 1.00
How do computers help tellers in banks?
a. By transporting cash from one location to another

b. By providing medical services to bank customers
c. By preparing food for bank customers
d. By recording all banking transactions, analyzing them, and preparing reports
The correct answer is: By recording all banking transactions, analyzing them, and preparing reports
Question 50
Not answered
Marked out of 1.00
How can you hide a row in Excel 2016?
a. Right-click on the row number and choose "Hide"

b. Click on the "Home" tab, choose "Hide Row" under the "Cells" section
c. Select the row and press the "Ctrl+H" shortcut
d. Click on the "Format" tab, choose "Hide Row" under the "Visibility" section
The correct answer is: Right-click on the row number and choose "Hide"
Question 51
Not answered
Marked out of 1.00
Which of the following is NOT mentioned as an educational facility included in online learning applications?
a. Microsoft Teams
b. Adobe Photoshop
c. Zoom
d. Cisco WebEx
15 of 77 10/17/2024, 8:47 PM
The correct answer is: Adobe Photoshop
Question 52
Not answered
Marked out of 1.00
What does the #DIV/0! error value in Excel 2016 indicate?
a. The formula contains an incorrect argument.

b. The formula contains a reference to an invalid cell.
c. The formula is attempting to divide by zero.
d. The formula contains a circular reference.
The correct answer is: The formula is attempting to divide by zero.
Question 53
Not answered
Marked out of 1.00
Can you copy multiple worksheets at the same time in Excel 2016?
a. No, you can only copy one worksheet at a time

b. No, you can only copy worksheets within the same workbook
c. Yes, by pressing Ctrl + C and then Ctrl + V for each worksheet
d. Yes, by selecting the worksheets before using the copy method
The correct answer is: Yes, by selecting the worksheets before using the copy method
Question 54
Not answered
Marked out of 1.00
How do you deselect a cell or range of cells in Excel 2016?
a. Click on a different cell or range of cells

b. Click outside the selected area
c. All answers are true
d. Press the Esc key
Question 55
Not answered
Marked out of 1.00
16 of 77 10/17/2024, 8:47 PM
What distinguishes open schedule online courses from asynchronous courses?
a. Use of physical textbooks

b. Presence of deadlines
c. Lack of communication with teachers
d. No fixed schedule or deadlines
The correct answer is: No fixed schedule or deadlines
Question 56
Not answered
Marked out of 1.00
What does the Search button on the Taskbar in Windows 10 do?
a. It allows you to change the sound level of your PC.

b. It shows the currently active language.
c. It opens the Task View display.
d. It opens the Search box where you can search for files, folders, apps or settings on your computer or interact with Cortana.
The correct answer is: It opens the Search box where you can search for files, folders, apps or settings on your computer or interact with Cortana.
Question 57
Not answered
Marked out of 1.00
when you write a term in the Search box a new Search tab in the File Explorer appears
a. False
b. True
Question 58
Not answered
Marked out of 1.00
What is the primary objective of distance learning?
a. Providing free educational resources

b. Enhancing campus-based education
c. Conquering barriers of place and time
d. Increasing physical presence in classrooms
17 of 77 10/17/2024, 8:47 PM
The correct answer is: Conquering barriers of place and time
Question 59
Not answered
Marked out of 1.00
To sort data in Excel 2016, which option should you select?
a. Insert > Sort

b. View > Sort
c. Home > Sort
d. Data > Sort
The correct answer is: Data > Sort
Question 60
Not answered
Marked out of 1.00
Which of the following is a common input device for a computer system?
a. Monitor
b. Scanner
c. Printer
d. Speakers
The correct answer is: Scanner
Question 61
Not answered
Marked out of 1.00
What is the purpose of backup?
a. To store unnecessary files

b. To clean up hard disk space
c. To preserve information in case of computer failure or disasters
d. To make the computer run faster
The correct answer is: To preserve information in case of computer failure or disasters
Question 62
18 of 77 10/17/2024, 8:47 PM
Not answered
Marked out of 1.00
What is the purpose of adding tabs in a channel in Microsoft Teams?
a. To access email
b. To play games
c. To organize content
d. To make phone calls
The correct answer is: To organize content
Question 63
Not answered
Marked out of 1.00
Which Excel function returns the absolute value of a number?
a. ROUNDDOWN
b. ROUNDUP
c. ROUND
d. ABS
The correct answer is: ABS
Question 64
Not answered
Marked out of 1.00
What is distance learning?
a. Activities that combine computers and interactive networks

b. Learning materials given via a Web browser
c. Content that can be accessed quickly on a computer
d. Teacher-to-learner engagement at a distance
The correct answer is: Teacher-to-learner engagement at a distance
Question 65
Not answered
Marked out of 1.00
The arrangement that shows the multiple windows one above the other is……………….
19 of 77 10/17/2024, 8:47 PM
a. Windows Height
b. Windows side by side
c. Windows stack
d. Cascade windows
The correct answer is: Windows stack
Question 66
Not answered
Marked out of 1.00
How can you hide a column in Excel 2016?
a. Select the column and press the "Ctrl+H" shortcut

b. Click on the "Home" tab, choose "Hide Column" under the "Cells" section
c. Right-click on the column letter and choose "Hide"
d. Click on the "Format" tab, choose "Hide Column" under the "Visibility" section
The correct answer is: Right-click on the column letter and choose "Hide"
Question 67
Not answered
Marked out of 1.00
What is the mouse action to select multiple non-contiguous columns in Excel 2016?
a. Left-click and drag from the first cell of the first column to the last cell of the last column while holding down the Ctrl key
b. Single-click the column header of each column while holding down the Ctrl key
c. Double-click the column header of each column while holding down the Ctrl key
d. Right-click the column header of each column while holding down the Ctrl key
The correct answer is: Single-click the column header of each column while holding down the Ctrl key
Question 68
Not answered
Marked out of 1.00
Which component of a computer system is a physical entity?
a. Both
b. None
c. Hardware
d. Software
20 of 77 10/17/2024, 8:47 PM
The correct answer is: Hardware
Question 69
Not answered
Marked out of 1.00
How do students and instructors communicate in distance learning?
a. None of the answers

b. Through in-person meetings
c. Through phone calls
d. Through video conferencing
The correct answer is: Through video conferencing
Question 70
Not answered
Marked out of 1.00
Which of the following is a valid data type in Excel 2016?
a. All answers are true

b. Date/Time
c. Number
d. Text
Question 71
Not answered
Marked out of 1.00
How has the use of computers in government services impacted transactions with the government?
a. It has no impact on transactions with the government

b. It has made transactions with the government less perfect
c. It has made transactions with the government easier and more perfect
d. It has made transactions with the government more difficult
The correct answer is: It has made transactions with the government easier and more perfect
Question 72
Not answered
Marked out of 1.00
21 of 77 10/17/2024, 8:47 PM
Marked out of 1.00
What is displayed at the right side of the Taskbar in Windows 10?
a. Time and date

b. Running applications
c. Control Panel shortcuts
d. The Start button
The correct answer is: Time and date
Question 73
Not answered
Marked out of 1.00
Which tab in the Format Cells dialog box in Excel 2016 allows you to change the alignment of the data within a cell?
a. Alignment
b. Number
c. Border
d. Font
The correct answer is: Alignment
Question 74
Not answered
Marked out of 1.00
The autofill tool is used only to copy content.
a. False
b. True
Question 75
Not answered
Marked out of 1.00
Which option should you select in the Page Setup dialog box to adjust the scaling for printing a worksheet in Excel 2016?
a. Sheet
b. Scaling
c. Margins
d. Header/Footer
22 of 77 10/17/2024, 8:47 PM
d. Header/Footer
The correct answer is: Scaling
Question 76
Not answered
Marked out of 1.00
Which type of CD is rewritable?
a. CD-RW
c. CD-ROM
d. CD-R
The correct answer is: CD-RW
Question 77
Not answered
Marked out of 1.00
What is the CPU of a computer system?
a. An electronic chip that carries out program instructions

b. An input device
c. An output device
d. A storage device
The correct answer is: An electronic chip that carries out program instructions
Question 78
Not answered
Marked out of 1.00
Fixed-time online courses are a type of synchronous courses Select one:
a. True
b. False
Question 79
Not answered
Marked out of 1.00
23 of 77 10/17/2024, 8:47 PM
Marked out of 1.00
Which Excel function returns the average of a range of numbers?
a. AVERAGE
b. MAX
c. MIN
d. SUM
The correct answer is: AVERAGE
Question 80
Not answered
Marked out of 1.00
In most cases, teachers and students can access Google Classroom using a Yahoo account Select one:
a. True
b. False
Question 81
Not answered
Marked out of 1.00
What is the purpose of hiding rows and columns in Excel 2016?
a. To highlight important cells in those rows and columns

b. To keep certain rows and columns visible while scrolling through a large worksheet
c. To make certain rows and columns invisible without deleting them
d. To prevent anyone from editing the cells in those rows and columns
The correct answer is: To make certain rows and columns invisible without deleting them
Question 82
Not answered
Marked out of 1.00
What is hybrid distance education in distance learning?
a. A tool for teachers to communicate with students in real-time classes

b. A type of asynchronous learning
c. A type of open schedule online course
d. A type of blended learning in which students learn the same material in real-time
24 of 77 10/17/2024, 8:47 PM
d. A type of blended learning in which students learn the same material in real-time
The correct answer is: A type of blended learning in which students learn the same material in real-time
Question 83
Not answered
Marked out of 1.00
What is the keyboard shortcut to open the "Find and Replace" dialog box in Excel 2016?
a. Ctrl + H
b. Ctrl + P
c. Ctrl + F
d. Ctrl + R
The correct answer is: Ctrl + H
Question 84
Not answered
Marked out of 1.00
What is synchronous learning?
a. Learning at the same time and in the same location

b. Learning at different times with direct communication
c. Learning independently with no set schedule
d. Learning at the same time but in different physical locations
The correct answer is: Learning at the same time and in the same location
Question 85
Not answered
Marked out of 1.00
What is the mouse action to select an entire row in Excel 2016?
a. Single-click the row header

b. Left-click and drag from the first to last cell of the row
c. Double-click the row header
d. Right-click the row header
The correct answer is: Single-click the row header
Question 86
25 of 77 10/17/2024, 8:47 PM
Question 86
Not answered
Marked out of 1.00
What is copyright?
a. The ownership of an intellectual property within legal limits.

b. The right to access an intellectual property.
c. The right to modify an intellectual property.
d. A type of ownership of a physical property.
The correct answer is: The ownership of an intellectual property within legal limits.
Question 87
Not answered
Marked out of 1.00
The…………………includes copy and rename
a. Move group
b. Organize group
c. Clipboard group
d. Contents group
The correct answer is: Organize group
Question 88
Not answered
Marked out of 1.00
What is the storage capacity of a CD-R?
a. 650 MB to 700 MB
b. 100 MB
c. 1 GB
d. 500 MB
The correct answer is: 650 MB to 700 MB
Question 89
Not answered
Marked out of 1.00
What is the basic unit of memory in a computer system?
26 of 77 10/17/2024, 8:47 PM
a. Bit
b. Megabyte
c. Byte
d. Gigabyte
The correct answer is: Byte
Question 90
Not answered
Marked out of 1.00
One of the default libraries in Windows 10 are……
a. Camera Roll
b. Folders
c. Files
d. Online video
The correct answer is: Camera Roll
Question 91
Not answered
Marked out of 1.00
Which Excel function returns the sum of a range of numbers?
a. AVERAGE
b. SUM
c. MIN
d. MAX
The correct answer is: SUM
Question 92
Not answered
Marked out of 1.00
Students should be divided into groups to improve interaction among them Select one:
a. True
b. False
27 of 77 10/17/2024, 8:47 PM
Question 93
Not answered
Marked out of 1.00
What is the purpose of the Notifications icon on the Windows 10 interface screen?
a. It displays the current Time and Date.

b. It allows you to change sound settings.
c. It shows the status of your network connection.
d. It opens the Notification and Action Center pane.
The correct answer is: It opens the Notification and Action Center pane.
Question 94
Not answered
Marked out of 1.00
What are some examples of input devices that can be used with a computer?
a. Telephone and fax machine

b. Keyboard and mouse
c. Television and radio
d. Printer and scanner
The correct answer is: Keyboard and mouse
Question 95
Not answered
Marked out of 1.00
What is a Microcomputer?
a. A computer with complex hardware configuration

b. A computer with small and compact hardware
c. A computer with high-level computational capacity
d. None of the above
The correct answer is: A computer with small and compact hardware
Question 96
Not answered
Marked out of 1.00
28 of 77 10/17/2024, 8:47 PM
Which of the following is a removable and rewritable storage device?
a. DVD
b. Flash drive
c. Hard disk
d. CD-ROM
The correct answer is: Flash drive
Question 97
Not answered
Marked out of 1.00
Which component of the CPU controls the movement of signals among CPU, memory, and other devices?
a. Arithmetic-Logic Unit (ALU)

b. Motherboard
c. Control Unit (CU)
d. Hard disk
The correct answer is: Control Unit (CU)
Question 98
Not answered
Marked out of 1.00
To delete object in excel sheet, ____ Select one:
a. Double click the object

b. Select it and then press Ctrl + Del
c. Select it and then press the delete key
d. Select it and then press Alt + Enter
The correct answer is: Select it and then press the delete key
Question 99
Not answered
Marked out of 1.00
What is online banking?
a. A service that allows you to withdraw cash from an ATM

b. A service that allows you to physically visit the bank to perform transactions
c. A service that allows you to cook food online while waiting for a bank transaction
29 of 77 10/17/2024, 8:47 PM
d. A service that allows you to check your bank balance online
The correct answer is: A service that allows you to check your bank balance online
Question 100
Not answered
Marked out of 1.00
Which of the following is a part of the CPU in a computer system?
a. Keyboard
b. Monitor
c. Printer
d. Arithmetic-Logic Unit (ALU)
The correct answer is: Arithmetic-Logic Unit (ALU)
Question 101
Not answered
Marked out of 1.00
How is document storage managed in Microsoft Teams?
a. All files are saved to individual user computers

b. All files are saved in a shared folder on OneDrive
c. All files are saved in a folder on Dropbox
d. All files are saved in a default document library folder on SharePoint Online
The correct answer is: All files are saved in a default document library folder on SharePoint Online
Question 102
Not answered
Marked out of 1.00
Which error of the Excel displays when a formula refers to a cell that is not valid?
a. Error #REF!
b. Error #DIV/0!
c. Error #####
d. Error #NAME?
The correct answer is: Error #REF!
30 of 77 10/17/2024, 8:47 PM
Question 103
Not answered
Marked out of 1.00
How does a computer provide output?
a. By displaying text, images, sounds, or other types of data

b. By executing program instructions
c. By processing input from the keyboard
d. By storing data in memory
The correct answer is: By displaying text, images, sounds, or other types of data
Question 104
Not answered
Marked out of 1.00
How are lectures and educational materials delivered in distance learning?
a. Through physical textbooks only

b. Via the postal service
c. Through traditional classrooms
d. Through the internet
The correct answer is: Through the internet
Question 105
Not answered
Marked out of 1.00
Which Excel function returns the smallest number in a range of numbers?
a. MIN
b. AVERAGE
c. MAX
d. SUM
The correct answer is: MIN
Question 106
Not answered
Marked out of 1.00
Which of the following is a non-volatile memory?
31 of 77 10/17/2024, 8:47 PM
a. RAM
b. Cache memory
c. ROM
d. Virtual memory
The correct answer is: ROM
Question 107
Not answered
Marked out of 1.00
Which input device is used to control movement of a cursor or pointer on a display screen?
a. Mouse
b. Microphone
c. Scanner
d. Keyboard
The correct answer is: Mouse
Question 108
Not answered
Marked out of 1.00
Which Excel function capitalizes the first letter of each word in a text string?
a. PROPER
b. UPPER
c. IF
d. LOWER
The correct answer is: PROPER
Question 109
Not answered
Marked out of 1.00
Which of the following is not a task that can be managed using computers in government offices?
a. Analysis
b. Documentation
c. Building and construction
d. Calculation
32 of 77 10/17/2024, 8:47 PM
The correct answer is: Building and construction
Question 110
Not answered
Marked out of 1.00
…………………………………is a flat circuit board that connects hardware components Select one:
a. Arithmetic-Logic Unit
b. Control Unit
c. System board
d. System unit
The correct answer is: System board
Question 111
Not answered
Marked out of 1.00
How can distance learning provide easy access to education?
a. By providing access to educational facilities in rural locations

c. By offering online education that can be accessed from anywhere
d. By accommodating students who are differently abled
Question 112
Not answered
Marked out of 1.00
Which of the following statements about RAM is true?
a. RAM is called volatile storage

b. RAM holds programs and data permanently
c. RAM is a permanent storage
d. RAM can't be upgraded
The correct answer is: RAM is called volatile storage
Question 113
Not answered
33 of 77 10/17/2024, 8:47 PM
Not answered
Marked out of 1.00
Blended learning in which students learn the same material in real time, but some of them are physically present while others learn remotely?
Select one:
a. Hybrid education
c. Formal education
d. traditional learning
The correct answer is: Hybrid distance education
Question 114
Not answered
Marked out of 1.00
……………………holds instructions required by the CPU to process
a. RAT
b. RAD
c. ROM
d. RAM
The correct answer is: RAM
Question 115
Not answered
Marked out of 1.00
What is the mouse action to select an entire column in Excel 2016?
a. Single-click the column header

b. Double-click the column header
c. Left-click and drag from the first to last cell of the column
d. Right-click the column header
The correct answer is: Single-click the column header
Question 116
Not answered
Marked out of 1.00
Which of the following is a feature of Moodle, a Learning Platform or course management system (LMS)?
34 of 77 10/17/2024, 8:47 PM
a. Video conferencing
b. Assignments
c. Email communication
d. Social media integration
The correct answer is: Assignments
Question 117
Not answered
Marked out of 1.00
To move the chart to new sheet or another file, you can use the Move chart options at the ____ tab.
a. Insert
b. Review
c. Design
d. Home
The correct answer is: Design
Question 118
Not answered
Marked out of 1.00
Web-based learning is linked to learning materials given via……………… Select one:
a. Computer
b. Compact desk
c. Web browser
d. Network
The correct answer is: Web browser
Question 119
Not answered
Marked out of 1.00
Which Excel function returns the largest number in a range of numbers?
a. MIN
b. AVERAGE
c. SUM
d. MAX
35 of 77 10/17/2024, 8:47 PM
The correct answer is: MAX
Question 120
Not answered
Marked out of 1.00
What should you do to stay protected from Malware?
a. Use anti-spyware software, anti-virus software and scan and update regularly
b. Use the "auto-run" option in Windows OS for portable drives
c. Click, download and install without confirmation while browsing the internet
d. Always open email attachments without confirmation
The correct answer is: Use anti-spyware software, anti-virus software and scan and update regularly
Question 121
Not answered
Marked out of 1.00
Microsoft Teams is a persistent chat-based collaboration platform complete with document sharing and online meetings Select one:
a. False
b. True
Question 122
Not answered
Marked out of 1.00
Which option should you select in the Page Setup dialog box to adjust the paper size for printing a worksheet in Excel 2016?
a. Margins
b. Sheet
c. Paper
d. Header/Footer
The correct answer is: Paper
Question 123
Not answered
Marked out of 1.00
36 of 77 10/17/2024, 8:47 PM
Which Excel function concatenates two or more text strings into one string?
a. CONCAT
b. LEN
c. FIND
d. MID
The correct answer is: CONCAT
Question 124
Not answered
Marked out of 1.00
Which Excel function converts a text string to all uppercase letters?
a. UPPER
b. PROPER
c. IF
d. LOWER
The correct answer is: UPPER
Question 125
Not answered
Marked out of 1.00
What is the significance of focusing on attendance in distance learning management?
a. Engagement is important in both traditional and online classrooms.

b. Engagement is a “nice to have” in a traditional classroom, but not in an online classroom.
c. It is not important to focus on attendance in online classes.
d. None of the answers
The correct answer is: Engagement is important in both traditional and online classrooms.
Question 126
Not answered
Marked out of 1.00
Which of the following components of a computer system acts as the communication medium for all hardware devices?
a. Motherboard
b. CPU
c. Memory
37 of 77 10/17/2024, 8:47 PM
d. Hard disk
The correct answer is: Motherboard
Question 127
Not answered
Marked out of 1.00
Which of the following is an example of an Open Source Operating System?
a. Windows 10
b. MacOS
c. Android
d. Linux
The correct answer is: Linux
Question 128
Not answered
Marked out of 1.00
What is Microsoft Teams?
a. An email service
b. A collaboration platform
c. A video game
d. A web browser
The correct answer is: A collaboration platform
Question 129
Not answered
Marked out of 1.00
Can teachers use Google Classroom for live instruction?
a. Only with school-managed accounts

b. No, Google Classroom doesn't support live instruction
c. Yes, with Google Meet
d. Yes, but only with Zoom
The correct answer is: Yes, with Google Meet
38 of 77 10/17/2024, 8:47 PM
Question 130
Not answered
Marked out of 1.00
In hybrid distance education, how do students learn the same material?
a. Through online materials only

b. In real-time, with some physically present and others remote
c. Independently without any interaction
d. In different locations and times
The correct answer is: In real-time, with some physically present and others remote
Question 131
Not answered
Marked out of 1.00
Which of the following is a part of the Windows 10 interface screen?
a. The Start Menu

b. The Control Panel
c. The Desktop
d. The System Tray
The correct answer is: The Desktop
Question 132
Not answered
Marked out of 1.00
Which type of computer is useful when a huge amount of data needs to be processed in a short time?
a. Microcomputer
b. Labtop
c. Tablet
d. Supercomputer
The correct answer is: Supercomputer
Question 133
Not answered
Marked out of 1.00
What does the Time & Date display on the Windows 10 interface screen show?
39 of 77 10/17/2024, 8:47 PM
a. The current Time and Date

b. The current time only
c. The current date only
d. The current weather conditions
The correct answer is: The current Time and Date
Question 134
Not answered
Marked out of 1.00
How do instructors send information to students in distance learning?
a. Via the internet

b. Through assignments
c. Through video recordings
d. Through physical textbooks
The correct answer is: Via the internet
Question 135
Not answered
Marked out of 1.00
What are some of the tasks that can be managed using computers in government offices?
a. Documenting and generating reports

b. Planting and harvesting crops
c. Cooking and cleaning
d. Marketing and advertising
The correct answer is: Documenting and generating reports
Question 136
Not answered
Marked out of 1.00
What type of courses have a fixed schedule for classes?
a. Open schedule online courses

b. Fixed-time online courses
c. Hybrid distance education courses
d. Synchronous learning courses
40 of 77 10/17/2024, 8:47 PM
The correct answer is: Fixed-time online courses
Question 137
Not answered
Marked out of 1.00
Which type of learning involves students being on different schedules and not in direct communication with the teacher?
a. Asynchronous learning
c. Open schedule online courses
d. Synchronous learning
The correct answer is: Asynchronous learning
Question 138
Not answered
Marked out of 1.00
What is the purpose of the ABS function in Excel?
a. To find the absolute value of a number

b. To find the highest value in a range of cells
c. To find the average value of a range of cells
d. To find the lowest value in a range of cells
The correct answer is: To find the absolute value of a number
Question 139
Not answered
Marked out of 1.00
Which output device is used to produce physical objects from digital designs?
a. 3D printer
b. Projector
c. Touchscreen
d. Printer
The correct answer is: 3D printer
Question 140
Not answered
41 of 77 10/17/2024, 8:47 PM
Not answered
Marked out of 1.00
What are the two ways to back up important data for personal computer users?
a. USB and DVD backup

b. Cloud and network backup
c. Internet and email backup
d. Local and cloud backup
The correct answer is: Local and cloud backup
Question 141
Not answered
Marked out of 1.00
Which of the following is an example of a Command Line Interface (CLI) operating system?
a. Windows 10
b. Android
c. MacOS
d. MS-DOS
The correct answer is: MS-DOS
Question 142
Not answered
Marked out of 1.00
What kind of language can computers understand?
a. Only languages consisting of letters, numbers, and punctuation marks

b. Only sign language
c. Only Binary Machine Language consisting of 0 and 1
d. Only spoken languages
The correct answer is: Only Binary Machine Language consisting of 0 and 1
Question 143
Not answered
Marked out of 1.00
Which of the following is not a recommended practice for managing virtual classrooms?
a. Creating a plan for classroom management
42 of 77 10/17/2024, 8:47 PM
a. Creating a plan for classroom management

b. Keeping lectures as the only format for video classes
c. Creating a session plan
d. Sending a pre-session notification to students
The correct answer is: Keeping lectures as the only format for video classes
Question 144
Not answered
Marked out of 1.00
Which type of Malware can spread without a host program or human help?
a. Trojan Horse
b. Virus
c. Worm
d. Spyware
The correct answer is: Worm
Question 145
Not answered
Marked out of 1.00
To change the color of selected cells in Excel 2016, which option should you select?
a. Home > Borders

b. Home > Font
c. Home > Number
d. Home > Fill
The correct answer is: Home > Fill
Question 146
Not answered
Marked out of 1.00
Which of the following is an external storage device?
a. Cache memory
b. RAM
c. ROM
d. Flash drive
43 of 77 10/17/2024, 8:47 PM
Question 147
Not answered
Marked out of 1.00
How do you get information from a computer?
a. By reading the output on a screen or printed paper

b. By listening to the computer's voice
c. By smelling it
d. By touching the screen
The correct answer is: By reading the output on a screen or printed paper
Question 148
Not answered
Marked out of 1.00
Remote learning may include all of the following, except…………….Select one:
a. Emails between students and teachers

b. Lessons posted to a web site
c. Live class video chats
d. A teacher and students in the same room
The correct answer is: A teacher and students in the same room
Question 149
Not answered
Marked out of 1.00
In Excel 2016, which function would you use to count the number of cells in a range that contain numbers?
a. COUNTA
b. COUNT
c. COUNTIF
d. COUNTIFS
The correct answer is: COUNT
Question 150
Not answered
Marked out of 1.00
44 of 77 10/17/2024, 8:47 PM
What is software in a computer system?
a. Physical equipment in a computer system

b. A set of instructions that directs and controls operations of the computer
The correct answer is: A set of instructions that directs and controls operations of the computer
Question 151
Not answered
Marked out of 1.00
What is the purpose of freezing rows and columns in Excel 2016?
a. To prevent anyone from editing the cells in those rows and columns
b. To keep certain rows and columns visible while scrolling through a large worksheet
c. To delete the cells in those rows and columns
d. To highlight important cells in those rows and columns
The correct answer is: To keep certain rows and columns visible while scrolling through a large worksheet
Question 152
Not answered
Marked out of 1.00
How can you copy a worksheet in Excel 2016 using the Move or Copy dialog box?
a. Right-click on the worksheet tab and select "Move or Copy", then select the "Copy" checkbox
b. Press Ctrl + C to copy the worksheet, then right-click on the worksheet tab and select "Paste"
c. Press Ctrl + X to cut the worksheet, then right-click on the worksheet tab and select "Paste"
d. Right-click on the worksheet tab and select "Copy Sheet"
The correct answer is: Right-click on the worksheet tab and select "Move or Copy", then select the "Copy" checkbox
Question 153
Not answered
Marked out of 1.00
What is the keyboard shortcut to move to the next cell in a row in Excel 2016?
a. Shift + Tab
b. Enter
c. Tab
d. Spacebar
45 of 77 10/17/2024, 8:47 PM
The correct answer is: Tab
Question 154
Not answered
Marked out of 1.00
What is the maximum number of rows in Excel 2016?
a. 4,194,304
b. 2,097,152
c. 1,048,576
d. 65,536
The correct answer is: 1,048,576
Question 155
Not answered
Marked out of 1.00
How can students receive formal education from a distance?
a. By using digital tools to interact with the instructor and peers.

b. By attending classes on campus.
c. By attending classes in person.
d. By attending classes via telephone.
The correct answer is: By using digital tools to interact with the instructor and peers.
Question 156
Not answered
Marked out of 1.00
How can you protect a workbook in Excel 2016?
a. Click on the "Review" tab, choose "Protect Workbook" under the "Changes" section, and set a password if desired
b. Click on the "File" tab, choose "Protect Workbook" under the "Info" section, and set a password if desired
c. All of the above
d. Right-click on the workbook tab, choose "Protect Workbook", and set a password if desired
The correct answer is: Click on the "Review" tab, choose "Protect Workbook" under the "Changes" section, and set a password if desired
Question 157
46 of 77 10/17/2024, 8:47 PM
Not answered
Marked out of 1.00
What does the ##### error value in Excel 2016 indicate?
a. The formula is attempting to divide by zero.

b. Column isn't wide enough to display the numerical value.
c. The formula contains an incorrect argument.
d. The formula contains a reference to an invalid cell.
The correct answer is: Column isn't wide enough to display the numerical value.
Question 158
Not answered
Marked out of 1.00
Which of the following is a good practice for managing passwords?
a. Changing passwords periodically.

b. Keeping a written record of passwords on a paper or in an email message.
c. Sharing passwords with others.
d. Using the same password for all accounts.
The correct answer is: Changing passwords periodically.
Question 159
Not answered
Marked out of 1.00
Which of the following is not a type of Malware?
a. Viruses
b. Cookies
c. Spyware
d. Worms
The correct answer is: Cookies
Question 160
Not answered
Marked out of 1.00
What is internet backup?
47 of 77 10/17/2024, 8:47 PM
a. Backing up of data onto several servers on the internet.

b. Backing up data on a cloud storage service.
c. Backing up data on an external hard disk, CD, flash drives, etc.
d. Backing up data on an email account.
The correct answer is: Backing up of data onto several servers on the internet.
Question 161
Not answered
Marked out of 1.00
What does the #VALUE! error value in Excel 2016 indicate?

b. The formula contains a reference to an invalid cell.
c. The formula contains a circular reference.
d. The formula contains an incorrect argument type.
The correct answer is: The formula contains an incorrect argument type.
Question 162
Not answered
Marked out of 1.00
………………………………contains links to folders and libraries that you access frequently
a. Local disk D
b. Quick Access
c. Network
d. Local disk C
The correct answer is: Quick Access
Question 163
Not answered
Marked out of 1.00
What is the storage capacity of a DVD?
a. 100 GB
b. 50 GB
c. 4.7 GB to 17 GB
d. 2.7 GB
48 of 77 10/17/2024, 8:47 PM
The correct answer is: 4.7 GB to 17 GB
Question 164
Not answered
Marked out of 1.00
What is the purpose of memory in a computer system?
a. To process data and perform arithmetic operations

b. To store data temporarily while processing and executing instructions
c. To store data and programs permanently
d. To display information on the screen
The correct answer is: To store data temporarily while processing and executing instructions
Question 165
Not answered
Marked out of 1.00
What is a Trojan Horse?
a. A program or file that enhances the performance of a computer

b. A program or file that looks genuine but is harmful
c. A program or file that creates backup copies of data
d. A program or file that is harmful to a computer or user privacy
The correct answer is: A program or file that looks genuine but is harmful
Question 166
Not answered
Marked out of 1.00
Which of the following is NOT a valid operator in Excel 2016?
a. %
b. -
c. *
d. +
The correct answer is: %
Question 167
Not answered
Marked out of 1.00
49 of 77 10/17/2024, 8:47 PM
Marked out of 1.00
…………………is just below the Ribbon
a. Content pane
b. Devices
c. Folders
d. Search Bar
The correct answer is: Search Bar
Question 168
Not answered
Marked out of 1.00
What is the mouse action to select multiple non-contiguous rows in Excel 2016?
a. Double-click the row header of each row while holding down the Ctrl key
b. Single-click the row header of each row while holding down the Ctrl key
c. Right-click the row header of each row while holding down the Ctrl key
d. Left-click and drag from the first cell of the first row to the last cell of the last row while holding down the Ctrl key
The correct answer is: Single-click the row header of each row while holding down the Ctrl key
Question 169
Not answered
Marked out of 1.00
The WebEx has no desktop version Select one:
a. False
b. True
Question 170
Not answered
Marked out of 1.00
How can you modify the width of a column or the height of a row in Excel 2016?
a. Right-click on the column letter/row number that you want to modify, select "Column Width" or "Row Height"
b. Press Ctrl + W for column width or Ctrl + H for row height
c. Go to the "Page Layout" tab and choose "Column Width" or "Row Height" from the "Page Setup" group
d. Right-click on the column letter/row number that you want to modify, select "Format Cells", then choose "Column Width" or "Row
50 of 77 10/17/2024, 8:47 PM
d. Right-click on the column letter/row number that you want to modify, select "Format Cells", then choose "Column Width" or "Row
Height"
The correct answer is: Right-click on the column letter/row number that you want to modify, select "Column Width" or "Row Height"
Question 171
Not answered
Marked out of 1.00
Which of the following special features of a computer allows it to perform multiple tasks simultaneously?
a. Huge storage
b. Attentiveness
c. Accuracy
d. Multitasking
The correct answer is: Multitasking
Question 172
Not answered
Marked out of 1.00
What is the keyboard shortcut to switch between open workbooks in Excel 2016?
a. Ctrl + W
b. Ctrl + Tab
c. Ctrl + Shift + W
d. Ctrl + Shift + Tab
The correct answer is: Ctrl + Tab
Question 173
Not answered
Marked out of 1.00
What is the function of @ mention in Microsoft Teams?
a. To start a video call

b. To highlight important messages
c. To add a user to a conversation
d. To send a private message to a specific user
The correct answer is: To add a user to a conversation
51 of 77 10/17/2024, 8:47 PM
Question 174
Not answered
Marked out of 1.00
What are some examples of the use of computers in medical services?
a. Diagnosis, prescription and treatment, surgeries, monitoring and analysis

b. Cooking and cleaning
c. Gardening
d. Entertainment for patients
The correct answer is: Diagnosis, prescription and treatment, surgeries, monitoring and analysis
Question 175
Not answered
Marked out of 1.00
Which Excel function rounds a number to a specified number of decimal places?
a. ROUNDDOWN
b. ABS
c. ROUND
d. ROUNDUP
The correct answer is: ROUND
Question 176
Not answered
Marked out of 1.00
Can you freeze multiple rows and columns at the same time in Excel 2016?
a. Yes, by selecting the rows and columns you want to freeze before choosing "Freeze Panes"
b. No, freezing multiple rows and columns is not possible in Excel 2016
c. Yes, by right-clicking on the cell in the intersection of the rows and columns you want to freeze and choosing "Freeze Panes"
d. No, you can only freeze one row or one column at a time
The correct answer is: Yes, by selecting the rows and columns you want to freeze before choosing "Freeze Panes"
Question 177
Not answered
Marked out of 1.00
What does the #NAME? error value in Excel 2016 indicate?
52 of 77 10/17/2024, 8:47 PM
What does the #NAME? error value in Excel 2016 indicate?
a. The formula contains an incorrect function name.

b. The formula contains a circular reference.
c. The formula is attempting to divide by zero.
d. The formula contains a reference to an invalid cell.
The correct answer is: The formula contains an incorrect function name.
Question 178
Not answered
Marked out of 1.00
…………………………is used to configure the layout of the File Explorer window
a. View tab
b. Home tab
c. Share tab
d. File tab
The correct answer is: View tab
Question 179
Not answered
Marked out of 1.00
To select non-adjacent rows or columns, hold Ctrl and select the row or column numbers / letters.
a. True
b. False
Question 180
Not answered
Marked out of 1.00
RAM is a volatile memory
a. False
b. True
53 of 77 10/17/2024, 8:47 PM
Question 181
Not answered
Marked out of 1.00
In most cases, teachers and students can access Google Classroom using a ........ account Select one:
a. Edu account
b. Outlook Account
c. Yahoo Account
d. Google Account
The correct answer is: Google Account
Question 182
Not answered
Marked out of 1.00
Which of the following is NOT a mobile technology for distance learning mentioned in the material?
a. E-Readers
b. Smart Phones
c. Digital Tablets
d. Desktop Computers
The correct answer is: Desktop Computers
Question 183
Not answered
Marked out of 1.00
The autofill tool mouse pointer on the bottom left corner of the cell appears as
a. +
b. *
c. -
d. #
The correct answer is: +
Question 184
Not answered
Marked out of 1.00
How can you unhide a column in Excel 2016?
54 of 77 10/17/2024, 8:47 PM
a. Click on the "Format" tab, choose "hide Column" under the "Visibility" section
b. Select the columns on either side of the hidden column, right-click, and choose "Unhide"
c. Click on the "Home" tab, choose "hide Column" under the "Cells" section
The correct answer is: Select the columns on either side of the hidden column, right-click, and choose "Unhide"
Question 185
Not answered
Marked out of 1.00
What is one of the benefits of backing up data on a cloud storage service?
a. Ease of sharing files

b. Reducing internet speed
c. Required payment for service
d. Increased file size
The correct answer is: Ease of sharing files
Question 186
Not answered
Marked out of 1.00
ROM retains data without flow of electricity
a. True
b. False
Question 187
Not answered
Marked out of 1.00
What is the function of a scanner as an input device?
a. To enter alphabets, numbers, and special characters

b. To convert sound signals into a form that can be processed by a computer
c. To control movement of a cursor or pointer on a display screen
d. To scan photographs and documents and translate it into a digital image
The correct answer is: To scan photographs and documents and translate it into a digital image
55 of 77 10/17/2024, 8:47 PM
Question 188
Not answered
Marked out of 1.00
What is the purpose of an input device in a computer system?
a. To provide input to the computer

b. To provide output to the user
c. To store data and instructions
d. To execute program instructions
The correct answer is: To provide input to the computer
Question 189
Not answered
Marked out of 1.00
Which of the following is a valid format code for displaying a percentage in Excel 2016?
a. hh:mm:ss
b. 0.00%
c. #,##0.00
d. yyyy/mm/dd
The correct answer is: 0.00%
Question 190
Not answered
Marked out of 1.00
What is the purpose of merging cells in Excel 2016?
a. To split data from one cell into multiple cells

b. To apply a formatting style to a range of cells
c. To combine data from multiple cells into one cell
d. To create a new worksheet within a workbook
The correct answer is: To combine data from multiple cells into one cell
Question 191
Not answered
Marked out of 1.00
56 of 77 10/17/2024, 8:47 PM
The Window borders can be used to resize a window
a. False
b. True
Question 192
Not answered
Marked out of 1.00
Which tab in the Format Cells dialog box in Excel 2016 allows you to select a border style for your cell?
a. Font
b. Alignment
c. Border
d. Number
The correct answer is: Border
Question 193
Not answered
Marked out of 1.00
Which of the following are examples of primary storage devices?
a. Hard disk and CD

b. RAM and ROM
c. DVD and Flash Memory
d. USB drive and External hard drive
The correct answer is: RAM and ROM
Question 194
Not answered
Marked out of 1.00
In distance learning, lectures and educational materials delivered could be delivered via
a. Textbooks.
b. Collaboration Platforms.
c. Telephone.
d. Video conferencing.
57 of 77 10/17/2024, 8:47 PM
The correct answer is: Collaboration Platforms.
Question 195
Not answered
Marked out of 1.00
Which operating system is designed primarily for mobile and touch screen devices such as Smartphones and Tablets?
a. Linux
b. Windows 10
c. Android
d. MacOS
The correct answer is: Android
Question 196
Not answered
Marked out of 1.00
How can you select the location where you want to place the copied worksheet in the Move or Copy dialog box in Excel 2016?
a. By selecting the location from a list of options

b. By selecting the worksheet from a dropdown list
c. By selecting the worksheet that appears before the copied worksheet
d. By typing the name of the worksheet in a text box
The correct answer is: By selecting the location from a list of options
Question 197
Not answered
Marked out of 1.00
How do computers interact with people?
a. By using a keyboard and mouse

b. By telepathy
c. By sending telegrams
d. By using sign language
The correct answer is: By using a keyboard and mouse
Question 198
Not answered
Marked out of 1.00
58 of 77 10/17/2024, 8:47 PM
Marked out of 1.00
What is the purpose of the SUM function in Excel?
a. To find the total value in a range of cells

c. To find the average value in a range of cells
d. To find the lowest value in a range of cells
The correct answer is: To find the total value in a range of cells
Question 199
Not answered
Marked out of 1.00
Which type of distance learning involves real-time interaction with instructors and peers?
a. Asynchronous learning
b. Open schedule online courses
c. Video conference
d. Fixed-time online courses
The correct answer is: Video conference
Question 200
Not answered
Marked out of 1.00
To freeze the top row in Excel 2016, which option should you select?
a. Split Panes
b. Unfreeze Panes
c. Freeze Panes
d. Hide Panes
The correct answer is: Freeze Panes
Question 201
Not answered
Marked out of 1.00
What are some of the facilities offered by airlines and other web services through the use of computers?
a. Medical facilities
b. Flight search and reservation management
59 of 77 10/17/2024, 8:47 PM
b. Flight search and reservation management

c. Cooking and cleaning services
d. Laundry and dry cleaning services
The correct answer is: Flight search and reservation management
Question 202
Not answered
Marked out of 1.00
What does the #REF! error value in Excel 2016 indicate?

b. The formula contains a circular reference.
c. The formula contains a reference to an invalid cell.
d. The formula contains an incorrect argument.
The correct answer is: The formula contains a reference to an invalid cell.
Question 203
Not answered
Marked out of 1.00
What is a computer?
a. An electronic device used for cooking

b. An electronic device used for communication
c. An electronic device used for processing data and providing output
d. An electronic device used for transportation
The correct answer is: An electronic device used for processing data and providing output
Question 204
Not answered
Marked out of 1.00
Spreadsheet is used for the organization and storage of data in tabular form
a. False
b. True
Question 205
60 of 77 10/17/2024, 8:47 PM
Question 205
Not answered
Marked out of 1.00
What are Digital Tablets?
a. A device solely for reading digital books

b. A device used to manage and deliver learning content
c. A software program designed specifically for mobile devices
d. Touch-screen portable gadgets that change the way instructional content is stored, shown, and transmitted
The correct answer is: Touch-screen portable gadgets that change the way instructional content is stored, shown, and transmitted
Question 206
Not answered
Marked out of 1.00
What rights are granted to the owner of a copyright?
a. The right to prepare derivative works.

b. The right to invent new work.
c. The right to sell the work.
d. The right to use the work without permission.
The correct answer is: The right to prepare derivative works.
Question 207
Not answered
Marked out of 1.00
What is the keyboard shortcut to select two or more nonadjacent sheets in Excel 2016?
a. Shift + click each sheet tab

b. Alt + click each sheet tab
c. Ctrl + click each sheet tab
d. Ctrl + Shift + click each sheet tab
The correct answer is: Ctrl + click each sheet tab
Question 208
Not answered
Marked out of 1.00
How can you insert a new column or row in Excel 2016?
61 of 77 10/17/2024, 8:47 PM
a. Press Ctrl + I
b. Press Ctrl + X
c. Right-click on the column letter/row number that you want to remove, select "Insert"
d. Right-click on the column letter/row number that is the column/row you want to add, select "Insert"
The correct answer is: Right-click on the column letter/row number that is the column/row you want to add, select "Insert"
Question 209
Not answered
Marked out of 1.00
How do you select non-adjacent cells in Excel 2016?
a. Click and drag over the cells

b. Hold down the Shift key and click on each cell
c. Hold down the Ctrl key and click on each cell
d. Right-click and select "Select Non-adjacent Cells"
The correct answer is: Hold down the Ctrl key and click on each cell
Question 210
Not answered
Marked out of 1.00
What is the keyboard shortcut to insert a new worksheet in Excel 2016?
a. Ctrl + S
b. Ctrl + W
c. Ctrl + N
d. Ctrl + A
The correct answer is: Ctrl + N
Question 211
Not answered
Marked out of 1.00
What is a voice-over slideshow?
a. A type of quiz
b. A live discussion between students and the instructor
c. None of the above
d. A presentation with voice record
62 of 77 10/17/2024, 8:47 PM
The correct answer is: A presentation with voice record
Question 212
Not answered
Marked out of 1.00
Which of the following is NOT a data type in Excel 2016?
a. Date/Time
b. Number
c. Text
d. Animation
The correct answer is: Animation
Question 213
Not answered
Marked out of 1.00
Protection tab – changes the alignment of the data within a cell. F
a. False
b. True
Question 214
Not answered
Marked out of 1.00
What is the purpose of the IF function in Excel?
a. To evaluate a logical condition and return one value if true and another value if false
c. To format cells based on specific criteria
d. To perform mathematical calculations on data in cells
The correct answer is: To evaluate a logical condition and return one value if true and another value if false
Question 215
Not answered
Marked out of 1.00
63 of 77 10/17/2024, 8:47 PM
What is a password?
a. A device used to secure a network.

b. A software used to browse the Internet.
c. A program used to create backups.
d. A set of characters used to get access to a computer, web page, network resource or data.
The correct answer is: A set of characters used to get access to a computer, web page, network resource or data.
Question 216
Not answered
Marked out of 1.00
What can be included as activities in Moodle?
a. Outdoor excursions
b. Live lectures
c. Attendance tracking
d. Book reviews
The correct answer is: Attendance tracking
Question 217
Not answered
Marked out of 1.00
The intersection of a row and a column is called a.......
a. cell
b. sum
c. chart
d. worksheet
The correct answer is: cell
Question 218
Not answered
Marked out of 1.00
What is the difference between system software and application software?
a. System software is used to create documents, while application software controls the hardware of the computer.
b. System software manages the computer system, while application software performs specific tasks.
c. System software provides output to the user, while application software provides input to the computer.
64 of 77 10/17/2024, 8:47 PM
d. System software is used for communication, while application software is used for data storage.
The correct answer is: System software manages the computer system, while application software performs specific tasks.
Question 219
Not answered
Marked out of 1.00
To select a range, select a cell, then with the left mouse button pressed, drag over the other cells.
a. False
b. True
Question 220
Not answered
Marked out of 1.00
A microphone is an audio input device that converts sound
a. False
b. True
The correct answers are: True, False
Question 221
Not answered
Marked out of 1.00
Addition is……………
a. non arithmetic operation

b. arithmetic operation
c. illogical operation
d. logical operation
The correct answer is: arithmetic operation
Question 222
Not answered
Marked out of 1.00
65 of 77 10/17/2024, 8:47 PM
Which of the following is a valid error value in Excel 2016?
a. All answers are true

b. #DIV/0!
c. #VALUE!
d. #REF!
Question 223
Not answered
Marked out of 1.00
Which of the following is a recommended tip for creating a strong password?
a. The password should contain the user's name.

b. The password should contain a mixture of numbers, letters, and special characters.
c. The password should be less than 8 characters in length.
d. The password should contain only letters.
The correct answer is: The password should contain a mixture of numbers, letters, and special characters.
Question 224
Not answered
Marked out of 1.00
Which of the following is a valid conditional formatting rule in Excel 2016?
a. Format cells that are greater than a certain value

b. Format cells that contain specific text
c. Format cells that are less than a certain value
d. All answers are true
Question 225
Not answered
Marked out of 1.00
What is online web check-in?
a. A service that allows you to book your flight online

b. A service that allows you to cook food online while waiting for your flight
c. A service that allows you to clean your clothes online while waiting for your flight
d. A service that allows you to check in for your flight online
66 of 77 10/17/2024, 8:47 PM
d. A service that allows you to check in for your flight online
The correct answer is: A service that allows you to check in for your flight online
Question 226
Not answered
Marked out of 1.00
What is the keyboard shortcut to select two or more adjacent sheets in Excel 2016?
a. Ctrl + Shift + click each sheet tab

b. Ctrl + click each sheet tab
c. Alt + click each sheet tab
d. Shift + click each sheet tab
The correct answer is: Shift + click each sheet tab
Question 227
Not answered
Marked out of 1.00
How can you unfreeze rows and columns in Excel 2016?
a. Click on the "Page Layout" tab, then select "Unfreeze Panes"

b. Click on the "Home" tab, then select "Unfreeze Panes"
c. Right-click on the row or column you want to unfreeze, choose "Unfreeze Panes"
d. Go to the "View" tab, choose "Freeze Panes", then select "Unfreeze Panes"
The correct answer is: Go to the "View" tab, choose "Freeze Panes", then select "Unfreeze Panes"
Question 228
Not answered
Marked out of 1.00
To insert a new worksheet in Excel 2016, you can use the shortcut key:
a. Ctrl + S
b. Ctrl + N
c. Ctrl + A
d. Ctrl + W
The correct answer is: Ctrl + N
67 of 77 10/17/2024, 8:47 PM
Question 229
Not answered
Marked out of 1.00
What are some of the forms that the data can take in distance learning?
a. Screen recorded videos

c. Physical textbooks
d. Physical lectures
The correct answer is: Screen recorded videos
Question 230
Not answered
Marked out of 1.00
What is the purpose of the MAX function in Excel?
a. To find the average value in a range of cells

b. To find the total value in a range of cells
c. To find the lowest value in a range of cells
d. To find the highest value in a range of cells
The correct answer is: To find the highest value in a range of cells
Question 231
Not answered
Marked out of 1.00
Which tab in the Format Cells dialog box in Excel 2016 allows you to add shading and background colors to a cell?
a. Number
b. Font
c. Alignment
d. Fill
The correct answer is: Fill
Question 232
Not answered
Marked out of 1.00
What options can you restrict when protecting a worksheet in Excel 2016?
68 of 77 10/17/2024, 8:47 PM
a. Selecting cells
b. Editing objects
c. Formatting cells
d. All answers are true
Question 233
Not answered
Marked out of 1.00
Screen share button lets you share your computer screen with only FOUR participants in a Zoom meeting. Select one:
a. False
b. True
Question 234
Not answered
Marked out of 1.00
What is the function of the Control Unit in a CPU?
a. Store data for later use

b. Control movement of signals among CPU, memory, and other devices
c. Perform basic arithmetical and logical operations
d. Carry out the instructions of a computer program
The correct answer is: Control movement of signals among CPU, memory, and other devices
Question 235
Not answered
Marked out of 1.00
The arrangement that shows multiple open windows overlapped one over the other is………….
a. Cascade windows
b. Windows side by side
c. Windows stack
d. Windows Height
The correct answer is: Cascade windows
69 of 77 10/17/2024, 8:47 PM
Question 236
Not answered
Marked out of 1.00
Asynchronous learning It means that the teacher and the student are most likely on different schedules and are not in direct communication.
Select one:
a. True
b. False
Question 237
Not answered
Marked out of 1.00
Which Excel function rounds a number down to a specified number of decimal places?
a. ROUNDDOWN
b. ABS
c. ROUNDUP
d. ROUND
The correct answer is: ROUNDDOWN
Question 238
Not answered
Marked out of 1.00
Which Malware is transmitted as an attachment to an email or in a downloaded file?
a. Spyware
b. Trojan Horse
c. Worm
d. Virus
The correct answer is: Virus
Question 239
Not answered
Marked out of 1.00
What is the most significant benefit of distance education?
70 of 77 10/17/2024, 8:47 PM
What is the most significant benefit of distance education?
a. Low cost
b. Flexible learning
c. All answers are true
d. Easy access
Question 240
Not answered
Marked out of 1.00
How can you protect yourself from Malware?
a. Click, download and install without confirmation while browsing the internet
b. Use the "auto-run" option in Windows OS for portable drives
c. Be ware of strange emails, especially ones with attachments
d. Do not use anti-virus software
The correct answer is: Be ware of strange emails, especially ones with attachments
Question 241
Not answered
Marked out of 1.00
What are Icons on the Windows 10 Desktop?
a. Buttons that perform system functions

b. Shortcuts to websites
c. Small text boxes containing information
d. Small graphical pictures linked to files, folders or applications
The correct answer is: Small graphical pictures linked to files, folders or applications
Question 242
Not answered
Marked out of 1.00
Which Excel function rounds a number up to a specified number of decimal places?
a. ROUND
b. ROUNDDOWN
c. ROUNDUP
d. ABS
71 of 77 10/17/2024, 8:47 PM
The correct answer is: ROUNDUP
Question 243
Not answered
Marked out of 1.00
What is Zoom's primary function?
a. Video conferencing
b. Online shopping
c. Social networking
d. Email service
The correct answer is: Video conferencing
Question 244
Not answered
Marked out of 1.00
When all the numbers between 1000 and 2000 in a range should be displayed in Green Color, you can use? Select one:
a. Font color
b. Conditional Formatting
c. IF function
d. Filtering
The correct answer is: Conditional Formatting
Question 245
Not answered
Marked out of 1.00
What elements should a copyright notice contain?
a. The name of the author.

b. The symbol ©, the year of the copyright, and the name of the owner.
c. The date of publication.
d. The ISBN number.
The correct answer is: The symbol ©, the year of the copyright, and the name of the owner.
Question 246
72 of 77 10/17/2024, 8:47 PM
Not answered
Marked out of 1.00
How can you copy a worksheet in Excel 2016 by dragging the worksheet tab?
a. Press Alt + drag the worksheet tab to the tab location you want
b. Press Ctrl + Shift + drag the worksheet tab to the tab location you want
c. Press Ctrl + drag the worksheet tab to the tab location you want
d. Press Shift + drag the worksheet tab to the tab location you want
The correct answer is: Press Ctrl + drag the worksheet tab to the tab location you want
Question 247
Not answered
Marked out of 1.00
To apply a border to selected cells in Excel 2016, which option should you select?
a. Home > Font

b. Home > Borders
c. Home > Fill
d. Home > Number
The correct answer is: Home > Borders
Question 248
Not answered
Marked out of 1.00
How can you delete a column or row in Excel 2016?
a. Right-click on the column letter / row number that is the column / row you want to remove, select "Delete"
b. Press Ctrl + D
c. Press Ctrl + X
d. Right-click on the column letter / row number that you want to add, select "Delete"
The correct answer is: Right-click on the column letter / row number that is the column / row you want to remove, select "Delete"
Question 249
Not answered
Marked out of 1.00
Which Excel function tests a condition and returns one value if the condition is true, and another value if the condition is false?
73 of 77 10/17/2024, 8:47 PM
a. NOT
b. IF
c. OR
d. AND
The correct answer is: IF
Question 250
Not answered
Marked out of 1.00
Why does the value in cell G1 look slightly different from the value in the formula bar?
a. It's using a formula

b. It's using an absolute cell reference
c. It's using the Currency number format
d. It's using conditional formatting
The correct answer is: It's using conditional formatting
Question 251
Not answered
Marked out of 1.00
Why should an instructor hold small-group conversations in breakout rooms in virtual classroom management?
a. To encourage student interaction.

b. To avoid interactions between Instructor and students.
c. None of the above.
d. To reduce the number of students in the live session.
The correct answer is: To encourage student interaction.
Question 252
Not answered
Marked out of 1.00
The Task View button provides easy switching among open windows
a. False
b. True
74 of 77 10/17/2024, 8:47 PM
Question 253
Not answered
Marked out of 1.00
To use libraries, you have to move files from their original location
a. False
b. True
Question 254
Not answered
Marked out of 1.00
Which error occurs when something needs to be corrected in the syntax of the formula?
a. Error #####
b. Error #DIV/0!
c. Error #REF!
d. Error #NAME?
The correct answer is: Error #NAME?
Question 255
Not answered
Marked out of 1.00
Which of the following is not an output device?
a. Keyboard
b. Monitor
c. Speakers
d. Printer
Question 256
Not answered
Marked out of 1.00
What is the function of primary storage devices?
To store data permanently
75 of 77 10/17/2024, 8:47 PM
a. To store data permanently

b. To provide backup of important files
c. To provide extra storage capacity
d. To hold programs and data currently in use by the CPU
The correct answer is: To hold programs and data currently in use by the CPU
Question 257
Not answered
Marked out of 1.00
Which option should you select in the Print dialog box to print a chart in Excel 2016?
a. Selection
b. Home
c. Active Sheet
d. Charts
The correct answer is: Charts
Question 258
Not answered
Marked out of 1.00
Which Excel function converts a text string to all lowercase letters?
a. LOWER
b. UPPER
c. PROPER
d. IF
The correct answer is: LOWER
Question 259
Not answered
Marked out of 1.00
What is the Taskbar in Windows 10?
a. A vertical bar on the left side of the screen

b. A wide horizontal bar at the bottom of the Desktop
c. An area on the right side of the screen that shows system notifications
d. A small box that displays running applications
76 of 77 10/17/2024, 8:47 PM
The correct answer is: A wide horizontal bar at the bottom of the Desktop
Question 260
Not answered
Marked out of 1.00
What is the role of technology in evaluation in remote education?
a. To link evaluation to the manner of delivery of distant education

b. To make evaluation more complicated
c. To replace paper-based evaluation techniques
d. To create more barriers for learners
The correct answer is: To link evaluation to the manner of delivery of distant education
Question 261
Not answered
Marked out of 1.00
In Excel 2016, what is the shortcut key to select non-adjacent cells?
a. Ctrl + Click
b. Shift + Click
c. Alt + Click
d. Tab + Click
The correct answer is: Ctrl + Click
77 of 77 10/17/2024, 8:47 PM

Trial Exam For Final 1 - Attempt Review

Uploaded by

Copyright:

Available Formats

Trial Exam For Final 1 - Attempt Review

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Trial Exam For Final 1 - Attempt Review

Uploaded by

Copyright:

Available Formats

Trial exam for final 1: Attempt review https://smartlearning.must.edu.eg/mod/quiz/review.php?attempt=3220...

Started on Thursday, 17 October 2024, 8:43 PM

Mark 0.00 out of 1.00

The correct answer is: Asynchronous learning

Mark 1.00 out of 1.00

Which of the following is an example of hardware in a computer system?

The correct answer is: Keyboard

Mark 1.00 out of 1.00

What are the options available for students in distance learning?

a. Video conferencing possibilities

d. Options to suit almost everyone's requirements

The correct answer is: All answers are true

Mark 1.00 out of 1.00

How can you unhide a row in Excel 2016?

Mark 1.00 out of 1.00

Which quality is helpful for distance learning? Select one:

The correct answer is: Flexibility

Marked out of 1.00

The correct answer is: interactive networks

Marked out of 1.00

a. To create a duplicate copy of the original worksheet

Marked out of 1.00

To Show or hide the Details pane, use………………

The correct answer is: ALT+shift+P

Marked out of 1.00

Which of the following is NOT a benefit of distance education?

a. Physical presence in the classroom

The correct answer is: Physical presence in the classroom

Marked out of 1.00

Do all devices require an Operating System to function properly?

a. No, devices can function without an Operating System.

a. No, devices can function without an Operating System.

Marked out of 1.00

The correct answer is: MAX

Marked out of 1.00

The correct answer is: Computer memory

Marked out of 1.00

The worksheet tab color can't be changed

The correct answer is: False

Marked out of 1.00

The correct answer is: False

Marked out of 1.00

The correct answer is: Orientation

Marked out of 1.00

Hybrid distance education is a type of blended learning Select one:

The correct answer is: True

Marked out of 1.00

How do you give data to a computer?

The correct answer is: By typing it using a keyboard

Marked out of 1.00

What is local backup?

a. Backing up data on an email account.

Marked out of 1.00

Which of the following statements about ROM is true?

a. ROM is a non- volatile memory

The correct answer is: ROM is a non- volatile memory

Marked out of 1.00

Which of the following is a primary storage device?

The correct answer is: RAM