امتحان مستوى CIS 99
امتحان مستوى لمادة الحاسوب 99 في جامعة العلوم والتكنولوجيا لعام 2018-2019 BioNeer Team في الهندسة الطبية
- 1.
In Excel the intersection of a column and a row is called:
- A.
A. Rang
- B.
B. Block.
- C.
C. Selection.
- D.
D. Cell.
Correct Answer
D. D. Cell.Explanation
In Excel, the intersection of a column and a row is referred to as a "cell". This is where data can be entered and manipulated, and formulas can be applied to perform calculations. Cells are identified by their unique combination of column letter and row number, such as A1, B2, etc.Rate this question:
-
- 2.
A rectangular block of cells is called a:
- A.
A. Data block.
- B.
B. Paragraph.
- C.
C. Code segment.
- D.
D. Range.
Correct Answer
D. D. Range.Explanation
A rectangular block of cells is commonly referred to as a range. A range in this context refers to a group of cells in a spreadsheet that are selected or referenced together. It can be a single row, a single column, or a combination of both. Ranges are often used for performing calculations, applying formatting, or manipulating data in spreadsheets.Rate this question:
-
- 3.
In Excel, what is the result of the formula = 3 +(4 – 2 )*3?
- A.
15
- B.
9
- C.
4
- D.
None
Correct Answer
B. 9Explanation
The given formula is = 3 + (4 - 2) * 3. According to the order of operations in mathematics, we should first solve the inner parentheses, which is 4 - 2 = 2. Then, we multiply 2 by 3, resulting in 6. Finally, we add 3 to 6, giving us the final result of 9.Rate this question:
-
- 4.
What happens when you close a workbook that you work with in Excel?
- A.
A. The workbook is automatically saved.
- B.
B. Excel will automatically exit.
- C.
C. If you made changes to the workbook since you last saved, a dialog box will appear and give you the opportunity to save again.
- D.
D. A new, empty workbook will automatically appear.
Correct Answer
C. C. If you made changes to the workbook since you last saved, a dialog box will appear and give you the opportunity to save again.Explanation
When you close a workbook that you work with in Excel, if you made changes to the workbook since you last saved, a dialog box will appear and give you the opportunity to save again. This ensures that any changes you made are not lost and allows you to save the updated version of the workbook before closing it.Rate this question:
-
- 5.
What is the shorter way of computing = C1+C2+C3+C4+C5+C6+C7+C8?
- A.
A. ADD (C1..C8).
- B.
B. TOTAL (C1:C8).
- C.
C. SUM (C1:C8).
- D.
D. C1:C8.
Correct Answer
C. C. SUM (C1:C8).Explanation
The correct answer is c. SUM (C1:C8). This is the shorter way of computing the sum of C1 to C8. The SUM function in most spreadsheet software allows you to add up a range of cells by specifying the starting and ending cell references. In this case, C1:C8 represents the range of cells from C1 to C8, and using the SUM function with this range will give you the sum of all the values in those cells.Rate this question:
-
- 6.
Writing an incorrect formula that attempts to perform math by referring to a text entry causes excel to display what in the formula cell?
- A.
Error
- B.
Value
Correct Answer
B. ValueExplanation
When writing an incorrect formula that attempts to perform math by referring to a text entry, Excel will display "Value" in the formula cell. This means that Excel is unable to calculate the formula due to the presence of a text entry, which is not a valid input for mathematical operations. Therefore, instead of displaying an error message, Excel shows "Value" to indicate that the formula cannot be evaluated.Rate this question:
-
- 7.
On a Chart, what is used to indicate what each color or symbol stands for?
- A.
A data series.
- B.
B. The X-axis.
- C.
C. A legend.
- D.
D. A category.
Correct Answer
C. C. A legend.Explanation
A legend is used on a chart to indicate what each color or symbol stands for. It helps the viewer understand the meaning of different elements in the chart, such as different data series or categories. The legend provides a key that explains the representation of each element, making it easier for the viewer to interpret the chart accurately.Rate this question:
-
- 8.
Line charts are most appropriate for:
- A.
A. Showing trends or changes over time.
- B.
B. Comparing individual values at specific times.
- C.
C. Showing relationships among portions of a whole.
- D.
D. None of the above.
Correct Answer
A. A. Showing trends or changes over time.Explanation
Line charts are most appropriate for showing trends or changes over time because they visually represent the relationship between two variables on a continuous scale. By plotting data points and connecting them with lines, line charts effectively illustrate how the values of a variable change over a specific period. This makes them ideal for analyzing patterns, identifying trends, and understanding the direction and magnitude of changes over time. Comparing individual values at specific times or showing relationships among portions of a whole are better suited for other types of charts, such as bar charts or pie charts.Rate this question:
-
- 9.
Pie charts are most appropriate for:
- A.
A. Showing trends or changes over time.
- B.
B. Comparing individual values at specific times.
- C.
C. Showing relationships among portions of a whole.
- D.
D. None of the above.
Correct Answer
C. C. Showing relationships among portions of a whole.Explanation
Pie charts are most appropriate for showing relationships among portions of a whole because they visually represent the proportion of each category in relation to the total. The size of each slice in the pie chart corresponds to the percentage or proportion it represents, making it easy to compare the relative sizes of each category. This allows for a clear understanding of the distribution and relationship between different parts of the whole.Rate this question:
-
- 10.
What is the combination of keys required to come back to the top of the worksheet?
- A.
a. Page Up (PgUp).
- B.
B. Alt and Page Up.
- C.
C. Ctrl and Home.
- D.
D. Ctrl and left arrow.
Correct Answer
C. C. Ctrl and Home.Explanation
To come back to the top of the worksheet, the combination of keys required is Ctrl and Home. This combination allows the user to quickly navigate to the first cell of the worksheet, regardless of the current position on the sheet.Rate this question:
-
- 11.
The name of the document is:
- A.
A. Computer Skills.doc.
- B.
B. Computer Skills.xlsx.
- C.
C. Computer Skills.pdf.
- D.
D. Computer Skills.dox.
Correct Answer
D. D. Computer Skills.dox. -
- 12.
If you select a cell with a date in it and drag the fill handle down across several cells, what happens is that.
- A.
A. The date is copied to each cell.
- B.
B. The date is increased by 1 day into each cell.
- C.
C. The date is increased by 1 week into each cell.
- D.
D. Nothing as AutoFill applies only to numbers.
Correct Answer
B. B. The date is increased by 1 day into each cell.Explanation
When you select a cell with a date in it and drag the fill handle down across several cells, the date is increased by 1 day into each cell. This is because the fill handle automatically increments the date by 1 day as you drag it down.Rate this question:
-
- 13.
The formula that will add the value of cell D4 to the value of C2 and then multiply by the value in B2 is:
- A.
A. (D4+C2)*B2.
- B.
B. D4+C2*B2.
- C.
C. = (D4+C2*B2.
- D.
D. = (B2*(D4+C2).
Correct Answer
A. A. (D4+C2)*B2.Explanation
The correct answer is (D4+C2)*B2 because the formula specifies that the value of cell D4 should be added to the value of C2 first, and then the result should be multiplied by the value in B2. The parentheses ensure that the addition is performed before the multiplication.Rate this question:
-
- 14.
You can automatically resize the column to fit the width of the column’s contents by on the column boundary line:
- A.
A. Clicking.
- B.
B. Double-clicking.
- C.
C. Right-clicking.
- D.
D. Double right-clicking.
Correct Answer
B. B. Double-clicking.Explanation
By double-clicking on the column boundary line, the column will automatically resize to fit the width of the column's contents. This action triggers the automatic resizing feature in the software, which adjusts the column width based on the content within it.Rate this question:
-
- 15.
To save an existing file with a new name, what command should you use?
- A.
A. File Name.
- B.
B. Save As.
- C.
C. Versions.
- D.
D. Save
Correct Answer
B. B. Save As.Explanation
To save an existing file with a new name, you should use the "Save As" command. This command allows you to specify a new name and location for the file, while preserving the original file. It is useful when you want to create a duplicate or a modified version of the file without overwriting the original. The other options, such as "File Name," "Versions," and "Save," do not specifically allow you to save the file with a new name.Rate this question:
-
- 16.
/ How many cells are included in the range A1:B3?
- A.
2
- B.
4
- C.
6
- D.
9
Correct Answer
C. 6Explanation
The range A1:B3 includes 6 cells. It includes 3 cells in the first row (A1, B1, and C1) and 3 cells in the second row (A2, B2, and C2), making a total of 6 cells.Rate this question:
-
- 17.
Which of the following functions is written in the correct syntax?
- A.
NOW(today).
- B.
B. SUM(D2-A2).
- C.
C. =SUM(A1:D1).
- D.
D. =SUM(A1=B1).
Correct Answer
C. C. =SUM(A1:D1).Explanation
The correct answer is c. =SUM(A1:D1). This is the correct syntax for the SUM function in Excel, where the function name is followed by parentheses and the range of cells to be summed is specified within the parentheses. In this case, the range A1:D1 is being summed.Rate this question:
-
- 18.
What type of chart is this?
- A.
A. Doughnut
- B.
B. Radar.
- C.
C. Bar
- D.
D. Pie.
Correct Answer
D. D. Pie.Explanation
This chart is a pie chart because it represents data as slices of a circle, with each slice representing a proportion or percentage of the whole.Rate this question:
-
- 19.
/ The values in cells D5 , D6 , D7 in this figure are:
- A.
A. 8, -2, 29.
- B.
B. 9, 29, -3.
- C.
C. 9, -3, 29.
- D.
D. 3, -3, 21.
Correct Answer
C. C. 9, -3, 29. -
- 20.
Internet is:
- A.
A. A local computer network.
- B.
B. A worldwide network of computers.
- C.
C. An interconnected network of computers.
- D.
D. A worldwide interconnected network of computers which use a common protocol to communicate with one another.
Correct Answer
D. D. A worldwide interconnected network of computers which use a common protocol to communicate with one another.Explanation
The correct answer is d. This answer provides the most comprehensive and accurate description of the internet. It highlights that the internet is not just a local network or a worldwide network, but rather a worldwide interconnected network of computers. It also mentions the use of a common protocol for communication, which is a key characteristic of the internet.Rate this question:
-
- 21.
Each computer connected to the internet must:
- A.
A. Be an IBM PC.
- B.
B. Have a unique IP address.
- C.
C. Be internet compatible.
- D.
D. Have a modem connection.
Correct Answer
B. B. Have a unique IP address.Explanation
Each computer connected to the internet must have a unique IP address. An IP address is a numerical label assigned to each device connected to a computer network that uses the Internet Protocol for communication. It serves as an identifier for the device, allowing it to send and receive data over the internet. Without a unique IP address, multiple devices would not be able to communicate effectively on the internet, leading to network conflicts and communication issues.Rate this question:
-
- 22.
Worldwide Web:
- A.
A. Is another name for Internet.
- B.
B. Worldwide connection for computers.
- C.
C. A collection of linked information residing on computers connected by the Internet.
- D.
D. A collection of worldwide information.
Correct Answer
C. C. A collection of linked information residing on computers connected by the Internet.Explanation
The correct answer is c. The Worldwide Web is a collection of linked information that is stored on computers that are connected by the Internet. This means that the information is not just located in one place, but rather spread out across multiple computers all over the world. These computers are connected by the Internet, allowing users to access and navigate through the linked information.Rate this question:
-
- 23.
A search engine is a program to search:
- A.
A. For information.
- B.
B. Web pages.
- C.
C. Web pages for specified index terms.
- D.
D. Web pages for information using specified search terms.
Correct Answer
D. D. Web pages for information using specified search terms.Explanation
A search engine is a program that allows users to search for information on the internet by using specific search terms. It does not just search for web pages or index terms, but it specifically searches for web pages that contain information related to the specified search terms. Therefore, the correct answer is d. Web pages for information using specified search terms.Rate this question:
-
- 24.
/ The computer jargon - WWWW, stands for:
- A.
A. World Wide Web Worm
- B.
B. World Wide Wildlife Web.
- C.
C. World Wide Women's Web.
- D.
D. World Wide Women's Week.
Correct Answer
A. A. World Wide Web WormExplanation
The correct answer is a. World Wide Web Worm. The acronym WWWW does not correspond to any of the other options. "World Wide Web Worm" is a term used in computer jargon to refer to a malicious program that replicates itself across the internet.Rate this question:
-
- 25.
/ The process of transferring files from a computer on the Internet to your computer is called:
- A.
A. Uploading.
- B.
B. Forwarding
- C.
C. FTP.
- D.
D. Downloading.
Correct Answer
D. D. Downloading.Explanation
Downloading refers to the process of transferring files from a computer on the Internet to your own computer. It is the opposite of uploading, which is the process of transferring files from your computer to another computer on the Internet. Forwarding is the process of sending a file or message to another recipient. FTP (File Transfer Protocol) is a network protocol used for transferring files between a client and a server on a computer network. Therefore, the correct answer is d. Downloading.Rate this question:
-
- 26.
Moving from one website to another is called:
- A.
A. Downloading.
- B.
B. Browsing .
- C.
C. Uploading.
- D.
D. Attachment.
Correct Answer
B. B. Browsing .Explanation
Moving from one website to another is called browsing. Browsing refers to the activity of searching and navigating through different websites on the internet. It involves accessing various web pages, links, and content on the internet. Downloading refers to the process of transferring files from a remote system to a local device, while uploading refers to the opposite, transferring files from a local device to a remote system. Attachment refers to adding a file or document to an email or message. Therefore, the correct answer is browsing.Rate this question:
-
- 27.
Control Unit (CU) is the:
- A.
A. Main unit of the computer and sometimes is called the brain of the computer.
- B.
B. Unit that controls and coordinates all other computer components.
- C.
C. Main memory of any computer system.
- D.
D. Unit that is responsible for performing all the computer calculations.
Correct Answer
B. B. Unit that controls and coordinates all other computer components.Explanation
The Control Unit (CU) is responsible for controlling and coordinating all other computer components. It acts as the central nervous system of the computer, directing the flow of data and instructions between the various hardware components such as the CPU, memory, and input/output devices. The CU interprets instructions from the computer's memory and generates the necessary control signals to execute them. It ensures that all components work together harmoniously and in sync, enabling the computer to perform tasks efficiently and effectively.Rate this question:
-
- 28.
The largest computers, used mainly for research, are called:
- A.
A. Microcomputers.
- B.
B. Maxicomputers
- C.
C. Supercomputers.
- D.
D. Mainframe computers.
Correct Answer
C. C. Supercomputers.Explanation
Supercomputers are the largest computers used mainly for research purposes. They are capable of performing complex calculations and processing large amounts of data at incredibly high speeds. These computers are designed to handle tasks that require massive computational power, such as weather forecasting, scientific simulations, and nuclear research. Supercomputers are typically housed in specialized facilities and are used by government agencies, academic institutions, and large corporations for advanced scientific and engineering applications.Rate this question:
-
- 29.
The name for the kind of software that performs tasks like word processing or database management is:
- A.
A. DOS.
- B.
B. System software.
- C.
C. Application software.
- D.
D. Operation software.
Correct Answer
C. C. Application software.Explanation
The correct answer is c. Application software. Application software refers to the type of software that is designed to perform specific tasks such as word processing or database management. It is different from system software (b) which is responsible for managing and controlling computer hardware and providing a platform for running application software. DOS (a) is an operating system, not a type of software. Operation software (d) is not a commonly used term in the context of software.Rate this question:
-
- 30.
Software used to interact between user programs and the computer is called:
- A.
A. Application software.
- B.
B. System software.
- C.
C. Operation software.
- D.
D. Custom made software.
Correct Answer
B. B. System software.Explanation
System software is the correct answer because it refers to the software that manages and controls the computer hardware and provides a platform for running application software. It includes operating systems, device drivers, and utility programs that help in the smooth functioning of the computer system. Application software, on the other hand, refers to the programs that are designed for specific tasks or applications, such as word processors, spreadsheets, or web browsers. Operation software and custom-made software are not commonly used terms in the context of software classification.Rate this question:
-
- 31.
/ The number of bits in a byte is:
- A.
4
- B.
8
- C.
16
- D.
32
Correct Answer
B. 8Explanation
A byte consists of 8 bits. Each bit can represent either a 0 or a 1, and when combined together, they form a byte. Therefore, the correct answer is 8.Rate this question:
-
- 32.
The CU:
- A.
A. Used to store the processed data temporarily.
- B.
B. Used to control the processes in the CPU.
- C.
C. Used to control the output and the input units only.
- D.
D. Used to control the RAM only.
Correct Answer
B. B. Used to control the processes in the CPU.Explanation
The CU, or Control Unit, is responsible for controlling the processes in the CPU. It coordinates and manages the flow of data and instructions within the CPU and ensures that all operations are executed in the correct sequence. It fetches instructions from memory, decodes them, and then coordinates the execution of these instructions by sending control signals to other components of the CPU. The CU also manages the flow of data between the CPU and other devices, such as input and output units. Therefore, option b is the correct answer.Rate this question:
-
- 33.
Which of the following statements is correct?
- A.
A. Mini-computers more powerful than mainframes
- B.
B. Micro-computers such as laptops.
- C.
C. Mini-computers are suitable for personals.
- D.
D. Mainframes are suitable for small companies
Correct Answer
B. B. Micro-computers such as laptops. -
- 34.
The sound blaster is:
- A.
A. An output unit only.
- B.
B. An input unit only.
- C.
C. Both of the above.
Correct Answer
A. A. An output unit only.Explanation
The correct answer is a. An output unit only. This means that the sound blaster is designed to only produce sound output and does not have any input capabilities. It is typically used to enhance the audio experience on a computer or other electronic device by providing high-quality sound output for activities such as listening to music, watching videos, or playing games.Rate this question:
-
- 35.
The most widely used type of computer is the:
- A.
A. Supercomputer.
- B.
B. Mainframe.
- C.
C. Minicomputer.
- D.
D. Microcomputer.
Correct Answer
D. D. Microcomputer.Explanation
The most widely used type of computer is the microcomputer because it is small, affordable, and can be found in various forms such as laptops, desktops, tablets, and smartphones. Microcomputers are commonly used by individuals, businesses, and organizations for personal and professional purposes. They are versatile and can perform a wide range of tasks, including word processing, internet browsing, multimedia playback, and software development. Due to their popularity and accessibility, microcomputers have become the dominant type of computer in terms of usage and market share.Rate this question:
-
- 36.
Floppy disks, optical disks, DVDs, and hard drives are all examples of:
- A.
A. System software .
- B.
B. Primary storage or memory.
- C.
C. Secondary storage.
- D.
D. CPUs
Correct Answer
C. C. Secondary storage.Explanation
Floppy disks, optical disks, DVDs, and hard drives are all examples of secondary storage. Secondary storage refers to non-volatile storage devices that are used to store data for long-term or permanent use. These storage devices are external to the computer's main memory and are used to store large amounts of data that can be accessed at a later time. System software refers to the software that manages and controls the computer's hardware and software resources. Primary storage or memory refers to the computer's main memory where data is temporarily stored for immediate use. CPUs are the central processing units of a computer that perform the majority of the processing tasks.Rate this question:
-
- 37.
The ALU performs:
- A.
A. Input and Output operations.
- B.
B. Absolute and Lateral operations.
- C.
C. Memory and I/O operations.
- D.
D. Arithmetic and Logical operations.
Correct Answer
D. D. Arithmetic and Logical operations.Explanation
The ALU, or Arithmetic Logic Unit, is responsible for performing arithmetic and logical operations. It is a fundamental component of a computer's central processing unit (CPU) and is used to perform calculations and logical comparisons. This includes operations such as addition, subtraction, multiplication, division, AND, OR, and NOT operations. The ALU takes input values, performs the specified operation, and produces an output result. Therefore, option d, which states that the ALU performs Arithmetic and Logical operations, is the correct answer.Rate this question:
-
- 38.
A mouse, touch screen, and trackball are all examples of :
- A.
A. Scanning devices.
- B.
B. Voice-input devices.
- C.
C. Pointing devices.
- D.
D. Output devices.
Correct Answer
C. C. Pointing devices.Explanation
A mouse, touch screen, and trackball are all examples of pointing devices because they are used to control the movement of a cursor or pointer on a computer screen. These devices allow the user to interact with the computer by selecting and clicking on items displayed on the screen. Scanning devices are used to convert physical documents into digital format, voice-input devices allow users to input commands or data using their voice, and output devices are used to display or produce information from a computer.Rate this question:
-
- 39.
When you select search icon from start menu and type S*S.doc, this means that:
- A.
A. The computer will find all files that have extension doc only.
- B.
B. The computer will find all files that have only three letters and extension is doc.
- C.
C. The computer will find all files that have first and last letter is S and extension is doc. d. None of the above .
Correct Answer
C. C. The computer will find all files that have first and last letter is S and extension is doc. d. None of the above .Explanation
When you select the search icon from the start menu and type S*S.doc, it means that the computer will find all files that have the letter "S" as the first and last letter of their filename, and have the extension ".doc". This means that the computer will search for files that have names like "SOS.doc" or "SIS.doc". The answer "c. The computer will find all files that have first and last letter is S and extension is doc" accurately describes this behavior. The answer "d. None of the above" is incorrect because option c is the correct answer.Rate this question:
-
- 40.
To launch an application in Windows, you can on its icon.
- A.
A. Click.
- B.
B. Drag.
- C.
C. Double click.
- D.
D. None of the above
Correct Answer
A. A. Click.Explanation
To launch an application in Windows, you can click on its icon. This action typically involves using the mouse to select and press the left mouse button on the application's icon. By clicking on the icon, the user initiates the process of opening and running the application.Rate this question:
-
- 41.
Windows xp is an example of a(n):
- A.
A. Operating system.
- B.
B. Graphical user interface.
- C.
C. Application software.
- D.
D. Basic tools
Correct Answer
A. A. Operating system.Explanation
Windows XP is an example of an operating system because it is a software program that manages computer hardware and software resources and provides common services for computer programs. It controls the computer's memory, processes, and devices, and allows users to interact with the computer through a graphical user interface. Windows XP is specifically designed to be an operating system for personal computers.Rate this question:
-
- 42.
What we call this figure:
- A.
A. Stick Note.
- B.
B. Desktop Gadgets.
- C.
C. File.
- D.
D. Folder.
Correct Answer
A. A. Stick Note.Explanation
The figure in question is most likely a stick note. Stick notes are small pieces of paper with adhesive on one side, often used for writing short notes or reminders. The term "desktop gadgets" refers to small applications or tools that can be placed on a computer desktop, so it is not applicable in this context. While a file or folder could also be depicted in the figure, the square shape and lack of any additional elements suggest that it is more likely a stick note.Rate this question:
-
- 43.
This figure represents:
- A.
A. Taskbar Properties.
- B.
B. Start Menu Properties.
- C.
C. Desktop Properties.
- D.
D. Taskbar and Start Menu Properties.
Correct Answer
D. D. Taskbar and Start Menu Properties.Explanation
The figure in question likely shows the settings or properties related to both the taskbar and the start menu. This can be inferred based on the options provided and the fact that the figure is likely displaying a combination of settings for both the taskbar and the start menu.Rate this question:
-
- 44.
If you try to quit word for windows without first saving changes to your document:
- A.
A. The changes will be lost.
- B.
B. Word for windows will save the changes automatically.
- C.
C. You will destroy your document file.
- D.
D. You will be asked if you want to save changes before quitting.
Correct Answer
D. D. You will be asked if you want to save changes before quitting.Explanation
If you try to quit Word for Windows without first saving changes to your document, you will be asked if you want to save the changes before quitting. This is a common feature in many applications, including Word, to prevent accidental loss of unsaved work. By prompting the user to save changes, Word gives them the opportunity to preserve their work before exiting the program.Rate this question:
-
- 45.
What would you do to highlight a word? You position the cursor next to the word and then:
- A.
A. Drag the mouse while holding the left mouse button.
- B.
B. Roll mouse around.
- C.
C. Click the mouse three times.
- D.
D. None of the above.
Correct Answer
A. A. Drag the mouse while holding the left mouse button.Explanation
To highlight a word, you would position the cursor next to the word and then drag the mouse while holding the left mouse button. This action allows you to select the desired word or text by dragging the cursor over it, thus highlighting it. Rolling the mouse around or clicking the mouse three times does not serve the purpose of highlighting a word.Rate this question:
-
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 21, 2023Quiz Edited by
ProProfs Editorial Team -
Sep 07, 2018Quiz Created by
RazanMetani
Back to top