CS001 Chapter Wise MCQs

CS001 NOTES AND PAST PAPERS

Download Notes

CS001 Lesson-1 MCQs

CS001 Lesson 1

1 / 25

Which of the following is a storage device?

A) Keyboard

B) Hard disk

C) Monitor

D) Mouse

Explanation:

Keyboard, monitor, and mouse are not storage devices.

Explanation:

A hard disk is a common storage device used in computers to store data.

2 / 25

Which type of storage is typically used for immediate access to data by a computer's processor?

A) CD-ROM

B) Hard disk

C) DVD

D) RAM

Explanation:

CD-ROMs, DVDs, and hard disks are not typically used for immediate access to data by a computer's processor.

Explanation:

RAM (Random Access Memory) is used for immediate access to data by the computer's processor, facilitating fast processing and access.

3 / 25

What is the typical use of mainframe computers?

A) For individual use in homes

B) For playing video games

C) For bulk data processing in large organizations

D) For portable computing needs

Explanation:

Mainframe computers are not typically used for personal tasks, playing video games, or portable computing needs.

Explanation:

Mainframe computers are typically used in large organizations for bulk data processing tasks like census and enterprise resource management.

4 / 25

Which component of a computer is considered hardware?

A) Operating System

B) Application software

C) Data processing algorithms

D) Keyboard

Explanation:

Operating systems, application software, and data processing algorithms are not considered hardware.

Explanation:

Hardware refers to the physical elements of a computer, such as the keyboard.

5 / 25

What primarily defines a computer?

A) A device that only stores data

B) A device that processes instructions to produce information

C) A device used for manual calculations

D) A device that can only output data

Explanation:

A computer is not merely a device that only stores data, is used for manual calculations, or can only output data.

Explanation:

A computer is defined as an electronic device that processes instructions to produce information as output.

6 / 25

What distinguishes a personal computer (PC) from other types of computers?

A) It is mainly used for large-scale data processing

B) It is designed for individual personal use

C) It cannot perform internet browsing

D) It is used exclusively for gaming

Explanation:

Personal computers are not mainly used for large-scale data processing, designed exclusively for gaming, or incapable of internet browsing.

Explanation:

Personal computers are designed for individual personal use, including household, personal productivity, and small business applications.

7 / 25

What does 'output' refer to in a computer system?

A) The data saved on the hard drive

B) The results or information produced by a computer after processing

C) The energy consumed by the computer

D) The components inside the computer case

Explanation:

The data saved on the hard drive, energy consumption, and components inside the computer case do not define 'output' in a computer system.

Explanation:

Output in a computer system refers to the results or information that comes out after the processing of input.

8 / 25

Which of the following best describes the physical characteristics of a personal computer compared to other types?

A) More expensive and less accessible

B) Larger and less portable

C) Smaller and more cost-effective

D) Less capable of handling multiple tasks

Explanation:

Personal computers are not more expensive and less accessible, larger and less portable, or less capable of handling multiple tasks compared to other types.

Explanation:

Personal computers are characterized by their smaller size and cost-effectiveness compared to larger systems like mainframes and minicomputers.

9 / 25

Which type of computer is known for its high speed and capability to perform large-scale calculations?

A) Personal computers

B) Mini computers

C) Supercomputers

D) Mainframe computers

Explanation:

Personal computers, minicomputers, and mainframe computers are not typically known for high speed and large-scale calculations.

Explanation:

Supercomputers are known for their exceptional speed and ability to handle large-scale computations.

10 / 25

What does the term 'processing' describe in the context of computer operations?

A) Storing data permanently

B) Inputting data into the computer

C) Turning raw data into meaningful information

D) Displaying information on the monitor

Explanation:

Storing data permanently, inputting data, and displaying information do not describe 'processing' in the context of computer operations.

Explanation:

Processing in computer operations involves converting raw data into organized, meaningful, and useful information.

11 / 25

What is a characteristic of software?

A) It is tangible

B) It has physical mass

C) It can be physically touched

D) It is intangible

Explanation:

Software being tangible, having physical mass, and being physically touchable are not characteristics of software.

Explanation:

Software is intangible, meaning it cannot be physically touched or held like hardware.

12 / 25

What is the role of an output device in a computer system?

A) To enter data into the computer

B) To process data into information

C) To display or produce the result of processed data

D) To store data for long-term retrieval

Explanation:

Output devices do not enter data into the computer, process data into information, or store data for long-term retrieval.

Explanation:

Output devices are used to display or produce the results of processed data, such as sounds or visual displays.

13 / 25

Which of the following is not a function of a computer's software?

A) Directing the hardware to perform tasks

B) Storing physical data

C) Executing specific computational operations

D) Managing the interaction between hardware components

Explanation:

Software does not store physical data, perform mechanical tasks, or manage the interaction between hardware components.

Explanation:

Software does not store physical data; it consists of programs that direct the hardware and manage computational tasks.

14 / 25

What is meant by 'input' in the context of computer terminology?

A) The instructions given to a computer

B) The output produced by a computer

C) The processing speed of a computer

D) The physical components of a computer

Explanation:

The output produced by a computer, processing speed, and physical components do not define 'input' in computer terminology.

Explanation:

In computer terminology, 'input' refers to the data, instructions, or information that is entered into the computer.

15 / 25

What is a common use for a mainframe computer in a commercial setting?

A) Managing personal data at home

B) Handling transactions for a large bank

C) Playing high-definition video games

D) Personal blogging and web browsing

Explanation:

Mainframe computers are not typically used for personal data management, playing video games, or personal blogging.

Explanation:

Mainframe computers are commonly used in commercial settings like banks to handle large-scale transactions efficiently.

16 / 25

Which of the following best describes a mini computer?

A) A low-cost computer for home use

B) A computer used for basic data processing

C) A powerful, expensive computer for complex tasks

D) A small, portable computer for personal use

Explanation:

A mini computer is not low-cost, used for basic data processing, or small and portable for personal use.

Explanation:

Mini computers are powerful and expensive, designed for complex procedures and intended for use by one user at a time.

17 / 25

Which of the following is an example of an input device?

A) Speaker

B) Monitor

C) Keyboard

D) Printer

Explanation:

Speaker, monitor, and printer are not examples of input devices.

Explanation:

A keyboard is an input device used to enter data and instructions into a computer.

18 / 25

Which of the following would be considered an output from a computer?

A) The text you type on a keyboard

B) The video displayed on a monitor

C) The data saved on a USB flash drive

D) The instructions sent to a printer

Explanation:

Text typed on a keyboard, data saved on a USB flash drive, and instructions sent to a printer are not outputs from a computer.

Explanation:

The video displayed on a monitor is an output, as it is the visible result of processed data.

19 / 25

What distinguishes software from hardware in a computer system?

A) Software is tangible, while hardware is not

B) Software performs mechanical tasks

C) Software is a set of instructions that directs the hardware

D) Hardware can operate independently of software

Explanation:

Software being tangible, performing mechanical tasks, and hardware operating independently of software do not distinguish software from hardware.

Explanation:

Software is a collection of programs or instructions that directs the hardware to perform specific tasks.

20 / 25

What is the primary advantage of portable computers over desktop PCs?

A) Higher processing power

B) More storage capacity

C) Mobility and integrated components

D) Better for gaming

Explanation:

Portable computers are not typically higher in processing power, have more storage capacity, or better for gaming compared to desktop PCs.

Explanation:

The primary advantage of portable computers is their mobility, allowing users to carry an integrated system of typical computer components wherever they go.

21 / 25

Which device is typically used as an output device in computers?

A) Microphone

B) Keyboard

C) Mouse

D) Headphones

Explanation:

Microphone, keyboard, and mouse are not typically used as output devices in computers.

Explanation:

Headphones are used as an output device for listening to sounds produced by a computer.

22 / 25

What is a characteristic of portable computers?

A) They lack a built-in battery

B) They cannot perform complex computations

C) They integrate all typical computer components into a single unit

D) They are primarily used for data center operations

Explanation:

Portable computers do not lack a built-in battery, cannot perform complex computations, and are not primarily used for data center operations.

Explanation:

Portable computers are designed for mobile use, integrating components like a display, keyboard, pointing device, and battery into one unit.

23 / 25

Which of the following is a key advantage of using computers over manual processes?

A) Higher error rate in outputs

B) Slower processing time

C) Increased efficiency in performing tasks

D) Limited storage capacity

Explanation:

Higher error rates, slower processing times, and limited storage capacity are not advantages of using computers.

Explanation:

Computers provide increased efficiency by performing millions of calculations effortlessly in a very short time.

24 / 25

What is the role of storage in computers?

A) To display information

B) To enter data into the computer

C) To keep data secure from unauthorized access

D) To hold data, information, or instructions

Explanation:

Displaying information, entering data, and keeping data secure do not define the role of storage in computers.

Explanation:

Storage in computers refers to the ability to save and hold data, information, or instructions.

25 / 25

What is the most reliable aspect of computers when compared to human effort?

A) Emotion-based decision making

B) Prone to making errors in calculations

C) Consistency and accuracy in outputs

D) Limited to physical tasks only

Explanation:

Emotion-based decision making, errors in calculations, and being limited to physical tasks are not aspects of reliability in computers.

Explanation:

Computers are highly reliable due to their ability to consistently produce accurate outputs based on the instructions they receive.

Your score is

LinkedIn Facebook Twitter VKontakte

CS001 Lesson-2 MCQs

CS001 Lesson 2

1 / 25

How do the arrow keys function differently when 'Scroll Lock' is on?

A) They navigate between applications.

B) They scroll the window instead of moving the cursor.

C) They do not function.

D) They increase text size.

Explanation:

When 'Scroll Lock' is on, the arrow keys do not navigate between applications or increase text size.

Explanation:

When 'Scroll Lock' is on, the arrow keys scroll the window content rather than moving the cursor.

2 / 25

What is the result of pressing Shift + 4 on a standard keyboard?

A) 4

B) $

C) %

D) &

Explanation:

Pressing Shift + 4 does not result in typing the number 4, the % symbol, or the & symbol.

Explanation:

Shift + 4 results in the $ symbol being printed.

3 / 25

What does the F5 function key do in most web browsers?

A) Opens a new tab

B) Closes the current window

C) Refreshes the page

D) Saves the current page

Explanation:

F5 does not open a new tab, close the current window, or save the current page.

Explanation:

F5 is commonly used to refresh the web page in internet browsers.

4 / 25

Which key is used to create a space between characters?

A) Enter key

B) Space Bar

C) Tab key

D) Caps lock key

Explanation:

The Enter key, Tab key, and Caps lock key are not used to generate space between characters.

Explanation:

The Space Bar is used to generate space between two characters.

5 / 25

What is the purpose of the 'Escape' key on a keyboard?

A) To save the current file

B) To exit from applications or dialog boxes

C) To refresh the web page

D) To print the document

Explanation:

The 'Escape' key does not save the current file, refresh the web page, or print the document.

Explanation:

The 'Escape' key is typically used to exit from applications or close dialog boxes.

6 / 25

How many keys are typically found on a standard keyboard?

A) 88

B) 101

C) 104

D) 110

Explanation:

A standard keyboard does not typically have 88, 101, or 110 keys.

Explanation:

A standard keyboard typically has 104 keys.

7 / 25

What happens when the 'Insert' key is in the overwrite state on a keyboard?

A) Characters are inserted between other characters.

B) Characters overwrite existing characters.

C) No text can be entered.

D) Text is automatically formatted.

Explanation:

When the 'Insert' key is in the overwrite state, characters are not inserted between other characters, no text can be entered, and text is not automatically formatted.

Explanation:

When the 'Insert' key is in the overwrite state, any character typed will overwrite the character at the cursor's position.

8 / 25

What is the primary use of the 'Tab' key on a keyboard?

A) To shift between open applications

B) To indent text or move to the next field

C) To lock the keyboard

D) To switch the keyboard layout

Explanation:

The Tab key is not used to shift between open applications, lock the keyboard, or switch the keyboard layout.

Explanation:

The Tab key is used to indent text or move the cursor to the next field in a form.

9 / 25

What is the primary function of a keyboard?

A) To display information

B) To provide input to a computer

C) To enhance sound quality

D) To store data

Explanation:

Keyboards do not display information, enhance sound quality, or store data.

Explanation:

A keyboard is an input device used to provide input to a computer, analogous to using a pen for writing.

10 / 25

Which keys become active when the 'Shift' key is held down while pressing a letter key?

A) Numeric keys

B) Arrow keys

C) Function keys

D) Character keys

Explanation:

Numeric keys, arrow keys, and function keys do not become active when the 'Shift' key is held down.

Explanation:

When the 'Shift' key is held down while pressing a letter key, the character keys produce uppercase letters.

11 / 25

Which key combination is typically used to copy selected text or files?

A) Alt + C

B) Shift + C

C) Ctrl + C

D) Tab + C

Explanation:

Alt + C, Shift + C, and Tab + C are not typically used to copy selected text or files.

Explanation:

Ctrl + C is the commonly used shortcut to copy selected text or files.

12 / 25

What is the primary use of the 'Enter' key on a keyboard?

A) To delete text

B) To add spaces between words

C) To execute commands or move the cursor to the next line

D) To lock the keyboard

Explanation:

The 'Enter' key does not delete text, add spaces between words, or lock the keyboard.

Explanation:

The 'Enter' key is used to execute commands or move the cursor to the next line or field in documents and forms.

13 / 25

What is the function of the 'Print Screen' key?

A) To print the document

B) To save the screen's content temporarily

C) To close the application

D) To delete the content

Explanation:

The 'Print Screen' key does not print the document, close the application, or delete content.

Explanation:

The 'Print Screen' key is used to capture all contents of the screen in a temporary area.

14 / 25

Which key combination is used to close the active window?

A) Ctrl + W

B) Alt + F4

C) Shift + Q

D) Ctrl + F4

Explanation:

Ctrl + W, Shift + Q, and Ctrl + F4 are not typically used to close the active window.

Explanation:

Alt + F4 is the standard key combination used to close the active window in most operating systems.

15 / 25

What is the function of the Shift key on a keyboard?

A) To delete text

B) To alter the function of other keys

C) To save a document

D) To open a new window

Explanation:

The Shift key does not delete text, save a document, or open a new window.

Explanation:

The Shift key modifies the function of other keys, such as turning lowercase letters into uppercase.

16 / 25

Which key would you press to go to the next page in a document?

A) Page Up

B) Page Down

C) Enter

D) End

Explanation:

The Page Up key, Enter key, and End key are not used to go to the next page in a document.

Explanation:

The 'Page Down' key is used to navigate to the next page of a document.

17 / 25

What is the function of the 'Home' key on a keyboard?

A) To delete the current line

B) To move the cursor to the beginning of the line or document

C) To minimize all windows

D) To open the home page of the default web browser

Explanation:

The 'Home' key does not delete the current line, minimize all windows, or open the home page of the default web browser.

Explanation:

The 'Home' key is used to move the cursor to the beginning of the current line or document.

18 / 25

What action does pressing Shift + 8 on a standard keyboard perform?

A) Types the number 8

B) Types the ampersand (&) symbol

C) Types the asterisk (*) symbol

D) Types the parenthesis ()

Explanation:

Pressing Shift + 8 does not type the number 8 or the & symbol.

Explanation:

Pressing Shift + 8 on a standard keyboard produces the asterisk (*) symbol.

19 / 25

Which key is used to delete characters ahead of the cursor?

A) Backspace

B) Delete

C) Enter

D) Shift

Explanation:

The Backspace key, Enter key, and Shift key are not used to delete characters ahead of the cursor.

Explanation:

The 'Delete' key is used to remove characters that are positioned ahead of the cursor.

20 / 25

Which key is used to launch a context menu equivalent to a right mouse click?

A) Function key

B) Windows key

C) Application key

D) Ctrl key

Explanation:

The Function key, Windows key, and Ctrl key are not used to launch a context menu equivalent to a right mouse click.

Explanation:

The Application key is used to launch a context menu that is typically accessible via a right-click of the mouse

21 / 25

Which keys are used to navigate the cursor on a keyboard?

A) Numeric keys

B) Function keys

C) Arrow keys

D) Special keys

Explanation:

Numeric keys, function keys, and special keys are not used for cursor navigation.

Explanation:

Arrow keys (left, right, up, down) are used for cursor navigation.

22 / 25

What additional function does the 'Caps Lock' key perform aside from changing letter case?

A) It activates the numeric keypad.

B) It locks the keyboard layout.

C) It indicates the lock status with a light.

D) It switches the computer off.

Explanation:

The 'Caps Lock' key does not activate the numeric keypad, switch the computer off, or delete content.

Explanation:

The 'Caps Lock' key not only changes the letter case but also has an indicator light to show whether it is active.

23 / 25

What are the keys on the numeric keypad used for when Num Lock is active?

A) Navigation

B) Typing letters

C) Entering numbers

D) Performing special operations

Explanation:

The keys on the numeric keypad do not function for navigation, typing letters, or performing special operations when Num Lock is active.

Explanation:

When Num Lock is active, the keys on the numeric keypad function as numbers and mathematical operational keys.

24 / 25

How does the 'Alt' key modify the operation of other keys?

A) It locks the keyboard.

B) It changes the numeric values.

C) It creates special character combinations.

D) It doesn’t modify other keys.

Explanation:

The 'Alt' key does not lock the keyboard, change the numeric values, or switch the computer off.

Explanation:

The 'Alt' key, when pressed in combination with other keys, can create special character combinations or perform specific tasks.

25 / 25

What type of keys are 'Caps lock', 'Num lock', and 'Scroll lock'?

A) Function keys

B) Toggle keys

C) Special keys

D) Numeric keys

Explanation:

'Caps lock', 'Num lock', and 'Scroll lock' are not function keys, special keys, or numeric keys.

Explanation:

'Caps lock', 'Num lock', and 'Scroll lock' are toggle keys, changing the state of function for certain keys.

Your score is

CS001 Lesson-3 MCQs

CS001 Lesson 3

1 / 25

Which device among the following is primarily used for gaming and 3D navigation by detecting the rotation of an embedded ball?

A) Keyboard

B) Touchpad

C) Trackball

D) Webcam

Explanation:

A keyboard, touchpad, or webcam is not primarily used for gaming and 3D navigation by detecting the rotation of an embedded ball. It is a trackball that serves this purpose.

Explanation:

A trackball is a type of pointing device used for gaming and 3D navigation that detects the rotation of a ball embedded within it.

2 / 25

Which device translates a user’s finger motion into cursor movement on a screen?

A) Keyboard

B) Mouse

C) Track pad

D) Scanner

Explanation:

A keyboard, scanner, or mouse does not translate a user’s finger motion into cursor movement on a screen. It is a trackpad (or touchpad) that serves this purpose.

Explanation:

A trackpad (or touchpad) is a sensitive surface that translates the motion of a user's finger into a relative position on the screen.

3 / 25

What is the main function of the track pad on laptops?

A) To increase the laptop's processing power

B) To serve as a primary typing device

C) To navigate and control the cursor on the screen

D) To store extra data

Explanation:

The main function of the track pad on laptops is not to increase the laptop's processing power, serve as a primary typing device, or store extra data. It is used as a pointing device to control and navigate the cursor on the screen.

Explanation:

The track pad on laptops is used as a pointing device to control and navigate the cursor on the screen.

4 / 25

Which input device is used to scan physical documents into digital format?

A) Microphone

B) Keyboard

C) Scanner

D) Digital camera

Explanation:

A microphone, keyboard, or digital camera is not used to scan physical documents into digital format. It is a scanner specifically designed for this purpose.

Explanation:

A scanner is specifically used to convert physical documents and images into digital format for storage and manipulation on computers.

5 / 25

What is the primary function of a computer mouse?

A) To output audio signals

B) To display images on the screen

C) To detect motion relative to its supporting surface

D) To store data

Explanation:

The primary function of a computer mouse is not to output audio signals, display images on the screen, or store data. It is primarily used to detect motion relative to its supporting surface to navigate and interact with what is displayed on a computer screen.

Explanation:

A computer mouse is primarily used for detecting motion relative to its supporting surface to navigate and interact with what is displayed on a computer screen.

6 / 25

How does the left mouse button typically function in most applications?

A) It is used to perform right-click functions.

B) It is not used.

C) It performs primary clicking operations like selecting and opening items.

D) It helps navigate through menus.

Explanation:

The left mouse button does not perform right-click functions, remain unused, or navigate through menus. It is used for primary clicking operations such as selecting and opening items.

Explanation:

In most applications, the left mouse button is used for primary clicking operations such as selecting and opening items.

7 / 25

Which device allows for finger gestures to control cursor movement on the screen?

A) Keyboard

B) Mouse

C) Trackball

D) Trackpad

Explanation:

A keyboard, mouse, or trackball does not allow for finger gestures to control cursor movement on the screen. It is a trackpad that provides this functionality.

Explanation:

A trackpad translates finger gestures into cursor movements on the screen, providing a touch-sensitive method for navigating and interacting with computer interfaces.

8 / 25

What is the function of the mouse pointer?

A) To indicate the position of the mouse on the screen

B) To store the mouse's location data

C) To clean the computer screen

D) To enhance the mouse's sensitivity

Explanation:

The function of the mouse pointer is not to store the mouse's location data or enhance the mouse's sensitivity. It indicates the current position of the mouse on the computer screen, helping users interact with graphical elements.

Explanation:

The mouse pointer (or cursor) indicates the current position of the mouse on the computer screen, helping users interact with graphical elements.

9 / 25

Which type of mouse pad is designed to enhance the motion sensing of a mouse?

A) A hard surface pad

B) A soft foam pad

C) A reflective surface pad

D) A motion-sensitive pad

Explanation:

A soft foam pad, reflective surface pad, or motion-sensitive pad is not designed to enhance the motion sensing of a mouse. It is a hard surface pad that serves this purpose.

Explanation:

Hard surface mouse pads are specifically designed to enhance the mouse's motion sensing capabilities, providing a smooth, consistent surface that improves tracking.

10 / 25

What characteristic differentiates a trackball from a traditional mouse?

A) A trackball requires more desk space.

B) A trackball is embedded with a rotating ball for navigation.

C) A trackball uses light to detect movement.

D) A trackball is less precise.

Explanation:

A trackball does not require more desk space, use light to detect movement, or lack precision. The defining characteristic is that it is embedded with a rotating ball for navigation.

Explanation:

The defining characteristic of a trackball is the embedded ball that users rotate to navigate the cursor, differentiating it from a traditional mouse that moves on a surface.

11 / 25

Which of the following is NOT a function commonly associated with a mouse?

A) Scrolling through a document

B) Typing text

C) Dragging and dropping items

D) Selecting items

Explanation:

Scrolling through a document, dragging and dropping items, or selecting items are functions commonly associated with a mouse. Typing text is typically done with a keyboard.

Explanation:

Typing text is not a function performed by a mouse; this is typically done with a keyboard.

12 / 25

What action does clicking and dragging with a mouse typically perform?

A) It deletes files.

B) It opens new programs.

C) It selects or moves items on the screen.

D) It shuts down the computer.

Explanation:

Clicking and dragging with a mouse does not delete files, open new programs, or shut down the computer. It is commonly used to select text, move files, or adjust items within graphical user interfaces.

Explanation:

Clicking and dragging with a mouse is commonly used to select text, move files, or adjust items within graphical user interfaces.

13 / 25

How many standard buttons does a typical mouse have?

A) 1

B) 2

C) 3

D) 4

Explanation:

A typical mouse does not have 1, 3, or 4 standard buttons. It typically features two buttons: a left and a right mouse button.

Explanation:

A standard mouse typically features two buttons: a left and a right mouse button.

14 / 25

What is a trackball?

A) A device that outputs sound to a computer

B) A camera used for recording motion pictures

C) A pointing device with a ball that detects rotation

D) A type of mouse pad

Explanation:

A trackball is not a device that outputs sound to a computer, a camera used for recording motion pictures, or a type of mouse pad. It is a pointing device with a ball that detects rotation.

Explanation:

A trackball is a pointing device that features a ball placed in a socket, with sensors to detect the ball's rotation in two dimensions.

15 / 25

Which devices are used to input video into a computer?

A) Microphone and scanner

B) Trackball and track pad

C) Digital camera and webcam

D) Keyboard and mouse

Explanation:

A microphone and scanner, trackball and track pad, or keyboard and mouse are not used to input video into a computer. Digital cameras and webcams serve this purpose.

Explanation:

Digital cameras and webcams are input devices used for capturing still images and video to input into a computer.

16 / 25

What function does the right mouse button typically perform?

A) It is used for primary clicking.

B) It opens contextual menus.

C) It helps in dragging files.

D) It is not used.

Explanation:

The right mouse button is not used for primary clicking, helping in dragging files, or remaining unused. It is commonly used to open contextual menus, providing additional options depending on where it is clicked.

Explanation:

The right mouse button is commonly used to open contextual menus, providing additional options depending on where it is clicked.

17 / 25

What is a unique feature of digital cameras compared to other video input devices?

A) They can input text.

B) They capture still and moving images.

C) They enhance audio input.

D) They serve as output devices.

Explanation:

Digital cameras cannot input text, enhance audio input, or serve as output devices. Their unique feature is capturing both still and moving images.

Explanation:

Digital cameras uniquely capture both still and moving images, allowing them to serve as versatile input devices for visual content.

18 / 25

What action does double-clicking perform in most desktop environments?

A) It deletes files.

B) It opens files or applications.

C) It minimizes the window.

D) It changes the screen resolution.

Explanation:

Double-clicking does not delete files, minimize the window, or change the screen resolution. It is commonly used to open files or applications on most computer systems.

Explanation:

Double-clicking is commonly used to open files or applications on most computer systems.

19 / 25

What is the purpose of a scanner?

A) To input keyboard strokes

B) To scan and store images or documents in a computer

C) To display images from a computer

D) To control computer games

Explanation:

A scanner is not used to input keyboard strokes, display images from a computer, or control computer games. Its purpose is to scan and store images or documents in a computer.

Explanation:

A scanner is an input device that scans images or documents and stores them digitally in a computer.

20 / 25

What is a common use for a webcam in terms of input?

A) Capturing and inputting live video into a computer

B) Scanning documents

C) Recording high-quality audio

D) Enhancing Wi-Fi connectivity

Explanation:

A webcam is not used for scanning documents, recording high-quality audio, or enhancing Wi-Fi connectivity. It is primarily used to capture live video, which can then be input and processed by a computer.

Explanation:

Webcams are primarily used to capture live video, which can then be input and processed by a computer.

21 / 25

Which of the following devices is specifically designed to capture audio input for computers?

A) Scanner

B) Microphone

C) Digital camera

D) Trackball

Explanation:

A scanner, digital camera, or trackball is not specifically designed to capture audio input for computers. It is a microphone that serves this purpose.

Explanation:

A microphone is specifically designed to capture audio input, making it suitable for tasks like recording sound and voice communication on computers.

22 / 25

Which of the following is not an input device?

A) Microphone

B) Printer

C) Webcam

D) Scanner

Explanation:

A microphone, webcam, or scanner is an input device used to input sound, video, and physical documents into a computer. A printer is an output device used to produce hard copies of digital documents.

Explanation:

A printer is an output device, designed to produce hard copies of documents and images from digital data stored on a computer, unlike microphones, webcams, and scanners which are input devices.

23 / 25

Which device is used to input sound into a computer?

A) Scanner

B) Microphone

C) Digital camera

D) Track pad

Explanation:

A scanner, digital camera, or track pad is not used to input sound into a computer. It is a microphone specifically used for this purpose.

Explanation:

A microphone is specifically used to input sound into a computer, suitable for applications like broadcasting and recording.

24 / 25

What is the primary use of a digital camera in terms of computer input?

A) To enhance the display settings of a computer

B) To input still images and video into a computer

C) To improve the sound quality of recordings

D) To navigate the computer's interface

Explanation:

A digital camera is not used to enhance the display settings of a computer, improve the sound quality of recordings, or navigate the computer's interface. Its primary use is to input still images and video into a computer.

Explanation:

Digital cameras are used primarily for inputting still images and video into a computer, allowing for processing, editing, or sharing.

25 / 25

Which of the following is an advantage of using a microphone for input?

A) It allows for video input.

B) It enhances graphic display.

C) It inputs sound to a computer.

D) It increases storage capacity.

Explanation:

A microphone does not allow for video input, enhance graphic display, or increase storage capacity. Its primary advantage is its ability to input sound into a computer.

Explanation:

A microphone's primary advantage is its ability to input sound into a computer, essential for tasks like voice recording and audio broadcasting.

Your score is

CS001 Lesson-4 MCQs

CS001 Lesson 4

1 / 25

What type of output is generated by a computer monitor?

A) Hard copy

B) Soft copy

C) Audio output

D) Data storage

Explanation:

Option A describes hard copy output. Option C is about audio output. Option D refers to data storage. Therefore, option B is correct. A computer monitor generates soft copy output, displaying images and text electronically on a screen.

Explanation:

A computer monitor generates soft copy output, displaying images and text electronically on a screen.

2 / 25

Which output device is used to produce sound from a computer?

A) Printer

B) Monitor

C) Speakers

D) Scanner

Explanation:

Option A refers to printers. Option B describes monitors. Option D is about scanners. Therefore, option C is correct. Speakers are the output devices specifically designed to produce sound from computer audio data.

Explanation:

Speakers are the output devices specifically designed to produce sound from computer audio data.

3 / 25

Which type of speaker setup is commonly used with computers?

A) Concert hall speakers

B) Car audio speakers

C) Home theater speakers

D) Computer desktop speakers

Explanation:

Option A describes large venue speakers. Option B refers to car audio speakers. Option C is about home theater speakers. Therefore, option D is correct. Computer desktop speakers are specifically designed for use with computers, providing sound output for multimedia and other audio needs.

Explanation:

Computer desktop speakers are specifically designed for use with computers, providing sound output for multimedia and other audio needs.

4 / 25

What technology do laser printers share with photocopy machines?

A) Inkjet technology

B) Electrophotography

C) Thermal printing

D) Impact printing

Explanation:

Option A describes inkjet technology. Option C is not related to laser printers. Option D refers to impact printing technology. Therefore, option B is correct. Laser printers use a technology called electrophotography, similar to what is used in photocopy machines, involving laser light to transfer toner onto paper.

Explanation:

Laser printers use a technology called electrophotography, similar to what is used in photocopy machines, involving laser light to transfer toner onto paper.

5 / 25

How do inkjet printers create images on paper?

A) By burning images onto the paper surface.

B) By pressing ink directly onto the paper using pins.

C) By spraying ink through nozzles onto the paper.

D) By using lasers to transfer ink from ribbons.

Explanation:

Option A is not an accurate description of inkjet printing. Option B describes dot matrix printing. Option D refers to laser printers. Therefore, option C is correct. Inkjet printers create images by spraying tiny droplets of ink through nozzles onto paper, allowing for detailed and high-quality printouts.

Explanation:

Inkjet printers create images by spraying tiny droplets of ink through nozzles onto paper, allowing for detailed and high-quality printouts.

6 / 25

What type of output device is a printer?

A) Soft copy output device

B) Hard copy output device

C) Sound output device

D) Data input device

Explanation:

Option A is incorrect because printers are generally hard copy output devices. Option C refers to sound output devices. Option D is related to data input devices. Therefore, option B is correct. A printer is a hard copy output device that prints text or images from the computer onto paper.

Explanation:

A printer is a hard copy output device that prints text or images from the computer onto paper.

7 / 25

What advantage does an LCD monitor have over a CRT monitor?

A) Higher energy consumption

B) More space-efficient and lighter

C) Lower image quality

D) Limited viewing angles

Explanation:

Option A describes a disadvantage. Option C refers to image quality. Option D is about viewing angles. Therefore, option B is correct. LCD monitors are more space-efficient and lighter than CRT monitors, making them easier to handle and more suitable for modern work environments.

Explanation:

LCD monitors are more space-efficient and lighter than CRT monitors, making them easier to handle and more suitable for modern work environments.

8 / 25

What is a common feature of multimedia projectors?

A) They print high-quality text documents.

B) They enlarge the display and sound onto a screen.

C) They store data digitally.

D) They receive television signals.

Explanation:

Option A describes printers. Option C refers to data storage devices. Option D is about television receivers. Therefore, option B is correct. Multimedia projectors are used to enlarge the display and sound from a computer onto a larger screen, functioning similarly to a magnifying glass.

Explanation:

Multimedia projectors are used to enlarge the display and sound from a computer onto a larger screen, functioning similarly to a magnifying glass.

9 / 25

What is meant by a 'built-in speaker' in a device?

A) A detachable speaker that comes with the device.

B) An external speaker that enhances sound quality.

C) A speaker integrated within the device for audio output.

D) A special type of speaker used only for alarms.

Explanation:

Option A describes detachable speakers. Option B is about external speakers. Option D refers to special speakers. Therefore, option C is correct. A 'built-in speaker' refers to a speaker that is integrated directly into the device itself, providing audio output without the need for external speakers.

Explanation:

A 'built-in speaker' refers to a speaker that is integrated directly into the device itself, providing audio output without the need for external speakers.

10 / 25

What is the primary output of a multimedia projector?

A) Text documents

B) Sound recordings

C) Enlarged visual and audio outputs

D) High-resolution photographs

Explanation:

Option A describes text documents. Option B refers to sound recordings. Option D is about photographs. Therefore, option C is correct. Multimedia projectors output enlarged visual and audio content, projecting it onto screens for larger audiences.

Explanation:

Multimedia projectors output enlarged visual and audio content, projecting it onto screens for larger audiences.

11 / 25

Which printer technology works similar to a typewriter by striking pins against an ink ribbon?

A) Laser printer

B) Inkjet printer

C) Dot matrix printer

D) Line printer

Explanation:

Option A refers to laser printing technology. Option B describes inkjet printing. Option D is another type of printer technology. Therefore, option C is correct. A dot matrix printer operates similarly to a typewriter, using pins to strike an ink ribbon to form characters and illustrations.

Explanation:

A dot matrix printer operates similarly to a typewriter, using pins to strike an ink ribbon to form characters and illustrations.

12 / 25

Which printer type is known for printing a complete page at a time and using toner?

A) Dot matrix printer

B) Line printer

C) Inkjet printer

D) Laser printer

Explanation:

Option A refers to dot matrix printers. Option B describes line printers. Option C is about inkjet printers. Therefore, option D is correct. Laser printers print a complete page at a time, similar to a photocopier, and use a powder ink known as toner.

Explanation:

Laser printers print a complete page at a time, similar to a photocopier, and use a powder ink known as toner.

13 / 25

Which printer is best suited for high-quality graphic printing?

A) Dot matrix printer

B) Line printer

C) Laser printer

D) Inkjet printer

Explanation:

Option A refers to dot matrix printers. Option B describes line printers. Option D is about inkjet printers. Therefore, option C is correct. Laser printers are particularly well-suited for high-quality graphic printing due to their precise application of toner using laser technology.

Explanation:

Laser printers are particularly well-suited for high-quality graphic printing due to their precise application of toner using laser technology.

14 / 25

What is the key difference between hard copy and soft copy output?

A) Hard copy output is digital, while soft copy is physical.

B) Hard copy output is physical, while soft copy is digital.

C) Hard copy output can only be text, while soft copy includes images.

D) There is no significant difference; they are interchangeable terms.

Explanation:

Option A is incorrect because hard copy output is physical, not digital. Option C is not accurate as soft copies can include images. Option D is incorrect as there is a significant difference between hard copy and soft copy outputs. Therefore, option B is correct. Hard copy output refers to physical outputs like printed documents, while soft copy output refers to digital formats like images displayed on a monitor.

Explanation:

Hard copy output refers to physical outputs like printed documents, while soft copy output refers to digital formats like images displayed on a monitor.

15 / 25

What is the definition of 'output' in computing?

A) The process of storing data in a computer.

B) The process of deleting data from a computer.

C) The process of entering data into a computer.

D) The process of extracting data from a computer.

Explanation:

The process of storing data in a computer (option A) refers to input. The process of deleting data from a computer (option B) is unrelated to output. The process of entering data into a computer (option C) is also input. Therefore, option D is correct. In computing, 'output' refers to the process of extracting data from a computer, typically to display, print, or otherwise make it perceptible.

Explanation:

In computing, 'output' refers to the process of extracting data from a computer, typically to display, print, or otherwise make it perceptible.

16 / 25

Which type of printer is capable of printing whole lines at once?

A) Laser printer

B) Inkjet printer

C) Dot matrix printer

D) Line printer

Explanation:

Option A describes dot matrix printers. Option B refers to line printers. Option D is about inkjet printers. Therefore, option C is correct. Line printers can print entire lines at a time, making them faster and more suitable for printing large volumes of text quickly.

Explanation:

Line printers can print entire lines at a time, making them faster and more suitable for printing large volumes of text quickly.

17 / 25

What characteristic defines CRT monitors compared to other types of monitors?

A) They use liquid crystals.

B) They are lighter and more power-efficient.

C) They utilize cathode ray tube technology.

D) They use organic light-emitting diodes.

Explanation:

Option A is not accurate for CRT monitors. Option B is about energy consumption. Option D refers to OLED monitors. Therefore, option C is correct. CRT monitors utilize cathode ray tube technology, which distinguishes them from other types like LCDs and LEDs that use different methods for displaying images.

Explanation:

CRT monitors utilize cathode ray tube technology, which distinguishes them from other types like LCDs and LEDs that use different methods for displaying images.

18 / 25

Which output device would be used to show a presentation to a large group?

A) Printer

B) Monitor

C) Multimedia projector

D) Speakers

Explanation:

Option A describes printers. Option B is about monitors. Option D refers to speakers. Therefore, option C is correct. Multimedia projectors are ideal for showing presentations to large groups, as they can project both visual and audio content onto a large screen.

Explanation:

Multimedia projectors are ideal for showing presentations to large groups, as they can project both visual and audio content onto a large screen.

19 / 25

What is the function of built-in speakers in a device?

A) To display images

B) To enhance the device's processing power

C) To produce audio output integrated within the device

D) To print documents

Explanation:

Option A is inaccurate for monitors. Option B is unrelated to built-in speakers. Option D refers to printers. Therefore, option C is correct. Built-in speakers are integrated within devices like laptops and monitors to provide audio output without the need for external speakers.

Explanation:

Built-in speakers are integrated within devices like laptops and monitors to provide audio output without the need for external speakers.

20 / 25

What is an advantage of LCD monitors over CRT monitors?

A) Higher energy consumption

B) Bulkier and heavier design

C) Lower space requirement and lighter weight

D) More expensive

Explanation:

Option A describes higher energy consumption. Option B is a characteristic of CRT monitors. Option D refers to cost, not an advantage. Therefore, option C is correct. LCD monitors have the advantage of being lighter and more compact than CRT monitors, requiring less space and often consuming less power.

Explanation:

LCD monitors have the advantage of being lighter and more compact than CRT monitors, requiring less space and often consuming less power.

21 / 25

Which of the following monitors uses liquid crystals to display images?

A) CRT monitor

B) LCD monitor

C) LED monitor

D) Plasma monitor

Explanation:

Option A describes a CRT monitor. Option C refers to LED monitors. Option D is about plasma monitors. Therefore, option B is correct. LCD (Liquid Crystal Display) monitors use liquid crystals sandwiched between sheets of glass to display images, known for their compact size and clarity.

Explanation:

LCD (Liquid Crystal Display) monitors use liquid crystals sandwiched between sheets of glass to display images, known for their compact size and clarity.

22 / 25

Which type of printer would be considered most economical based on running costs?

A) Laser printer

B) Inkjet printer

C) Dot matrix printer

D) Line printer

Explanation:

Option A describes laser printers. Option D refers to line printers. Option B is about inkjet printers. Therefore, option C is correct. Dot matrix printers are generally considered economical due to their lower cost of consumables and maintenance compared to more modern printing technologies.

Explanation:

Dot matrix printers are generally considered economical due to their lower cost of consumables and maintenance compared to more modern printing technologies.

23 / 25

Which printer type prints one entire line at a time?

A) Dot matrix printer

B) Line printer

C) Laser printer

D) Inkjet printer

Explanation:

Option A describes dot matrix printers. Option B refers to line printers. Option D is about inkjet printers. Therefore, option C is correct. Line printers are designed to print an entire line of text at a time, making them faster than dot matrix printers which print character by character.

Explanation:

Line printers are designed to print an entire line of text at a time, making them faster than dot matrix printers which print character by character.

24 / 25

Which monitor type is known for its heavy and bulky design but provides vivid color depth?

A) LCD monitor

B) LED monitor

C) CRT monitor

D) OLED monitor

Explanation:

Option B describes LED monitors. Option D refers to OLED monitors. Option A is not accurate for CRT monitors. Therefore, option C is correct. CRT (Cathode Ray Tube) monitors are known for their bulky and heavy design but are favored for their color depth and viewing angles.

Explanation:

CRT (Cathode Ray Tube) monitors are known for their bulky and heavy design but are favored for their color depth and viewing angles.

25 / 25

Which of the following is considered a soft copy output?

A) Printed document

B) Displayed image on a monitor

C) Printed photograph

D) Text printed on paper

Explanation:

A printed document (option A) is a hard copy. A printed photograph (option C) is also a hard copy. Text printed on paper (option D) is another example of a hard copy. Therefore, option B is correct. A soft copy output is an electronic version of a document, such as an image displayed on a monitor, as opposed to a hard copy, which is physically printed on paper.

Explanation:

A soft copy output is an electronic version of a document, such as an image displayed on a monitor, as opposed to a hard copy, which is physically printed on paper.

Your score is

CS001 Lesson-5 MCQs

CS001 Lesson 5

1 / 25

Which storage device is traditionally used for transporting small files between computers?

A) Magnetic tape

B) DVD-RAM

C) Hard disk

D) Floppy disk

Explanation:

Option A is incorrect as magnetic tape is not commonly used for small file transfer. Option B is incorrect due to low capacity and rarity. Option C is not commonly used for this purpose. Therefore, option D is correct. Traditionally, floppy disks were commonly used for transporting small files between computers due to their portability and ease of use.

Explanation:

Traditionally, floppy disks were commonly used for transporting small files between computers due to their portability and ease of use.

2 / 25

What does RAM stand for?

A) Read Access Memory

B) Random Access Memory

C) Rapid Action Memory

D) Read Alone Memory

Explanation:

Option A is incorrect. Option C is not a standard term. Option D is incorrect. Therefore, option B is correct. RAM stands for Random Access Memory, which is used for storing data temporarily while programs are running.

Explanation:

RAM stands for Random Access Memory, which is used for storing data temporarily while programs are running.

3 / 25

What is the smallest unit of measurement in computer memory?

A) Kilobyte (KB)

B) Megabyte (MB)

C) Byte

D) Gigabyte (GB)

Explanation:

Option A describes a larger unit of measurement. Option B is also larger than the smallest unit. Option D is larger as well. Therefore, option C is correct. A byte is the smallest unit of memory used to measure storage capacity, typically representing a single character of data.

Explanation:

A byte is the smallest unit of memory used to measure storage capacity, typically representing a single character of data.

4 / 25

Which type of memory is known as volatile memory?

A) ROM

B) RAM

C) Hard disk

D) CD-ROM

Explanation:

Option A refers to non-volatile memory. Option C is about storage devices. Option D describes a specific type of optical disc. Therefore, option B is correct. RAM (Random Access Memory) is considered volatile memory because it loses its content when the power is turned off.

Explanation:

RAM (Random Access Memory) is considered volatile memory because it loses its content when the power is turned off.

5 / 25

What is the significant advantage of using hard disks over floppy disks?

A) Lower cost per disk

B) Enhanced portability

C) Higher storage capacity

D) Simpler data management

Explanation:

Option A does not accurately describe the difference between hard disks and floppy disks. Option B is incorrect as floppy disks are more portable. Option D is not a significant difference between the two storage media. Therefore, option C is correct. Hard disks offer a significantly higher storage capacity compared to floppy disks, making them more suitable for modern data storage needs.

Explanation:

Hard disks offer a significantly higher storage capacity compared to floppy disks, making them more suitable for modern data storage needs.

6 / 25

Why are ROM chips important for computers?

A) They facilitate internet access.

B) They store temporary data for processing.

C) They contain essential information for starting the computer.

D) They enhance the graphics display.

Explanation:

Option A is incorrect as ROM chips do not facilitate internet access. Option B describes RAM, not ROM. Option D is about graphics enhancement. Therefore, option C is correct. ROM chips are critical because they contain the firmware or essential startup instructions needed for a computer's initial boot process.

Explanation:

ROM chips are critical because they contain the firmware or essential startup instructions needed for a computer's initial boot process.

7 / 25

What is the primary advantage of using floppy disks?

A) High-speed data transfer

B) High storage capacity

C) Portability

D) Durability

Explanation:

Option A is not a primary advantage of floppy disks. Option B describes a different storage characteristic. Option D refers to durability. Therefore, option C is correct. The primary advantage of floppy disks is their portability, despite their limited storage capacity and susceptibility to physical damage.

Explanation:

The primary advantage of floppy disks is their portability, despite their limited storage capacity and susceptibility to physical damage.

8 / 25

What distinguishes a DVD-ROM from a DVD-RAM?

A) DVD-ROM can only read data.

B) DVD-ROM can record data multiple times.

C) DVD-ROM uses magnetic storage.

D) DVD-ROM is less durable.

Explanation:

Option B is incorrect as DVD-ROMs cannot record data. Option C describes a different storage technology. Option D is not a distinguishing feature. Therefore, option A is correct. DVD-ROM is a type of DVD that can only read data, whereas DVD-RAM allows for data to be read and written multiple times.

Explanation:

DVD-ROM is a type of DVD that can only read data, whereas DVD-RAM allows for data to be read and written multiple times.

9 / 25

Which of the following is a characteristic of hard disks?

A) They use volatile memory.

B) They store data temporarily.

C) They have high storage capacity.

D) They are primarily used for data transport.

Explanation:

Option A is incorrect as hard disks use non-volatile memory. Option B is about temporary storage. Option D describes a different function. Therefore, option C is correct. Hard disks are characterized by their high storage capacity, making them ideal for storing large volumes of data permanently.

Explanation:

Hard disks are characterized by their high storage capacity, making them ideal for storing large volumes of data permanently.

10 / 25

What type of storage is ROM classified as?

A) Volatile memory

B) Non-volatile memory

C) Temporary storage

D) External storage

Explanation:

Option A describes a different type of memory. Option C is incorrect as ROM is not temporary. Option D refers to external storage. Therefore, option B is correct. ROM is classified as non-volatile memory because it retains its data even when the computer is turned off.

Explanation:

ROM is classified as non-volatile memory because it retains its data even when the computer is turned off.

11 / 25

What is the primary function of CD-ROM?

A) To allow unlimited data writing and erasing.

B) To read data only.

C) To enhance data processing speeds.

D) To transmit data wirelessly.

Explanation:

Option A describes a different type of storage. Option C is incorrect as CD-ROMs do not affect processing speeds. Option D refers to a different transmission method. Therefore, option B is correct. CD-ROM stands for Compact Disc Read-Only Memory, which is designed to store data that can only be read and not written or erased.

Explanation:

CD-ROM stands for Compact Disc Read-Only Memory, which is designed to store data that can only be read and not written or erased.

12 / 25

What does the term 'non-volatile storage' refer to?

A) Storage that retains data without power.

B) Storage that cannot retain data without power.

C) Storage that can be easily modified.

D) Storage used only for temporary data.

Explanation:

Option B is incorrect as non-volatile storage retains data without power. Option C is not directly related to storage properties. Option D describes temporary data storage. Therefore, option A is correct. Non-volatile storage refers to storage devices that retain data even when the power is turned off, such as hard disks and optical disks.

Explanation:

Non-volatile storage refers to storage devices that retain data even when the power is turned off, such as hard disks and optical disks.

13 / 25

What role does a floppy disk's notch play?

A) It increases storage capacity.

B) It allows the disk to spin faster.

C) It protects the disk from data overwrite.

D) It enables wireless data transfer.

Explanation:

Option A does not accurately describe the notch's function. Option B is incorrect as it does not affect the disk's rotational speed. Option D is unrelated to data storage. Therefore, option C is correct. The notch on a floppy disk is used to engage the write-protect feature, preventing data from being written to or overwritten on the disk.

Explanation:

The notch on a floppy disk is used to engage the write-protect feature, preventing data from being written to or overwritten on the disk.

14 / 25

How is data stored on magnetic tape?

A) In a non-linear format

B) In a volatile format

C) In a sequential format

D) In a random-access format

Explanation:

Option A describes a different storage format. Option B refers to a property of volatile memory. Option D is incorrect as magnetic tape is not a random-access storage medium. Therefore, option C is correct. Magnetic tape stores data in a sequential format, meaning data is saved in order and must be accessed in the same sequence.

Explanation:

Magnetic tape stores data in a sequential format, meaning data is saved in order and must be accessed in the same sequence.

15 / 25

What is the primary disadvantage of using floppy disks compared to other storage media?

A) Low storage capacity

B) High storage capacity

C) High durability

D) High data transfer speeds

Explanation:

Option B is incorrect as floppy disks have low, not high, storage capacity. Option C describes an advantage, not a disadvantage. Option D is about data transfer speeds, not storage capacity. Therefore, option A is correct. The primary disadvantage of floppy disks is their low storage capacity, typically up to only 1.44 MB, which is significantly lower than other modern storage devices.

Explanation:

The primary disadvantage of floppy disks is their low storage capacity, typically up to only 1.44 MB, which is significantly lower than other modern storage devices.

16 / 25

Which device is used to store data in circular tracks?

A) RAM

B) ROM

C) Floppy disk

D) DVD-ROM

Explanation:

Option A describes a different type of memory. Option B refers to ROM. Option D is about optical discs. Therefore, option C is correct. Floppy disks store data in circular tracks and are covered by a hard casing to protect the magnetic surface.

Explanation:

Floppy disks store data in circular tracks and are covered by a hard casing to protect the magnetic surface.

17 / 25

What is the purpose of a 'Write Once Read Many' (WORM) disk?

A) It can be written to and erased many times.

B) It allows data to be written once and read many times.

C) It is primarily used for temporary data storage.

D) It enhances data read speeds significantly.

Explanation:

Option A is incorrect as WORM disks cannot be erased. Option C describes a different type of storage. Option D is not related to WORM disk functionality. Therefore, option B is correct. A WORM disk allows data to be written once and then read many times without the possibility of modification, ensuring data integrity.

Explanation:

A WORM disk allows data to be written once and then read many times without the possibility of modification, ensuring data integrity.

18 / 25

How does an optical disc store data?

A) Using magnetic fields

B) Through electric charges

C) By physical impressions on a disc surface

D) Using a laser to read and write data

Explanation:

Option A is incorrect as optical discs do not use magnetic fields. Option B describes a different storage method. Option D is about reading and writing methods. Therefore, option C is correct. Optical discs use lasers to read and write data, where data is stored by making physical changes on the disc's surface that reflect light differently.

Explanation:

Optical discs use lasers to read and write data, where data is stored by making physical changes on the disc's surface that reflect light differently.

19 / 25

Which statement best describes secondary storage devices?

A) They store data temporarily and lose data when power is off.

B) They are integrated directly into the computer's CPU.

C) They store data permanently and retain data without power.

D) They can only store text data.

Explanation:

Option A is incorrect as secondary storage devices retain data without power. Option B describes CPU integration. Option D is incorrect as it limits the scope to text data. Therefore, option C is correct. Secondary storage devices store data permanently and retain data even when the power is turned off, unlike primary storage which is volatile.

Explanation:

Secondary storage devices store data permanently and retain data even when the power is turned off, unlike primary storage which is volatile.

20 / 25

Which storage device is most suitable for large-scale backup of data?

A) RAM

B) Floppy disk

C) Hard disk

D) Magnetic tape

Explanation:

Option A describes volatile memory. Option B is not commonly used for large-scale backup due to its low capacity. Option C is a more common choice for general storage. Therefore, option D is correct. Magnetic tape is most suitable for large-scale data backup due to its high capacity and cost-effectiveness for storing large amounts of data.

Explanation:

Magnetic tape is most suitable for large-scale data backup due to its high capacity and cost-effectiveness for storing large amounts of data.

21 / 25

Which device represents an example of primary storage?

A) DVD

B) External hard drive

C) RAM

D) USB flash drive

Explanation:

Option A is incorrect as DVDs are secondary storage devices. Option B describes external storage. Option D is also an external storage device. Therefore, option C is correct. RAM is a type of primary storage device, directly accessible by the CPU for fast data processing and temporary data storage.

Explanation:

RAM is a type of primary storage device, directly accessible by the CPU for fast data processing and temporary data storage.

22 / 25

What is the characteristic of ROM (Read Only Memory)?

A) Data can be modified.

B) It is temporary storage.

C) Data cannot be modified.

D) It is mainly used for output.

Explanation:

Option A is incorrect because data in ROM cannot be modified. Option B is about temporary storage. Option D refers to output devices. Therefore, option C is correct. ROM stands for Read Only Memory, where data is permanently written during manufacturing and cannot be modified.

Explanation:

ROM stands for Read Only Memory, where data is permanently written during manufacturing and cannot be modified.

23 / 25

Which optical disc has the highest storage capacity?

A) CD-ROM

B) DVD-ROM

C) Re-writable CD

D) DVD-RAM

Explanation:

Option A describes a different type of optical disc. Option B is incorrect as DVD-ROMs cannot record data. Option C refers to a rewritable format. Therefore, option D is correct. DVD-RAM has the highest storage capacity among the options listed, typically ranging from 4.7 GB to 9.4 GB.

Explanation:

DVD-RAM has the highest storage capacity among the options listed, typically ranging from 4.7 GB to 9.4 GB.

24 / 25

Which device is best suited for long-term archival storage of data?

A) RAM

B) CD-ROM

C) SSD (Solid State Drive)

D) Magnetic tape

Explanation:

Option A is incorrect as RAM is volatile. Option B describes a read-only storage medium. Option C is more suitable for general storage. Therefore, option D is correct. Magnetic tape is best suited for long-term archival storage of data due to its high capacity, reliability, and cost-effectiveness for storing large amounts of data over time.

Explanation:

Magnetic tape is best suited for long-term archival storage of data due to its high capacity, reliability, and cost-effectiveness for storing large amounts of data over time.

25 / 25

What is the main purpose of computer storage?

A) To process data

B) To display data

C) To store data

D) To delete data

Explanation:

Option A describes data processing. Option B is about displaying data. Option D refers to deleting data. Therefore, option C is correct. The main purpose of computer storage is to store data, allowing information to be saved and accessed as needed.

Explanation:

The main purpose of computer storage is to store data, allowing information to be saved and accessed as needed.

Your score is

CS001 Lesson-6 MCQs

CS001 Lesson 6

1 / 25

Which component is essential for connecting a computer to a telephone line for internet access?

B) Power supply

D) Processor

A) USB port

C) Modem

Explanation:

USB port, power supply, and processor are not essential components for connecting a computer to a telephone line for internet access. A modem is specifically designed for this purpose.

Explanation:

A modem is necessary for connecting a computer to the internet via a telephone line, facilitating dial-up or DSL connections.

2 / 25

Which component in a computer is known as the 'brain' of the computer?

D) The power supply

C) The processor

B) The fan

A) The hard drive

Explanation:

The hard drive, fan, and power supply are not typically referred to as the 'brain' of the computer. The processor, or CPU, is responsible for processing instructions.

Explanation:

The processor, or CPU, is often referred to as the brain of the computer because it handles all instructions it receives from hardware and software running on the computer.

3 / 25

What is the main purpose of the power cable supplied to the monitor?

B) To supply power to the monitor

D) To enhance the display quality of the monitor

A) To transmit data to the monitor

C) To connect the monitor to peripheral devices

Explanation:

To transmit data to the monitor, connect the monitor to peripheral devices, and enhance the display quality of the monitor are not the main purposes of the power cable supplied to the monitor. It is used to supply power.

Explanation:

The power cable for the monitor is specifically used to supply electrical power, enabling the monitor to function.

4 / 25

Which type of port is typically used to connect a printer to a computer?

B) Parallel port

D) RJ11 jack

C) USB port

A) Serial port

Explanation:

USB port and RJ11 jack are not typically used to connect a printer to a computer. Serial port and parallel port are the common types of ports used for this purpose.

Explanation:

A parallel port, which usually has 25 holes, is traditionally used to connect a printer to a computer.

5 / 25

What is the function of the drive bay in a computer system?

B) It is used for mounting and connecting internal storage devices like hard drives.

D) It serves as a connection point for external peripherals.

A) It provides additional cooling to the system.

C) It enhances the audio output of the computer.

Explanation:

It provides additional cooling to the system, enhances the audio output of the computer, and serves as a connection point for external peripherals are not the primary functions of a drive bay. It is used for mounting and connecting internal storage devices like hard drives.

Explanation:

The drive bay is a designated area within the system unit where internal storage devices such as hard drives are mounted and connected to the motherboard.

6 / 25

Why are power connectors important in a computer system?

A) They enhance the graphical capabilities.

D) They are used to connect external storage devices.

C) They allow the computer to connect to wireless networks.

B) They supply power to the computer's internal components.

Explanation:

They enhance the graphical capabilities, allow the computer to connect to wireless networks, and are used to connect external storage devices are not the primary reasons power connectors are important. They supply power to the computer's internal components.

Explanation:

Power connectors are crucial as they supply electrical power to the motherboard and other internal components, ensuring the computer operates effectively.

7 / 25

What is an RJ11 jack commonly used for in computers?

D) To connect audio devices

B) To connect the computer to a power supply

A) To connect to external storage devices

C) To connect the computer to the internet or a network via a phone line

Explanation:

To connect to external storage devices, connect the computer to a power supply, and connect audio devices are not common uses of an RJ11 jack in computers. It is primarily used for internet or network connections.

Explanation:

An RJ11 jack is used primarily to connect a computer to the internet or network through a phone line, commonly used for dial-up connections.

8 / 25

What does the presence of lights on the front panel of a computer typically indicate?

B) The connectivity status to the internet

D) The sound level being output by the computer

C) The running status of the computer

A) The computer's age

Explanation:

The computer's age, the connectivity status to the internet, and the sound level being output by the computer are not typically indicated by lights on the front panel of a computer. They generally indicate the running status of the computer.

Explanation:

Lights on the front panel of a computer generally indicate its running status, such as power on, processing activity, and hard drive access.

9 / 25

What is the purpose of the power button on a computer?

B) To switch the computer on or off

D) To increase the computer's processing speed

A) To adjust the display settings

C) To connect external devices

Explanation:

To adjust the display settings, connect external devices, and increase the computer's processing speed are not the purposes of the power button on a computer. The power button is used to turn the computer on or off.

Explanation:

The power button is used to turn the computer on or off.

10 / 25

What distinguishes a motherboard from a processor?

C) The motherboard is used for data storage, while the processor is not.

B) The motherboard is the main circuit board that hosts and connects all critical hardware components, while the processor is specifically responsible for executing instructions.

D) The motherboard supplies power to the computer, while the processor uses this power to operate.

A) The motherboard facilitates network connections, whereas the processor does not.

Explanation:

The motherboard facilitates network connections, supplies power to the computer, and is used for data storage are not the main distinctions between a motherboard and a processor. The main difference lies in their functions.

Explanation:

The motherboard serves as the central hub for connecting various components, including the processor, which is primarily responsible for processing data and executing system instructions.

11 / 25

What is the primary purpose of the sound card in a computer?

A) To process video output

C) To produce sound through speakers or headphones

B) To manage data storage

D) To enhance the processing speed of the computer

Explanation:

To process video output, manage data storage, and enhance the processing speed of the computer are not the primary purposes of a sound card. It is primarily used to produce sound through speakers or headphones.

Explanation:

The sound card is an interface used to produce sound via speakers or headphones, converting digital data to audio signals.

12 / 25

What does the restart button on a computer do?

D) It checks the computer for errors.

B) It turns the computer's monitor on or off.

A) It deletes all data from the hard drive.

C) It restarts the computer without the need to manually shut down first.

Explanation:

It deletes all data from the hard drive, turns the computer's monitor on or off, and checks the computer for errors are not the primary functions of the restart button. It restarts the computer without the need to manually shut down first.

Explanation:

The restart button is used to reboot the computer, shutting it down and then automatically starting it again without user intervention.

13 / 25

What role does a LAN card play in a computer?

C) It enables a computer to connect to a network.

D) It supplies power to the computer.

A) It processes audio signals.

B) It stores additional data.

Explanation:

It processes audio signals, stores additional data, and supplies power to the computer are not the primary roles of a LAN card. It enables a computer to connect to a network.

Explanation:

A LAN card, or network interface card, is used to establish a connection to a network, allowing the computer to communicate with other devices and access shared resources.

14 / 25

What is the role of the motherboard in a computer?

A) It processes all the data in the computer.

D) It outputs data to the monitor.

C) It supplies power to the computer.

B) It serves as the main platform where various hardware components connect and interact.

Explanation:

It processes all the data in the computer, supplies power to the computer, and outputs data to the monitor are not the primary roles of the motherboard. The motherboard serves as the main platform where various hardware components connect and interact.

Explanation:

The motherboard is the main printed circuit board in a computer, hosting the CPU, RAM, and other components, and providing connectors for other peripherals.

15 / 25

What differentiates a serial port from a parallel port?

B) A serial port is used for monitors; a parallel port is used for printers.

A) A serial port transmits data one bit at a time; a parallel port can transmit multiple bits at once.

D) A serial port provides power; a parallel port does not.

C) A serial port has fewer pins than a parallel port.

Explanation:

A serial port is used for monitors, has fewer pins than a parallel port, and provides power are not the main differences between serial and parallel ports. The primary difference is in the way they transmit data.

Explanation:

Serial ports transmit data serially, one bit at a time, whereas parallel ports can transmit multiple bits simultaneously, making them faster for data transmission over short distances.

16 / 25

What is the function of a modem in a computer system?

C) To store data

B) To connect to the internet

D) To generate power

A) To process data

Explanation:

To process data, store data, and generate power are not the primary functions of a modem in a computer system. A modem is specifically used for connecting to the internet.

Explanation:

A modem is a hardware device that allows a computer to send and receive data over a telephone line or cable for internet connections.

17 / 25

What is the function of the system unit in a computer?

A) It is used to store software applications.

D) It manages network connections.

C) It is primarily used to output data.

B) It serves as the main body that houses most of the critical hardware components.

Explanation:

It is used to store software applications, output data, and manage network connections are not the primary functions of the system unit. The system unit serves as the main body that houses most of the critical hardware components.

Explanation:

The system unit is the enclosure that contains the computer's main components, including the motherboard, processor, RAM, and internal storage devices.

18 / 25

What does a fan within a computer system primarily help to prevent?

D) Power surges

C) Unauthorized access

B) Overheating

A) Data loss

Explanation:

Data loss, unauthorized access, and power surges are not primarily prevented by a fan within a computer system. Its main function is to prevent overheating.

Explanation:

The primary function of a fan in a computer system is to cool down the processor and other components, preventing them from overheating.

19 / 25

Which type of port is used to connect a scanner or mouse with fewer connectivity pins?

C) Serial port

A) USB port

B) Parallel port

D) RJ11 port

Explanation:

USB port, parallel port, and RJ11 port are not typically used to connect a scanner or mouse with fewer connectivity pins. Serial port is commonly used for this purpose.

Explanation:

The serial port, which typically has 9 pins, is used to connect devices like scanners and older mice, facilitating data transmission one bit at a time.

20 / 25

What is the purpose of pin sockets on a computer?

B) They connect speakers and microphones to the computer.

A) They are used for high-speed internet connections.

C) They provide additional USB ports.

D) They serve as additional power supply units.

Explanation:

They are used for high-speed internet connections, to connect speakers and microphones to the computer, and to provide additional USB ports are not the primary purposes of pin sockets on a computer. They are used to connect audio devices such as speakers and microphones.

Explanation:

Pin sockets on a computer are used to connect audio devices such as speakers and microphones, facilitating audio input and output.

21 / 25

What is computer hardware?

B) The physical components of a computer

C) The instructions that tell the computer what to do

A) The software that manages the computer's operations

D) The data stored on a computer

Explanation:

The software that manages the computer's operations, the instructions that tell the computer what to do, and the data stored on a computer are not considered computer hardware. Computer hardware refers to the physical components of a computer, such as the keyboard, monitor, mouse, and internal components like the processor and motherboard.

Explanation:

Computer hardware refers to the physical elements of a computer, such as the keyboard, monitor, mouse, and internal components like the processor and motherboard.

22 / 25

What is the primary use of RAM in a computer?

A) To store permanent data

B) To provide temporary storage and access for running programs

C) To supply power to the computer

D) To produce sound

Explanation:

To store permanent data and produce sound are not the primary uses of RAM in a computer. RAM is used for temporary storage and access for running programs.

Explanation:

RAM (Random Access Memory) is used by the computer system to temporarily hold data and programs that are currently in use.

23 / 25

What is the role of a USB port in a computer?

D) It is used for connecting the computer to electrical outlets.

B) It provides a connection for internet access.

A) It is used exclusively for video output.

C) It serves as an interface for a wide range of peripherals, including keyboards, mice, printers, and storage devices.

Explanation:

It is used exclusively for video output, provides a connection for internet access, and is used for connecting the computer to electrical outlets are not the primary roles of a USB port. It serves as an interface for various peripherals.

Explanation:

USB ports are versatile interfaces used to connect a wide array of peripherals to a computer, simplifying connections and supporting a broad range of functionalities.

24 / 25

What is a common use of the CD-ROM drive in a computer?

C) To enhance the computer's RAM

A) To supply power to the computer

D) To connect the computer to the internet

B) To read data from CDs

Explanation:

To supply power to the computer, enhance the computer's RAM, and connect the computer to the internet are not common uses of a CD-ROM drive. It is used to read data from CDs.

Explanation:

The CD-ROM drive is an input device used specifically for reading data stored on CDs, commonly used for software installation, media playback, and data access.

25 / 25

Which device is used to cool the processor in a computer?

B) RAM chip

A) Power supply

D) Sound card

C) Fan

Explanation:

Power supply, RAM chip, and sound card are not used to cool the processor in a computer. A fan is specifically used for this purpose.

Explanation:

A fan is used to cool down the processor, helping prevent overheating and potential damage.

Your score is

CS001 Lesson-7 MCQs

Report a question

What's wrong with this question?

You cannot submit an empty report. Please add some details.

CS001 Lesson 7

1 / 25

Which software version follows an earlier version, such as moving from Win 95 to Win 98?

A) Downgrade

B) Update

D) Review

C) Patch

Explanation:

Downgrade, patch, and review do not accurately describe the software version that follows an earlier version.

Explanation:

An update refers to a new version of software that follows an earlier version, typically including improvements or enhancements from the previous version.

2 / 25

Which type of software would you use for creating spreadsheets?

D) Database software

A) Word processor

B) Presentation software

C) Spreadsheet software

Explanation:

Word processor, presentation software, and database software are not specifically designed for creating spreadsheets.

Explanation:

Spreadsheet software, like Microsoft Excel, is specifically designed for tasks involving accounting, finance, and other functions that require organization in rows and columns with formula-based operations.

3 / 25

What type of software is commonly used for virus scanning and system maintenance?

B) System software

D) Development software

A) Application software

C) Utility software

Explanation:

Application software, development software, and antivirus software do not accurately define the type of software commonly used for virus scanning and system maintenance.

Explanation:

Utility software includes tools for system maintenance and virus scanning, helping to manage and optimize the operating system or application software.

4 / 25

What is an example of application software?

C) Norton Antivirus

D) Intel Drivers

A) Windows 10

B) Microsoft Word

Explanation:

Windows 10, Norton Antivirus, and Intel Drivers are not examples of application software.

Explanation:

Microsoft Word is an example of application software, which helps users perform daily life tasks such as document creation and editing.

5 / 25

Which software would you use to create a professional presentation for a business meeting?

D) Windows Operating System

A) MS Word

B) MS Excel

C) MS PowerPoint

Explanation:

MS Word, MS Excel, and Windows Operating System are not primarily used to create a professional presentation for a business meeting.

Explanation:

MS PowerPoint is specifically designed for creating presentations, allowing users to compile slides with text, images, and multimedia to convey information effectively in settings such as business meetings.

6 / 25

What is the purpose of utility software?

B) To facilitate internet browsing

C) To create documents

D) To manage emails

A) To perform specific tasks related to maintenance and troubleshooting

Explanation:

To facilitate internet browsing, create documents, and manage emails do not accurately define the purpose of utility software.

Explanation:

Utility software is designed to perform specific tasks like maintenance and troubleshooting, including disk scanning and virus protection.

7 / 25

What is the primary function of a spreadsheet software?

A) To scan for malware

D) To develop websites

B) To manage file storage

C) To assist in mathematical and statistical calculations

Explanation:

To scan for malware, manage file storage, and develop websites do not accurately define the primary function of a spreadsheet software.

Explanation:

Spreadsheet software, like Microsoft Excel, is used primarily for tasks involving mathematical and statistical calculations organized into cells within rows and columns, utilizing various built-in formulas and functions.

8 / 25

Which of the following is an example of system software that helps manage computer resources and simplify programming tasks?

A) Microsoft PowerPoint

C) Operating system

D) Microsoft Excel

B) Adobe Photoshop

Explanation:

Microsoft PowerPoint, Adobe Photoshop, and Microsoft Excel are not examples of system software that helps manage computer resources and simplify programming tasks.

Explanation:

An operating system is a crucial example of system software that manages computer resources, simplifies programming tasks, and provides an interface for user interaction with the computer.

9 / 25

Which software category does Microsoft Excel belong to?

A) System software

B) Utility software

C) Application software

D) Security software

Explanation:

System software, utility software, and security software are not categories that Microsoft Excel belongs to.

Explanation:

Microsoft Excel is an example of application software, primarily used for tasks such as data analysis, accounting, and spreadsheet management.

10 / 25

What role does application software play in daily computing needs?

C) It enhances the computer’s boot processes.

A) It coordinates hardware operations only.

B) It facilitates specific tasks like document creation, data analysis, and presentations.

D) It only provides security against viruses.

Explanation:

It does not solely coordinate hardware operations, enhance the computer’s boot processes, or provide security against viruses.

Explanation:

Application software directly assists users in performing daily tasks such as document creation, data analysis, and creating presentations, catering to specific needs beyond basic computer management.

11 / 25

What is the role of device drivers?

B) To manage specific hardware components

D) To store data permanently

A) To enhance the computer's speed

C) To create graphics

Explanation:

To enhance the computer's speed, create graphics, and store data permanently are not the primary roles of device drivers.

Explanation:

Device drivers are a type of system software that manage specific hardware components, acting as an intermediary between the operating system and the hardware.

12 / 25

How does utility software differ from application software in its use?

B) Utility software is used for web browsing.

D) Utility software is used for entertainment purposes.

C) Utility software is used for performing specific tasks to manage computer resources.

A) Utility software is used for creating documents.

Explanation:

Utility software is not primarily used for creating documents, web browsing, or entertainment purposes.

Explanation:

Utility software is specifically designed to perform specific tasks that help manage and optimize the computer's operating system or application software, unlike application software that is geared towards general productivity or entertainment tasks.

13 / 25

What is software in the context of computers?

D) A type of computer hardware

B) A set of instructions that directs hardware to perform tasks

C) An electrical component that powers the computer

A) The physical components of a computer

Explanation:

The physical components of a computer, an electrical component that powers the computer, and a type of computer hardware do not accurately define software in the context of computers.

Explanation:

Software refers to a set of instructions or programs that enable the hardware to perform specific tasks.

14 / 25

Which type of software would be used to connect a new hardware device to a computer?

D) Device driver

C) Utility software

B) Antivirus software

A) Application software

Explanation:

Application software, antivirus software, and utility software are not primarily used to connect a new hardware device to a computer.

Explanation:

Device drivers are specialized software used to connect new hardware devices to a computer, ensuring proper communication and functionality between the device and the computer's operating system.

15 / 25

What distinguishes system software from application software?

C) Application software does not require system software to run.

D) Application software is designed for computer maintenance tasks only.

A) System software cannot be directly interacted with by the user, while application software can.

B) System software is used for external hardware management only.

Explanation:

System software cannot be directly interacted with by the user, system software is used for external hardware management only, and application software does not require system software to run are not accurate distinctions between system and application software.

Explanation:

System software, such as operating systems and device drivers, operates in the background and is not directly interacted with by the user in the same way as application software, which includes programs like word processors and spreadsheet tools.

16 / 25

Which software helps in presenting ideas or information in the form of slides?

C) MS PowerPoint

B) MS Excel

A) MS Word

D) MS Access

Explanation:

MS Word, MS Excel, and MS Access are not specifically designed for presenting ideas or information in the form of slides.

Explanation:

MS PowerPoint is specifically designed for creating presentations, consisting of slides that can contain text, images, and sounds to effectively convey information or ideas.

17 / 25

Which company is known for developing major application software like MS Word, Excel, and PowerPoint?

C) Google

D) IBM

A) Apple

B) Microsoft

Explanation:

Apple, Google, and IBM are not known for developing major application software like MS Word, Excel, and PowerPoint.

Explanation:

Microsoft is a major software company known for developing widely used application software like MS Word, MS Excel, and MS PowerPoint.

18 / 25

Which type of software is responsible for managing computer hardware?

A) System software

D) Development software

B) Utility software

C) Application software

Explanation:

Utility software, application software, and development software are not primarily responsible for managing computer hardware.

Explanation:

System software includes operating systems and device drivers that manage and coordinate the activities of computer hardware.

19 / 25

What would you use to manage the settings for a connected printer?

B) Device driver

A) Operating system

D) Application software

C) Utility software

Explanation:

Operating system and application software are not primarily used to manage the settings for a connected printer.

Explanation:

Device drivers are used to manage specific hardware devices, such as printers, communicating between the device and the operating system to ensure proper functionality.

20 / 25

What is a software version?

C) An updated copy of a software program

B) The process of the computer shutting down

D) A manual for using software

A) A type of hardware component

Explanation:

A type of hardware component, the process of the computer shutting down, and a manual for using software do not accurately define a software version.

Explanation:

A software version refers to an updated copy of a software program that is released to provide new features or fix issues from previous versions.

21 / 25

What is the primary function of an operating system?

B) To manage and coordinate the activities of computer hardware and software

D) To connect to the internet

A) To provide security against viruses

C) To process text documents

Explanation:

To provide security against viruses, process text documents, and connect to the internet do not accurately define the primary function of an operating system.

Explanation:

The operating system manages and coordinates the activities of the computer hardware and other software, ensuring that all components function together effectively.

22 / 25

What is the function of antivirus software?

C) To protect a computer against malware and viruses

A) To enhance internet speed

D) To manage printer settings

B) To process text documents

Explanation:

To enhance internet speed, process text documents, and manage printer settings are not functions of antivirus software.

Explanation:

Antivirus software is designed to detect, prevent, and remove malware, including viruses, from computers, ensuring system security and integrity.

23 / 25

What is the primary advantage of updating software to a new version?

D) To increase the complexity of the software

B) To improve security and add new features

C) To remove essential features

A) To decrease the software's functionality

Explanation:

Decreasing the software's functionality, removing essential features, and increasing the complexity of the software are not primary advantages of updating software to a new version.

Explanation:

Updating software to a new version typically includes improvements in security, bug fixes, and the addition of new features, enhancing the overall functionality and safety of the software.

24 / 25

Which software allows for the customization and formatting of large text documents?

B) Spreadsheet software

D) Word processor

A) Antivirus software

C) Presentation software

Explanation:

Antivirus software, spreadsheet software, and presentation software do not primarily allow for the customization and formatting of large text documents.

Explanation:

Word processor software, like Microsoft Word, allows for extensive customization and formatting of text documents, including features like spell check, text styling, and layout design.

25 / 25

Which of the following is a feature of word processing software?

A) Creating and managing databases

D) Editing video files

C) Managing network connections

B) Providing basic text editing and formatting functions

Explanation:

Creating and managing databases, managing network connections, and editing video files do not accurately define features of word processing software.

Explanation:

Word processing software, such as Microsoft Word, primarily provides basic text editing, updating, and formatting functions, including spell and grammar checking.

Your score is

/66

CS-001 M-4

1 / 66

What does the colon (:) sign represent in MS Excel functions?

A. An individual cell reference

B. A range of cells

C. A text string

D. A formula separator

Explanation:

An individual cell reference, a text string, and a formula separator are not represented by the colon (:) sign in MS Excel functions.

Explanation:

In MS Excel functions, the colon (:) sign represents a range of cells. For example, in the function =SUM(B3:B12), the colon indicates that the sum should be calculated for all cells from B3 to B12.

2 / 66

Which symbol is used to begin all formulas in MS Excel?

A. +

B. =

C. *

D. /

Explanation:

The +, *, and / symbols are not used to begin all formulas in MS Excel.

Explanation:

All formulas in MS Excel begin with an equal sign (=). This tells Excel that the following characters constitute a formula or function.

3 / 66

Which of the following functions is used to subtract one cell's value from another in Excel?

A) SUBTRACT()

B) MINUS()

C) - (Minus sign)

D) SUB()

Explanation:

Excel does not have SUBTRACT(), MINUS(), or SUB() functions. Subtraction is performed using the minus sign (-) between the cell references or values.

Explanation:

In Excel, subtraction is performed using the minus sign (-) between the cell references or values. For example, to subtract the value in cell B2 from the value in cell A2, you would write =A2-B2.

4 / 66

In MS Excel, what command should you use when saving a file for the first time or saving it in a different version?

A. Save

B. Save As

C. Export

D. Backup

Explanation:

The Save, Export, and Backup commands are not used when saving a file for the first time or saving it in a different version in MS Excel.

Explanation:

The "Save As" command is used when saving a file for the first time or when you want to save the file in a different version. This command allows you to specify the file format and location while keeping the original file unchanged.

5 / 66

What is the purpose of freezing panes in an Excel worksheet?

A. To prevent changes to the worksheet

B. To highlight certain cells

C. To keep rows or columns visible while scrolling

D. To change the color of the worksheet tab

Explanation:

Preventing changes to the worksheet, highlighting certain cells, and changing the color of the worksheet tab are not purposes of freezing panes in an Excel worksheet.

Explanation:

Freezing panes in an Excel worksheet keeps specific rows or columns visible while you scroll through the rest of the worksheet. This is useful for keeping headers or labels in view as you navigate large sets of data.

6 / 66

What feature in MS Excel allows you to view the complete content of a cell even if it overflows beyond the cell boundaries?

A. Text Wrap

B. Merge Cells

C. Alignment

D. Format Painter

Explanation:

Merge Cells, Alignment, and Format Painter do not allow you to view the complete content of a cell if it overflows beyond the cell boundaries.

Explanation:

The Text Wrap feature in MS Excel allows you to view the complete content of a cell by wrapping the text within the cell boundaries. This means the text will be displayed on multiple lines within the cell if it overflows.

7 / 66

How do you apply conditional formatting to a spreadsheet in MS Excel?

A. Go to the Insert tab and select Conditional Formatting

B. Right-click on the spreadsheet and select Conditional Formatting

C. Go to the Home tab, then click on Conditional Formatting from the Styles group

D. Click on the Data tab, then select Conditional Formatting

Explanation:

Going to the Insert tab, right-clicking on the spreadsheet, and going to the Data tab and selecting Conditional Formatting are not the correct methods to apply conditional formatting to a spreadsheet in MS Excel.

Explanation:

To apply conditional formatting to a spreadsheet in MS Excel, go to the Home tab and click on Conditional Formatting from the Styles group.

8 / 66

The Pivot table option can be found under ____________ tab.

Insert

Review

Home

Data

Explanation:

Review, Home, and Data are not tabs where the ‘PivotTable’ option is typically found in Excel.

Explanation:

The ‘PivotTable’ option in Excel can be found under the ‘Insert’ tab. A PivotTable is a powerful tool that lets you analyze large amounts of data.

9 / 66

Worksheet of MS Excel is divided into ____.

Figure

Rows and columns

Objects

Facts and figures

Explanation:

Figure, Objects, and Facts and figures are not correct divisions of an Excel worksheet.

Explanation:

An Excel worksheet is divided into rows and columns. These rows and columns intersect to form cells, where you can enter and manipulate data.

10 / 66

What is a Pivot Table in MS Excel used for?

A. To create charts

B. To apply conditional formatting

C. To abstract, organize, and summarize data

D. To perform spell checks

Explanation:

Creating charts, applying conditional formatting, and performing spell checks are not the main purposes of a Pivot Table in MS Excel.

Explanation:

A Pivot Table in MS Excel is used to abstract, organize, and summarize data, making it easier to manage and analyze.

11 / 66

What can be done from the 'Check for Issues' dropdown list in the Backstage view?

A. Print the document

B. Save the document as PDF

C. Inspect the document for potential issues

D. Change the chart type

Explanation:

Printing the document, saving the document as PDF, and changing the chart type cannot be done from the 'Check for Issues' dropdown list in the Backstage view.

Explanation:

From the 'Check for Issues' dropdown list in the Backstage view, you can select the 'Inspect Document' option to check the document for potential issues such as hidden metadata or personal information that might need to be removed.

12 / 66

What feature can be used to automatically highlight cells that meet certain criteria in MS Excel?

A. Pivot Table

B. Conditional Formatting

C. Track Changes

D. Data Validation

Explanation:

Pivot Table, Track Changes, and Data Validation are not features used to automatically highlight cells that meet certain criteria in MS Excel.

Explanation:

Conditional Formatting is the feature used in MS Excel to automatically highlight cells that meet certain criteria. This feature can be accessed from the Home tab under the Styles group.

13 / 66

Which of the following is NOT a type of sorting available in MS Excel?

A. Alphabetical sorting

B. Numerical sorting

C. Sort by date and time

D. Sort by worksheet name

Explanation:

Alphabetical sorting, numerical sorting, and sort by date and time are types of sorting available in MS Excel.

Explanation:

Sorting by worksheet name is not a standard type of sorting available in MS Excel. The available types of sorting include alphabetical sorting, numerical sorting, sorting by date and time, customized sorting, and sorting by cell color, font color, or cell icon.

14 / 66

Which tab on the Ribbon bar contains the Auto Sum function in MS Excel?

A. Home

B. Insert

C. Data

D. Formula

Explanation:

The Home, Insert, and Data tabs on the Ribbon bar do not contain the Auto Sum function in MS Excel.

Explanation:

The Auto Sum function is found under the Formula tab on the Ribbon bar in MS Excel. It is part of the Function Library group of commands.

15 / 66

What is the purpose of saving an Excel workbook as a PDF?

A. To allow others to edit the workbook

B. To make the workbook smaller in size

C. To enable readers without MS Excel to view it

D. To convert it into a text file

Explanation:

Allowing others to edit the workbook, making the workbook smaller in size, and converting it into a text file are not purposes of saving an Excel workbook as a PDF.

Explanation:

Saving an Excel workbook as a PDF allows readers who do not have MS Excel to view the workbook. Additionally, PDFs prevent others from editing the content, ensuring the data is read-only.

16 / 66

Which of the following operations is performed using the caret (^) symbol in MS Excel?

A. Addition

B. Subtraction

C. Multiplication

D. Exponentiation

Explanation:

Addition, Subtraction, and Multiplication are not performed using the caret (^) symbol in MS Excel.

Explanation:

In MS Excel, the caret (^) symbol is used for exponentiation, which means raising a number to the power of another number. For example, 2^3 calculates 2 raised to the power of 3.

17 / 66

How do you change the chart type in MS Excel?

A. Select the chart and go to the Insert tab

B. Right-click on the chart and select Change Chart Type

C. Double-click on the chart and select Edit Chart Type

D. Go to the Data tab and select Change Chart Type

Explanation:

Selecting the chart and going to the Insert tab, double-clicking on the chart and selecting Edit Chart Type, and going to the Data tab and selecting Change Chart Type are not the correct methods to change the chart type in MS Excel.

Explanation:

To change the chart type in MS Excel, right-click on the chart and select the 'Change Chart Type' option from the menu.

18 / 66

What is the purpose of the Name Box in MS Excel?

A. To insert a new worksheet

B. To show the address of the selected cell

C. To create a chart

D. To save the workbook

Explanation:

Inserting a new worksheet, creating a chart, and saving the workbook are not purposes of the Name Box in MS Excel.

Explanation:

The Name Box in MS Excel shows the address of the selected cell. It displays the reference of the active cell and can also be used to name cell ranges for easier navigation and reference.

19 / 66

What is an absolute cell reference in MS Excel?

A. A cell reference that changes when copied

B. A cell reference that does not change when copied, indicated by a $ sign

C. A cell reference that uses a range of cells

D. A cell reference that is always relative to the active cell

Explanation:

A cell reference that changes when copied, a cell reference that uses a range of cells, and a cell reference that is always relative to the active cell are not absolute cell references in MS Excel.

Explanation:

An absolute cell reference in MS Excel is a reference that does not change when copied to another cell. It is indicated by a $ sign, for example, $A$1. This ensures that the reference remains constant regardless of where the formula is copied.

20 / 66

To remove the contents of several cells at once, you can ______.

Select the cells and drag the fill handle back up over them

Select the cells and choose Edit | Clear … | Contents

Select the cells and press DELETE

Press Esc button

Explanation:

The other options listed have different functions. For example, dragging the fill handle over cells copies the content or applies a pattern, choosing Edit | Clear … | Contents from the menu also clears the contents but involves more steps, and pressing the “Esc” button cancels the current cell entry.

Explanation:

21 / 66

What command group in the Review tab is used to track changes in a worksheet?

A. Comments

B. Changes

C. Protection

D. Insights

Explanation:

Comments, Protection, and Insights command groups are not used to track changes in a worksheet.

Explanation:

The 'Changes' command group in the Review tab is used to track changes in a worksheet. This includes options like Track Changes, which allows you to highlight edits and share your workbook with others.

22 / 66

When cell addresses are changed in copying a formula it is called ____ like = sum( A1, B1).

Absolute cell referencing

None of given

Relative cell referencing

Duplicate cell referencing

Explanation:

Absolute cell referencing and None of given are not correct terms for this scenario.

Explanation:

In Excel, when you copy a formula that contains a relative cell reference, this reference changes based on the relative position of the row and column. For example, if you copy the formula =sum(A1, B1) from row 1 to row 2, the formula will adjust to =sum(A2, B2).

23 / 66

Which number format option should be used in MS Excel to convert currency values from dollars to PKR?

A. General

B. Percentage

C. Scientific

D. More Number Formats

Explanation:

The General, Percentage, and Scientific number format options are not used to convert currency values from dollars to PKR in MS Excel.

Explanation:

The "More Number Formats" option in MS Excel is used to convert currency values, such as from dollars to PKR. This option allows users to apply various custom number formats.

24 / 66

In MS Excel, how can you delete the contents of a cell without removing the cell itself?

A. Press Backspace

B. Right-click the cell and select Delete

C. Select the cell and press DELETE

D. Click on Clear and select Clear Contents from the drop-down list

Explanation:

Pressing DELETE or Backspace also deletes cell contents, but the correct procedure as described in the content involves using the Clear Contents option.

Explanation:

To delete the contents of a cell without removing the cell itself, you can click on the Clear option from the Home tab and then select Clear Contents from the drop-down list.

25 / 66

How can you ensure that an entire Excel workbook is saved as a PDF instead of just the active worksheet?

A) Select all worksheets before saving

B) Use the Export option and select Entire Workbook

C) Use Save As and choose PDF, then select the entire workbook in the Options

D) Change the default save format to PDF

Explanation:

Selecting all worksheets before saving, using the Export option, and changing the default save format to PDF will not ensure that the entire workbook is saved as a PDF. You must use Save As and choose PDF, then select the entire workbook in the Options.

Explanation:

To save the entire workbook as a PDF, you use the Save As command, choose PDF as the file type, then click on Options and select the "Entire Workbook" option before finalizing the save.

26 / 66

Which of the following is NOT a part of the MS Excel interface?

A. Quick Access Toolbar

B. Ribbon Bar

C. Start Menu

D. Name Box

Explanation:

The Quick Access Toolbar, Ribbon Bar, and Name Box are all components of the MS Excel interface, providing access to various commands and functions within the software.

Explanation:

The Start Menu is part of the operating system interface, not specific to MS Excel.

27 / 66

Which chart type would you use to display the comparison between parts of a whole?

A. Column Chart

B. Pie Chart

C. Line Chart

D. Surface Chart

Explanation:

Column Chart, Line Chart, and Surface Chart are not typically used for displaying comparisons between parts of a whole.

Explanation:

A Pie Chart is used to display the comparison between parts of a whole, showing how individual pieces contribute to the total.

28 / 66

How do you apply conditional formatting to a spreadsheet in MS Excel?

A. Go to the Data tab and select Conditional Formatting

B. Go to the Home tab and select Conditional Formatting from the Styles group

C. Right-click on the spreadsheet and select Conditional Formatting

D. Go to the Review tab and select Conditional Formatting

Explanation:

Going to the Data tab, right-clicking on the spreadsheet, and going to the Review tab and selecting Conditional Formatting are not the correct methods to apply conditional formatting to a spreadsheet in MS Excel.

Explanation:

To apply conditional formatting to a spreadsheet in MS Excel, go to the Home tab, and click on the Conditional Formatting dropdown list from the Styles group.

29 / 66

Which tab on the Ribbon bar do you use to access the Merge and Center option in MS Excel?

A. File

B. Home

C. Insert

D. View

Explanation:

The other options listed (File, Insert, View) do not contain the Merge and Center option.

Explanation:

The Merge and Center option is found under the Home tab on the Ribbon bar in MS Excel. This feature allows users to merge selected cells into one cell and center the content within the new cell.

30 / 66

How do you set print titles in MS Excel?

A. Go to the Home tab and select Print Titles

B. Click on the Insert tab and choose Titles

C. Click on the Page Layout tab, select Print Titles from the Page Setup group

D. Go to the View tab and click on Print Titles

Explanation:

Going to the Home tab and selecting Print Titles, clicking on the Insert tab and choosing Titles, and going to the View tab and clicking on Print Titles are not methods to set print titles in MS Excel.

Explanation:

To set print titles in MS Excel, click on the Page Layout tab, then select Print Titles from the Page Setup group. This opens the Page Setup dialog box, where you can specify rows or columns to repeat on each printed page.

31 / 66

Which one is not a relational operator in the given options?

()

Explanation:

The operators “<=”, “=”, and “:” are all used in various programming languages for comparison or assignment. They are relational operators used to compare values.

Explanation:

The “()” symbols are not a relational operator. They are typically used for grouping expressions or declaring function parameters, depending on the context. Therefore, they do not fit the category of relational operators.

32 / 66

Which key is used to convert a function to its absolute reference in MS Excel?

A. F2

B. F3

C. F4

D. F5

Explanation:

F2, F3, and F5 keys are not used to convert a function to its absolute reference in MS Excel.

Explanation:

In MS Excel, pressing the F4 key converts a function or cell reference to its absolute reference, which means adding $ signs to the cell reference, such as changing A1 to $A$1.

33 / 66

How does MS Excel typically represent a date like ¼?

A. 1/4

B. April 1

C. 4-Jan

D. January 4

Explanation:

MS Excel does not typically represent the date ¼ as 1/4, April 1, or January 4.

Explanation:

In MS Excel, when entering a fraction like ¼, it is typically interpreted as 4-Jan by default. This is due to Excel's automatic conversion of certain inputs to date formats.

34 / 66

Which key displays the Help task pane in MS Excel?

Explanation:

The other keys listed (F4, F3, F2) have different functions in Excel. For example, “F2” is used for editing the active cell, “F3” is used to display the Paste Name dialog box, and “F4” repeats the last command or action, if possible.

Explanation:

35 / 66

The spelling can be verified using the Spelling option in ________ tab.

Home

Review

Data

File

Explanation:

Home, Data, and File are not tabs where the 'Spelling' option is typically found in Microsoft Office applications.

Explanation:

The ‘Spelling’ option in Microsoft Office applications like Word and Excel is typically found under the ‘Review’ tab. This option allows you to check the spelling of the text within your document.

36 / 66

Which one is not a relational operator in the given options?

“=”

“<”

“≤”

“{}”

Explanation:

The symbol “=”, “<”, and “≤” are all relational operators.

Explanation:

In most programming languages, relational operators are used to compare two values. The operators “=”, “<”, and “≤” are all relational operators. The “{}” symbols are not a relational operator. They are often used to denote a block of code or an object.

37 / 66

How do you change the color of a table in MS Excel?

A. Click on the Insert tab and select Table Color

B. Click on the Home tab and select Format and Table option

C. Right-click on the table and select Change Color

D. Go to the Data tab and select Table Color

Explanation:

Clicking on the Insert tab and selecting Table Color, right-clicking on the table and selecting Change Color, and going to the Data tab and selecting Table Color are not methods to change the color of a table in MS Excel.

Explanation:

To change the color of a table in MS Excel, click on the Home tab, select the Format and Table option, and choose the desired color from the dropdown list.

38 / 66

In MS Excel data can be sorted as following

Go to the Data

you need to sort

Go to the Edit

Go to the File

Explanation:

Go to the Edit, you need to sort and Go to the File, you need to sort are not correct ways to sort data in Excel.

Explanation:

In Excel, you can sort data by selecting the data and then going to the ‘Data’ tab and choosing the ‘Sort’ option. This allows you to sort your data based on the values in one or more columns.

39 / 66

Columns of MS Excel are represented by ______.

Names

Numbers

Alphabets

Marks

Explanation:

The other options listed (Names, Numbers, Marks) are not typically used to represent columns in Excel.

Explanation:

In Microsoft Excel, columns are represented by alphabets. Starting from ‘A’ for the first column, ‘B’ for the second column, and so on. After ‘Z’, the columns continue with ‘AA’, ‘AB’, and so forth. This allows for a virtually unlimited number of columns.

40 / 66

What is the purpose of the Document Inspector in MS Excel?

A. To apply conditional formatting

B. To check the document for potential issues

C. To create a Pivot Table

D. To insert charts

Explanation:

Applying conditional formatting, creating a Pivot Table, and inserting charts are not the purposes of the Document Inspector in MS Excel.

Explanation:

The Document Inspector in MS Excel is used to check the document for potential issues, such as hidden metadata or personal information that might need to be removed. This option is available under the File tab.

41 / 66

To copy data in MS Excel, you can ______.

Press Ctrl+Y

Press Ctrl+C

Press Alt+C

Press Ctrl+D

Explanation:

The other options listed have different functions. For example, “Ctrl+Y” is typically used to redo an action, “Alt+C” may not have a predefined function in Excel, and “Ctrl+D” is used to fill down.

Explanation:

42 / 66

What is the main purpose of a Pivot Table in MS Excel?

A. To create charts

B. To format cells

C. To abstract, organize, and summarize data

D. To apply conditional formatting

Explanation:

Creating charts, formatting cells, and applying conditional formatting are not the main purposes of a Pivot Table in MS Excel.

Explanation:

The main purpose of a Pivot Table in MS Excel is to abstract, organize, and summarize data, making it easier to manage and analyze. Pivot Tables allow you to view data from different perspectives quickly.

43 / 66

How can you rename a worksheet in MS Excel?

A. Double-click on the worksheet tab

B. Right-click on the worksheet tab and select Rename

C. Go to the File menu and select Rename Sheet

D. Press F2 and type the new name

Explanation:

Double-clicking on the worksheet tab, going to the File menu and selecting Rename Sheet, and pressing F2 and typing the new name are not methods to rename a worksheet in MS Excel.

Explanation:

To rename a worksheet in MS Excel, right-click on the worksheet tab and select the 'Rename' option from the context menu. Then, type the new name for the worksheet.

44 / 66

How can you modify the Ribbon or Quick Access Toolbar in MS Excel?

A. Click on the File tab and select Options

B. Right-click on the Ribbon and select Customize the Ribbon

C. Use the Save As option

D. Open the Format Cells dialog box

Explanation:

Clicking on the File tab and selecting Options, using the Save As option, and opening the Format Cells dialog box are not the correct methods to modify the Ribbon or Quick Access Toolbar in MS Excel.

Explanation:

To modify the Ribbon or Quick Access Toolbar in MS Excel, you right-click on the Ribbon and select Customize the Ribbon from the pop-up menu. This opens the Excel Options dialog box where you can add or remove commands and create custom tabs.

45 / 66

What is the main purpose of a spreadsheet in Microsoft Excel?

A. To create text documents

B. To design web pages

C. To calculate numeric data and apply different formats on data

D. To edit photos

Explanation:

The other options (creating text documents, designing web pages, editing photos) are not primary functions of Excel.

Explanation:

46 / 66

How do you create a formula using cell references in MS Excel?

A. Select the cell and type the values directly

B. Select the cell and write the cell name followed by its value

C. Write the cell name directly in the Name Box

D. Press Enter and then type the values

Explanation:

Selecting the cell and typing the values directly, writing the cell name directly in the Name Box, and pressing Enter and then typing the values are not methods for creating a formula using cell references in MS Excel.

Explanation:

To create a formula using cell references in MS Excel, select the cell where you want the result to appear, then type the cell reference and the operation in the formula bar. For example, to multiply the values in cells C3 and C4, you would write =C3*C4 in the formula bar.

47 / 66

A worksheet of MS Excel is divided into ______.

Figure

Objects

Rows and columns

Facts and figures

Explanation:

The other options listed (Figure, Objects, Facts and figures) are not typically used to describe the structure of an Excel worksheet.

Explanation:

48 / 66

What is the function of the Formula Bar in MS Excel?

A. It shows the name of the selected cell

B. It is used to insert charts and graphs

C. It is used to edit or change data by using formulas or text

D. It displays the number of cells in a worksheet

Explanation:

The other options (shows the name of the selected cell, used to insert charts and graphs, displays the number of cells in a worksheet) are not the primary functions of the Formula Bar.

Explanation:

The Formula Bar in MS Excel is used to edit or change data by using formulas, text, or functions. It allows users to enter and manipulate data directly within the cell, providing a space to create and view formulas and cell contents.

49 / 66

The spelling can be verified using the Spelling option in ______ tab.

Home

Review

Data

File

Explanation:

The other options listed (Home, Data, File) are tabs in Excel, but they do not contain the Spelling option.

Explanation:

In Microsoft Excel, the Spelling option can be found under the Review tab. This feature allows you to check the spelling of the text within your worksheet. It can be very useful for ensuring the accuracy of your data, especially when dealing with large amounts of text.

50 / 66

How do you print a worksheet in landscape style in MS Excel?

A. Select Print from the File menu, then choose Landscape under Page Layout

B. Go to the Home tab, then select Landscape from the Layout options

C. Click on File, then Print, and choose Landscape from the Page Setup options

D. Click on Insert, then choose Landscape from the Page Orientation options

Explanation:

Selecting Print from the File menu and choosing Landscape under Page Layout, going to the Home tab and selecting Landscape from the Layout options, and clicking on Insert and choosing Landscape from the Page Orientation options are not methods to print a worksheet in landscape style in MS Excel.

Explanation:

To print a worksheet in landscape style in MS Excel, click on the File tab, select Print, and then choose Landscape from the Page Setup options. This setting changes the orientation of the worksheet to print horizontally on the page.

51 / 66

How many worksheets an MS Excel document contains by default?

10 worksheet

1 worksheet

2 worksheet

3 worksheet

Explanation:

10 worksheet and 2 worksheet are incorrect numbers of default worksheets in an Excel document.

Explanation:

By default, a new Excel workbook starts with one worksheet. You can add more worksheets as needed.

52 / 66

What is the NETWORKDAYS function used for in MS Excel?

A. To calculate the difference between two dates

B. To count the number of workdays between two dates

C. To display the current date

D. To calculate the network speed

Explanation:

Calculating the difference between two dates, displaying the current date, and calculating the network speed are not uses of the NETWORKDAYS function in MS Excel.

Explanation:

The NETWORKDAYS function in MS Excel is used to count the number of workdays (excluding weekends and holidays) between two dates. This is particularly useful for project management and scheduling.

53 / 66

Which command group in the Review tab is used to track changes in a worksheet?

A. Comments

B. Changes

C. Protection

D. Insights

Explanation:

Comments, Protection, and Insights command groups are not used to track changes in a worksheet.

Explanation:

54 / 66

What is the correct order of operations in complex formulas in MS Excel?

A. Parentheses, Addition/Subtraction, Multiplication/Division, Caret

B. Caret, Parentheses, Multiplication/Division, Addition/Subtraction

C. Parentheses, Caret, Multiplication/Division, Addition/Subtraction

D. Multiplication/Division, Parentheses, Caret, Addition/Subtraction

Explanation:

Parentheses, Addition/Subtraction, Multiplication/Division, Caret; Caret, Parentheses, Multiplication/Division, Addition/Subtraction; and Multiplication/Division, Parentheses, Caret, Addition/Subtraction are not the correct orders of operations in complex formulas in MS Excel.

Explanation:

The correct order of operations in complex formulas in MS Excel is to perform the operations in parentheses first, followed by the caret (^), then multiplication and division, and finally addition and subtraction.

55 / 66

What is the default file format for MS Excel 2010?

A. .XLS

B. .XLSX

C. .CSV

D. .TXT

Explanation:

The other options (XLS, CSV, TXT) are different file formats but not the default for MS Excel 2010.

Explanation:

The default file format for MS Excel 2010 is .XLSX. This format is used for storing Excel workbooks and supports more advanced features compared to the older .XLS format.

56 / 66

When cell addresses are not changing in copying a formula it is called ____ like ‘=$A$2 + $B$2’.

None of given

Single cell reference

Mix cell reference

Absolute cell referencing

Explanation:

None of given and Single cell reference are not correct terms for this scenario.

Explanation:

In Excel, when you copy a formula that contains an absolute cell reference, this reference does not change in the copied formula. Absolute cell references are denoted by a dollar sign before the column letter and row number, like in the example ‘=$A$2 + $B$2’.

57 / 66

Which tab on the Ribbon bar contains the option to insert a Pivot Table?

A. Home

B. Insert

C. Data

D. View

Explanation:

The Home, Data, and View tabs on the Ribbon bar do not contain the option to insert a Pivot Table.

Explanation:

To insert a Pivot Table in MS Excel, go to the Insert tab on the Ribbon bar, and select the Pivot Table option from the dropdown list.

58 / 66

In MS Excel data can be sorted as following ______.

Select the data, you need to sort. Go to File > Sort

None of Given

Select the data, you need to sort. Go to Edit > Sort

Select the data, you need to sort. Go to Data > Sort

Explanation:

The other options listed (File > Sort, None of Given, Edit > Sort) are not typically used to sort data in Excel.

Explanation:

59 / 66

What steps do you follow to change the chart type in MS Excel?

A. Select the chart and go to the Insert tab

B. Right-click on the chart and select Change Chart Type

C. Double-click on the chart and select Edit Chart Type

D. Go to the Data tab and select Change Chart Type

Explanation:

To change the chart type in MS Excel, right-click on the chart and select Change Chart Type from the context menu.

60 / 66

How can you assign a color to a worksheet tab in Excel?

A) Double-click the tab and choose a color

B) Right-click the tab, select Tab Color, and choose a color

C) Go to the Home tab and select Format Tab Color

D) Use the Page Layout tab

Explanation:

You cannot assign a color to a worksheet tab by double-clicking the tab, using the Home tab, or the Page Layout tab. The correct method is to right-click the tab, select Tab Color, and choose a color.

Explanation:

To assign a color to a worksheet tab, right-click the tab, select Tab Color, and choose your desired color from the options.

61 / 66

What is the default purpose of a template in MS Excel?

A. To create charts automatically

B. To apply a collection of different color combinations, effects, fonts, and settings

C. To import data from external sources

D. To save worksheets as PDF

Explanation:

Creating charts automatically, importing data from external sources, and saving worksheets as PDF are not the default purposes of a template in MS Excel.

Explanation:

The default purpose of a template in MS Excel is to provide a collection of different color combinations, effects, fonts, and settings, allowing users to quickly apply a consistent and professional look to their workbooks.

62 / 66

If you press ____________, the cell accepts your typing as its contents.

Tab

Esc

Enter

Back-Space

Explanation:

The other keys listed (Tab, Esc, Back-Space) have different functions. For example, “Tab” usually moves the cursor to the next cell, “Esc” cancels the current entry, and “Back-Space” deletes the character before the cursor.

Explanation:

63 / 66

Relative reference is useful when we need to apply _______ types of calculations.

Striplin

Mathematical

Contigis

Same

Explanation:

The other options (Striplin, Mathematical, Contigis) do not specifically describe the type of calculations that benefit from relative references.

Explanation:

In Microsoft Excel, a relative reference in an Excel formula is a cell address that changes when you copy the formula to another cell. Relative references are especially convenient whenever you need to repeat the same calculation across multiple rows or columns.

64 / 66

What options are available in the Auto Sum dropdown list?

A. Text, Number, Date, Time

B. Sum, Average, Count Numbers, Max, Min

C. Bold, Italic, Underline, Strikethrough

D. Insert, Delete, Format, Clear

Explanation:

Text, Number, Date, Time; Bold, Italic, Underline, Strikethrough; and Insert, Delete, Format, Clear are not options available in the Auto Sum dropdown list.

Explanation:

The Auto Sum dropdown list in the Function Library Command group contains options such as Sum, Average, Count Numbers, Max, and Min. These are commonly used functions for quick calculations.

65 / 66

What does the Compatibility View in MS Excel do?

A. Enables all new and advanced features of MS Excel

B. Disables old features and enables new features

C. Enables all old features and disables new and advanced features

D. Creates a backup of the Excel file

Explanation:

The other options listed (Enables all new and advanced features of MS Excel, Disables old features and enables new features, Creates a backup of the Excel file) are not the function of Compatibility View.

Explanation:

The Compatibility View in MS Excel enables all old features and disables new and advanced features. This is useful when working with files created in earlier versions of Excel, ensuring compatibility and preventing issues that might arise from using newer features not supported in older versions.

66 / 66

How do you access the NETWORKDAYS function in MS Excel?

A. Go to the Home tab and select Functions

B. Go to the Data tab and select Date & Time

C. Go to the Formula tab, then select Date & Time from the Function Library

D. Go to the View tab and select NETWORKDAYS

Explanation:

Going to the Home tab and selecting Functions, going to the Data tab and selecting Date & Time, and going to the View tab and selecting NETWORKDAYS are not methods to access the NETWORKDAYS function in MS Excel.

Explanation:

To access the NETWORKDAYS function in MS Excel, go to the Formula tab, then select Date & Time from the Function Library. From the dropdown list, select NETWORKDAYS.

Your score is

CS001 Quiz 1

Quiz 1

1 / 10

What does Microsoft Excel primarily use?

presentations

rows and columns

objects

elements

Explanation:

Microsoft Excel is a spreadsheet application that organizes data in rows and columns.

Explanation:

Microsoft Excel is a spreadsheet application that organizes data in rows and columns.

2 / 10

Which one of the following is an output device?

RAM

monitor

scanner

keyboard

Explanation:

Monitors display visual output from the computer.

Explanation:

Monitors display visual output from the computer.

3 / 10

The physical elements of a computer are called:

freeware

software

hardware

shareware

Explanation:

Hardware refers to the physical components of a computer system, including the CPU, memory, storage devices, and peripherals.

Explanation:

Hardware refers to the physical components of a computer system, including the CPU, memory, storage devices, and peripherals.

4 / 10

The process of saving data is called:

writing

copying

monitoring

reading

Explanation:

When you save data, you write it to a storage medium (such as a hard disk or flash drive).

Explanation:

When you save data, you write it to a storage medium (such as a hard disk or flash drive).

5 / 10

Microsoft Help and Support can be accessed by pressing which key?

Ctrl+F4

6 / 10

Which of the following is the secondary storage device?

RAM

ROM

HARD DISK

CACHE

Explanation:
Secondary storage devices are used for long-term data storage. RAM (Random Access Memory) is a primary memory component, not a secondary storage device.

Explanation:
Secondary storage devices are used for long-term data storage. RAM (Random Access Memory) is a primary memory component, not a secondary storage device.

7 / 10

The parallel port at the back of the computer that connects to a printer has how many holes?

Explanation:

The parallel port (also known as LPT port) typically has 25 holes or pins. It is used for connecting printers and other parallel devices.

Explanation:

The parallel port (also known as LPT port) typically has 25 holes or pins. It is used for connecting printers and other parallel devices.

8 / 10

A user can carry a __________ computer anywhere.

super

mine

portable

Explanation:
Portable computers (such as laptops or notebooks) are designed for mobility and can be carried anywhere.

Explanation:
Portable computers (such as laptops or notebooks) are designed for mobility and can be carried anywhere.

9 / 10

The impact printers can produce ___________ at a time.

a line

a page

an image

a character

Explanation:
Impact printers (such as dot matrix printers) produce characters one at a time by striking an inked ribbon against the paper.

Explanation:
Impact printers (such as dot matrix printers) produce characters one at a time by striking an inked ribbon against the paper.

10 / 10

RAM is a/an _________ device.

storage

printing

saving

Explanation:

- RAM (Random Access Memory) is a volatile memory used for temporarily storing data while the computer is running. It allows fast access to data for processing.

Explanation:

- RAM (Random Access Memory) is a volatile memory used for temporarily storing data while the computer is running. It allows fast access to data for processing.

Your score is

The average score is 59%

CS-001 Preparations MCQS MID-Term

CS001-MID TERM PREP

1 / 116

What is the World Wide Web commonly referred to as?

A) The Net

B) The Web

C) The Internet

D) The Cloud

Explanation:

The Net, The Internet, and The Cloud are not the common terms used for the World Wide Web.

Explanation:

The commonly used term for the World Wide Web is 'The Web,' which refers to a system of interlinked hypertext documents accessed via the internet.

2 / 116

What is the main advantage of email over regular mail?

A) It requires postage stamps

B) It is slower

C) It can be accessed from anywhere

D) It is less secure

Explanation:

Email does not require postage stamps, is faster than regular mail, and is generally more secure.

Explanation:

One of the main advantages of email over regular mail is that it can be accessed from anywhere, provided there is internet connectivity.

3 / 116

Which of the following is NOT an email client?

A) Gmail

B) Hotmail

C) AOL

D) Internet Explorer

Explanation:

Gmail, Hotmail, and AOL are examples of email clients.

Explanation:

Internet Explorer is not an email client; it is a web browser developed by Microsoft.

4 / 116

How do you access ‘Windows Explorer’?

A) Start > All Programs > Accessories > Windows Explorer

B) Double-clicking the Recycle Bin

C) Pressing ‘Ctrl + Alt + Del’

D) Right-clicking the Start button

Explanation:

Double-clicking the Recycle Bin, pressing ‘Ctrl + Alt + Del’, and right-clicking the Start button are incorrect. ‘Windows Explorer’ can be accessed through the Start menu by navigating to All Programs > Accessories.

Explanation:

‘Windows Explorer’ can be accessed through the Start menu by navigating to All Programs > Accessories.

5 / 116

What is the purpose of device drivers?

A) To play music

B) To manage hardware components

C) To write software code

D) To design computer games

Explanation:

Device drivers do not play music, write software code, or design computer games.

Explanation:

Their purpose is to manage hardware components and ensure their proper functioning with the operating system.

6 / 116

What is computer software?

A) Physical components of a computer

B) A type of computer virus

C) Set of instructions for hardware

D) A tool for designing hardware

Explanation:

Computer software is not physical components of a computer, a type of computer virus, or a tool for designing hardware.

Explanation:

It is a set of instructions that direct the computer’s hardware to perform various tasks.

7 / 116

What does formatting a USB drive do?

A) Increases its storage capacity

B) Changes its color

C) Erases all data on the drive

D) Installs new software on the drive

Explanation:

Increases its storage capacity, changes its color, and installs new software on the drive are incorrect. Formatting a USB drive removes all data and prepares it for new data to be stored.

Explanation:

Formatting a USB drive removes all data and prepares it for new data to be stored.

8 / 116

Which of the following is NOT a popular web browser?

A) Internet Explorer

B) Mozilla Firefox

C) Google Chrome

D) Microsoft Excel

Explanation:

Internet Explorer, Mozilla Firefox, and Google Chrome are popular web browsers.

Explanation:

Microsoft Excel is not a web browser; it is spreadsheet software used for data manipulation and analysis.

9 / 116

What is the main function of the Internet?

A) To play online games only

B) To share information and resources

C) To connect to the television

D) To make phone calls

Explanation:

The main function of the Internet is not limited to playing online games or connecting to the television or making phone calls.

Explanation:

The primary function of the Internet is to share information and resources globally, enabling communication, collaboration, and access to various services.

10 / 116

Which language is used to write a web page?

A) CSS

B) JavaScript

C) HTML

D) Python

Explanation:

CSS, JavaScript, and Python are not the languages primarily used to write a web page.

Explanation:

HTML (Hypertext Markup Language) is the standard markup language used to create web pages.

11 / 116

Which of the following is not a type of computer software?

A) System software

B) Utility software

C) Application software

D) Furniture software

Explanation:

System software, utility software, and application software are recognized types of computer software.

Explanation:

Furniture software is not a recognized category of computer software.

12 / 116

What feature in MS Word helps to check spelling and grammar?

A) Thesaurus

B) Spell Check

C) AutoCorrect

D) Word Count

Explanation:

Thesaurus, AutoCorrect, and Word Count are features in MS Word, but they do not specifically check spelling and grammar.

Explanation:

Spell Check is the feature in MS Word that helps identify and correct spelling and grammar mistakes.

13 / 116

What is the function of the ‘Zoom’ feature in MS Word?

A) To change the document layout

B) To adjust the view size of the document

C) To edit text

D) To print the document

Explanation:

To change the document layout, edit text, and print the document are tasks that can be performed in MS Word, but they are not specifically related to the Zoom feature.

Explanation:

The Zoom feature in MS Word allows users to increase or decrease the size of the document on the screen for better visibility.

14 / 116

What is the purpose of file attributes?

A) To determine the file’s color

B) To set the file’s permissions and visibility

C) To change the file’s format

D) To play the file’s content

Explanation:

To determine the file’s color, to change the file’s format, and to play the file’s content are incorrect. File attributes include settings for read-only status, hidden status, and other permissions.

Explanation:

File attributes include settings for read-only status, hidden status, and other permissions.

15 / 116

What is the role of an ISP?

A) To provide internet connection

B) To create web pages

C) To manage emails

D) To sell computers

Explanation:

An ISP's role does not include creating web pages, managing emails, or selling computers.

Explanation:

The role of an ISP (Internet Service Provider) is to provide internet connectivity services to individuals and organizations.

16 / 116

Which of the following is an example of an email address?

A) www.vu.edu.pk

B) info@vu.edu.pk

C) vu@info.com

D) email@website

Explanation:

www.vu.edu.pk and vu@info.com are not valid email addresses.

Explanation:

info@vu.edu.pk is an example of a valid email address format, typically comprising a username followed by the '@' symbol and domain name.

17 / 116

Which feature would you use to correct grammatical errors in MS Word?

A) AutoCorrect

B) Thesaurus

C) Grammar Check

D) Word Count

Explanation:

AutoCorrect, Thesaurus, and Word Count are features in MS Word, but they are not specifically for correcting grammatical errors.

Explanation:

Grammar Check is a feature in MS Word that identifies and suggests corrections for grammatical errors.

18 / 116

What does antivirus software do?

A) Slows down the computer

B) Scans and eliminates viruses

C) Creates viruses

D) Steals personal information

Explanation:

Antivirus software does not slow down the computer, create viruses, or steal personal information.

Explanation:

Antivirus software scans and eliminates viruses to protect the computer from malicious software.

19 / 116

How can you permanently delete a file from the Recycle Bin?

A) By clicking ‘Restore this item’

B) By selecting ‘Empty Recycle Bin’

C) By dragging it back to the desktop

D) By renaming the file

Explanation:

By clicking ‘Restore this item’ and by dragging it back to the desktop are incorrect. Selecting ‘Empty Recycle Bin’ will permanently delete the files contained within it.

Explanation:

Selecting ‘Empty Recycle Bin’ will permanently delete the files contained within it.

20 / 116

What is the primary purpose of computer security?

A) To play games

B) To protect hardware, software, and data

C) To make the computer run faster

D) To design new software

Explanation:

To play games or make the computer run faster are not the primary purposes of computer security.

Explanation:

Computer security is primarily to protect hardware, software, and data from theft, damage, or unauthorized access.

21 / 116

What is the first step in creating a new folder on the desktop?

A) Opening Windows Explorer

B) Right-clicking on the desktop and selecting ‘New Folder’

C) Going to the ‘Control Panel’

D) Pressing ‘Ctrl + N’

Explanation:

Opening Windows Explorer or going to the ‘Control Panel’ are not the first steps in creating a new folder on the desktop.

Explanation:

Right-clicking on the desktop and selecting ‘New Folder’ starts the process of creating a folder.

22 / 116

What does an operating system do?

A) Damages the computer hardware

B) Manages computer hardware and software

C) Creates viruses

D) Connects computers to furniture

Explanation:

An operating system does not damage computer hardware, create viruses, or connect computers to furniture.

Explanation:

Its primary role is to manage computer hardware and software, enabling communication between them.

23 / 116

What is the purpose of links on a website?

A) To decorate the webpage

B) To provide access to other web pages

C) To display advertisements

D) To increase the download time

Explanation:

Links on a website are not primarily used for decorating the webpage or increasing download time.

Explanation:

The main purpose of links on a website is to provide navigation and access to other web pages or resources.

24 / 116

How do you rename a folder on the desktop?

A) By selecting it and pressing ‘F2’

B) By dragging it to a new location

C) By opening it and choosing ‘Rename’ from the File menu

D) By right-clicking on it and selecting ‘Rename’

Explanation:

By selecting it and pressing ‘F2’ and by dragging it to a new location are incorrect. Right-clicking on a folder and selecting ‘Rename’ allows you to change its name.

Explanation:

Right-clicking on a folder and selecting ‘Rename’ allows you to change its name.

25 / 116

What happens when you delete a file or folder?

A) It is permanently deleted immediately

B) It is moved to the Recycle Bin

C) It is sent via email

D) It is copied to the clipboard

Explanation:

Files and folders are not permanently deleted immediately or copied to the clipboard when deleted.

Explanation:

Deleted files and folders are temporarily moved to the Recycle Bin.

26 / 116

What is the purpose of the ‘Header & Footer’ tools in MS Word?

A) To insert and edit headers and footers

B) To add page numbers

C) To change document margins

D) To format paragraphs

Explanation:

To add page numbers, to change document margins, and to format paragraphs are not accurate descriptions of the purpose of the Header & Footer tools in MS Word.

Explanation:

The ‘Header & Footer’ tools in the Insert tab are used to add and modify headers and footers in a document.

27 / 116

How do you insert a picture into an MS Word document?

A) File > Open

B) Insert > Picture

C) View > Zoom

D) Tools > Options

Explanation:

File > Open, View > Zoom, and Tools > Options are options in MS Word, but they are not specifically for inserting a picture into a document.

Explanation:

The Insert tab has an option called ‘Picture’ that allows users to add images to their document.

28 / 116

How do you check spelling and grammar in MS Word?

A) File > Info

B) Review > Spelling & Grammar

C) View > Macros

D) Insert > Symbol

Explanation:

File > Info, View > Macros, and Insert > Symbol are not accurate descriptions of how to check spelling and grammar in MS Word.

Explanation:

The ‘Spelling & Grammar’ feature in the Review tab checks the document for spelling and grammatical errors.

29 / 116

What is the shortcut key to save a document in MS Word?

A) Ctrl + S

B) Ctrl + O

C) Ctrl + N

D) Ctrl + P

Explanation:

Ctrl + O, Ctrl + N, and Ctrl + P are not accurate descriptions of the shortcut key to save a document in MS Word.

Explanation:

Ctrl + S is the shortcut key used to save a document in MS Word.

30 / 116

How do you insert a picture into a Word document?

A) Review > Language

B) Insert > Picture

C) Layout > Watermark

D) References > Insert Footnote

Explanation:

Review > Language, Layout > Watermark, and References > Insert Footnote are not accurate descriptions of how to insert a picture into a Word document.

Explanation:

The ‘Picture’ option in the Insert tab allows you to add images to your document.

31 / 116

How can you view the properties of a file?

A) By double-clicking the file

B) By pressing ‘Ctrl + P’

C) By right-clicking the file and choosing ‘Properties’

D) By dragging the file to the taskbar

Explanation:

By double-clicking the file and by dragging the file to the taskbar are incorrect. Right-clicking a file and selecting ‘Properties’ opens a window with detailed information about the file.

Explanation:

Right-clicking a file and selecting ‘Properties’ opens a window with detailed information about the file.

32 / 116

What are the two main areas of the Windows Explorer window?

A) The Menu Bar and the Taskbar

B) The List Panel and the Detail Section

C) The Desktop and the System Tray

D) The Toolbar and the Navigation Pane

Explanation:

The Menu Bar and the Taskbar or the Desktop and the System Tray are not the main areas of the Windows Explorer window.

Explanation:

Windows Explorer features a List Panel for navigation and a Detail Section for content.

33 / 116

How do you move a desktop icon?

A) Double-click it

B) Right-click and select ‘Move’

C) Click and drag it to the new location

D) Press ‘Ctrl + M’

Explanation:

Double-clicking the icon or pressing ‘Ctrl + M’ do not move desktop icons.

Explanation:

Clicking and dragging an icon allows you to move it around the desktop.

34 / 116

Which shortcut key combination is used to align text to the left in MS Word?

A) Ctrl + L

B) Ctrl + E

C) Ctrl + J

D) Ctrl + R

Explanation:

Ctrl + E, Ctrl + J, and Ctrl + R are shortcut key combinations in MS Word, but they are not specifically for aligning text to the left.

Explanation:

Ctrl + L is the shortcut key used to align text to the left in MS Word.

35 / 116

What does the acronym ‘ISP’ stand for?

A) Internet Security Provider

B) Internet Service Provider

C) Internal Service Provider

D) International Software Program

Explanation:

Internet Security Provider, Internal Service Provider, and International Software Program are incorrect options. ISP stands for Internet Service Provider, which offers access to the internet.

Explanation:

ISP stands for Internet Service Provider, which offers access to the internet.

36 / 116

How can you create a bulleted list in MS Word?

A) Home > Bullets

B) Insert > Shapes

C) Page Layout > Indents

D) References > Add Text

Explanation:

Insert > Shapes, Page Layout > Indents, and References > Add Text are not accurate descriptions of how to create a bulleted list in MS Word.

Explanation:

The ‘Bullets’ option in the Home tab allows you to create a bulleted list in your document.

37 / 116

What does the ‘Mailings’ tab in MS Word primarily deal with?

A) Emailing documents

B) Creating and printing letters and envelopes

C) Inserting images

D) Changing document themes

Explanation:

Emailing documents, inserting images, and changing document themes are tasks that can be performed in MS Word, but they are not specifically related to the Mailings tab.

Explanation:

The Mailings tab is used for mail merge tasks, including creating and printing letters and envelopes.

38 / 116

Why are new versions of software released?

A) To make the software heavier

B) To update and improve the software

C) To increase the cost of the software

D) To make the software obsolete

Explanation:

To make the software heavier, increase the cost of the software, or make the software obsolete are not reasons for releasing new versions of software.

Explanation:

New versions are released to update and improve the software, introducing new features and enhancements.

39 / 116

What distinguishes an active window from other open windows?

A) It is always minimized

B) It has a different color title bar

C) It is larger in size

D) It is always on top

Explanation:

It is always minimized, it is larger in size, and it is always on top are incorrect. The active window is indicated by a differently colored title bar compared to inactive windows.

Explanation:

The active window is indicated by a differently colored title bar compared to inactive windows.

40 / 116

How does a dot matrix printer work?

A) By using laser technology

B) By spraying ink through nozzles

C) By striking pins against an ink ribbon

D) By heating special paper

Explanation:

A dot matrix printer does not work by using laser technology, spraying ink through nozzles, or heating special paper.

Explanation:

A dot matrix printer creates characters and illustrations by striking pins against an ink ribbon to form a matrix of dots.

41 / 116

What is the difference between ROM and RAM?

A) ROM is temporary, RAM is permanent

B) ROM can be modified, RAM cannot

C) ROM is permanent, RAM is temporary

D) ROM is for gaming, RAM is for storage

Explanation:

ROM being temporary, RAM being permanent, ROM being for gaming, or RAM being for storage are not the differences between the two types of memory.

Explanation:

The difference is that ROM is permanent and stores essential instructions, while RAM is temporary and stores data currently being processed.

42 / 116

What is the purpose of the ‘Review’ tab in MS Word?

A) To insert tables

B) To change document views

C) To proofread and review the document

D) To adjust page setup

Explanation:

To insert tables, change document views, and adjust page setup are tasks that can be performed in MS Word, but they are not specifically related to the Review tab.

Explanation:

The Review tab contains tools for spell check, grammar check, and other reviewing features.

43 / 116

What is the main difference between a laser printer and an inkjet printer?

A) Laser printers are slower

B) Inkjet printers use laser technology

C) Laser printers produce high-quality graphics

D) Inkjet printers are more expensive

Explanation:

Laser printers being slower, inkjet printers using laser technology, or inkjet printers being more expensive are not the main differences between the two types of printers.

Explanation:

The main difference is that laser printers produce high-quality graphics, unlike inkjet printers which spray ink to form images.

44 / 116

What is the primary method to connect to the Internet?

A) Through satellite only

B) Via telephone line or satellite

C) By using a radio

D) Through cable television

Explanation:

Connecting to the Internet is not primarily done through satellite only, using a radio, or through cable television.

Explanation:

The primary methods to connect to the Internet are via telephone line or satellite connections, which provide access to ISPs (Internet Service Providers).

45 / 116

Which feature in MS Word allows you to change page orientation?

A) Review > Language

B) Insert > Table

C) Page Layout > Orientation

D) References > Table of Contents

Explanation:

Review > Language and References > Table of Contents are not accurate descriptions of features that allow you to change page orientation in MS Word.

Explanation:

The ‘Orientation’ option in the Page Layout tab lets you switch between portrait and landscape page orientations.

46 / 116

What is the purpose of using templates in MS Word?

A) To fix errors

B) To create documents with pre-defined formatting

C) To save documents

D) To print documents

Explanation:

To fix errors, save documents, and print documents are tasks that can be performed in MS Word, but they are not specifically related to using templates.

Explanation:

Templates in MS Word provide pre-designed formatting to help create documents quickly and consistently.

47 / 116

What is the shortcut key for printing a document in MS Word?

A) Ctrl + S

B) Ctrl + P

C) Ctrl + C

D) Ctrl + X

Explanation:

Ctrl + S, Ctrl + C, and Ctrl + X are shortcut keys in MS Word, but they are not specifically for printing a document.

Explanation:

Ctrl + P is the shortcut key used to open the print dialog box in MS Word.

48 / 116

What does ‘mail merge’ in MS Word typically involve?

A) Merging emails

B) Combining letters with recipient data

C) Merging two documents

D) Sending emails from Word

Explanation:

Merging emails and merging two documents are tasks that MS Word can perform, but they are not specifically related to mail merge.

Explanation:

Mail merge is used to combine a standard letter with individual recipient data for mass mailings.

49 / 116

How do you access the ‘Shut down’ option on a computer?

A) By pressing ‘Ctrl + Alt + Del’

B) By right-clicking on the desktop

C) By clicking Start and then ‘Shut down’

D) By closing all open applications

Explanation:

Pressing ‘Ctrl + Alt + Del’ or right-clicking on the desktop does not directly access the ‘Shut down’ option.

Explanation:

The ‘Shut down’ option is found by clicking Start and then ‘Shut down.’

50 / 116

What does ‘email’ stand for?

A) Electronic mail

B) Express mail

C) Elegant mail

D) Essential mail

Explanation:

Express mail, Elegant mail, and Essential mail are not expansions of the acronym 'email.'

Explanation:

Email stands for Electronic mail, which refers to the transmission of messages and files over a computer network.

51 / 116

What is the main difference between a track pad and a trackball?

A) A track pad uses a ball for navigation

B) A trackball uses finger motion for navigation

C) A track pad translates finger motion to screen position

D) A trackball is used for typing

Explanation:

A track pad using a ball for navigation, a trackball being used for typing, or a trackpad translating finger motion to screen position are not the main differences between the two input devices.

Explanation:

The main difference is that a trackpad translates finger motion to screen position, while a trackball uses a rotatable ball for navigation.

52 / 116

What is the purpose of the ‘Design’ tab in MS Word?

A) To insert tables

B) To check spelling

C) To format the document design

D) To print the document

Explanation:

To insert tables, check spelling, and print the document are not accurate descriptions of the purpose of the Design tab in MS Word.

Explanation:

The ‘Design’ tab provides options for formatting the overall design of the document, such as themes and style sets.

53 / 116

What is the shortcut key to align text to the center in MS Word?

A) Ctrl + L

B) Ctrl + E

C) Ctrl + R

D) Ctrl + J

Explanation:

Ctrl + L, Ctrl + R, and Ctrl + J are not accurate descriptions of the shortcut key to align text to the center in MS Word.

Explanation:

Ctrl + E is the shortcut key for centering text in MS Word.

54 / 116

What is the function of the ‘Windows Explorer’?

A) To browse the internet

B) To manage files and folders on the computer

C) To edit images

D) To play videos

Explanation:

To browse the internet, to edit images, and to play videos are incorrect. Windows Explorer is a file management utility that allows users to browse and organize their files and folders.

Explanation:

Windows Explorer is a file management utility that allows users to browse and organize their files and folders.

55 / 116

What is the function of the ‘New Folder’ option when right-clicking on the desktop?

A) To create a new file

B) To open a new application

C) To create a new folder

D) To refresh the desktop

Explanation:

To create a new file, to open a new application, and to refresh the desktop are incorrect. The ‘New Folder’ option is used to create a new folder directly on the desktop.

Explanation:

The ‘New Folder’ option is used to create a new folder directly on the desktop.

56 / 116

How can you change the font style in MS Word?

A) View > Macros

B) Home > Font Style

C) Insert > Text

D) Layout > Page Background

Explanation:

View > Macros, Insert > Text, and Layout > Page Background are options in MS Word, but they are not specifically for changing the font style.

Explanation:

The Home tab contains the Font section where you can change the font style.

57 / 116

How can you select multiple files at once?

A) By clicking each file while holding down the ‘Ctrl’ key

B) By double-clicking each file

C) By renaming each file

D) By dragging each file to the Recycle Bin

Explanation:

By double-clicking each file, by renaming each file, and by dragging each file to the Recycle Bin are incorrect. Holding down the ‘Ctrl’ key while clicking allows you to select multiple files individually.

Explanation:

Holding down the ‘Ctrl’ key while clicking allows you to select multiple files individually.

58 / 116

What does ‘www’ in a URL typically stand for?

A) World Wide Web

B) World Wide Window

C) Wide Web World

D) Web World Wide

Explanation:

The 'www' in a URL typically does not stand for Wide Web World.

Explanation:

In a URL, 'www' typically stands for World Wide Web, indicating the address is part of the global network of interconnected documents and resources.

59 / 116

Which tab in MS Word allows you to insert a table?

A) Home

B) Insert

C) Design

D) Layout

Explanation:

Home, Design, and Layout are tabs in MS Word, but they do not specifically allow you to insert a table.

Explanation:

The Insert tab in MS Word provides the option to insert tables into a document.

60 / 116

What indicates that the printer is powered on during installation?

A) The computer restarts

B) The LED on the printer panel is on

C) The printer prints a test page automatically

D) The printer makes a sound

Explanation:

The computer restarting, the printer printing a test page automatically, or the printer making a sound are not indicators that the printer is powered on.

Explanation:

The LED light on the printer panel being on indicates that the printer has power.

61 / 116

How can you recover files from the Recycle Bin?

A) By restarting the computer

B) By selecting the file and clicking ‘Restore this item’

C) By dragging them back to the desktop

D) By performing a system restore

Explanation:

Files are not recovered by restarting the computer or dragging them back to the desktop.

Explanation:

To recover files from the Recycle Bin, you can select the file and click ‘Restore this item.’

62 / 116

How can you adjust the zoom level in MS Word?

A) File > Options

B) View > Zoom

C) Insert > Pictures

D) Home > Font Size

Explanation:

File > Options, Insert > Pictures, and Home > Font Size are not accurate descriptions of how to adjust the zoom level in MS Word.

Explanation:

The ‘Zoom’ feature in the View tab allows users to adjust the zoom level of the document for better visibility.

63 / 116

How can you change the system time and date from the desktop?

A) By going to the ‘Control Panel’ and selecting ‘Date and Time’

B) By clicking the time in the system tray and selecting ‘Change date and time settings’

C) By right-clicking on the clock and choosing ‘Adjust Date/Time’

D) By opening the calendar application

Explanation:

The system time and date are not changed by going to the ‘Control Panel’ or opening the calendar application.

Explanation:

You can change the system time and date by clicking the time in the system tray and selecting ‘Change date and time settings.’

64 / 116

What is the function of the ‘Quick Access Toolbar’ in MS Word?

A) To quickly access document statistics

B) To provide shortcuts to frequently used commands

C) To change the Quick Styles

D) To access mail merge features

Explanation:

To quickly access document statistics, to change the Quick Styles, and to access mail merge features are not accurate descriptions of the function of the Quick Access Toolbar in MS Word.

Explanation:

The ‘Quick Access Toolbar’ offers easy access to commonly used commands such as Save, Undo, and Redo.

65 / 116

What is the process to restart a computer using the Start menu?

A) Click Start, then ‘Restart’

B) Click Start, then ‘Log Off’, then ‘Restart’

C) Click Start, then the arrow next to ‘Shut down’, and select ‘Restart’

D) Click Start, then ‘Control Panel’, then ‘Restart’

Explanation:

Pressing ‘Ctrl + Alt + Del’ or closing all open applications does not directly access the restart option.

Explanation:

To restart a computer using the Start menu, click Start, then the arrow next to ‘Shut down’, and select ‘Restart.’

66 / 116

What does ‘URL’ stand for?

A) Uniform Resource Locator

B) Universal Resource Link

C) Unified Retrieval Language

D) Unique Resource Link

Explanation:

Universal Resource Link, Unified Retrieval Language, and Unique Resource Link are incorrect expansions of the acronym 'URL.'

Explanation:

URL stands for Uniform Resource Locator, which is the address used to identify resources on the internet.

67 / 116

What is the purpose of the ‘Recycle Bin’ on a computer?

A) To store temporary files

B) To keep all the installed applications

C) To hold deleted files and folders

D) To display system notifications

Explanation:

To store temporary files, to keep all the installed applications, and to display system notifications are incorrect. The Recycle Bin is used to hold deleted files and folders.

Explanation:

The Recycle Bin is used to temporarily store files and folders that have been deleted from the computer.

68 / 116

What is the consequence of software piracy?

A) Increased software performance

B) Legal action

C) Software updates

D) Faster internet speeds

Explanation:

Increased software performance or software updates are not consequences of software piracy.

Explanation:

Software piracy can lead to legal action against individuals involved in illegal copying or selling of software.

69 / 116

What is the function of the ‘Draft’ view in MS Word?

A) To provide a simple layout for editing

B) To display the final print layout

C) To show how the document will look online

D) To create a draft email

Explanation:

To display the final print layout, to show how the document will look online, and to create a draft email are not accurate descriptions of the function of the Draft view in MS Word.

Explanation:

The ‘Draft’ view offers a simplified layout that is optimized for editing, without displaying headers, footers, or other complex formatting.

70 / 116

How do you close an application window?

A) By pressing ‘Ctrl + W’

B) By clicking the ‘Minimize’ button

C) By clicking the ‘Close’ button (X)

D) By dragging it to the Recycle Bin

Explanation:

By pressing ‘Ctrl + W’ and by clicking the ‘Minimize’ button are incorrect. The ‘Close’ button, usually represented by an ‘X’, is used to close an application window.

Explanation:

The ‘Close’ button, usually represented by an ‘X’, is used to close an application window.

71 / 116

Which tab do you use to insert a table in MS Word?

A) Home

B) Insert

C) Design

D) Layout

Explanation:

Home, Design, and Layout are not accurate descriptions of the tab you use to insert a table in MS Word.

Explanation:

The Insert tab provides the option to insert tables into a document.

72 / 116

How do you insert a hyperlink in MS Word?

A) Layout > Breaks

B) References > Insert Citation

C) Insert > Hyperlink

D) Review > Thesaurus

Explanation:

Layout > Breaks, References > Insert Citation, and Review > Thesaurus are not accurate descriptions of how to insert a hyperlink in MS Word.

Explanation:

The ‘Hyperlink’ option in the Insert tab allows you to add links to web pages, email addresses, or other documents.

73 / 116

What is the purpose of the ‘Send To’ option when right-clicking a file?

A) To send the file to the Recycle Bin

B) To send the file to another user via email

C) To copy the file to another location, like a USB drive

D) To change the file’s format

Explanation:

To send the file to the Recycle Bin, to change the file’s format, and to play the file’s content are incorrect. The ‘Send To’ option is used to copy files to different locations or devices.

Explanation:

The ‘Send To’ option is used to copy files to different locations or devices.

74 / 116

What does the ‘Restore this item’ option do in the Recycle Bin?

A) It deletes the file permanently

B) It moves the file to a USB drive

C) It restores the file to its original location

D) It opens the file for editing

Explanation:

It deletes the file permanently, it moves the file to a USB drive, and it opens the file for editing are incorrect. ‘Restore this item’ returns the deleted file or folder to the place it was before deletion.

Explanation:

‘Restore this item’ returns the deleted file or folder to the place it was before deletion.

75 / 116

What is the significance of a password for email access?

A) It slows down the computer

B) It uniquely identifies the user

C) It is optional for email access

D) It is the same as the username

Explanation:

A password for email access does not slow down the computer, is not optional, and is typically different from the username.

Explanation:

A password for email access serves to uniquely identify the user and secure their email account from unauthorized access.

76 / 116

What does the ‘Full Screen Reading’ view mode in MS Word do?

A) Displays the document in a format suitable for reading

B) Shows the document in a print layout

C) Presents the document in a web layout

D) Provides an outline view of the document

Explanation:

Shows the document in a print layout, presents the document in a web layout, and provides an outline view of the document are not accurate descriptions of what the Full Screen Reading view mode does in MS Word.

Explanation:

The ‘Full Screen Reading’ view mode optimizes the document for reading on the screen, with minimal distractions.

77 / 116

What information can you find in the ‘Properties’ panel of a folder?

A) The folder’s color and shape

B) The folder’s name, type, location, size, and creation date

C) The folder’s password

D) The number of icons on the desktop

Explanation:

The folder’s color and shape, the folder’s password, and the number of icons on the desktop are incorrect. The ‘Properties’ panel provides detailed information about the folder, including its name, type, location, size, and when it was created.

Explanation:

The ‘Properties’ panel provides detailed information about the folder, including its name, type, location, size, and when it was created.

78 / 116

How can you add a border to a Word document?

A) Insert > Shapes

B) Page Layout > Page Borders

C) Design > Watermark

D) References > Captions

Explanation:

Insert > Shapes, Design > Watermark, and References > Captions are not accurate descriptions of how to add a border to a Word document.

Explanation:

The ‘Page Borders’ option in the Page Layout tab allows you to add or customize borders around pages or text.

79 / 116

How do you change the font color in MS Word?

A) Home > Font Color

B) Page Layout > Page Color

C) Design > Colors

D) References > Insert Caption

Explanation:

Page Layout > Page Color, Design > Colors, and References > Insert Caption are not accurate descriptions of how to change the font color in MS Word.

Explanation:

The ‘Font Color’ option in the Home tab allows you to change the color of the selected text.

80 / 116

What is the first step to create a new folder on the desktop?

A) Pressing ‘Ctrl + N’

B) Right-clicking on the desktop and selecting ‘New > Folder’

C) Opening the ‘Control Panel’

D) Double-clicking on ‘My Computer’

Explanation:

Pressing ‘Ctrl + N’, opening the ‘Control Panel’, and double-clicking on ‘My Computer’ are incorrect. To create a new folder on the desktop, right-click on an empty area and select ‘New > Folder’.

Explanation:

To create a new folder on the desktop, right-click on an empty area and select ‘New > Folder’.

81 / 116

How do you adjust line spacing in MS Word?

A) Layout > Paragraph

B) Home > Line and Paragraph Spacing

C) Insert > Text Box

D) Design > Themes

Explanation:

Layout > Paragraph, Insert > Text Box, and Design > Themes are not accurate descriptions of how to adjust line spacing in MS Word.

Explanation:

The ‘Line and Paragraph Spacing’ option in the Home tab lets you adjust the spacing between lines and paragraphs.

82 / 116

How can you add a word to MS Word’s dictionary?

A) File > Options

B) Right-click > Add to Dictionary

C) Edit > Undo

D) View > Read Mode

Explanation:

File > Options, Edit > Undo, and View > Read Mode do not involve adding a word to MS Word’s dictionary.

Explanation:

Right-clicking on a word and selecting ‘Add to Dictionary’ adds it to MS Word’s dictionary, preventing it from being marked as a mistake in the future.

83 / 116

How do you resize an application window?

A) By double-clicking the title bar

B) By dragging the window’s edges

C) By pressing ‘Alt + Enter’

D) By selecting ‘Resize’ from the system menu

Explanation:

Double-clicking the title bar or pressing ‘Alt + Enter’ does not resize an application window.

Explanation:

You can resize an application window by dragging the window’s edges.

84 / 116

What is the function of a web browser?

A) To create web pages

B) To view web pages

C) To store web pages

D) To print web pages

Explanation:

A web browser does not create web pages, store web pages, or print web pages.

Explanation:

The primary function of a web browser is to view and interpret web pages, allowing users to navigate the internet and access various online resources.

85 / 116

What is the role of multimedia projectors in computer output?

A) To scan documents

B) To display output on a larger screen

C) To increase internet speed

D) To print documents

Explanation:

Multimedia projectors are not used to scan documents, increase internet speed, or print documents.

Explanation:

Their role is to display output on a larger screen, such as presentations, for better visibility.

86 / 116

What is the path to a file?

A) The file’s name only

B) The sequence of folders leading to a file

C) The URL of the file on the internet

D) The file’s size and type

Explanation:

The file’s size and type or the URL of the file on the internet do not constitute the path to a file.

Explanation:

The path to a file includes the sequence of folders leading to a file.

87 / 116

What does the ‘Print Layout’ view in MS Word show?

A) The document as it would appear when printed

B) The document in a web format

C) The document without images

D) The document in a draft format

Explanation:

The document in a web format, the document without images, and the document in a draft format are not accurate descriptions of the Print Layout view in MS Word.

Explanation:

The ‘Print Layout’ view displays the document as it would look on a printed page, including all formatting.

88 / 116

What is the significance of the system tray?

A) It is where the Recycle Bin is located

B) It contains icons for system notifications and background applications

C) It is used to change the screen resolution

D) It stores frequently used files

Explanation:

The system tray does not store frequently used files or contain the Recycle Bin.

Explanation:

The system tray, or notification area, shows icons for system notifications and background applications.

89 / 116

Which of the following is a security risk for computers?

A) Software updates

B) Antivirus software

C) Hardware theft

D) Password protection

Explanation:

Software updates and antivirus software are not security risks for computers.

Explanation:

Hardware theft poses a significant security risk for computers as it can lead to loss of valuable physical components.

90 / 116

What does the ‘Page Break’ feature do in MS Word?

A) Changes the page orientation

B) Adds a new page in the document

C) Inserts a break in the text

D) Creates a new paragraph

Explanation:

Changes the page orientation, inserts a break in the text, and creates a new paragraph are not accurate descriptions of what the Page Break feature does in MS Word.

Explanation:

The ‘Page Break’ feature inserts a new page at the location of the cursor within the document.

91 / 116

What distinguishes an active window from an inactive window?

A) The active window is always minimized

B) The active window has a dark-colored title bar

C) The active window cannot be moved

D) The active window is always on the left side

Explanation:

The active window is not always minimized or always on the left side.

Explanation:

An active window has a dark-colored title bar to indicate it’s currently in use.

92 / 116

What advantage do LCD monitors have over CRT monitors?

A) Heavier weight

B) Larger size

C) More space consumption

D) Compact and lightweight design

Explanation:

Heavier weight, larger size, and more space consumption are not advantages of LCD monitors over CRT monitors.

Explanation:

The advantage is that LCD monitors have a compact and lightweight design.

93 / 116

What does the power button on a system unit do?

A) Opens the Start menu

B) Turns on or wakes up the computer

C) Ejects the CD/DVD tray

D) Starts the screen saver

Explanation:

The power button does not open the Start menu, eject the CD/DVD tray, or start the screen saver.

Explanation:

The power button is used to turn on or wake up the computer.

94 / 116

What is the purpose of desktop icons?

A) To display the computer’s wallpaper

B) To represent programs, files, and folders

C) To show the current time

D) To change system settings

Explanation:

Desktop icons are not solely for displaying the computer’s wallpaper or changing system settings.

Explanation:

Desktop icons represent programs, files, and folders for easy access.

95 / 116

What is the shortcut key to save a document in MS Word?

A) Ctrl + S

B) Ctrl + O

C) Ctrl + N

D) Ctrl + P

Explanation:

Ctrl + O, Ctrl + N, and Ctrl + P are shortcut keys in MS Word, but they are not specifically for saving a document.

Explanation:

Ctrl + S is the shortcut key used to save a document in MS Word.

96 / 116

What is a web page?

A) A printed page from the internet

B) A resource of information on the web

C) A type of computer

D) A software program

Explanation:

A web page is not a printed page from the internet, a type of computer, or a software program.

Explanation:

A web page is a document or resource of information displayed on the World Wide Web, accessible through a web browser.

97 / 116

Which feature would you use to insert a table into a Word document?

A) References > Index

B) Insert > Table

C) Layout > Page Setup

D) View > Macros

Explanation:

References > Index, Layout > Page Setup, and View > Macros are options in MS Word, but they are not specifically for inserting a table into a document.

Explanation:

The Insert tab has a feature called ‘Table’ for adding tables to a document.

98 / 116

What are the two general types of computer output?

A) Input and output

B) Software and hardware

C) Soft copy and hard copy

D) Data and information

Explanation:

Input and output, software and hardware, and data and information are not the two general types of computer output.

Explanation:

The two general types of computer output are soft copy, displayed on a screen, and hard copy, printed on paper.

99 / 116

What is the taskbar used for?

A) To display the current time only

B) To show open tasks and provide quick access to applications

C) To store files and folders

D) To change the desktop background

Explanation:

The taskbar is not used solely to display the current time or to change the desktop background.

Explanation:

The taskbar shows open tasks and provides quick access to applications.

100 / 116

How do you search for a file using ‘My Computer’?

A) By opening each folder individually

B) By typing the file name in the search bar

C) By checking the Recycle Bin

D) By using the ‘Help and Support’ feature

Explanation:

By opening each folder individually, by checking the Recycle Bin, and by using the ‘Help and Support’ feature are incorrect. The search bar in ‘My Computer’ allows you to find files by typing their names.

Explanation:

The search bar in ‘My Computer’ allows you to find files by typing their names.

101 / 116

How can you format a USB drive using My Computer?

A) By dragging it to the Recycle Bin

B) By right-clicking on the USB drive icon and selecting ‘Format’

C) By opening the USB drive and deleting all files

D) By selecting ‘Format’ from the File menu

Explanation:

Dragging it to the Recycle Bin or opening the USB drive and deleting all files do not format a USB drive.

Explanation:

You can format a USB drive by right-clicking on the USB drive icon and selecting ‘Format.’

102 / 116

How do you typically access the internet?

A) By connecting to an ISP

B) By turning on the computer only

C) By using a typewriter

D) By opening a book

Explanation:

Accessing the internet does not involve using a typewriter or opening a book.

Explanation:

The typical method to access the internet is by connecting to an ISP (Internet Service Provider) through various means such as telephone lines or satellite connections.

103 / 116

What is ‘output’ in the context of computer systems?

A) The process of turning on a computer

B) The data entered into a computer

C) Anything that comes out of a computer

D) The physical components of a computer

Explanation:

Output is not the process of turning on a computer or the physical components of a computer.

Explanation:

Output refers to anything that comes out of a computer after processing, such as displayed images, printed documents, or sounds.

104 / 116

How can you create mailing envelopes using the mail merge feature in MS Word?

A) Insert > Envelope

B) Mailings > Envelopes

C) Layout > Page Setup

D) Review > Language

Explanation:

Insert > Envelope, Layout > Page Setup, and Review > Language are options in MS Word, but they are not specifically for creating mailing envelopes using the mail merge feature.

Explanation:

The Mailings tab in MS Word provides an option to create and print envelopes using the mail merge feature.

105 / 116

How does a computer mouse function?

A) By detecting keyboard strokes

B) By detecting motion relative to a surface

C) By emitting sound waves

D) By using ink to draw

Explanation:

A computer mouse does not detect keyboard strokes, emit sound waves, or use ink to draw.

Explanation:

It functions by detecting motion relative to a surface, translating it to cursor movement on the screen.

106 / 116

Where can you view the status of a print job?

A) In the ‘Devices and Printers’ window

B) In the ‘Control Panel’

C) On the desktop

D) In the ‘Recycle Bin’

Explanation:

The status of a print job is not typically viewed on the desktop or in the ‘Recycle Bin.’

Explanation:

The ‘Devices and Printers’ window is where you can view the status of print jobs.

107 / 116

What does the ‘Mailings’ tab in MS Word help you with?

A) Sending emails directly from Word

B) Creating and managing mail merge tasks

C) Checking mail

D) Formatting text

Explanation:

Sending emails directly from Word, checking mail, and formatting text are not accurate descriptions of what the Mailings tab helps you with in MS Word.

Explanation:

The ‘Mailings’ tab contains tools for creating and executing mail merge operations, such as letters and envelopes.

108 / 116

What does the ‘Page Layout’ tab in MS Word allow you to change?

A) Spelling errors

B) Page orientation and margins

C) Synonyms of words

D) Document view mode

Explanation:

Spelling errors and document view mode are aspects that can be changed in MS Word, but they are not specifically related to the Page Layout tab.

Explanation:

The Page Layout tab provides options to change the page setup, including orientation and margins.

109 / 116

What is the first step in printer installation?

A) Software Installation

B) Hardware Installation

C) Connecting to the internet

D) Downloading printer apps

Explanation:

The first step in printer installation is not software installation, connecting to the internet, or downloading printer apps.

Explanation:

The initial step in printer installation involves hardware installation, which includes connecting the printer physically to the power source and the computer.

110 / 116

How do you adjust the column width in a Word table?

A) Format > Column Width

B) Layout > AutoFit

C) Right-click > Column Width

D) Tools > Adjust Width

Explanation:

Format > Column Width and Tools > Adjust Width are options in MS Word, but they are not specifically for adjusting the column width in a table.

Explanation:

Right-clicking within a table column and selecting ‘Column Width’ allows you to adjust its width.

111 / 116

What is the purpose of scroll bars in a window?

A) To close the window

B) To resize the window

C) To navigate through content not visible in the window

D) To change the window’s color

Explanation:

To close the window, to resize the window, and to change the window’s color are incorrect. Scroll bars allow users to move through parts of the window that are not immediately visible.

Explanation:

Scroll bars allow users to move through parts of the window that are not immediately visible.

112 / 116

What is an email client?

A) A person who sends emails

B) A software to manage emails

C) A server that stores emails

D) A protocol for sending emails

Explanation:

An email client is not a person who sends emails, a server that stores emails, or a protocol for sending emails.

Explanation:

An email client is a software application used to manage emails, allowing users to send, receive, and organize their email messages.

113 / 116

How can you print a document from MS Word?

A) Press ‘Ctrl + S’

B) Press ‘Ctrl + P’

C) Press ‘Ctrl + C’

D) Press ‘Ctrl + X’

Explanation:

Pressing ‘Ctrl + S’, ‘Ctrl + C’, or ‘Ctrl + X’ do not initiate printing in MS Word.

Explanation:

Pressing ‘Ctrl + P’ is the shortcut for printing a document in MS Word.

114 / 116

How do you add a header to a document in MS Word?

A) Layout > Breaks

B) Insert > Header

C) Design > Page Background

D) References > Table of Contents

Explanation:

Layout > Breaks, Design > Page Background, and References > Table of Contents are options in MS Word, but they are not specifically for adding a header to a document.

Explanation:

The Insert tab provides an option to add headers to a document.

115 / 116

What does the ‘Draft’ view mode in MS Word do?

A) Prints the document

B) Shows a simplified layout without headers and footers

C) Checks spelling and grammar

D) Changes the document theme

Explanation:

Prints the document, checks spelling and grammar, and changes the document theme are actions that can be performed in MS Word, but they are not specifically related to the Draft view mode.

Explanation:

The ‘Draft’ view mode provides a simplified document layout that focuses on the text, omitting headers, footers, and other layout elements.

116 / 116

What is required to access email from anywhere in the world?

A) A telephone line

B) An email ID and password

C) A postal address

D) A specific computer

Explanation:

Accessing email from anywhere in the world does not require a telephone line, postal address, or a specific computer.

Explanation:

To access email from anywhere in the world, users typically need an email ID and password to log in to their email account via an internet-connected device.

Your score is

CS-001 PAST PAPERS

1 / 71

_____________ are used to connect speakers, microphone.

a) USB ports

b) Pin sockets

c) Parallel ports

d) Serial ports

Explanation:

Pin sockets, Parallel ports, and Serial ports are not typically used to connect speakers and microphones. USB ports are commonly used for this purpose.

Explanation:

USB ports are used to connect speakers, microphones, and other peripherals.

2 / 71

In Windows XP, the start menu appears as a panel containing _______ columns.

a) One

b) Two

c) Three

d) Four

Explanation:

One, Three, and Four columns are not the number of columns in the start menu of Windows XP. It appears as a panel containing two columns.

Explanation:

In Windows XP, the start menu appears as a panel containing two columns.

3 / 71

Email is sent via the ________.

a) fax

b) telephone

c) internet

d) radio waves

Explanation:

Fax, telephone, and radio waves are not mediums for sending email. Email is sent via the internet.

Explanation:

Email is sent via the internet.

4 / 71

There are ________ basic types of computers.

a) 2

b) 3

c) 4

d) 5

Explanation:

2, 4, and 5 are not the correct number of basic types of computers. There are three basic types of computers.

Explanation:

There are three basic types of computers.

5 / 71

There are ______ bits in one byte (character).

a) 4

b) 6

c) 8

d) 10

Explanation:

4, 6, and 10 bits are not the correct number of bits in a byte. A byte consists of 8 bits.

Explanation:

There are 8 bits in one byte.

6 / 71

Windows is a software developed by _________.

a) Dell

b) Microsoft

c) Apple

d) Sun

Explanation:

Dell, Apple, and Sun are not developers of Windows. Microsoft is the company behind the development of Windows.

Explanation:

Windows is developed by Microsoft.

7 / 71

Desktop’s icon can be selected after_________.

a) Clicking start button

b) Clicking on it

c) Clicking system tray

d) Clicking status bar

Explanation:

Clicking start button, Clicking system tray, and Clicking status bar do not directly relate to selecting desktop icons, which is done by clicking on them.

Explanation:

Desktop icons can be selected by clicking on them.

8 / 71

Outlook is a/an ________.

a) Web page

b) Web site

c) Word processing Software

d) Email client

Explanation:

Web page, Web site, and Word processing Software are different from Outlook, which is an email client.

Explanation:

Outlook is an email client.

9 / 71

Which type of software helps in performing day to day tasks?

a) Utility software

b) Device manager

c) System software

d) Application software

Explanation:

Utility software, Device manager, and System software serve specific purposes, but Application software is designed for day-to-day tasks.

Explanation:

Application software helps in performing day-to-day tasks.

10 / 71

__________________ is a special key, when pressed with other keys will perform special operations.

a) Arrow keys

b) Alt key

c) Backspace key

d) Enter key

Explanation:

Arrow keys, Backspace key, and Enter key are keys that perform specific functions, but the Alt key is specifically known for performing special operations.

Explanation:

The Alt key is a special key that, when pressed with other keys, performs special operations.

11 / 71

When can’t the desktop be seen?

When Windows is Minimized

When Clicking on the Start Button

When the Screen is Locked

When a Full-Screen Application is Open

Explanation:

When Windows is Minimized, When Clicking on the Start Button, and When the Screen is Locked are not when the desktop can't be seen. It is when a Full-Screen Application is Open.

Explanation:

The desktop is hidden when a full-screen application or window is open.

12 / 71

What is the list of folders and files called?

File and Folder Tree

File and Folder Browser

File and Folder Navigator

Directory Structure

Explanation:

File and Folder Tree, File and Folder Browser, and File and Folder Navigator are not what the list of folders and files is called. It is called the Directory Structure.

Explanation:

The directory structure is a hierarchical representation of folders and files.

13 / 71

When can we not change the order of icons on the desktop?

If the Properties Option is Selected

If the Auto Grid Option is Selected

If the Auto Arrange Option is Selected

If the Align to Grid Option is Selected

Explanation:

If the Properties Option is Selected, If the Auto Grid Option is Selected, and If the Align to Grid Option is Selected are not when we cannot change the order of icons on the desktop. It is when the Auto Arrange Option is Selected.

Explanation:

When ‘Auto arrange’ is enabled, icons are automatically sorted and cannot be freely moved.

14 / 71

Where does the Start button reside?

On the Menu Bar

On the Tool Bar

On the Status Bar

On the Task Bar

Explanation:

On the Menu Bar, On the Tool Bar, and On the Status Bar are not where the Start button resides. It is On the Task Bar.

Explanation:

The Start button is located on the taskbar, usually at the bottom left of the screen in Windows operating systems.

15 / 71

Where does the menu bar reside?

Below the Standard Bar

Below the Status Bar

Below the Tool Bar

At the Top of the Window

Explanation:

Below the Standard Bar, Below the Status Bar, and Below the Tool Bar are not where the menu bar resides. It is at the Top of the Window.

Explanation:

The menu bar is typically located at the top of the window and contains menus for commands and options.

16 / 71

What is the area called that you see after the computer starts?

Window

Desktop

Icons

Monitor

Explanation:

Window, Icons, and Monitor are not the area you see after the computer starts. It is called the Desktop.

Explanation:

The desktop is the primary user interface of a computer, where you can access files, folders, and applications.

17 / 71

How do you arrange icons on the desktop?

Right Click on the Desktop and Select “Refresh”

Right Click on Some Desktop Icon and Select “Arrange Icons By”

Select All Desktop Icons and Select “Arrange Icons By”

Right Click on the Desktop and Select “Arrange Icons By”

Explanation:

Right Clicking on the Desktop and Selecting “Refresh”, Right Clicking on Some Desktop Icon and Selecting “Arrange Icons By”, and Selecting All Desktop Icons and Selecting “Arrange Icons By” do not arrange icons on the desktop. Right Clicking on the Desktop and Selecting “Arrange Icons By” does.

Explanation:

This option allows you to organize desktop icons according to various criteria like name, size, or date modified.

18 / 71

How can we resize a window?

Single Clicking on Window

Double Clicking on Window

Pressing F5

Dragging the Edges of Window with Mouse

Explanation:

Single Clicking on Window, Double Clicking on Window, and Pressing F5 do not resize a window. Dragging the Edges of Window with Mouse does.

Explanation:

You can resize a window by clicking and dragging its edges.

19 / 71

The three small lights on the keyboard show the on/off status for:

Toggle Keys

Special Keys

Functional Keys

Lock Keys

Explanation:

The Toggle Keys, Special Keys, and Functional Keys are not the lights on the keyboard showing the on/off status. They are the Lock Keys.

Explanation:

The lights typically indicate the status of the Num Lock, Caps Lock, and Scroll Lock keys.

20 / 71

Which of the following is a non-typing key?

Tab Key

Enter Key

Space Key

Function Key

Explanation:

The Tab Key, Enter Key, and Space Key are all typing keys. The Function Key is a non-typing key.

Explanation:

Function keys are used to perform specific functions and do not type characters.

21 / 71

Which key is used to exit from certain types of applications?

Space Key

Enter Key

Escape Key

Backspace Key

Explanation:

The Space Key, Enter Key, and Backspace Key are not used to exit from certain types of applications. The Escape Key is.

Explanation:

The Escape key is commonly used to exit menus, dialog boxes, or applications.

22 / 71

Storage is also referred to as:

Data

Instructions

Files

Memory

Explanation:

Storage is not referred to as Data, Instructions, or Files. It is referred to as Memory.

Explanation:

Storage is often referred to as memory, particularly when discussing primary storage like RAM.

23 / 71

Which of the following is not an advantage of a computer?

Efficiency

Reliability

Safety

Fast Results

Explanation:

Efficiency, Reliability, and Fast Results are advantages of a computer. Safety is not.

Explanation:

While computers are efficient, reliable, and provide fast results, safety is not inherently an advantage of computers but depends on how they are used.

24 / 71

What does a computer take as input?

Software

Storage

Output

Input

Explanation:

Software and Output are not what a computer takes as input. It takes Input.

Explanation:

A computer takes data as input through various input devices like a keyboard or mouse.

25 / 71

What does every key on the keyboard send when it is pressed?

Unique Information to Computer

Encoded Information to Computer

Alphabetic Information to Computer

Numeric Information to Computer

Explanation:

Every key on the keyboard does not send Unique Information to Computer, Alphabetic Information to Computer, or Numeric Information to Computer. It sends Encoded Information to Computer.

Explanation:

Each key sends a specific encoded signal to the computer that represents a particular character or function.

26 / 71

How do the main components of the computer communicate with each other?

System Bus

Memory

Keyboard

CPU

Explanation:

Memory and Keyboard are not the main components of the computer that communicate with each other. The System Bus is responsible for this communication.

Explanation:

The system bus is a communication system that transfers data between components inside or between computers.

27 / 71

Which key, when pressed with other keys, performs special operations?

Backspace Key

Arrow Keys

Alt Key

Shift Key

Explanation:

The Backspace Key and Arrow Keys do not perform special operations when pressed with other keys. The Alt Key does.

Explanation:

The Alt key is used in combination with other keys to perform special functions and shortcuts.

28 / 71

What are the two broad categories of software?

MS Word and Spreadsheet

Windows and Mac

System and Application Software

Microsoft and Apple

Explanation:

MS Word and Spreadsheet, Windows and Mac, and Microsoft and Apple are not the two broad categories of software. System and Application Software are the correct categories.

Explanation:

Software is broadly categorized into system software, like operating systems, and application software, like word processors.

29 / 71

How do you remove a wrong character typed in Notepad?

Using Alt Key

Using CTRL Key

Using Delete Key

Using Backspace Key

Explanation:

Using the Alt Key, CTRL Key, or Delete Key does not remove the wrong character typed in Notepad. The Backspace Key is used for this purpose.

Explanation:

The Backspace key is used to delete the character to the left of the cursor in Notepad.

30 / 71

What is the blinking line in Notepad called?

Cursor

Long Bar

Pad Pointer

Character Setter

Explanation:

The Long Bar, Pad Pointer, and Character Setter are not terms used to describe the blinking line in Notepad. It is called the cursor.

Explanation:

The blinking line in Notepad that indicates where the next character will be placed is called the cursor.

31 / 71

When can’t the desktop be seen?

When Windows is Minimized

When Clicking on the Start Button

When the Screen is Locked

When a Full-Screen Application is Open

Explanation:

When Windows is Minimized, When Clicking on the Start Button, and When the Screen is Locked are not when the desktop can't be seen. It is when a Full-Screen Application is Open.

Explanation:

The desktop is hidden when a full-screen application or window is open.

32 / 71

Suppose you have written all your text in a Notepad file, what task will you perform after this?

Open this file

Delete this file

Move this file

Save this file

Explanation:

Open this file, Delete this file, Move this file

Explanation:

Save this file

33 / 71

Scroll bars are used to see the:

Properties of the window

Version of the window

Content of the window

Explanation:

Properties of the window, Version of the window

Explanation:

Content of the window

34 / 71

We cannot change the order of icons on the desktop if:

Properties option is selected

Auto grid option is selected

Auto arrange option is selected

Explanation:

Properties option is selected, Auto grid option is selected, Auto arrange option is selected

Explanation:

Auto arrange option is selected

35 / 71

The Start button resides on the left side of the:

Menu bar

Tool bar

Status bar

Taskbar

Explanation:

Menu bar, Tool bar, Status bar

Explanation:

Taskbar

36 / 71

Data is saved in the form of:

Folders

Content

Icons

Files

Explanation:

Folders, Content, Icons

Explanation:

Files

37 / 71

The system clock exists in the:

Menu bar

Tool bar

Status bar

System tray

Explanation:

Menu bar, Tool bar, Status bar

Explanation:

System tray

38 / 71

The taskbar shows the:

Completed tasks

History of tasks

Tasks being carried out in the computer

Explanation:

Completed tasks, History of tasks

Explanation:

Tasks being carried out in the computer

39 / 71

A desktop icon is a link to:

Hardware

Storage

Application

Explanation:

Hardware, Storage

Explanation:

Application

40 / 71

Windows is a software developed by:

Sun

Apple

Dell

Microsoft

Explanation:

Sun, Apple, Dell

Explanation:

Microsoft

41 / 71

To arrange icons on the desktop, you:

Right-click on the desktop and select “refresh” option

Right-click on some desktop icon and select “arrange icons by” option

Select all desktop icons and select “arrange icons by” option

Right-click on the desktop and select “arrange icons by” option

Explanation:

Right-click on the desktop and select “refresh” option, Right-click on some desktop icon and select “arrange icons by” option, Select all desktop icons and select “arrange icons by” option

Explanation:

Right-click on the desktop and select “arrange icons by” option

42 / 71

Fastest computers are called:

Personal computers

Portable computers

High-performance computers

Super computers

Explanation:

Personal computers, Portable computers, High-performance computers

Explanation:

Super computers

43 / 71

Computer takes input and produces output after the given input, this process is called:

Execution

Correction

Computation

Processing

Explanation:

Execution, Correction, Computation

Explanation:

Processing

44 / 71

Keys used to navigate the cursor in different directions are called:

Functional keys

Toggle keys

Directional keys

Arrow keys

Explanation:

Functional keys, Toggle keys, Directional keys

Explanation:

Arrow keys

45 / 71

The key used to generate space between two characters is called:

Enter key

Tab key

Spacebar

Explanation:

Enter key, Tab key, Spacebar

Explanation:

Spacebar

46 / 71

Every key on the keyboard sends what when it is pressed?

Unique information to the computer

Encoded information to the computer

Alphabetic information to the computer

Signal to the computer

Explanation:

Unique information to the computer, Encoded information to the computer, Alphabetic information to the computer

Explanation:

Signal to the computer

47 / 71

Caps lock, num lock, and scroll lock keys are called:

Toggle keys

Application keys

Arrow keys

Lock keys

Explanation:

Toggle keys, Application keys, Arrow keys

Explanation:

Lock keys

48 / 71

When pressed with other keys, it performs special operations:

Shift key

Arrow keys

Enter key

Ctrl key

Explanation:

Shift key, Arrow keys, Enter key

Explanation:

Ctrl key

49 / 71

Computers designed for mobile use are called:

Personal computers

Super computers

Mainframe computers

Laptops

Explanation:

Personal computers, Super computers, Mainframe computers

Explanation:

Laptops

50 / 71

What are the two broad categories of software?

MS Word and Spreadsheet

Windows and Mac

Microsoft and Apple

System and Application Software

Explanation:

MS Word and Spreadsheet, Windows and Mac, Microsoft and Apple

Explanation:

System and Application Software

51 / 71

During writing a letter, you typed a wrong character in Notepad. How will you go back and remove that character?

Using Alt Key

Using CTRL Key

Using Delete Key

Using Backspace Key

Explanation:

Using Alt Key, CTRL Key, Delete Key

Explanation:

Using Backspace Key

52 / 71

Suppose you have written all your text in a Notepad file, what task will you perform after this?

a) Open this file

b) Save this file

c) Delete this file

d) Move this file

Explanation:

Opening the file, Deleting the file, and Moving the file are not typically performed immediately after writing text in a Notepad file. After writing text in Notepad, you should Save the file to ensure that your work is not lost.

Explanation:

After writing text in Notepad, you should Save the file to ensure that your work is not lost.

53 / 71

Scroll bars are used to see the:

a) Properties of the window

b) Version of the window

c) Content of the window

Explanation:

The Properties of the window, and Version of the window are not displayed using scroll bars. Scroll bars allow you to navigate through the Content of the window.

Explanation:

Scroll bars allow you to navigate through the Content of the window.

54 / 71

The Start button resides on the left side of the:

a) Menu bar

b) Tool bar

c) Status bar

d) Task bar

Explanation:

The Menu bar, Tool bar, and Status bar do not typically contain the Start button. The Start button is part of the Task bar, which is usually found at the bottom of the screen in Windows operating systems.

Explanation:

The Start button is part of the Task bar, which is usually found at the bottom of the screen in Windows operating systems.

55 / 71

Which bar resides at the bottom of the window?

a) Status bar

b) Menu bar

c) Standard bar

d) Title bar

Explanation:

The Menu bar, Standard bar, and Title bar are not typically located at the bottom of the window. The Status bar is typically located at the bottom of a window and displays information about the current state of the program or document.

Explanation:

The Status bar is typically located at the bottom of a window and displays information about the current state of the program or document.

56 / 71

The system tray shows icons for programs that:

a) Need data backup

b) Run in the background

c) Consume more memory

d) are Special keys

Explanation:

Need data backup, Consume more memory, and are Special keys are not the correct reasons for icons in the system tray. The system tray displays icons for programs that Run in the background.

Explanation:

The system tray displays icons for programs that Run in the background.

57 / 71

To move an icon on the desktop, we have to:

a) Double-click it first

b) Select it first

c) Select 'arrange icons by' option

Explanation:

Double-clicking it first does not move the icon. Selecting the 'arrange icons by' option does not move the icon. To move an icon, you must Select it first by clicking once and then drag it to the desired location.

Explanation:

To move an icon, you must Select it first by clicking once and then drag it to the desired location.

58 / 71

To arrange icons on the desktop, you:

a) Right-click on the desktop and select 'refresh' option

b) Right-click on some desktop icon and select 'arrange icons by' option

c) Select all desktop icons and select 'arrange icons by' option

d) Right-click on the desktop and select 'arrange icons by' option

Explanation:

Right-clicking on the desktop and selecting the 'refresh' option does not arrange icons. Right-clicking on some desktop icon and selecting 'arrange icons by' option does not provide the option to arrange icons directly. Selecting all desktop icons and selecting 'arrange icons by' option does not allow you to arrange icons directly. Right-clicking on the desktop and selecting 'arrange icons by' option allows you to organize desktop icons according to various criteria like name, size, or date modified.

Explanation:

Right-clicking on the desktop and selecting 'arrange icons by' option allows you to organize desktop icons according to various criteria like name, size, or date modified.

59 / 71

We can resize a window by:

a) Single clicking on the window

b) Double clicking on the window

c) Pressing F5

d) Dragging the edges of the window with the mouse

Explanation:

Single-clicking on the window, Double-clicking on the window, and Pressing F5 do not resize windows. You can resize a window by Dragging the edges of the window with the mouse.

Explanation:

You can resize a window by Dragging the edges of the window with the mouse.

60 / 71

To view properties of a folder, we need to:

a) Press F4

b) Right-click on the folder and select properties

c) Double-click on the folder

d) Left-click on the folder and select properties

Explanation:

Pressing F4 and Double-clicking on the folder do not directly open the properties of the folder. Left-clicking on the folder and selecting properties is not the typical method. Right-clicking on the folder and selecting properties allows you to view its details.

Explanation:

Right-clicking on the folder and selecting properties allows you to view its details.

61 / 71

Three small lights on the keyboard show the on/off status for:

a) Lock keys

b) Toggle keys

c) Special keys

d) Functional keys

Explanation:

Toggle keys, Special keys, and Functional keys are not typically represented by lights on the keyboard. The lights typically indicate the status of the Lock keys (Num Lock, Caps Lock, and Scroll Lock).

Explanation:

These lights typically indicate the status of the Num Lock, Caps Lock, and Scroll Lock keys.

62 / 71

Keys used to navigate the cursor in different directions are called:

a) Arrow keys

b) Functional keys

c) Toggle keys

Explanation:

Functional keys are used for specific functions, not for navigating the cursor. Toggle keys change the state of a function. Arrow keys are used to move the cursor up, down, left, or right within text.

Explanation:

Arrow keys are used to move the cursor up, down, left, or right within text.

63 / 71

The key used to generate a particular number of spaces between two characters is called:

a) Tab key

b) Space key

c) Enter key

Explanation:

Space key and Enter key do not create spaces between characters. The Tab key is used to generate a particular number of spaces between two characters.

Explanation:

The Tab key is used to generate a particular number of spaces between two characters.

64 / 71

The Tab key is a:

a) Non-typing key

b) Typing key

c) Toggle key

d) Application key

Explanation:

The Tab key is not used for typing characters directly; hence, it's considered a Non-typing key.

Explanation:

The Tab key is not used for typing characters directly; hence, it's considered a Non-typing key.

65 / 71

To go to the next line in the document, you need to press:

a) Enter key

b) Backspace key

c) Alt key

d) Scroll key

Explanation:

Backspace key, Alt key, and Scroll key do not move the cursor to the next line. The Enter key is used to move the cursor to the next line in a text document.

Explanation:

The Enter key is used to move the cursor to the next line in a text document.

66 / 71

Which of the following is intangible?

a) Software

b) Hard disk

c) Optical disk

Explanation:

Hard disk and Optical disk are tangible physical components. Software, on the other hand, is intangible as it represents data and applications.

Explanation:

Software, on the other hand, is intangible as it represents data and applications.

67 / 71

Which of the following is primary storage?

a) Hard disk

b) Floppy disk

c) RAM

d) Optical disk

Explanation:

Hard disk, Floppy disk, and Optical disk are types of secondary storage. RAM (Random Access Memory) is considered primary storage.

Explanation:

RAM (Random Access Memory) is considered primary storage.

68 / 71

To type characters “H”, we use the:

a) Num lock

b) Pause lock

c) Caps lock

d) Scroll lock

Explanation:

Num lock, Pause lock, and Scroll lock are not used for typing characters. The Caps lock key is used to type uppercase letters.

Explanation:

The Caps lock key is used to type uppercase letters.

69 / 71

Latest computers are examples of:

a) Mechanical devices

b) Electronic devices

c) Electromechanical devices

Explanation:

Mechanical devices and Electromechanical devices are outdated types of computers. Modern computers are Electronic devices.

Explanation:

Modern computers are Electronic devices.

70 / 71

What are the two broad categories of software?

a) MS Word and Spreadsheet

b) Windows and Mac

c) System and Application Software

d) Microsoft and Apple

Explanation:

MS Word and Spreadsheet, Windows and Mac, and Microsoft and Apple are not the correct categories. Software is generally categorized into System and Application Software.

Explanation:

Software is generally categorized into System and Application Software.

71 / 71

A long bar line is blinking in Notepad. This line is called:

a) Cursor

b) Long Bar

c) Pad Pointer

d) Character Setter

Explanation:

The Long Bar, Pad Pointer, and Character Setter are not correct terms. The blinking line in Notepad is called the Cursor, indicating where the next character will be placed.

Explanation:

The blinking line in Notepad is called the Cursor, indicating where the next character will be placed.

Your score is

FINAL-TERM PREPARATION

/20

CS-001 | 25

1 / 20

Which icon can you use from the toolbar to open a new file in Excel?

A) Save icon

B) Open icon

C) New icon

D) Print icon

Explanation:

The "New" icon on the toolbar allows you to open a new file directly from the toolbar.

Explanation:

The "New" icon on the toolbar allows you to open a new file directly from the toolbar.

2 / 20

What are the three ways to save an existing file in Excel?

A) File > Save, Ctrl + S, Save icon in formatting toolbar

B) File > Save As, Ctrl + O, Save icon in formatting toolbar

C) File > Open, Ctrl + N, Save icon in formatting toolbar

D) File > Close, Ctrl + P, Save icon in formatting toolbar

Explanation:

You can save an existing file by using File > Save, pressing Ctrl + S, or clicking the Save icon in the formatting toolbar.

Explanation:

You can save an existing file by using File > Save, pressing Ctrl + S, or clicking the Save icon in the formatting toolbar.

3 / 20

Which toolbar in Excel provides shortcuts to various menu bar options?

A) Status bar

B) Task pan

C) Title bar

D) Toolbar

Explanation:

The toolbar provides shortcuts to various options available in the menu bar, allowing quicker access to these functions.

Explanation:

The toolbar provides shortcuts to various options available in the menu bar, allowing quicker access to these functions.

4 / 20

How do you close an Excel file using the file menu?

A) Go to File > Save

B) Go to File > Close

C) Go to File > Exit

D) Go to File > New

Explanation:

To close a file, you can go to the File menu and select "Close".

Explanation:

To close a file, you can go to the File menu and select "Close".

5 / 20

Which keyboard shortcut is used to save the current spreadsheet in Excel?

A) Ctrl + N

B) Ctrl + O

C) Ctrl + P

D) Ctrl + S

Explanation:

The keyboard shortcut Ctrl + S is used to save the current spreadsheet.

Explanation:

The keyboard shortcut Ctrl + S is used to save the current spreadsheet.

6 / 20

What is the function of the formula bar in Excel?

A) Displays the name of the active cell

B) Displays and edits the contents of the selected cell

C) Shows recently used files

D) Provides help and tips

Explanation:

The formula bar in Excel shows the content of the active cell and allows you to edit the cell's formula or value.

Explanation:

The formula bar in Excel shows the content of the active cell and allows you to edit the cell's formula or value.

7 / 20

What is the first step to create a new spreadsheet using the file menu in Excel?

A) Go to File > Open

B) Go to File > New

C) Go to File > Save

D) Go to File > Exit

Explanation:

To create a new spreadsheet, you start by going to the File menu and selecting "New".

Explanation:

To create a new spreadsheet, you start by going to the File menu and selecting "New".

8 / 20

Which keyboard shortcut can be used to open an existing Excel file?

A) Ctrl + N

B) Ctrl + S

C) Ctrl + O

D) Ctrl + P

Explanation:

The keyboard shortcut Ctrl + O is used to open an existing file in Excel.

Explanation:

The keyboard shortcut Ctrl + O is used to open an existing file in Excel.

9 / 20

What is the function of the "Name Box" in Excel?

A) Shows the active cell name

B) Displays the formula used in the cell

C) Provides a quick help menu

D) Shows recently opened files

Explanation:

The Name Box in Excel shows the name or address of the active cell.

Explanation:

The Name Box in Excel shows the name or address of the active cell.

10 / 20

What is displayed on the status bar in Excel?

A) Name of the workbook

B) Status of the document

C) List of all open workbooks

D) Menu options

Explanation:

The status bar at the bottom of the Excel window shows the status of the document, such as Ready, Enter, or Edit modes.

Explanation:

The status bar at the bottom of the Excel window shows the status of the document, such as Ready, Enter, or Edit modes.

11 / 20

How can you switch between multiple open spreadsheets in Excel?

A) By clicking on File > New

B) By pressing Ctrl + S

C) By clicking on the spreadsheet's name in the taskbar

D) By clicking on File > Save As

Explanation:

To switch between multiple open spreadsheets, you can click on the spreadsheet's name in the taskbar.

Explanation:

To switch between multiple open spreadsheets, you can click on the spreadsheet's name in the taskbar.

12 / 20

Which menu path do you use to exit Microsoft Excel software?

A) File > Save

B) File > Close

C) File > Exit

D) File > New

Explanation:

To exit Microsoft Excel, you go to the File menu and select "Exit".

Explanation:

To exit Microsoft Excel, you go to the File menu and select "Exit".

13 / 20

What option in the file menu is used to save a spreadsheet under a different name?

A) Save

B) Save As

C) Open

D) Close

Explanation:

To save a spreadsheet under a different name, you use the "Save As" option from the file menu.

Explanation:

To save a spreadsheet under a different name, you use the "Save As" option from the file menu.

14 / 20

Which bar in the Excel window shows the document's default name and control buttons (minimize, restore, close)?

A) Menu bar

B) Toolbar

C) Status bar

D) Title bar

Explanation:

The title bar is the most upper bar of the window that shows the document's default name and control buttons.

Explanation:

The title bar is the most upper bar of the window that shows the document's default name and control buttons.

15 / 20

What is the name of the screen that appears when you start Microsoft Excel?

A) Title screen

B) Splash screen

C) Home screen

D) Welcome screen

Explanation:

When you start Microsoft Excel, the first screen that appears for a few seconds is called the splash screen.

Explanation:

When you start Microsoft Excel, the first screen that appears for a few seconds is called the splash screen.

16 / 20

Which menu path opens Microsoft Excel in Windows?

A) Start > All Programs > Microsoft Office > Microsoft Excel2003

B) Start > Microsoft Office > All Programs > Microsoft Excel2003

C) Start > Programs > Microsoft Excel2003

D) Start > Microsoft Office > Excel2003

Explanation:

To open Microsoft Excel, you typically go through the Start menu, then All Programs, followed by Microsoft Office, and finally select Microsoft Excel2003.

Explanation:

To open Microsoft Excel, you typically go through the Start menu, then All Programs, followed by Microsoft Office, and finally select Microsoft Excel2003.

17 / 20

What are the steps to create a Microsoft Excel shortcut on the desktop?

A) Right-click on the desktop and select New > Shortcut

B) Drag the Microsoft Excel icon from the Start menu to the desktop and select 'Copy here'

C) Open Microsoft Excel and save it to the desktop

D) None of the above

Explanation:

To create a shortcut, you drag the Microsoft Excel icon from the Start menu to the desktop and select 'Copy here'.

Explanation:

To create a shortcut, you drag the Microsoft Excel icon from the Start menu to the desktop and select 'Copy here'.

18 / 20

How can you save a spreadsheet under a different name in Excel?

A) File > Save

B) File > Save As

C) Edit > Rename

D) Tools > Options

Explanation:

To save a spreadsheet under a different name, you use the "Save As" option in the File menu.

Explanation:

To save a spreadsheet under a different name, you use the "Save As" option in the File menu.

19 / 20

What is the name of the Excel panel on the right side that contains options such as 'Getting started', 'seek online help', and 'open recently opened files'?

A) Task pan

B) Formula bar

C) Menu bar

D) Status bar

Explanation:

The task pan is the panel on the right side of Excel that provides options for getting started, seeking online help, and opening recently used files.

Explanation:

The task pan is the panel on the right side of Excel that provides options for getting started, seeking online help, and opening recently used files.

20 / 20

How can you switch between different worksheets in an Excel workbook?

A) Using the task pan

B) Using the sheet tabs

C) Using the formula bar

D) Using the title bar

Explanation:

To switch between different worksheets, you use the sheet tabs located at the bottom of the workbook.

Explanation:

To switch between different worksheets, you use the sheet tabs located at the bottom of the workbook.

Your score is

/10

CS-001 | 26

1 / 10

What is the term used for a group of adjacent cells in Excel?

A) Collection

B) Range

C) Cluster

D) Block

Explanation:

A group of adjacent cells in Excel is referred to as a range.

Explanation:

A group of adjacent cells in Excel is referred to as a range.

2 / 10

How do you select an entire row in Excel?

A) Click the cell in the row and press Ctrl + A

B) Click the row number

C) Double click the row number

D) Right-click the row and select Select All

Explanation:

To select an entire row, you click the row number.

Explanation:

To select an entire row, you click the row number.

3 / 10

How can you select a range of adjacent cells in Excel?

A) Click and drag with the mouse

B) Click each cell individually while holding Ctrl

C) Click the first cell, hold Shift, and click the last cell

D) Use the File menu

Explanation:

To select a range of adjacent cells, you click the first cell, hold Shift, and click the last cell.

Explanation:

To select a range of adjacent cells, you click the first cell, hold Shift, and click the last cell.

4 / 10

What type of data can you enter in a spreadsheet?

A) Text only

B) Numbers only

C) Both text and numbers

D) Images only

Explanation:

In a spreadsheet, you can enter both text and numeric data, including alphanumeric data.

Explanation:

In a spreadsheet, you can enter both text and numeric data, including alphanumeric data.

5 / 10

Which keyboard shortcut selects the entire worksheet in Excel?

A) Ctrl + W

B) Ctrl + A

C) Ctrl + S

D) Ctrl + D

Explanation:

The keyboard shortcut Ctrl + A selects the entire worksheet.

Explanation:

The keyboard shortcut Ctrl + A selects the entire worksheet.

6 / 10

What are the steps to change the width of multiple columns in Excel?

A) Click and drag each column header

B) Select the columns, right-click and select Column Width

C) Select the columns and use the Format menu

D) Click the first column header, hold Shift, and click the last column header

Explanation:

To change the width of multiple columns, you can select the columns and use the Format menu.

Explanation:

To change the width of multiple columns, you can select the columns and use the Format menu.

7 / 10

How can you insert a new row in an Excel worksheet?

A) Use the File menu

B) Right-click a row number and select Insert

C) Double click a row number

D) Press Ctrl + R

Explanation:

To insert a new row, right-click the row number and select Insert.

Explanation:

To insert a new row, right-click the row number and select Insert.

8 / 10

Which method allows you to edit data directly in a cell by highlighting the text?

A) Right-click and select edit

B) Double click the cell

C) Press Ctrl + E

D) Use the File menu

Explanation:

Double-clicking a cell highlights the text, allowing you to edit it directly.

Explanation:

Double-clicking a cell highlights the text, allowing you to edit it directly.

9 / 10

What is the purpose of the "Find and Replace" command in Excel?

A) To search for and replace text or numbers

B) To format cells

C) To sort data

D) To create charts

Explanation:

The "Find and Replace" command is used to search for and replace specific text or numbers in the worksheet.

Explanation:

The "Find and Replace" command is used to search for and replace specific text or numbers in the worksheet.

10 / 10

What is the default alignment for text and numeric data in Excel?

A) Left for both

B) Right for both

C) Left for text, right for numeric

D) Right for text, left for numeric

Explanation:

By default, text data is left-aligned, and numeric data is right-aligned in Excel.

Explanation:

By default, text data is left-aligned, and numeric data is right-aligned in Excel.

Your score is

/20

CS-001 | 27

1 / 20

What happens when you apply the "Insert column" option?

A) A blank column is inserted to the left of the active column

B) A blank column is inserted to the right of the active column

C) A blank row is inserted above the active row

D) The entire worksheet is selected

Explanation:

When you apply the "Insert column" option, a blank column is inserted to the left of the active column.

Explanation:

When you apply the "Insert column" option, a blank column is inserted to the left of the active column.

2 / 20

How do you insert a blank column in a worksheet?

A) Use the Delete column option

B) Use the Insert column option

C) Use the Format menu

D) Use the View menu

Explanation:

To insert a blank column, you use the Insert column option.

Explanation:

To insert a blank column, you use the Insert column option.

3 / 20

What does the "Copy" command do in Excel?

A) Moves data to a new location

B) Deletes data from the current location

C) Duplicates data to a new location

D) Formats data

Explanation:

The "Copy" command duplicates data to a new location without removing it from the current location.

Explanation:

The "Copy" command duplicates data to a new location without removing it from the current location.

4 / 20

What is the keyboard shortcut to copy selected data in Excel?

A) Ctrl + X

B) Ctrl + V

C) Ctrl + C

D) Ctrl + A

Explanation:

The keyboard shortcut to copy selected data is Ctrl + C.

Explanation:

The keyboard shortcut to copy selected data is Ctrl + C.

5 / 20

How can you insert a blank row in a worksheet?

A) Use the File menu

B) Use the Edit menu

C) Use the Insert row option

D) Use the Format menu

Explanation:

To insert a blank row, you use the Insert row option.

Explanation:

To insert a blank row, you use the Insert row option.

6 / 20

How can you adjust the standard width of all columns in a new worksheet?

A) Use the Format menu

B) Use the Edit menu

C) Use the Insert menu

D) Use the File menu

Explanation:

The standard width of all columns can be adjusted using the Format menu.

Explanation:

The standard width of all columns can be adjusted using the Format menu.

7 / 20

How do you change the height of multiple rows at once?

A) Select the rows and use the Format menu

B) Use the Insert menu

C) Right-click each row and select Change Height

D) Use the View menu

Explanation:

To change the height of multiple rows, select the rows and use the Format menu.

Explanation:

To change the height of multiple rows, select the rows and use the Format menu.

8 / 20

What does the Ctrl + Z keyboard shortcut do in Excel?

A) Redo the last action

B) Undo the last action

C) Save the worksheet

D) Open a new worksheet

Explanation:

The Ctrl + Z keyboard shortcut is used to undo the last action.

Explanation:

The Ctrl + Z keyboard shortcut is used to undo the last action.

9 / 20

How do you redo a command that was undone?

A) Use the File menu

B) Use the Undo command again

C) Use the Redo command

D) Use the Format menu

Explanation:

To redo a command that was undone, you use the Redo command.

Explanation:

To redo a command that was undone, you use the Redo command.

10 / 20

What is the purpose of the undo command?

A) To apply a previously executed command

B) To reverse the last action taken

C) To save the worksheet

D) To format cells

Explanation:

The undo command is used to reverse the last action taken.

Explanation:

The undo command is used to reverse the last action taken.

11 / 20

What is the process to copy data in Excel?

A) Use the File menu

B) Use the Insert menu

C) Use the Edit < Copy option or press Ctrl+C

D) Use the View menu

Explanation:

To copy data, you can use the Edit < Copy option or press Ctrl+C.

Explanation:

To copy data, you can use the Edit < Copy option or press Ctrl+C.

12 / 20

Which command would you use to quickly reverse an undo action?

A) Ctrl + X

B) Ctrl + Z

C) Ctrl + Y

D) Ctrl + V

Explanation:

The Ctrl + Y keyboard shortcut is used to redo an action that was undone.

Explanation:

The Ctrl + Y keyboard shortcut is used to redo an action that was undone.

13 / 20

What happens to row numbers when you insert a new row?

A) They remain the same

B) They are deleted

C) They are automatically adjusted

D) They become invisible

Explanation:

When a new row is inserted, the row numbers are automatically adjusted.

Explanation:

When a new row is inserted, the row numbers are automatically adjusted.

14 / 20

What is the purpose of the "Find and Replace" feature in Excel?

A) To locate specific data and replace it with new data

B) To insert new rows

C) To format cells

D) To save the worksheet

Explanation:

The "Find and Replace" feature is used to locate specific data and replace it with new data.

Explanation:

The "Find and Replace" feature is used to locate specific data and replace it with new data.

15 / 20

What is the default width of cells in a new spreadsheet called?

A) Standard width

B) Custom width

C) Auto width

D) Fixed width

Explanation:

The default width of cells in a new spreadsheet is called standard width.

Explanation:

The default width of cells in a new spreadsheet is called standard width.

16 / 20

Which option would you use to insert multiple columns at once in Excel?

A) Insert > Multiple Columns

B) Insert > Insert Column

C) Format > Column Width

D) Edit > Insert Column

Explanation:

To insert multiple columns, you use the Insert > Insert Column option and select multiple columns.

Explanation:

To insert multiple columns, you use the Insert > Insert Column option and select multiple columns.

17 / 20

How do you sort data in ascending order in Excel?

A) Use the Insert menu

B) Use the Data menu and select Sort Ascending

C) Use the Format menu

D) Use the Edit menu

Explanation:

To sort data in ascending order, you use the Data menu and select Sort Ascending.

Explanation:

To sort data in ascending order, you use the Data menu and select Sort Ascending.

18 / 20

What command would you use to remove a column from an Excel worksheet?

A) Insert

B) Delete

C) Copy

D) Format

Explanation:

To remove a column, you use the Delete command from the Edit menu.

Explanation:

To remove a column, you use the Delete command from the Edit menu.

19 / 20

How can you delete columns and rows in Excel?

A) Use the File menu

B) Use the Edit menu

C) Use the Insert menu

D) Use the View menu

Explanation:

You can delete columns and rows by using the Edit menu.

Explanation:

You can delete columns and rows by using the Edit menu.

20 / 20

How do you increase the width of a column in Excel?

A) Use the File menu

B) Drag the border of the column header

C) Use the View menu

D) Use the Redo command

Explanation:

To increase the width of a column, you drag the border of the column header.

Explanation:

To increase the width of a column, you drag the border of the column header.

Your score is

/20

CS-001 | 28

1 / 20

How can you select multiple columns using the keyboard in Excel?

A) Ctrl + Click each column header

B) Shift + Click each column header

C) Alt + Click each column header

D) Ctrl + Shift + Click each column header

Explanation:

To select multiple columns using the keyboard, you hold the Shift key and click each column header.

Explanation:

To select multiple columns using the keyboard, you hold the Shift key and click each column header.

2 / 20

How do you sort data in ascending order in Excel?

A) Data > Sort Ascending

B) File > Sort Ascending

C) Edit > Sort Ascending

D) Insert > Sort Ascending

Explanation:

To sort data in ascending order, you use Data > Sort Ascending.

Explanation:

To sort data in ascending order, you use Data > Sort Ascending.

3 / 20

What command allows you to move data from one location to another in Excel?

A) Copy and Paste

B) Cut and Paste

C) Insert and Delete

D) Format and Align

Explanation:

The Cut and Paste commands are used to move data from one location to another.

Explanation:

The Cut and Paste commands are used to move data from one location to another.

4 / 20

What is the keyboard shortcut to paste copied data in Excel?

A) Ctrl + X

B) Ctrl + V

C) Ctrl + C

D) Ctrl + Z

Explanation:

The keyboard shortcut to paste copied data is Ctrl + V.

Explanation:

The keyboard shortcut to paste copied data is Ctrl + V.

5 / 20

What type of data does the Auto fill tool generate in series?

A) Only text data

B) Only numeric data

C) Dates, numbers, and other types

D) Only special characters

Explanation:

The Auto fill tool can generate a series of dates, numbers, and other types of data.

Explanation:

The Auto fill tool can generate a series of dates, numbers, and other types of data.

6 / 20

What keyboard shortcut can you use to copy selected data in Excel?

A) Ctrl + X

B) Ctrl + V

C) Ctrl + C

D) Ctrl + Z

Explanation:

To copy selected data, you use the keyboard shortcut Ctrl + C.

Explanation:

To copy selected data, you use the keyboard shortcut Ctrl + C.

7 / 20

What is the keyboard shortcut to cut selected data in Excel?

A) Ctrl + C

B) Ctrl + V

C) Ctrl + X

D) Ctrl + Z

Explanation:

The keyboard shortcut to cut selected data is Ctrl + X.

Explanation:

The keyboard shortcut to cut selected data is Ctrl + X.

8 / 20

What does the Sort command do in Excel?

A) Deletes data

B) Copies data

C) Arranges data in a specific order

D) Formats data

Explanation:

The Sort command arranges data in a specific order, either alphabetically or numerically.

Explanation:

The Sort command arranges data in a specific order, either alphabetically or numerically.

9 / 20

Which command allows you to search for and correct misspelled entries in Excel?

A) Find

B) Sort

C) Replace

D) Filter

Explanation:

The Replace command allows you to search for and correct misspelled entries.

Explanation:

The Replace command allows you to search for and correct misspelled entries.

10 / 20

Which command allows you to reapply an action that was undone in Excel?

A) Redo

B) Undo

C) Copy

D) Paste

Explanation:

The Redo command allows you to reapply an action that was undone.

Explanation:

The Redo command allows you to reapply an action that was undone.

11 / 20

How can you replace a value in an Excel worksheet?

A) Use the Find command

B) Use the Replace command

C) Use the Insert command

D) Use the Sort command

Explanation:

To replace a value, you use the Replace command.

Explanation:

To replace a value, you use the Replace command.

12 / 20

How do you generate a series of dates with the Auto fill tool in Excel?

A) Use the Replace command

B) Use the Find command

C) Use the Series option in the Fill menu

D) Use the Sort command

Explanation:

To generate a series of dates, you use the Series option in the Fill menu.

Explanation:

To generate a series of dates, you use the Series option in the Fill menu.

13 / 20

How can you paste data in Excel after cutting it?

A) Press Ctrl + Z

B) Press Ctrl + X

C) Press Ctrl + C

D) Press Ctrl + V

Explanation:

To paste data after cutting it, you press Ctrl + V.

Explanation:

To paste data after cutting it, you press Ctrl + V.

14 / 20

Which command is used to search for a specific value in an Excel worksheet?

A) Insert

B) Replace

C) Find

D) Sort

Explanation:

The Find command is used to search for a specific value in a worksheet.

Explanation:

The Find command is used to search for a specific value in a worksheet.

15 / 20

What is the default alignment for numeric data in Excel?

A) Left

B) Right

C) Center

D) Justify

Explanation:

By default, numeric data is aligned to the right in Excel.

Explanation:

By default, numeric data is aligned to the right in Excel.

16 / 20

How do you sort data alphabetically in Excel?

A) Data > Sort Descending

B) Data > Filter

C) Data > Sort A to Z

D) Data > Sort Z to A

Explanation:

To sort data alphabetically, you use Data > Sort A to Z.

Explanation:

To sort data alphabetically, you use Data > Sort A to Z.

17 / 20

What is the default alignment for text data in Excel?

A) Left

B) Right

C) Center

D) Justify

Explanation:

By default, text data is aligned to the left in Excel.

Explanation:

By default, text data is aligned to the left in Excel.

18 / 20

How can you cut data in Excel?

A) Select data and press Ctrl + C

B) Select data and press Ctrl + X

C) Select data and press Ctrl + V

D) Select data and press Ctrl + Z

Explanation:

To cut data, you select the data and press Ctrl + X.

Explanation:

To cut data, you select the data and press Ctrl + X.

19 / 20

Which command allows you to reverse the last action taken in Excel?

A) Redo

B) Undo

C) Copy

D) Paste

Explanation:

The Undo command allows you to reverse the last action taken.

Explanation:

The Undo command allows you to reverse the last action taken.

20 / 20

What tool can you use to copy data in any direction in Excel?

A) Cut tool

B) Auto fill tool

C) Format tool

D) Insert tool

Explanation:

The Auto fill tool allows you to copy data in any direction.

Explanation:

The Auto fill tool allows you to copy data in any direction.

Your score is

/20

CS-001 | 29

1 / 20

How can you move a worksheet in Excel?

A) Select the worksheet and drag it to the new location

B) Right-click the worksheet tab and select Move

C) Go to Edit > Move or Copy Sheet and select Move

D) All of the above

Explanation:

You can move a worksheet by selecting it and dragging it to the new location, right-clicking the worksheet tab and selecting Move, or using the Edit menu.

Explanation:

You can move a worksheet by selecting it and dragging it to the new location, right-clicking the worksheet tab and selecting Move, or using the Edit menu.

2 / 20

Which menu path would you follow to move a worksheet in Excel?

A) File > Move Sheet

B) Edit > Move or Copy Sheet

C) Insert > Move Sheet

D) View > Move Sheet

Explanation:

To move a worksheet, go to Edit > Move or Copy Sheet.

Explanation:

To move a worksheet, go to Edit > Move or Copy Sheet.

3 / 20

How do you rename a worksheet in Excel?

A) Right-click the worksheet tab and select Rename

B) Double-click the worksheet tab and type the new name

C) Go to Format > Sheet > Rename

D) All of the above

Explanation:

You can rename a worksheet by right-clicking the worksheet tab and selecting Rename, double-clicking the worksheet tab and typing the new name, or using the Format menu.

Explanation:

You can rename a worksheet by right-clicking the worksheet tab and selecting Rename, double-clicking the worksheet tab and typing the new name, or using the Format menu.

4 / 20

What is the keyboard shortcut to insert a new worksheet in Excel?

A) Alt + Shift + F1

B) Ctrl + Shift + F1

C) Ctrl + N

D) Ctrl + M

Explanation:

The keyboard shortcut to insert a new worksheet is Alt + Shift + F1.

Explanation:

The keyboard shortcut to insert a new worksheet is Alt + Shift + F1.

5 / 20

What indicates that a worksheet is selected in Excel?

A) The tab is highlighted in a different color

B) The tab is underlined

C) The tab appears in bold

D) The tab blinks

Explanation:

When a worksheet is selected, its tab appears in bold.

Explanation:

When a worksheet is selected, its tab appears in bold.

6 / 20

How do you insert a new worksheet in Excel?

A) Go to File > Insert > Worksheet

B) Go to Edit > Insert > Worksheet

C) Go to Insert > Worksheet

D) Go to View > Insert > Worksheet

Explanation:

To insert a new worksheet, go to Insert > Worksheet.

Explanation:

To insert a new worksheet, go to Insert > Worksheet.

7 / 20

How do you select non-contiguous worksheets in Excel?

A) Click the first sheet tab, hold Ctrl, and click additional sheet tabs

B) Click the first sheet tab, hold Shift, and click the last sheet tab

C) Click each sheet tab while holding Alt

D) Right-click each sheet tab

Explanation:

To select non-contiguous worksheets, click the first sheet tab, hold Ctrl, and click additional sheet tabs.

Explanation:

To select non-contiguous worksheets, click the first sheet tab, hold Ctrl, and click additional sheet tabs.

8 / 20

What action cannot be undone in Excel?

A) Renaming a worksheet

B) Moving a worksheet

C) Deleting a worksheet

D) Changing the tab color of a worksheet

Explanation:

Deleting a worksheet cannot be undone in Excel.

Explanation:

Deleting a worksheet cannot be undone in Excel.

9 / 20

How do you change the tab color of a worksheet in Excel?

A) Right-click the worksheet tab and select Tab Color

B) Go to Format > Sheet > Tab Color

C) Double-click the worksheet tab and select Tab Color

D) Both A and B

Explanation:

You can change the tab color by right-clicking the worksheet tab and selecting Tab Color, or by using the Format menu.

Explanation:

You can change the tab color by right-clicking the worksheet tab and selecting Tab Color, or by using the Format menu.

10 / 20

How do you duplicate a worksheet in Excel?

A) Select the worksheet and press Ctrl + D

B) Select the worksheet, go to Edit > Move or Copy Sheet, and select Copy

C) Right-click the worksheet tab and select Duplicate

D) Go to File > Duplicate Sheet

Explanation:

To duplicate a worksheet, select the worksheet, go to Edit > Move or Copy Sheet, and select Copy.

Explanation:

To duplicate a worksheet, select the worksheet, go to Edit > Move or Copy Sheet, and select Copy.

11 / 20

What is the default number of worksheets in a new Excel workbook?

A) One

B) Two

C) Three

D) Four

Explanation:

By default, a new Excel workbook contains three worksheets named sheet1, sheet2, and sheet3.

Explanation:

By default, a new Excel workbook contains three worksheets named sheet1, sheet2, and sheet3.

12 / 20

How can you select multiple worksheets at the same time in Excel?

A) Click each worksheet tab while holding the Ctrl key

B) Click each worksheet tab while holding the Shift key

C) Double-click each worksheet tab

D) Right-click each worksheet tab

Explanation:

To select multiple worksheets, click one worksheet tab, then hold the Shift key and click another worksheet tab.

Explanation:

To select multiple worksheets, click one worksheet tab, then hold the Shift key and click another worksheet tab.

13 / 20

What is the purpose of the Move or Copy Sheet command?

A) To delete a worksheet

B) To insert a new worksheet

C) To move or duplicate a worksheet

D) To rename a worksheet

Explanation:

The Move or Copy Sheet command is used to move or duplicate a worksheet.

Explanation:

The Move or Copy Sheet command is used to move or duplicate a worksheet.

14 / 20

What is the maximum number of characters allowed in a worksheet name?

A) 15

B) 21

C) 31

D) 41

Explanation:

The maximum number of characters allowed in a worksheet name is 31.

Explanation:

The maximum number of characters allowed in a worksheet name is 31.

15 / 20

Which characters are not allowed in a worksheet name?

A) Numbers

B) Letters

C) Spaces

D) Special characters

Explanation:

Special characters are not allowed in worksheet names.

Explanation:

Special characters are not allowed in worksheet names.

16 / 20

What happens when you delete a worksheet in Excel?

A) It is moved to the Recycle Bin

B) It is permanently deleted and cannot be undone

C) It is archived

D) It is hidden

Explanation:

When you delete a worksheet, it is permanently deleted and this action cannot be undone.

Explanation:

When you delete a worksheet, it is permanently deleted and this action cannot be undone.

17 / 20

How do you deselect multiple worksheets in Excel?

A) Click each sheet tab while holding the Ctrl key

B) Click each sheet tab while holding the Shift key

C) Click on a sheet tab that is not selected

D) Right-click and select Deselect

Explanation:

To deselect multiple worksheets, click on a sheet tab that is not selected.

Explanation:

To deselect multiple worksheets, click on a sheet tab that is not selected.

18 / 20

How do you insert multiple worksheets at once in Excel?

A) Select the number of sheets you want to insert and press Ctrl + N

B) Select the number of sheets, go to Insert > Worksheet

C) Select the number of sheets, go to Edit > Insert > Worksheet

D) Select the number of sheets, right-click and select Insert

Explanation:

To insert multiple worksheets at once, select the number of sheets and go to Insert > Worksheet.

Explanation:

To insert multiple worksheets at once, select the number of sheets and go to Insert > Worksheet.

19 / 20

How can you delete a worksheet in Excel?

A) Select the worksheet and press Delete on the keyboard

B) Right-click the worksheet tab and select Delete

C) Go to Edit > Delete Sheet

D) Both B and C

Explanation:

You can delete a worksheet by right-clicking the worksheet tab and selecting Delete, or by going to Edit > Delete Sheet.

Explanation:

You can delete a worksheet by right-clicking the worksheet tab and selecting Delete, or by going to Edit > Delete Sheet.

20 / 20

Which action can be performed by right-clicking a worksheet tab?

A) Renaming the worksheet

B) Deleting the worksheet

C) Changing the tab color

D) All of the above

Explanation:

Right-clicking a worksheet tab allows you to rename, delete, or change the tab color of the worksheet.

Explanation:

Right-clicking a worksheet tab allows you to rename, delete, or change the tab color of the worksheet.

Your score is

/20

CS-001 | 30

1 / 20

What type of error is displayed when a function or cell address is misspelled in Excel?

A) #DIV/0!

B) #NAME?

C) #NULL!

D) #VALUE!

Explanation:

The #NAME? error is displayed when a function or cell address is misspelled.

Explanation:

The #NAME? error is displayed when a function or cell address is misspelled.

2 / 20

How do you use the AutoSum feature in Excel?

A) Select cells and press Ctrl + S

B) Select cells and click the AutoSum button on the toolbar

C) Select cells and press Ctrl + A

D) Select cells and click the Insert button

Explanation:

The AutoSum feature is used by selecting the cells and clicking the AutoSum button on the toolbar.

Explanation:

The AutoSum feature is used by selecting the cells and clicking the AutoSum button on the toolbar.

3 / 20

How do you make a cell reference mixed in Excel?

A) $A$1

B) A1

C) $A1 or A$1

D) A$1$ or $A1$

Explanation:

Mixed cell referencing involves fixing either the row or the column, like $A1 or A$1.

Explanation:

Mixed cell referencing involves fixing either the row or the column, like $A1 or A$1.

4 / 20

What does the #NULL! error indicate in an Excel formula?

A) Misspelled function or cell address

B) Division by zero

C) Spaces between values in a function

D) Wrong data type in a formula

Explanation:

The #NULL! error indicates that there are spaces between values in a function, which is not allowed.

Explanation:

The #NULL! error indicates that there are spaces between values in a function, which is not allowed.

5 / 20

Which error code appears when the wrong data type is used in a formula?

A) #DIV/0!

B) #NAME?

C) #NULL!

D) #VALUE!

Explanation:

The #VALUE! error appears when the wrong data type is used in a formula.

Explanation:

The #VALUE! error appears when the wrong data type is used in a formula.

6 / 20

What function is used to count the number of cells that contain numbers?

A) SUM

B) COUNT

C) AVERAGE

D) MAX

Explanation:

The COUNT function counts the number of cells that contain numeric values.

Explanation:

The COUNT function counts the number of cells that contain numeric values.

7 / 20

What is the format of a function in Excel?

A) =FunctionName(Arguments)

B) FunctionName=Arguments

C) FunctionName(Arguments)=

D) =Arguments(FunctionName)

Explanation:

The format of a function in Excel is =FunctionName(Arguments).

Explanation:

The format of a function in Excel is =FunctionName(Arguments).

8 / 20

What error code appears when a formula tries to divide by zero?

A) #DIV/0!

B) #NAME?

C) #NULL!

D) #VALUE!

Explanation:

The #DIV/0! error appears when a formula attempts to divide by zero.

Explanation:

The #DIV/0! error appears when a formula attempts to divide by zero.

9 / 20

Which function calculates the average of a range of values in Excel?

A) SUM

B) COUNT

C) AVERAGE

D) MAX

Explanation:

The AVERAGE function calculates the average of a range of values.

Explanation:

The AVERAGE function calculates the average of a range of values.

10 / 20

How can you create a formula that multiplies the sum of A1 and B1 by 2?

A) =A1+B1*2

B) =(A1+B1)*2

C) =A1*B1+2

D) =SUM(A1+B1)*2

Explanation:

To multiply the sum of A1 and B1 by 2, you use the formula =(A1+B1)*2.

Explanation:

To multiply the sum of A1 and B1 by 2, you use the formula =(A1+B1)*2.

11 / 20

How do you reference a cell relatively in Excel?

A) $A$1

B) A1

C) $A1

D) A$1

Explanation:

Relative cell referencing is done by simply using the cell address without dollar signs, like A1.

Explanation:

Relative cell referencing is done by simply using the cell address without dollar signs, like A1.

12 / 20

What does the COUNT function do in Excel?

A) Adds values

B) Averages values

C) Counts the number of cells that contain numbers

D) Finds the maximum value

Explanation:

The COUNT function counts the number of cells that contain numeric values.

Explanation:

The COUNT function counts the number of cells that contain numeric values.

13 / 20

Which operator has the highest precedence in Excel formulas?

A) Addition (+)

B) Multiplication (*)

C) Parentheses (())

D) Exponentiation (^)

Explanation:

Parentheses have the highest precedence in Excel formulas, allowing certain calculations to be performed first.

Explanation:

Parentheses have the highest precedence in Excel formulas, allowing certain calculations to be performed first.

14 / 20

What is the purpose of the SUM function in Excel?

A) To find the average of values

B) To count cells with numbers

C) To add a range of values

D) To find the maximum value

Explanation:

The SUM function adds a range of values.

Explanation:

The SUM function adds a range of values.

15 / 20

What does the IF function do in Excel?

A) Performs mathematical calculations

B) Compares values and returns results based on a condition

C) Sorts data in ascending order

D) Filters data

Explanation:

The IF function compares values and returns results based on a specified condition.

Explanation:

The IF function compares values and returns results based on a specified condition.

16 / 20

What does a formula in Excel contain?

A) Text and numbers only

B) Numbers, cell addresses, and operators

C) Only numbers

D) Only operators

Explanation:

A formula in Excel contains numbers, cell addresses, and operators to perform calculations.

Explanation:

A formula in Excel contains numbers, cell addresses, and operators to perform calculations.

17 / 20

How do you insert a function in Excel?

A) Go to File > Insert

B) Go to Edit > Function

C) Go to Insert > Function

D) Go to Data > Function

Explanation:

To insert a function, you go to Insert > Function, which opens a dialogue box to choose the function.

Explanation:

To insert a function, you go to Insert > Function, which opens a dialogue box to choose the function.

18 / 20

Which operator is used for exponentiation in Excel?

A) *

B) /

C) ^

D) +

Explanation:

The ^ operator is used for exponentiation in Excel formulas.

Explanation:

The ^ operator is used for exponentiation in Excel formulas.

19 / 20

Which of the following is an example of absolute cell referencing?

A) A1+B1

B) $A$1+$B$1

C) A$1+B$1

D) $A1+B1

Explanation:

Absolute cell referencing uses dollar signs to fix the cell addresses, like $A$1+$B$1.

Explanation:

Absolute cell referencing uses dollar signs to fix the cell addresses, like $A$1+$B$1.

20 / 20

What does the IF function return if the condition is true?

A) The value if false

B) The value if true

C) An error

D) A warning

Explanation:

The IF function returns the value specified for the true condition.

Explanation:

The IF function returns the value specified for the true condition.

Your score is

/20

CS-001 | 31

1 / 20

Which tab in the Format Cells dialog box allows you to add a border to a cell or cell range?

A) Alignment tab

B) Font tab

C) Number tab

D) Border tab

Explanation:

The Border tab in the Format Cells dialog box allows you to add a border to a cell or cell range.

Explanation:

The Border tab in the Format Cells dialog box allows you to add a border to a cell or cell range.

2 / 20

How can you hide a column in Excel?

A) Right-click the column header and select Hide

B) Format > Cells > Hide Column

C) Data > Hide Column

D) Insert > Hide Column

Explanation:

To hide a column, you right-click the column header and select Hide.

Explanation:

To hide a column, you right-click the column header and select Hide.

3 / 20

What command would you use to display text in multiple lines within a single cell?

A) Merge Cells

B) Text Wrap

C) Text Align

D) Insert Line Break

Explanation:

The Text Wrap command is used to display text in multiple lines within a single cell.

Explanation:

The Text Wrap command is used to display text in multiple lines within a single cell.

4 / 20

What command would you use to apply a specific pattern to cell backgrounds?

A) Format > Cells > Number tab

B) Format > Cells > Font tab

C) Format > Cells > Pattern tab

D) Format > Cells > Border tab

Explanation:

To apply a specific pattern to cell backgrounds, you use the Pattern tab in the Format Cells dialog box.

Explanation:

To apply a specific pattern to cell backgrounds, you use the Pattern tab in the Format Cells dialog box.

5 / 20

How can you automatically format a range of cells using predefined styles in Excel?

A) Format > Cells > Number tab

B) Format > AutoFormat

C) Data > AutoFormat

D) Insert > AutoFormat

Explanation:

To automatically format a range of cells using predefined styles, you use the Format > AutoFormat option.

Explanation:

To automatically format a range of cells using predefined styles, you use the Format > AutoFormat option.

6 / 20

Which feature in Excel allows you to change the orientation of cell contents?

A) Text Wrap

B) Merge Cells

C) Cell Orientation

D) Conditional Formatting

Explanation:

The Cell Orientation feature allows you to change the direction of cell contents.

Explanation:

The Cell Orientation feature allows you to change the direction of cell contents.

7 / 20

How can you apply number formatting to a range of cells in Excel?

A) Select the range and use Insert menu

B) Select the range and use Format > Cells

C) Select the range and press Ctrl + S

D) Select the range and use Data menu

Explanation:

To apply number formatting, you select the range and use Format > Cells.

Explanation:

To apply number formatting, you select the range and use Format > Cells.

8 / 20

How can you change the font of cell contents in Excel?

A) Format > Cells > Alignment tab

B) Format > Cells > Border tab

C) Format > Cells > Font tab

D) Format > Cells > Number tab

Explanation:

To change the font of cell contents, you go to Format > Cells and select the Font tab.

Explanation:

To change the font of cell contents, you go to Format > Cells and select the Font tab.

9 / 20

What happens to a number when you apply percent format in Excel?

A) It is divided by 100 and the percent symbol is shown

B) It is multiplied by 100 and the percent symbol is shown

C) It remains the same

D) It is converted to text

Explanation:

When you apply percent format, the number is multiplied by 100 and the percent symbol is shown.

Explanation:

When you apply percent format, the number is multiplied by 100 and the percent symbol is shown.

10 / 20

How can you change the foreground color of cell contents in Excel?

A) Format > Cells > Number tab

B) Format > Cells > Font tab > Color

C) Format > Cells > Alignment tab

D) Format > Cells > Border tab

Explanation:

To change the foreground color, you go to Format > Cells, then select the Font tab and choose Color.

Explanation:

To change the foreground color, you go to Format > Cells, then select the Font tab and choose Color.

11 / 20

How can you apply conditional formatting in Excel?

A) Format > Cells > Number tab

B) Format > Conditional Formatting

C) Data > Conditional Formatting

D) Insert > Conditional Formatting

Explanation:

To apply conditional formatting, you use the Format menu and select Conditional Formatting.

Explanation:

To apply conditional formatting, you use the Format menu and select Conditional Formatting.

12 / 20

What does formatting mean in the context of an Excel worksheet?

A) Changing data types

B) Improving the appearance and layout of data

C) Deleting data

D) Inserting formulas

Explanation:

Formatting in Excel refers to changing and improving the appearance and layout of data to make it more readable and visually appealing.

Explanation:

Formatting in Excel refers to changing and improving the appearance and layout of data to make it more readable and visually appealing.

13 / 20

What feature allows you to copy formatting from one cell to another in Excel?

A) Copy and Paste

B) Format Painter

C) Auto Fill

D) Text Wrap

Explanation:

The Format Painter feature allows you to copy formatting from one cell to another.

Explanation:

The Format Painter feature allows you to copy formatting from one cell to another.

14 / 20

Which menu option would you use to freeze panes in Excel?

A) Format menu

B) Data menu

C) View menu

D) Window menu

Explanation:

To freeze panes, you use the Window menu in Excel.

Explanation:

To freeze panes, you use the Window menu in Excel.

15 / 20

How do you apply a date format to a cell in Excel?

A) Format > Cells > Font tab > Date

B) Format > Cells > Number tab > Date

C) Format > Cells > Alignment tab > Date

D) Format > Cells > Border tab > Date

Explanation:

To apply a date format to a cell, you use Format > Cells, then select the Number tab and choose Date.

Explanation:

To apply a date format to a cell, you use Format > Cells, then select the Number tab and choose Date.

16 / 20

How can you apply currency format to a number in Excel?

A) Format > Cells > Number tab > Currency

B) Format > Cells > Font tab > Currency

C) Format > Cells > Alignment tab > Currency

D) Format > Cells > Border tab > Currency

Explanation:

To apply currency format, you go to Format > Cells, then select the Number tab and choose Currency.

Explanation:

To apply currency format, you go to Format > Cells, then select the Number tab and choose Currency.

17 / 20

What is the default font style and size in Excel?

A) Times New Roman, 12

B) Arial, 10

C) Verdana, 16

D) Calibri, 11

Explanation:

The default font style in Excel is Arial and the size is 10.

Explanation:

The default font style in Excel is Arial and the size is 10.

18 / 20

How can you align cell contents to the center in Excel?

A) Format > Cells > Number tab

B) Format > Cells > Font tab

C) Format > Cells > Alignment tab > Horizontal > Center

D) Format > Cells > Border tab

Explanation:

To align cell contents to the center, you go to Format > Cells, select the Alignment tab, and choose Center from the Horizontal options.

Explanation:

To align cell contents to the center, you go to Format > Cells, select the Alignment tab, and choose Center from the Horizontal options.

19 / 20

Which tab in the Format Cells dialog box allows you to change the number format?

A) Alignment tab

B) Font tab

C) Number tab

D) Border tab

Explanation:

The Number tab in the Format Cells dialog box allows you to change the number format.

Explanation:

The Number tab in the Format Cells dialog box allows you to change the number format.

20 / 20

How can you center a title over a cell range in Excel?

A) Format > Cells > Font tab > Center

B) Format > Cells > Alignment tab > Merge Cells

C) Format > Cells > Number tab > Center

D) Format > Cells > Border tab > Center

Explanation:

To center a title over a cell range, you use the Merge Cells option in the Alignment tab of the Format Cells dialog box.

Explanation:

To center a title over a cell range, you use the Merge Cells option in the Alignment tab of the Format Cells dialog box.

Your score is

/20

CS-001 | 32

1 / 20

Which menu option would you use to freeze panes in Excel?

A) Format menu

B) Data menu

C) View menu

D) Window menu

Explanation:

To freeze panes, you use the Window menu in Excel.

Explanation:

To freeze panes, you use the Window menu in Excel.

2 / 20

What command would you use to display text in multiple lines within a single cell?

A) Merge Cells

B) Text Wrap

C) Text Align

D) Insert Line Break

Explanation:

The Text Wrap command is used to display text in multiple lines within a single cell.

Explanation:

The Text Wrap command is used to display text in multiple lines within a single cell.

3 / 20

How can you align cell contents to the center in Excel?

A) Format > Cells > Number tab

B) Format > Cells > Font tab

C) Format > Cells > Alignment tab > Horizontal > Center

D) Format > Cells > Border tab

Explanation:

To align cell contents to the center, you go to Format > Cells, select the Alignment tab, and choose Center from the Horizontal options.

Explanation:

To align cell contents to the center, you go to Format > Cells, select the Alignment tab, and choose Center from the Horizontal options.

4 / 20

How can you apply currency format to a number in Excel?

A) Format > Cells > Number tab > Currency

B) Format > Cells > Font tab > Currency

C) Format > Cells > Alignment tab > Currency

D) Format > Cells > Border tab > Currency

Explanation:

To apply currency format, you go to Format > Cells, then select the Number tab and choose Currency.

Explanation:

To apply currency format, you go to Format > Cells, then select the Number tab and choose Currency.

5 / 20

What command would you use to apply a specific pattern to cell backgrounds?

A) Format > Cells > Number tab

B) Format > Cells > Font tab

C) Format > Cells > Pattern tab

D) Format > Cells > Border tab

Explanation:

To apply a specific pattern to cell backgrounds, you use the Pattern tab in the Format Cells dialog box.

Explanation:

To apply a specific pattern to cell backgrounds, you use the Pattern tab in the Format Cells dialog box.

6 / 20

How can you automatically format a range of cells using predefined styles in Excel?

A) Format > Cells > Number tab

B) Format > AutoFormat

C) Data > AutoFormat

D) Insert > AutoFormat

Explanation:

To automatically format a range of cells using predefined styles, you use the Format > AutoFormat option.

Explanation:

To automatically format a range of cells using predefined styles, you use the Format > AutoFormat option.

7 / 20

Which feature in Excel allows you to change the orientation of cell contents?

A) Text Wrap

B) Merge Cells

C) Cell Orientation

D) Conditional Formatting

Explanation:

The Cell Orientation feature allows you to change the direction of cell contents.

Explanation:

The Cell Orientation feature allows you to change the direction of cell contents.

8 / 20

What feature allows you to copy formatting from one cell to another in Excel?

A) Copy and Paste

B) Format Painter

C) Auto Fill

D) Text Wrap

Explanation:

The Format Painter feature allows you to copy formatting from one cell to another.

Explanation:

The Format Painter feature allows you to copy formatting from one cell to another.

9 / 20

What does formatting mean in the context of an Excel worksheet?

A) Changing data types

B) Improving the appearance and layout of data

C) Deleting data

D) Inserting formulas

Explanation:

Formatting in Excel refers to changing and improving the appearance and layout of data to make it more readable and visually appealing.

Explanation:

Formatting in Excel refers to changing and improving the appearance and layout of data to make it more readable and visually appealing.

10 / 20

How can you apply number formatting to a range of cells in Excel?

A) Select the range and use Insert menu

B) Select the range and use Format > Cells

C) Select the range and press Ctrl + S

D) Select the range and use Data menu

Explanation:

To apply number formatting, you select the range and use Format > Cells.

Explanation:

To apply number formatting, you select the range and use Format > Cells.

11 / 20

What is the default font style and size in Excel?

A) Times New Roman, 12

B) Arial, 10

C) Verdana, 16

D) Calibri, 11

Explanation:

The default font style in Excel is Arial and the size is 10.

Explanation:

The default font style in Excel is Arial and the size is 10.

12 / 20

How can you center a title over a cell range in Excel?

A) Format > Cells > Font tab > Center

B) Format > Cells > Alignment tab > Merge Cells

C) Format > Cells > Number tab > Center

D) Format > Cells > Border tab > Center

Explanation:

To center a title over a cell range, you use the Merge Cells option in the Alignment tab of the Format Cells dialog box.

Explanation:

To center a title over a cell range, you use the Merge Cells option in the Alignment tab of the Format Cells dialog box.

13 / 20

How can you change the foreground color of cell contents in Excel?

A) Format > Cells > Number tab

B) Format > Cells > Font tab > Color

C) Format > Cells > Alignment tab

D) Format > Cells > Border tab

Explanation:

To change the foreground color, you go to Format > Cells, then select the Font tab and choose Color.

Explanation:

To change the foreground color, you go to Format > Cells, then select the Font tab and choose Color.

14 / 20

How do you apply a date format to a cell in Excel?

A) Format > Cells > Font tab > Date

B) Format > Cells > Number tab > Date

C) Format > Cells > Alignment tab > Date

D) Format > Cells > Border tab > Date

Explanation:

To apply a date format to a cell, you use Format > Cells, then select the Number tab and choose Date.

Explanation:

To apply a date format to a cell, you use Format > Cells, then select the Number tab and choose Date.

15 / 20

How can you change the font of cell contents in Excel?

A) Format > Cells > Alignment tab

B) Format > Cells > Border tab

C) Format > Cells > Font tab

D) Format > Cells > Number tab

Explanation:

To change the font of cell contents, you go to Format > Cells and select the Font tab.

Explanation:

To change the font of cell contents, you go to Format > Cells and select the Font tab.

16 / 20

How can you hide a column in Excel?

A) Right-click the column header and select Hide

B) Format > Cells > Hide Column

C) Data > Hide Column

D) Insert > Hide Column

Explanation:

To hide a column, you right-click the column header and select Hide.

Explanation:

To hide a column, you right-click the column header and select Hide.

17 / 20

What happens to a number when you apply percent format in Excel?

A) It is divided by 100 and the percent symbol is shown

B) It is multiplied by 100 and the percent symbol is shown

C) It remains the same

D) It is converted to text

Explanation:

When you apply percent format, the number is multiplied by 100 and the percent symbol is shown.

Explanation:

When you apply percent format, the number is multiplied by 100 and the percent symbol is shown.

18 / 20

How can you apply conditional formatting in Excel?

A) Format > Cells > Number tab

B) Format > Conditional Formatting

C) Data > Conditional Formatting

D) Insert > Conditional Formatting

Explanation:

To apply conditional formatting, you use the Format menu and select Conditional Formatting.

Explanation:

To apply conditional formatting, you use the Format menu and select Conditional Formatting.

19 / 20

Which tab in the Format Cells dialog box allows you to add a border to a cell or cell range?

A) Alignment tab

B) Font tab

C) Number tab

D) Border tab

Explanation:

The Border tab in the Format Cells dialog box allows you to add a border to a cell or cell range.

Explanation:

The Border tab in the Format Cells dialog box allows you to add a border to a cell or cell range.

20 / 20

Which tab in the Format Cells dialog box allows you to change the number format?

A) Alignment tab

B) Font tab

C) Number tab

D) Border tab

Explanation:

The Number tab in the Format Cells dialog box allows you to change the number format.

Explanation:

The Number tab in the Format Cells dialog box allows you to change the number format.

Your score is

/20

CS-001 | 33

1 / 20

What is the default font style and size in Excel?

A) Times New Roman, 12

B) Arial, 10

C) Verdana, 16

D) Calibri, 11

Explanation:

The default font style in Excel is Arial and the size is 10.

Explanation:

The default font style in Excel is Arial and the size is 10.

2 / 20

How can you apply conditional formatting in Excel?

A) Format > Cells > Number tab

B) Format > Conditional Formatting

C) Data > Conditional Formatting

D) Insert > Conditional Formatting

Explanation:

To apply conditional formatting, you use the Format menu and select Conditional Formatting.

Explanation:

To apply conditional formatting, you use the Format menu and select Conditional Formatting.

3 / 20

How can you hide a column in Excel?

A) Right-click the column header and select Hide

B) Format > Cells > Hide Column

C) Data > Hide Column

D) Insert > Hide Column

Explanation:

To hide a column, you right-click the column header and select Hide.

Explanation:

To hide a column, you right-click the column header and select Hide.

4 / 20

Which tab in the Format Cells dialog box allows you to change the number format?

A) Alignment tab

B) Font tab

C) Number tab

D) Border tab

Explanation:

The Number tab in the Format Cells dialog box allows you to change the number format.

Explanation:

The Number tab in the Format Cells dialog box allows you to change the number format.

5 / 20

What command would you use to apply a specific pattern to cell backgrounds?

A) Format > Cells > Number tab

B) Format > Cells > Font tab

C) Format > Cells > Pattern tab

D) Format > Cells > Border tab

Explanation:

To apply a specific pattern to cell backgrounds, you use the Pattern tab in the Format Cells dialog box.

Explanation:

To apply a specific pattern to cell backgrounds, you use the Pattern tab in the Format Cells dialog box.

6 / 20

Which tab in the Format Cells dialog box allows you to add a border to a cell or cell range?

A) Alignment tab

B) Font tab

C) Number tab

D) Border tab

Explanation:

The Border tab in the Format Cells dialog box allows you to add a border to a cell or cell range.

Explanation:

The Border tab in the Format Cells dialog box allows you to add a border to a cell or cell range.

7 / 20

How do you apply a date format to a cell in Excel?

A) Format > Cells > Font tab > Date

B) Format > Cells > Number tab > Date

C) Format > Cells > Alignment tab > Date

D) Format > Cells > Border tab > Date

Explanation:

To apply a date format to a cell, you use Format > Cells, then select the Number tab and choose Date.

Explanation:

To apply a date format to a cell, you use Format > Cells, then select the Number tab and choose Date.

8 / 20

How can you automatically format a range of cells using predefined styles in Excel?

A) Format > Cells > Number tab

B) Format > AutoFormat

C) Data > AutoFormat

D) Insert > AutoFormat

Explanation:

To automatically format a range of cells using predefined styles, you use the Format > AutoFormat option.

Explanation:

To automatically format a range of cells using predefined styles, you use the Format > AutoFormat option.

9 / 20

How can you apply currency format to a number in Excel?

A) Format > Cells > Number tab > Currency

B) Format > Cells > Font tab > Currency

C) Format > Cells > Alignment tab > Currency

D) Format > Cells > Border tab > Currency

Explanation:

To apply currency format, you go to Format > Cells, then select the Number tab and choose Currency.

Explanation:

To apply currency format, you go to Format > Cells, then select the Number tab and choose Currency.

10 / 20

How can you apply number formatting to a range of cells in Excel?

A) Select the range and use Insert menu

B) Select the range and use Format > Cells

C) Select the range and press Ctrl + S

D) Select the range and use Data menu

Explanation:

To apply number formatting, you select the range and use Format > Cells.

Explanation:

To apply number formatting, you select the range and use Format > Cells.

11 / 20

What feature allows you to copy formatting from one cell to another in Excel?

A) Copy and Paste

B) Format Painter

C) Auto Fill

D) Text Wrap

Explanation:

The Format Painter feature allows you to copy formatting from one cell to another.

Explanation:

The Format Painter feature allows you to copy formatting from one cell to another.

12 / 20

What command would you use to display text in multiple lines within a single cell?

A) Merge Cells

B) Text Wrap

C) Text Align

D) Insert Line Break

Explanation:

The Text Wrap command is used to display text in multiple lines within a single cell.

Explanation:

The Text Wrap command is used to display text in multiple lines within a single cell.

13 / 20

What happens to a number when you apply percent format in Excel?

A) It is divided by 100 and the percent symbol is shown

B) It is multiplied by 100 and the percent symbol is shown

C) It remains the same

D) It is converted to text

Explanation:

When you apply percent format, the number is multiplied by 100 and the percent symbol is shown.

Explanation:

When you apply percent format, the number is multiplied by 100 and the percent symbol is shown.

14 / 20

What does formatting mean in the context of an Excel worksheet?

A) Changing data types

B) Improving the appearance and layout of data

C) Deleting data

D) Inserting formulas

Explanation:

Formatting in Excel refers to changing and improving the appearance and layout of data to make it more readable and visually appealing.

Explanation:

Formatting in Excel refers to changing and improving the appearance and layout of data to make it more readable and visually appealing.

15 / 20

How can you change the foreground color of cell contents in Excel?

A) Format > Cells > Number tab

B) Format > Cells > Font tab > Color

C) Format > Cells > Alignment tab

D) Format > Cells > Border tab

Explanation:

To change the foreground color, you go to Format > Cells, then select the Font tab and choose Color.

Explanation:

To change the foreground color, you go to Format > Cells, then select the Font tab and choose Color.

16 / 20

How can you center a title over a cell range in Excel?

A) Format > Cells > Font tab > Center

B) Format > Cells > Alignment tab > Merge Cells

C) Format > Cells > Number tab > Center

D) Format > Cells > Border tab > Center

Explanation:

To center a title over a cell range, you use the Merge Cells option in the Alignment tab of the Format Cells dialog box.

Explanation:

To center a title over a cell range, you use the Merge Cells option in the Alignment tab of the Format Cells dialog box.

17 / 20

How can you change the font of cell contents in Excel?

A) Format > Cells > Alignment tab

B) Format > Cells > Border tab

C) Format > Cells > Font tab

D) Format > Cells > Number tab

Explanation:

To change the font of cell contents, you go to Format > Cells and select the Font tab.

Explanation:

To change the font of cell contents, you go to Format > Cells and select the Font tab.

18 / 20

Which menu option would you use to freeze panes in Excel?

A) Format menu

B) Data menu

C) View menu

D) Window menu

Explanation:

To freeze panes, you use the Window menu in Excel.

Explanation:

To freeze panes, you use the Window menu in Excel.

19 / 20

Which feature in Excel allows you to change the orientation of cell contents?

A) Text Wrap

B) Merge Cells

C) Cell Orientation

D) Conditional Formatting

Explanation:

The Cell Orientation feature allows you to change the direction of cell contents.

Explanation:

The Cell Orientation feature allows you to change the direction of cell contents.

20 / 20

How can you align cell contents to the center in Excel?

A) Format > Cells > Number tab

B) Format > Cells > Font tab

C) Format > Cells > Alignment tab > Horizontal > Center

D) Format > Cells > Border tab

Explanation:

To align cell contents to the center, you go to Format > Cells, select the Alignment tab, and choose Center from the Horizontal options.

Explanation:

To align cell contents to the center, you go to Format > Cells, select the Alignment tab, and choose Center from the Horizontal options.

Your score is

/20

CS-001 | 34

1 / 20

How do you create links to source data in a consolidation table?

A) Check the Create links to source data box in the Consolidate dialog box

B) Manually enter links in the formula bar

C) Use the Insert > Link option

D) Use the Data > Link option

Explanation:

To create links to source data, you check the Create links to source data box in the Consolidate dialog box.

Explanation:

To create links to source data, you check the Create links to source data box in the Consolidate dialog box.

2 / 20

What should you ensure when consolidating data by position?

A) Each range has matching labels

B) Each range is in the same cell in each worksheet

C) Each range is in a different layout

D) Each range is named differently

Explanation:

When consolidating by position, ensure that each range is in the same cell in each worksheet.

Explanation:

When consolidating by position, ensure that each range is in the same cell in each worksheet.

3 / 20

How do you add a field to the data area of a pivot table?

A) Drag the field to the Row area

B) Drag the field to the Column area

C) Drag the field to the Data area

D) Drag the field to the Filter area

Explanation:

To add a field to the data area, you drag the field to the Data area in the PivotTable Field List.

Explanation:

To add a field to the data area, you drag the field to the Data area in the PivotTable Field List.

4 / 20

What step follows selecting the range of data when creating a pivot table?

A) Click Insert > Table

B) Define the layout of the report

C) Select the type of report (PivotTable or PivotChart)

D) Click Finish

Explanation:

After selecting the range of data, you follow the instructions to define the layout of the report.

Explanation:

After selecting the range of data, you follow the instructions to define the layout of the report.

5 / 20

Which step involves selecting the summary function for consolidating data?

A) Step 3 in the Consolidate wizard

B) Step 1 in the Consolidate wizard

C) Step 2 in the Consolidate wizard

D) The final step before clicking OK

Explanation:

Selecting the summary function for consolidating data is part of the final step before clicking OK in the Consolidate wizard.

Explanation:

Selecting the summary function for consolidating data is part of the final step before clicking OK in the Consolidate wizard.

6 / 20

How do you remove a field from a pivot table?

A) Select the field and press Delete

B) Click on the field and select Remove Field

C) Drag the field outside the pivot table report

D) Click View > Remove Field

Explanation:

To remove a field, you click on the field heading and drag it outside the pivot table report.

Explanation:

To remove a field, you click on the field heading and drag it outside the pivot table report.

7 / 20

Which function is recommended for consolidating data of any type or arrangement?

A) Position

B) Category

C) 3-D references in formulas

D) Layout

Explanation:

3-D references in formulas are recommended for consolidating data of any type or arrangement.

Explanation:

3-D references in formulas are recommended for consolidating data of any type or arrangement.

8 / 20

What is the first step in creating a pivot table?

A) Click on File > New

B) Click on Insert > PivotTable

C) Click on Data > PivotTable and PivotChart Report

D) Click on View > PivotTable

Explanation:

To create a pivot table, you start by clicking on Data > PivotTable and PivotChart Report.

Explanation:

To create a pivot table, you start by clicking on Data > PivotTable and PivotChart Report.

9 / 20

What is a pivot table in Excel?

A) A tool to create charts

B) A tool to sort data

C) An interactive table that summarizes data

D) A formula to calculate data

Explanation:

A pivot table is an interactive table that extracts, organizes, and summarizes data.

Explanation:

A pivot table is an interactive table that extracts, organizes, and summarizes data.

10 / 20

What should you do if the data for your pivot table is retrieved from a database?

A) Skip to step 6 in the wizard

B) Create a new Excel list

C) Convert the data to a chart

D) Delete the retrieved data

Explanation:

If the data is from a database or an Office Data Connection returns the data as a blank PivotTable report, continue with step 6.

Explanation:

If the data is from a database or an Office Data Connection returns the data as a blank PivotTable report, continue with step 6.

11 / 20

How do you create a pivot table that summarizes sales data by region and type?

A) Drag the region field to the Row area and the type field to the Column area

B) Drag the type field to the Row area and the region field to the Column area

C) Drag the sales field to the Row area and the type field to the Column area

D) Drag the region field to the Data area and the type field to the Filter area

Explanation:

To summarize sales data by region and type, drag the region field to the Row area and the type field to the Column area.

Explanation:

To summarize sales data by region and type, drag the region field to the Row area and the type field to the Column area.

12 / 20

How do you add a field to a pivot table?

A) Click Insert > Field

B) Click View > Field

C) Drag the field from the PivotTable Field List to the desired section

D) Type the field name in the pivot table

Explanation:

To add a field, you drag it from the PivotTable Field List to the desired section of the pivot table.

Explanation:

To add a field, you drag it from the PivotTable Field List to the desired section of the pivot table.

13 / 20

Which of the following is not a type of report you can create using the PivotTable and PivotChart Wizard?

A) PivotTable

B) PivotChart

C) PivotMap

D) PivotTable and PivotChart

Explanation:

PivotMap is not an option in the PivotTable and PivotChart Wizard.

Explanation:

PivotMap is not an option in the PivotTable and PivotChart Wizard.

14 / 20

How do you consolidate data by category in Excel?

A) Use the same layout for each range

B) Use matching labels in rows or columns

C) Use 3-D references in formulas

D) Use data in the same cell in each range

Explanation:

To consolidate data by category, you use matching labels in rows or columns.

Explanation:

To consolidate data by category, you use matching labels in rows or columns.

15 / 20

Which type of reference is recommended for consolidating any type of data arrangement?

A) 3-D references in formulas

B) Position references

C) Category references

D) Named ranges

Explanation:

3-D references in formulas are recommended for consolidating any type of data arrangement.

Explanation:

3-D references in formulas are recommended for consolidating any type of data arrangement.

16 / 20

What function should you use in the Consolidate dialog box to combine data?

A) SUM

B) AVERAGE

C) MAX

D) Any summary function available

Explanation:

In the Consolidate dialog box, you can choose any summary function available, such as SUM, AVERAGE, etc.

Explanation:

In the Consolidate dialog box, you can choose any summary function available, such as SUM, AVERAGE, etc.

17 / 20

How do you define a name for a range in Excel?

A) Select the range, then go to Insert > Name > Define

B) Select the range, then go to File > Name > Define

C) Select the range, then go to View > Name > Define

D) Select the range, then go to Data > Name > Define

Explanation:

To define a name for a range, you select the range, then go to Insert > Name > Define.

Explanation:

To define a name for a range, you select the range, then go to Insert > Name > Define.

18 / 20

What is data consolidation in Excel?

A) Combining data from multiple charts

B) Summarizing data from multiple worksheets

C) Formatting data in a worksheet

D) Sorting data in a worksheet

Explanation:

Data consolidation involves summarizing data from multiple worksheets into a single worksheet.

Explanation:

Data consolidation involves summarizing data from multiple worksheets into a single worksheet.

19 / 20

What should you do if you're consolidating data by category?

A) Ensure each range has the same layout

B) Ensure labels have identical spelling and capitalization

C) Use different labels for each range

D) Use the same cell references for each range

Explanation:

When consolidating by category, ensure that the labels for columns or rows have identical spelling and capitalization.

Explanation:

When consolidating by category, ensure that the labels for columns or rows have identical spelling and capitalization.

20 / 20

How do you consolidate data by position in Excel?

A) Use 3-D references in formulas

B) Use data in the same cell in each range

C) Use different layouts for each range

D) Use matching labels in rows or columns

Explanation:

To consolidate by position, the data must be in the same cell in each of the ranges.

Explanation:

To consolidate by position, the data must be in the same cell in each of the ranges.

Your score is

/75

CS-001 MODULE 5

1 / 75

What is used to move text to a higher or lower level in a multilevel list?

A) Increase Indent and Decrease Indent buttons

B) Tab and Shift + Tab keys

C) Both A and B

D) None of the above

Explanation:

Both A and B are used to move text to a higher or lower level in a multilevel list.

Explanation:

Both A and B are used to move text to a higher or lower level in a multilevel list.

2 / 75

What is the probability of getting an odd number on a fair die?

1/6

1/2

2/3

5/6

Explanation:

A fair die has 6 faces, and there are 3 odd numbers (1, 3, 5), so the probability is 3/6 = 1/2.

Explanation:

A fair die has 6 faces, and there are 3 odd numbers (1, 3, 5), so the probability is 3/6 = 1/2.

3 / 75

Which view helps in arranging different files or seeing different presentation files?

A) Normal View

B) Slide Sorter View

C) Reading View

D) Outline View

Explanation:

Slide Sorter View helps in arranging different files or seeing different presentation files.

Explanation:

Slide Sorter View helps in arranging different files or seeing different presentation files.

4 / 75

Which tab contains the 'Header and Footer' command?

A) Home

B) Insert

C) Design

D) View

Explanation:

The Insert tab contains the 'Header and Footer' command.

Explanation:

The Insert tab contains the 'Header and Footer' command.

5 / 75

What shortcut key is used to add a new slide with the same layout as the current slide?

A) Ctrl + N

B) Ctrl + M

C) Ctrl + S

D) Ctrl + D

Explanation:

Ctrl + M is the shortcut key to add a new slide with the same layout as the current slide.

Explanation:

Ctrl + M is the shortcut key to add a new slide with the same layout as the current slide.

6 / 75

How can you insert a video in a slide?

A) Click on the Home tab and select Video

B) Click on the Insert tab and select Video

C) Click on the Design tab and select Video

D) Click on the View tab and select Video

Explanation:

Click on the Insert tab and select Video to insert a video in a slide.

Explanation:

Click on the Insert tab and select Video to insert a video in a slide.

7 / 75

Which command is used to change the slide orientation to portrait?

A) Click on the Home tab and select Slide Orientation

B) Click on the Design tab and select Slide Orientation

C) Click on the View tab and select Slide Orientation

D) Click on the Insert tab and select Slide Orientation

Explanation:

Click on the Design tab and select Slide Orientation to change the slide orientation to portrait.

Explanation:

Click on the Design tab and select Slide Orientation to change the slide orientation to portrait.

8 / 75

What is the new feature introduced in MS PowerPoint 2010?

A) Ribbon

B) Quick Access Toolbar

C) Backstage View

D) Animations

Explanation:

Backstage View is the new feature introduced in MS PowerPoint 2010.

Explanation:

Backstage View is the new feature introduced in MS PowerPoint 2010.

9 / 75

What is used to record a slide show in PowerPoint?

A) Slide Show tab and click on Record Slide Show

B) Home tab and click on Record Slide Show

C) Insert tab and click on Record Slide Show

D) View tab and click on Record Slide Show

Explanation:

The Slide Show tab and click on Record Slide Show is used to record a slide show in PowerPoint.

Explanation:

The Slide Show tab and click on Record Slide Show is used to record a slide show in PowerPoint.

10 / 75

Which tab contains the 'New Slide' button?

A) Home

B) Insert

C) Design

D) View

Explanation:

The Home tab contains the 'New Slide' button.

Explanation:

The Home tab contains the 'New Slide' button.

11 / 75

What is a 'Place Holder' in PowerPoint?

A) A tool to view slides

B) An input area shown on the slide in the form of a dotted area

C) A feature to add animations

D) A command under the Insert tab

Explanation:

A 'Place Holder' is an input area shown on the slide in the form of a dotted area.

Explanation:

A 'Place Holder' is an input area shown on the slide in the form of a dotted area.

12 / 75

Where is the Quick Access Toolbar located?

A) At the bottom of the Ribbon bar

B) On the left side of the screen

C) On the top of the Ribbon bar

D) In the Backstage View

Explanation:

The Quick Access Toolbar is located on the top of the Ribbon bar.

Explanation:

The Quick Access Toolbar is located on the top of the Ribbon bar.

13 / 75

How can you delete a slide in PowerPoint?

A) Select the slide and press Backspace or Delete

B) Right click on the slide and select Delete

C) Click on Delete Slide under the Home tab

D) Click on the View tab and select Delete Slide

Explanation:

Select the slide and press Backspace or Delete to delete a slide in PowerPoint.

Explanation:

Select the slide and press Backspace or Delete to delete a slide in PowerPoint.

14 / 75

How do you show or hide the Ribbon using a shortcut key?

A) Ctrl + F1

B) Ctrl + F2

C) Ctrl + F3

D) Ctrl + F4

Explanation:

Ctrl + F1 is the shortcut key to show or hide the Ribbon.

Explanation:

Ctrl + F1 is the shortcut key to show or hide the Ribbon.

15 / 75

How can you print slides in various views and outputs?

A) Click on the File tab and select Print

B) Click on the Home tab and select Print

C) Click on the Design tab and select Print

D) Click on the Insert tab and select Print

Explanation:

Click on the File tab and select Print to print slides in various views and outputs.

Explanation:

Click on the File tab and select Print to print slides in various views and outputs.

16 / 75

Which shortcut key opens the Backstage view?

A) Ctrl + F1

B) Alt + F

C) Ctrl + F2

D) Alt + H

Explanation:

Alt + F is the shortcut key to open the Backstage view.

Explanation:

Alt + F is the shortcut key to open the Backstage view.

17 / 75

Which tab contains the 'Tables' and 'Picture' options?

A) Home

B) Insert

C) Design

D) View

Explanation:

The Insert tab contains the 'Tables' and 'Picture' options.

Explanation:

The Insert tab contains the 'Tables' and 'Picture' options.

18 / 75

How can you customize the Ribbon in PowerPoint?

A) Right click on the Ribbon and select Customize the Ribbon

B) Click on the File tab and select Customize Ribbon

C) Press Ctrl + R

D) Click on the Home tab and select Ribbon Options

Explanation:

Right click on the Ribbon and select Customize the Ribbon to customize it in PowerPoint.

Explanation:

Right click on the Ribbon and select Customize the Ribbon to customize it in PowerPoint.

19 / 75

What is the function of the 'Justify' option?

A) To align text to the left

B) To align text to the right

C) To center align text

D) To align text to both left and right margins

Explanation:

The 'Justify' option is used to align text to both left and right margins.

Explanation:

The 'Justify' option is used to align text to both left and right margins.

20 / 75

How do you insert a hyperlink in a presentation?

A) Click on the Home tab and select Hyperlink

B) Right click on the text/picture and select Hyperlink

C) Click on the Insert tab and select Hyperlink

D) Both B and C

Explanation:

Both B and C are correct methods to insert a hyperlink in a presentation.

Explanation:

Both B and C are correct methods to insert a hyperlink in a presentation.

21 / 75

How do you change the color of a shape?

A) Click on the Home tab and select Shape Color

B) Click on the Insert tab and select Shape Color

C) Click on the Design tab and select Shape Color

D) Click on the Format tab and select Shape Color

Explanation:

Click on the Format tab and select Shape Color to change the color of a shape.

Explanation:

Click on the Format tab and select Shape Color to change the color of a shape.

22 / 75

Which key combination is used to copy selected text?

A) Ctrl + X

B) Ctrl + C

C) Ctrl + V

D) Ctrl + Z

Explanation:

Ctrl + C is the key combination used to copy selected text.

Explanation:

Ctrl + C is the key combination used to copy selected text.

23 / 75

Which tab contains the Slide Show options?

A) Home

B) Insert

C) Design

D) Slide Show

Explanation:

The Slide Show tab contains the Slide Show options.

Explanation:

The Slide Show tab contains the Slide Show options.

24 / 75

Which tab contains the 'Convert to Smart Art' option?

A) Home

B) Insert

C) Design

D) View

Explanation:

The Home tab contains the 'Convert to Smart Art' option.

Explanation:

The Home tab contains the 'Convert to Smart Art' option.

25 / 75

The sample space of rolling two dice consists of how many possible outcomes?

Explanation:

Each die has 6 faces, so rolling two dice gives 6×6=36 possible outcomes.

Explanation:

Each die has 6 faces, so rolling two dice gives 6×6=36 possible outcomes.

26 / 75

Which shortcut key is used to paste the copied content?

A) Ctrl + P

B) Ctrl + V

C) Ctrl + A

D) Ctrl + F

Explanation:

Ctrl + V is the shortcut key to paste the copied content.

Explanation:

Ctrl + V is the shortcut key to paste the copied content.

27 / 75

Which tab contains the 'Smart Art' command?

A) Home

B) Insert

C) Design

D) View

Explanation:

The Insert tab contains the 'Smart Art' command.

Explanation:

The Insert tab contains the 'Smart Art' command.

28 / 75

How can you quickly save a presentation?

A) Ctrl + P

B) Ctrl + S

C) Ctrl + Q

D) Ctrl + L

Explanation:

Ctrl + S is the shortcut key to quickly save a presentation.

Explanation:

Ctrl + S is the shortcut key to quickly save a presentation.

29 / 75

How do you broadcast a slide show?

A) Click on the Home tab and select Broadcast Slide Show

B) Click on the Slide Show tab and select Broadcast Slide Show

C) Click on the Insert tab and select Broadcast Slide Show

D) Click on the View tab and select Broadcast Slide Show

Explanation:

Click on the Slide Show tab and select Broadcast Slide Show to broadcast a slide show.

Explanation:

Click on the Slide Show tab and select Broadcast Slide Show to broadcast a slide show.

30 / 75

What is the purpose of the 'Slide Master' view?

A) To add animations

B) To set the contents of all other slides

C) To change the slide layout

D) To add notes to slides

Explanation:

The purpose of the 'Slide Master' view is to set the contents of all other slides.

Explanation:

The purpose of the 'Slide Master' view is to set the contents of all other slides.

31 / 75

What appears when you click on the File button in the Ribbon bar?

A) Home Tab

B) Slide Show

C) Backstage View

D) Quick Access Toolbar

Explanation:

The Backstage View appears when you click on the File button in the Ribbon bar.

Explanation:

The Backstage View appears when you click on the File button in the Ribbon bar.

32 / 75

How do you add a new slide with the same layout as the current slide?

A) Click on New Slide under the Home tab

B) Press Ctrl + N

C) Press Ctrl + M

D) Click on Insert tab and then New Slide

Explanation:

Press Ctrl + M to add a new slide with the same layout as the current slide.

Explanation:

Press Ctrl + M to add a new slide with the same layout as the current slide.

33 / 75

How do you apply animation effects to text?

A) Click on the Animations tab and select an animation from the options

B) Click on the Home tab and select an animation

C) Click on the Design tab and select Animations

D) Click on the Insert tab and select Animations

Explanation:

Click on the Animations tab and select an animation from the options to apply animation effects to text.

Explanation:

Click on the Animations tab and select an animation from the options to apply animation effects to text.

34 / 75

How do you insert a chart in a slide?

A) Click on the Home tab and select Chart

B) Click on the Insert tab and select Chart

C) Click on the Design tab and select Chart

D) Click on the View tab and select Chart

Explanation:

Click on the Insert tab and select Chart to insert a chart in a slide.

Explanation:

Click on the Insert tab and select Chart to insert a chart in a slide.

35 / 75

Which of the following is not a slide view option in PowerPoint?

A) Normal View

B) Slide Sorter View

C) Reading View

D) Thumbnail View

Explanation:

Thumbnail View is not a slide view option in PowerPoint.

Explanation:

Thumbnail View is not a slide view option in PowerPoint.

36 / 75

What is the shortcut for duplicating a slide?

A) Ctrl + D

B) Ctrl + V

C) Ctrl + C

D) Ctrl + X

Explanation:

Ctrl + D is the shortcut for duplicating a slide.

Explanation:

Ctrl + D is the shortcut for duplicating a slide.

37 / 75

How do you remove a place holder from a slide?

A) Select the place holder and press Backspace or Delete

B) Right click on the place holder and select Remove

C) Click on the Home tab and select Remove Place Holder

D) Click on the View tab and select Remove Place Holder

Explanation:

Select the place holder and press Backspace or Delete to remove it from a slide.

Explanation:

Select the place holder and press Backspace or Delete to remove it from a slide.

38 / 75

Which shortcut key is used to start a slide show from the beginning?

A) F1

B) F2

C) F5

D) F7

Explanation:

F5 is the shortcut key to start a slide show from the beginning.

Explanation:

F5 is the shortcut key to start a slide show from the beginning.

39 / 75

What is the shortcut for cutting selected text or object?

A) Ctrl + C

B) Ctrl + V

C) Ctrl + X

D) Ctrl + Z

Explanation:

Ctrl + X is the shortcut key for cutting selected text or object.

Explanation:

Ctrl + X is the shortcut key for cutting selected text or object.

40 / 75

How do you insert an image in a slide?

A) Click on the Home tab and select Picture

B) Click on the Insert tab and select Picture

C) Click on the Design tab and select Picture

D) Click on the View tab and select Picture

Explanation:

Click on the Insert tab and select Picture to insert an image in a slide.

Explanation:

Click on the Insert tab and select Picture to insert an image in a slide.

41 / 75

How do you add a new tab to the Ribbon?

A) Right click on the Ribbon and select Customize the Ribbon

B) Click on the File tab and select Options

C) Click on the Home tab and select Customize Ribbon

D) Click on the View tab and select Customize Ribbon

Explanation:

Right click on the Ribbon and select Customize the Ribbon to add a new tab to it.

Explanation:

Right click on the Ribbon and select Customize the Ribbon to add a new tab to it.

42 / 75

How can you apply a theme to a single slide?

A) Click on the Home tab and select Theme

B) Right click on the slide and select Apply Theme to Slide

C) Click on the Design tab, select a theme, and apply to the selected slide

D) Click on the View tab and select Theme

Explanation:

Click on the Design tab, select a theme, and apply to the selected slide to apply a theme to a single slide.

Explanation:

Click on the Design tab, select a theme, and apply to the selected slide to apply a theme to a single slide.

43 / 75

How do you add a shape to a slide?

A) Click on the Home tab and select Shapes

B) Click on the Insert tab and select Shapes

C) Click on the Design tab and select Shapes

D) Click on the View tab and select Shapes

Explanation:

Click on the Insert tab and select Shapes to add a shape to a slide.

Explanation:

Click on the Insert tab and select Shapes to add a shape to a slide.

44 / 75

What is the function of the 'Format Painter' tool?

A) To copy text

B) To copy formatting from one object to another

C) To delete formatting

D) To change text color

Explanation:

The 'Format Painter' tool is used to copy formatting from one object to another.

Explanation:

The 'Format Painter' tool is used to copy formatting from one object to another.

45 / 75

How do you insert a table in a slide?

A) Click on the Home tab and select Table

B) Click on the Insert tab and select Table

C) Click on the Design tab and select Table

D) Click on the View tab and select Table

Explanation:

Click on the Insert tab and select Table to insert a table in a slide.

Explanation:

Click on the Insert tab and select Table to insert a table in a slide.

46 / 75

Which shortcut key is used to undo an action?

A) Ctrl + U

B) Ctrl + Z

C) Ctrl + Y

D) Ctrl + R

Explanation:

Ctrl + Z is the shortcut key to undo an action.

Explanation:

Ctrl + Z is the shortcut key to undo an action.

47 / 75

What is used to adjust space between bullets and text?

A) Paragraph spacing

B) Line spacing

C) First line indent or hanging indent

D) Bullet spacing

Explanation:

The First line indent or hanging indent is used to adjust space between bullets and text.

Explanation:

The First line indent or hanging indent is used to adjust space between bullets and text.

48 / 75

What is the probability that a randomly selected birth from the provided data is a female live birth?

0.4859

0.4750

0.5021

0.0109

Explanation:

The probability of a female live birth is given by the proportion of female live births, which is 0.4750.

Explanation:

The probability of a female live birth is given by the proportion of female live births, which is 0.4750.

49 / 75

What is the function of the 'Slide Sorter View'?

A) To add new slides

B) To change slide layouts

C) To arrange slides and check for extra slides

D) To view slide notes

Explanation:

The 'Slide Sorter View' is used to arrange slides and check for extra slides.

Explanation:

The 'Slide Sorter View' is used to arrange slides and check for extra slides.

50 / 75

What is the function of the pen button in on-screen navigation tools?

A) To move to the next slide

B) To move to the previous slide

C) To show/hide the pen

D) To navigate to a specific slide

Explanation:

The pen button in on-screen navigation tools is used to show/hide the pen.

Explanation:

The pen button in on-screen navigation tools is used to show/hide the pen.

51 / 75

Which tab contains the 'Chart' command?

A) Home

B) Insert

C) Design

D) View

Explanation:

The Insert tab contains the 'Chart' command.

Explanation:

The Insert tab contains the 'Chart' command.

52 / 75

How can you duplicate a slide?

A) Select the slide and press Ctrl + D

B) Select the slide, click on New Slide under Home tab, and select Duplicate Selected Slide

C) Right click on the slide and select Duplicate Slide

D) All of the above

Explanation:

All of the above methods can be used to duplicate a slide.

Explanation:

All of the above methods can be used to duplicate a slide.

53 / 75

Which tab contains the 'Spelling' command?

A) Home

B) Insert

C) Design

D) Review

Explanation:

The Review tab contains the 'Spelling' command.

Explanation:

The Review tab contains the 'Spelling' command.

54 / 75

What is used to change the spacing between bullets and text?

A) Paragraph spacing

B) Line spacing

C) First line indent maker or hanging indent

D) Bullet spacing

Explanation:

The First line indent maker or hanging indent is used to change the spacing between bullets and text.

Explanation:

The First line indent maker or hanging indent is used to change the spacing between bullets and text.

55 / 75

How can you convert existing text to smart art?

A) Right click on the text and select Convert to Smart Art

B) Click on the Insert tab and select Smart Art

C) Click on the Design tab and select Smart Art

D) Click on the View tab and select Convert to Smart Art

Explanation:

Right click on the text and select Convert to Smart Art to convert existing text to smart art.

Explanation:

Right click on the text and select Convert to Smart Art to convert existing text to smart art.

56 / 75

Which view allows you to see all slides as thumbnails?

A) Normal View

B) Slide Sorter View

C) Reading View

D) Outline View

Explanation:

The Slide Sorter View allows you to see all slides as thumbnails.

Explanation:

The Slide Sorter View allows you to see all slides as thumbnails.

57 / 75

What is used to convert text into smart graphics?

A) Insert tab

B) Design tab

C) Convert to Smart dropdown list under the Home tab

D) View tab

Explanation:

The Convert to Smart dropdown list under the Home tab is used to convert text into smart graphics.

Explanation:

The Convert to Smart dropdown list under the Home tab is used to convert text into smart graphics.

58 / 75

How can you change the case of selected text?

A) Click on the Home tab and select Aa/

B) Click on the Insert tab and select Aa/

C) Click on the Design tab and select Aa/

D) Click on the View tab and select Aa/

Explanation:

Click on the Home tab and select Aa/ to change the case of selected text.

Explanation:

Click on the Home tab and select Aa/ to change the case of selected text.

59 / 75

How do you add notes to a slide?

A) Click on the Insert tab and select Notes

B) Click on the View tab and select Notes Page

C) Click on the Home tab and select Add Notes

D) Click on the Slide Show tab and select Add Notes

Explanation:

Click on the View tab and select Notes Page to add notes to a slide.

Explanation:

Click on the View tab and select Notes Page to add notes to a slide.

60 / 75

Which tab contains the 'Rehearse Timings' option?

A) Home

B) Insert

C) Design

D) Slide Show

Explanation:

The Slide Show tab contains the 'Rehearse Timings' option.

Explanation:

The Slide Show tab contains the 'Rehearse Timings' option.

61 / 75

How can you apply a theme to all slides in a presentation?

A) Click on the Home tab and select Themes

B) Click on the Design tab and select Apply to All

C) Click on the Insert tab and select Apply to All

D) Click on the View tab and select Apply to All

Explanation:

Click on the Design tab and select Apply to All to apply a theme to all slides in a presentation.

Explanation:

Click on the Design tab and select Apply to All to apply a theme to all slides in a presentation.

62 / 75

Which shortcut is used to copy selected text or object?

A) Ctrl + X

B) Ctrl + V

C) Ctrl + C

D) Ctrl + Z

Explanation:

Ctrl + C is the shortcut key to copy selected text or object.

Explanation:

Ctrl + C is the shortcut key to copy selected text or object.

63 / 75

Which tab contains the 'Slide Master' view command?

A) Home

B) Insert

C) Design

D) View

Explanation:

The View tab contains the 'Slide Master' view command.

Explanation:

The View tab contains the 'Slide Master' view command.

64 / 75

What is the purpose of 'Compatibility Mode'?

A) To create a new presentation

B) To convert the presentation

C) To save the presentation in a new format

D) To add new slides

Explanation:

The purpose of 'Compatibility Mode' is to convert the presentation.

Explanation:

The purpose of 'Compatibility Mode' is to convert the presentation.

65 / 75

The number of permutations of 4 objects taken 3 at a time from a set of 5 distinct objects is:

120

Explanation:

The number of permutations of 4 objects taken 3 at a time is 5P3=5!/(5−3)!=60.

Explanation:

The number of permutations of 4 objects taken 3 at a time is 5P3=5!/(5−3)!=60.

66 / 75

How do you change the theme of a presentation?

A) Click on the Home tab, then click on Themes button

B) Click on the Design tab and select a theme from the Themes group of commands

C) Click on the View tab and select Themes

D) Click on the File tab and then select Change Theme

Explanation:

Click on the Design tab and select a theme from the Themes group of commands to change the theme of a presentation.

Explanation:

Click on the Design tab and select a theme from the Themes group of commands to change the theme of a presentation.

67 / 75

Which of the following can be inserted using the Insert tab?

A) Tables

B) Pictures

C) Charts

D) All of the above

Explanation:

Tables, Pictures, and Charts can all be inserted using the Insert tab.

Explanation:

Tables, Pictures, and Charts can all be inserted using the Insert tab.

68 / 75

How do you create a new blank presentation?

A) Click on Home tab

B) Click on File button, then New, and then Create

C) Press Ctrl + N

D) Click on Insert tab and then New Slide

Explanation:

Click on the File button, then New, and then Create to create a new blank presentation.

Explanation:

Click on the File button, then New, and then Create to create a new blank presentation.

69 / 75

Which command is used to format line spacing in a presentation?

A) Paragraph spacing

B) Line spacing

C) First line indent

D) Hanging indent

Explanation:

The Line spacing command is used to format line spacing in a presentation.

Explanation:

The Line spacing command is used to format line spacing in a presentation.

70 / 75

Which tab contains the command to change the slide layout?

A) Home

B) Insert

C) Design

D) View

Explanation:

The Home tab contains the command to change the slide layout.

Explanation:

The Home tab contains the command to change the slide layout.

71 / 75

Which key can be used to start the slide show from the beginning?

A) F1

B) F5

C) F7

D) F11

Explanation:

F5 can be used to start the slide show from the beginning.

Explanation:

F5 can be used to start the slide show from the beginning.

72 / 75

The combination of 5 objects taken 2 at a time from a set of 5 distinct objects is:

Explanation:

The number of combinations of 5 objects taken 2 at a time is 5C2=5!/(2!(5−2)!)=10.

Explanation:

The number of combinations of 5 objects taken 2 at a time is 5C2=5!/(2!(5−2)!)=10.

73 / 75

How do you minimize the Ribbon bar?

A) Click on the File button

B) Click on the ^ button from the Ribbon bar

C) Press Ctrl + M

D) Press F5

Explanation:

Click on the ^ button from the Ribbon bar to minimize it.

Explanation:

Click on the ^ button from the Ribbon bar to minimize it.

74 / 75

How can you add commands to the Quick Access Toolbar?

A) Right click on the Ribbon

B) Right click on the Quick Access Toolbar

C) Click on File and then Options

D) Press Ctrl + Q

Explanation:

Right click on the Quick Access Toolbar to add commands to it.

Explanation:

Right click on the Quick Access Toolbar to add commands to it.

75 / 75

How can you convert a presentation to a different file format?

A) Click on the File tab and select Save As

B) Click on the Home tab and select Save As

C) Click on the Insert tab and select Save As

D) Click on the View tab and select Save As

Explanation:

Click on the File tab and select Save As to convert a presentation to a different file format.

Explanation:

Click on the File tab and select Save As to convert a presentation to a different file format.

Your score is

/87

CS-001 MODULE 6

1 / 87

What is the function of the 'Reading Pane' in Microsoft Outlook?

A) To view the contents of an email message

B) To compose a new email message

C) To attach files to an email message

D) To manage contacts

Explanation:

The function of the 'Reading Pane' in Microsoft Outlook is to view the contents of an email message.

Explanation:

The function of the 'Reading Pane' in Microsoft Outlook is to view the contents of an email message.

2 / 87

How do you delete the browsing history in Internet Explorer?

A) Tools > Internet Options > Delete

B) File > Open > Delete History

C) View > History > Delete

D) Edit > History > Delete

Explanation:

Tools > Internet Options > Delete is used to delete the browsing history in Internet Explorer.

Explanation:

Tools > Internet Options > Delete is used to delete the browsing history in Internet Explorer.

3 / 87

Which key combination opens the history in most web browsers?

A) Ctrl + H

B) Ctrl + J

C) Ctrl + K

D) Ctrl + L

Explanation:

Ctrl + H opens the history in most web browsers.

Explanation:

Ctrl + H opens the history in most web browsers.

4 / 87

Which key combination is used to copy selected text in an email message?

A) Ctrl + X

B) Ctrl + C

C) Ctrl + V

D) Ctrl + Z

Explanation:

Ctrl + C is the key combination used to copy selected text in an email message.

Explanation:

Ctrl + C is the key combination used to copy selected text in an email message.

5 / 87

Which pane in Microsoft Outlook shows the list of emails?

A) Navigation Pane

B) Content Area

C) Reading Pane

D) Task Pane

Explanation:

The Content Area pane in Microsoft Outlook shows the list of emails.

Explanation:

The Content Area pane in Microsoft Outlook shows the list of emails.

6 / 87

Which of the following is an email application?

A) Microsoft Word

B) Adobe Photoshop

C) Microsoft Outlook

D) VLC Media Player

Explanation:

Microsoft Outlook is an email application.

Explanation:

Microsoft Outlook is an email application.

7 / 87

What is a website?

A) A collection of online documents

B) A single web page

C) A web server

D) A program for browsing the internet

Explanation:

A website is a collection of online documents.

Explanation:

A website is a collection of online documents.

8 / 87

What does URL stand for?

A) Uniform Resource Locator

B) Uniform Resource Link

C) Unified Resource Locator

D) Unified Resource Link

Explanation:

URL stands for Uniform Resource Locator.

Explanation:

URL stands for Uniform Resource Locator.

9 / 87

What is the purpose of the World Wide Web (WWW)?

A) To store online documents

B) To create software

C) To manage databases

D) To design graphics

Explanation:

The purpose of the World Wide Web (WWW) is to store online documents.

Explanation:

The purpose of the World Wide Web (WWW) is to store online documents.

10 / 87

How can you add a bookmark in most web browsers?

A) Press Ctrl + D

B) Click the star icon in the address bar

C) Right-click on the page and select 'Bookmark'

D) Any of the above

Explanation:

Any of the given methods can be used to add a bookmark in most web browsers.

Explanation:

Any of the given methods can be used to add a bookmark in most web browsers.

11 / 87

What is the purpose of the status bar in a web browser?

A) To show the progress of page loading

B) To display the URL of the web page

C) To display bookmarks

D) To view the title of the web page

Explanation:

The purpose of the status bar in a web browser is to show the progress of page loading.

Explanation:

The purpose of the status bar in a web browser is to show the progress of page loading.

12 / 87

What is the primary purpose of an email client?

A) To browse the internet

B) To manage and send emails

C) To create websites

D) To edit graphics

Explanation:

The primary purpose of an email client is to manage and send emails.

Explanation:

The primary purpose of an email client is to manage and send emails.

13 / 87

How do you mark an email message as read in Microsoft Outlook?

A) Select the message and press Ctrl + R

B) Select the message, right-click, and choose 'Mark as read'

C) Click File > Mark as read

D) Click Tools > Mark as read

Explanation:

Select the message, right-click, and choose 'Mark as read' to mark an email message as read in Microsoft Outlook.

Explanation:

Select the message, right-click, and choose 'Mark as read' to mark an email message as read in Microsoft Outlook.

14 / 87

Which protocol is used to transfer files between computers on the internet?

A) FTP

B) HTTP

C) HTTPS

D) SMTP

Explanation:

FTP is used to transfer files between computers on the internet.

Explanation:

FTP is used to transfer files between computers on the internet.

15 / 87

Which key combination is used to reopen the last closed tab in most web browsers?

A) Ctrl + Shift + T

B) Ctrl + Shift + N

C) Ctrl + Shift + W

D) Ctrl + Shift + F

Explanation:

Ctrl + Shift + T is used to reopen the last closed tab in most web browsers.

Explanation:

Ctrl + Shift + T is used to reopen the last closed tab in most web browsers.

16 / 87

What does HTTP stand for?

A) HyperText Transfer Protocol

B) HyperText Transfer Program

C) HyperTransfer Text Protocol

D) HyperTool Transfer Protocol

Explanation:

HTTP stands for HyperText Transfer Protocol.

Explanation:

HTTP stands for HyperText Transfer Protocol.

17 / 87

Which protocol is used to securely transfer web pages?

A) HTTP

B) FTP

C) HTTPS

D) TCP/IP

Explanation:

HTTPS is used to securely transfer web pages.

Explanation:

HTTPS is used to securely transfer web pages.

18 / 87

What is the function of the 'Navigation Pane' in Microsoft Outlook?

A) To navigate through different folders and features

B) To compose a new email message

C) To attach files to an email message

D) To manage contacts

Explanation:

The function of the 'Navigation Pane' in Microsoft Outlook is to navigate through different folders and features.

Explanation:

The function of the 'Navigation Pane' in Microsoft Outlook is to navigate through different folders and features.

19 / 87

Which key combination is used to paste copied text in an email message?

A) Ctrl + X

B) Ctrl + C

C) Ctrl + V

D) Ctrl + Z

Explanation:

Ctrl + V is the key combination used to paste copied text in an email message.

Explanation:

Ctrl + V is the key combination used to paste copied text in an email message.

20 / 87

Which key combination is used to delete an email message?

A) Ctrl + D

B) Ctrl + X

C) Ctrl + Z

D) Ctrl + S

Explanation:

Ctrl + D is the key combination used to delete an email message.

Explanation:

Ctrl + D is the key combination used to delete an email message.

21 / 87

Which key combination is used to open a new tab in most web browsers?

A) Ctrl + N

B) Ctrl + T

C) Ctrl + W

D) Ctrl + F4

Explanation:

Ctrl + T is the key combination used to open a new tab in most web browsers.

Explanation:

Ctrl + T is the key combination used to open a new tab in most web browsers.

22 / 87

What is the shortcut key to send an email in Microsoft Outlook?

A) Ctrl + Enter

B) Ctrl + S

C) Ctrl + P

D) Ctrl + D

Explanation:

Ctrl + Enter is the shortcut key to send an email in Microsoft Outlook.

Explanation:

Ctrl + Enter is the shortcut key to send an email in Microsoft Outlook.

23 / 87

Which key combination is used to save a draft email in Microsoft Outlook?

A) Ctrl + S

B) Ctrl + D

C) Ctrl + P

D) Ctrl + E

Explanation:

Ctrl + S is the key combination used to save a draft email in Microsoft Outlook.

Explanation:

Ctrl + S is the key combination used to save a draft email in Microsoft Outlook.

24 / 87

How can you save a web page to your hard disk?

A) File > Save As

B) Right-click and select 'Save Page As'

C) Press Ctrl + S

D) Any of the above

Explanation:

Any of the given methods can be used to save a web page to your hard disk.

Explanation:

Any of the given methods can be used to save a web page to your hard disk.

25 / 87

Which key combination is used to stop a web page from loading?

A) Esc

B) Ctrl + F4

C) Ctrl + Shift + S

D) Ctrl + Alt + S

Explanation:

Esc is used to stop a web page from loading.

Explanation:

Esc is used to stop a web page from loading.

26 / 87

What is the shortcut key to create a new email message in Microsoft Outlook?

A) Ctrl + N

B) Ctrl + M

C) Ctrl + E

D) Ctrl + S

Explanation:

Ctrl + N is the shortcut key to create a new email message in Microsoft Outlook.

Explanation:

Ctrl + N is the shortcut key to create a new email message in Microsoft Outlook.

27 / 87

What is the function of the progress bar in a web browser?

A) To display the completion of a process

B) To show bookmarks

C) To display the URL of the web page

D) To view the title of the web page

Explanation:

The function of the progress bar in a web browser is to display the completion of a process.

Explanation:

The function of the progress bar in a web browser is to display the completion of a process.

28 / 87

How can you close the current window in most web browsers?

A) Press Alt + F4

B) Click the Close button (X) on the title bar

C) Click File > Close

D) Any of the above

Explanation:

Any of the given methods can be used to close the current window in most web browsers.

Explanation:

Any of the given methods can be used to close the current window in most web browsers.

29 / 87

Which key combination is used to open the 'Save As' dialog in most web browsers?

A) Ctrl + S

B) Ctrl + A

C) Ctrl + F

D) Ctrl + D

Explanation:

Ctrl + S is used to open the 'Save As' dialog in most web browsers.

Explanation:

Ctrl + S is used to open the 'Save As' dialog in most web browsers.

30 / 87

How can you sort email messages by date in Microsoft Outlook?

A) Open inbox, click Arrange by, and choose 'Date'

B) Click File > Sort by Date

C) Click Tools > Sort by Date

D) Click Edit > Sort by Date

Explanation:

Open inbox, click Arrange by, and choose 'Date' to sort email messages by date in Microsoft Outlook.

Explanation:

Open inbox, click Arrange by, and choose 'Date' to sort email messages by date in Microsoft Outlook.

31 / 87

How can you move an email message to a different folder?

A) Select the message, right-click, and choose 'Move'

B) Drag and drop the message to the desired folder

C) Click File > Move

D) Any of the above

Explanation:

Any of the given methods can be used to move an email message to a different folder.

Explanation:

Any of the given methods can be used to move an email message to a different folder.

32 / 87

How can you change the home page in Internet Explorer?

A) Tools > Internet Options > General > Address

B) File > Open > Home Page

C) View > Home > Change

D) Edit > Home > Address

Explanation:

Tools > Internet Options > General > Address is used to change the home page in Internet Explorer.

Explanation:

Tools > Internet Options > General > Address is used to change the home page in Internet Explorer.

33 / 87

What does SMTP stand for?

A) Simple Mail Transfer Protocol

B) Simple Message Transfer Protocol

C) Secure Mail Transfer Protocol

D) Secure Message Transfer Protocol

Explanation:

SMTP stands for Simple Mail Transfer Protocol.

Explanation:

SMTP stands for Simple Mail Transfer Protocol.

34 / 87

What is the purpose of the 'Flag' feature in Microsoft Outlook?

A) To mark an email message for follow-up

B) To delete an email message

C) To attach a file to an email message

D) To create a new email message

Explanation:

The purpose of the 'Flag' feature in Microsoft Outlook is to mark an email message for follow-up.

Explanation:

The purpose of the 'Flag' feature in Microsoft Outlook is to mark an email message for follow-up.

35 / 87

How can you create a contact group in Microsoft Outlook?

A) Click Contacts > New Contact Group

B) Click File > New Contact Group

C) Click Tools > New Contact Group

D) Click Edit > New Contact Group

Explanation:

Click Contacts > New Contact Group to create a contact group in Microsoft Outlook.

Explanation:

Click Contacts > New Contact Group to create a contact group in Microsoft Outlook.

36 / 87

What is the first part of an email address?

A) User's name

B) Domain name

C) Protocol

D) Server name

Explanation:

The first part of an email address is the user's name.

Explanation:

The first part of an email address is the user's name.

37 / 87

What does FTP stand for?

A) File Transfer Protocol

B) File Transmission Protocol

C) File Transfer Program

D) File Transmission Program

Explanation:

FTP stands for File Transfer Protocol.

Explanation:

FTP stands for File Transfer Protocol.

38 / 87

What does a URL typically start with?

A) http:// or https://

B) www

C) ftp://

D) mailto:

Explanation:

A URL typically starts with http:// or https://.

Explanation:

A URL typically starts with http:// or https://.

39 / 87

How can you download a file attached to an email in Microsoft Outlook?

A) Right-click the attachment and select 'Save As'

B) Click File > Save Attachment

C) Click Tools > Save Attachment

D) Click Edit > Save Attachment

Explanation:

Right-click the attachment and select 'Save As' to download a file attached to an email in Microsoft Outlook.

Explanation:

Right-click the attachment and select 'Save As' to download a file attached to an email in Microsoft Outlook.

40 / 87

What is a bookmark in a web browser?

A) A saved link to a web page

B) A type of search engine

C) A tool to create websites

D) A feature to edit HTML code

Explanation:

A bookmark in a web browser is a saved link to a web page.

Explanation:

A bookmark in a web browser is a saved link to a web page.

41 / 87

What software is commonly used for web servers?

A) Microsoft Excel

B) Apache

C) Microsoft Word

D) Adobe Photoshop

Explanation:

Apache is commonly used for web servers.

Explanation:

Apache is commonly used for web servers.

42 / 87

How can you flag an email message for follow-up in Microsoft Outlook?

A) Select the message, click Follow Up in the Home tab

B) Right-click the message, select Follow Up

C) Both A and B

D) Click Tools > Follow Up

Explanation:

Both A and B are correct methods to flag an email message for follow-up in Microsoft Outlook.

Explanation:

Both A and B are correct methods to flag an email message for follow-up in Microsoft Outlook.

43 / 87

Which key combination is used to open the settings or preferences in most web browsers?

A) Ctrl + , (Comma)

B) Ctrl + ;

C) Ctrl + '

D) Ctrl + L

Explanation:

Ctrl + , (Comma) is used to open the settings or preferences in most web browsers.

Explanation:

Ctrl + , (Comma) is used to open the settings or preferences in most web browsers.

44 / 87

How can you proofread an email message in Microsoft Outlook?

A) Click Review tab > Spell & Grammar

B) Click File > Spell & Grammar

C) Click Edit > Spell & Grammar

D) Click Tools > Spell & Grammar

Explanation:

Click Review tab > Spell & Grammar to proofread an email message in Microsoft Outlook.

Explanation:

Click Review tab > Spell & Grammar to proofread an email message in Microsoft Outlook.

45 / 87

Which key combination is used to open the 'Find' function in most web browsers?

A) Ctrl + F

B) Ctrl + G

C) Ctrl + H

D) Ctrl + J

Explanation:

Ctrl + F is used to open the 'Find' function in most web browsers.

Explanation:

Ctrl + F is used to open the 'Find' function in most web browsers.

46 / 87

How do you reply to an email message in Microsoft Outlook?

A) Select the message, click Reply in the Home tab

B) Double-click the message, click Reply in the Message tab

C) Select the message, press Ctrl + R

D) Any of the above

Explanation:

Any of the given methods can be used to reply to an email message in Microsoft Outlook.

Explanation:

Any of the given methods can be used to reply to an email message in Microsoft Outlook.

47 / 87

How can you search for an email message in Microsoft Outlook?

A) Type keywords in the search box in the Content Area

B) Click File > Search

C) Click Tools > Search

D) Click View > Search

Explanation:

Type keywords in the search box in the Content Area to search for an email message in Microsoft Outlook.

Explanation:

Type keywords in the search box in the Content Area to search for an email message in Microsoft Outlook.

48 / 87

Which key combination is used to cut selected text in an email message?

A) Ctrl + X

B) Ctrl + C

C) Ctrl + V

D) Ctrl + Z

Explanation:

Ctrl + X is the key combination used to cut selected text in an email message.

Explanation:

Ctrl + X is the key combination used to cut selected text in an email message.

49 / 87

What is the function of the address bar in a web browser?

A) To type URLs

B) To display bookmarks

C) To show the title of the web page

D) To view the status of downloads

Explanation:

The address bar in a web browser is used to type URLs.

Explanation:

The address bar in a web browser is used to type URLs.

50 / 87

What is the purpose of an email application?

A) To create websites

B) To send and receive emails

C) To manage databases

D) To design graphics

Explanation:

The purpose of an email application is to send and receive emails.

Explanation:

The purpose of an email application is to send and receive emails.

51 / 87

Which key combination is used to open the 'New Email' window?

A) Ctrl + N

B) Ctrl + M

C) Ctrl + E

D) Ctrl + S

Explanation:

Ctrl + N is the key combination used to open the 'New Email' window.

Explanation:

Ctrl + N is the key combination used to open the 'New Email' window.

52 / 87

How can you undelete a message from the Deleted Items folder?

A) Open 'Deleted Items' folder, right-click on the message, and select 'Move to Inbox'

B) Click File > Undelete

C) Click Tools > Undelete

D) Click Edit > Undelete

Explanation:

Open 'Deleted Items' folder, right-click on the message, and select 'Move to Inbox' to undelete a message from the Deleted Items folder.

Explanation:

Open 'Deleted Items' folder, right-click on the message, and select 'Move to Inbox' to undelete a message from the Deleted Items folder.

53 / 87

What does ISP stand for?

A) Internet Server Provider

B) Internet Service Provider

C) Internal Service Provider

D) International Service Provider

Explanation:

ISP stands for Internet Service Provider.

Explanation:

ISP stands for Internet Service Provider.

54 / 87

Which key combination is used to send an email message?

A) Ctrl + Enter

B) Ctrl + S

C) Ctrl + P

D) Ctrl + D

Explanation:

Ctrl + Enter is the key combination used to send an email message.

Explanation:

Ctrl + Enter is the key combination used to send an email message.

55 / 87

How can you open a hyperlink in a new tab using the mouse?

A) Right-click the link and select 'Open in new tab'

B) Middle-click the link

C) Ctrl + Click the link

D) Any of the above

Explanation:

Any of the given methods can be used to open a hyperlink in a new tab using the mouse.

Explanation:

Any of the given methods can be used to open a hyperlink in a new tab using the mouse.

56 / 87

How can you view the download history in most web browsers?

A) Ctrl + J

B) Ctrl + H

C) Ctrl + L

D) Ctrl + K

Explanation:

Ctrl + J is used to view the download history in most web browsers.

Explanation:

Ctrl + J is used to view the download history in most web browsers.

57 / 87

What is the shortcut to close the current tab in most web browsers?

A) Ctrl + W

B) Ctrl + F4

C) Ctrl + Q

D) Both A and B

Explanation:

Both Ctrl + W and Ctrl + F4 can be used to close the current tab in most web browsers.

Explanation:

Both Ctrl + W and Ctrl + F4 can be used to close the current tab in most web browsers.

58 / 87

How can you create a new folder in Microsoft Outlook?

A) Click Folder > New Folder

B) Click File > New Folder

C) Click Tools > New Folder

D) Click Edit > New Folder

Explanation:

Click Folder > New Folder to create a new folder in Microsoft Outlook.

Explanation:

Click Folder > New Folder to create a new folder in Microsoft Outlook.

59 / 87

How can you stop a web page from downloading?

A) Click View > Stop

B) Press the Stop button

C) Press the Esc key

D) Any of the above

Explanation:

Any of the given methods can be used to stop a web page from downloading.

Explanation:

Any of the given methods can be used to stop a web page from downloading.

60 / 87

Which of the following is a common search engine?

A) Google

B) Bing

C) Yahoo

D) All of the above

Explanation:

Google, Bing, and Yahoo are all common search engines.

Explanation:

Google, Bing, and Yahoo are all common search engines.

61 / 87

What is the structure of an email address?

A) User's name, followed by '@', followed by domain name

B) User's name, followed by '.', followed by domain name

C) User's name, followed by '-', followed by domain name

D) User's name, followed by '_', followed by domain name

Explanation:

An email address is structured as the user's name, followed by '@', followed by the domain name.

Explanation:

An email address is structured as the user's name, followed by '@', followed by the domain name.

62 / 87

How can you refresh a web page using the keyboard?

A) F2

B) F4

C) F5

D) F8

Explanation:

F5 is used to refresh a web page using the keyboard.

Explanation:

F5 is used to refresh a web page using the keyboard.

63 / 87

How can you switch between open tabs in most web browsers using the keyboard?

A) Ctrl + Tab

B) Ctrl + Shift + Tab

C) Ctrl + Page Up/Page Down

D) Any of the above

Explanation:

Any of the given methods can be used to switch between open tabs in most web browsers using the keyboard.

Explanation:

Any of the given methods can be used to switch between open tabs in most web browsers using the keyboard.

64 / 87

Which key combination is used to view the source code of a web page?

A) Ctrl + U

B) Ctrl + S

C) Ctrl + P

D) Ctrl + O

Explanation:

Ctrl + U is used to view the source code of a web page.

Explanation:

Ctrl + U is used to view the source code of a web page.

65 / 87

Which key combination is used to select the address bar in most web browsers?

A) Ctrl + L

B) Ctrl + D

C) Ctrl + P

D) Ctrl + O

Explanation:

Ctrl + L is used to select the address bar in most web browsers.

Explanation:

Ctrl + L is used to select the address bar in most web browsers.

66 / 87

Which of the following is a popular web browser?

A) Google Chrome

B) Adobe Acrobat

C) Microsoft Word

D) VLC Media Player

Explanation:

Google Chrome is a popular web browser.

Explanation:

Google Chrome is a popular web browser.

67 / 87

What is the shortcut key to zoom out in most web browsers?

A) Ctrl + Minus (-)

B) Ctrl + Plus (+)

C) Ctrl + Zero (0)

D) Ctrl + P

Explanation:

Ctrl + Minus (-) is the shortcut key to zoom out in most web browsers.

Explanation:

Ctrl + Minus (-) is the shortcut key to zoom out in most web browsers.

68 / 87

What is the main function of a web browser?

A) To create web pages

B) To browse and view web pages

C) To edit HTML code

D) To manage emails

Explanation:

The main function of a web browser is to browse and view web pages.

Explanation:

The main function of a web browser is to browse and view web pages.

69 / 87

Which key combination is used to cut selected text in an email message?

A) Ctrl + X

B) Ctrl + C

C) Ctrl + V

D) Ctrl + Z

Explanation:

Ctrl + X is the key combination used to cut selected text in an email message.

Explanation:

Ctrl + X is the key combination used to cut selected text in an email message.

70 / 87

What is the function of the 'Title Bar' in a web browser?

A) To display the title of the web page

B) To show the URL of the web page

C) To display bookmarks

D) To view the status of downloads

Explanation:

The function of the 'Title Bar' in a web browser is to display the title of the web page.

Explanation:

The function of the 'Title Bar' in a web browser is to display the title of the web page.

71 / 87

What is the primary purpose of a search engine?

A) To find information on the web

B) To create websites

C) To design graphics

D) To manage emails

Explanation:

The primary purpose of a search engine is to find information on the web.

Explanation:

The primary purpose of a search engine is to find information on the web.

72 / 87

How do you create an email signature in Microsoft Outlook?

A) Click New Email > Signature button > New

B) Click File > Signature

C) Click Tools > Signature

D) Click Edit > Signature

Explanation:

Click New Email > Signature button > New to create an email signature in Microsoft Outlook.

Explanation:

Click New Email > Signature button > New to create an email signature in Microsoft Outlook.

73 / 87

How do you open Internet Explorer from the desktop?

A) Double-click the Internet Explorer icon

B) Right-click and select Open

C) Click Start and search for Internet Explorer

D) Any of the above

Explanation:

Any of the given methods can be used to open Internet Explorer from the desktop.

Explanation:

Any of the given methods can be used to open Internet Explorer from the desktop.

74 / 87

What is the first step to configure an email account in Microsoft Outlook?

A) Click File > Account Settings > New

B) Click Tools > Options > New

C) Click Edit > Preferences > New

D) Click View > Layout > New

Explanation:

Click File > Account Settings > New is the first step to configure an email account in Microsoft Outlook.

Explanation:

Click File > Account Settings > New is the first step to configure an email account in Microsoft Outlook.

75 / 87

How can you display the bookmarks toolbar in a web browser?

A) View > Toolbars > Bookmarks Bar

B) Tools > Bookmarks > Show Bookmarks Bar

C) File > Open > Bookmarks Bar

D) Edit > Bookmarks > Show Bookmarks Bar

Explanation:

View > Toolbars > Bookmarks Bar is used to display the bookmarks toolbar in a web browser.

Explanation:

View > Toolbars > Bookmarks Bar is used to display the bookmarks toolbar in a web browser.

76 / 87

What does ISDN stand for?

A) Integrated Services Digital Network

B) International Services Digital Network

C) Internet Services Digital Network

D) Internal Services Digital Network

Explanation:

ISDN stands for Integrated Services Digital Network.

Explanation:

ISDN stands for Integrated Services Digital Network.

77 / 87

Which key combination is used to zoom in on a web page?

A) Ctrl + Plus (+)

B) Ctrl + Minus (-)

C) Ctrl + Zero (0)

D) Ctrl + P

Explanation:

Ctrl + Plus (+) is used to zoom in on a web page.

Explanation:

Ctrl + Plus (+) is used to zoom in on a web page.

78 / 87

What does HTTPS stand for?

A) HyperText Transfer Protocol Secure

B) HyperText Transfer Program Secure

C) HyperTransfer Text Protocol Secure

D) HyperTool Transfer Protocol Secure

Explanation:

HTTPS stands for HyperText Transfer Protocol Secure.

Explanation:

HTTPS stands for HyperText Transfer Protocol Secure.

79 / 87

How do you attach a file to an email in Microsoft Outlook?

A) Click Insert tab > Attach File

B) Click File > Attach File

C) Click Tools > Attach File

D) Click Edit > Attach File

Explanation:

Click Insert tab > Attach File to attach a file to an email in Microsoft Outlook.

Explanation:

Click Insert tab > Attach File to attach a file to an email in Microsoft Outlook.

80 / 87

How can you mark an email message as unread in Microsoft Outlook?

A) Select the message, right-click, and choose 'Mark as unread'

B) Click File > Mark as unread

C) Click Tools > Mark as unread

D) Click Edit > Mark as unread

Explanation:

Select the message, right-click, and choose 'Mark as unread' to mark an email message as unread in Microsoft Outlook.

Explanation:

Select the message, right-click, and choose 'Mark as unread' to mark an email message as unread in Microsoft Outlook.

81 / 87

How can you open Microsoft Outlook?

A) Click Start > All Programs > Microsoft Office > Microsoft Outlook

B) Right-click the desktop and select 'Open Outlook'

C) Press Ctrl + O

D) Click Start > Control Panel > Microsoft Outlook

Explanation:

Click Start > All Programs > Microsoft Office > Microsoft Outlook to open Microsoft Outlook.

Explanation:

Click Start > All Programs > Microsoft Office > Microsoft Outlook to open Microsoft Outlook.

82 / 87

What does POP3 stand for?

A) Post Office Protocol

B) Postal Office Protocol

C) Personal Office Protocol

D) Permanent Office Protocol

Explanation:

POP3 stands for Post Office Protocol.

Explanation:

POP3 stands for Post Office Protocol.

83 / 87

Which key combination is used to print a web page?

A) Ctrl + P

B) Ctrl + S

C) Ctrl + O

D) Ctrl + Q

Explanation:

Ctrl + P is used to print a web page.

Explanation:

Ctrl + P is used to print a web page.

84 / 87

Which key combination is used to open a new window in most web browsers?

A) Ctrl + N

B) Ctrl + T

C) Ctrl + W

D) Ctrl + F4

Explanation:

Ctrl + N is the key combination used to open a new window in most web browsers.

Explanation:

Ctrl + N is the key combination used to open a new window in most web browsers.

85 / 87

What is the function of the 'Signature' button in the Message tab?

A) To attach a file

B) To insert a signature

C) To spell check

D) To reply to an email

Explanation:

The 'Signature' button in the Message tab is used to insert a signature.

Explanation:

The 'Signature' button in the Message tab is used to insert a signature.

86 / 87

What is the shortcut key to open the Spell & Grammar check in Microsoft Outlook?

A) F7

B) F2

C) F4

D) F8

Explanation:

F7 is the shortcut key to open the Spell & Grammar check in Microsoft Outlook.

Explanation:

F7 is the shortcut key to open the Spell & Grammar check in Microsoft Outlook.

87 / 87

How can you search for a specific email message in Microsoft Outlook?

A) Type relevant keywords in the search box

B) Click File > Search

C) Click Tools > Search

D) Click Edit > Search

Explanation:

Type relevant keywords in the search box to search for a specific email message in Microsoft Outlook.

Explanation:

Type relevant keywords in the search box to search for a specific email message in Microsoft Outlook.

Your score is

FINAL-TERM EXAM

/133

CS-001 FINALS

1 / 133

In Word which of the following shortcut key combination, Save.

Shift + F12

Ctrl + Shift + F12

Alt + Shift + T

Alt + Shift + S

Explanation:

Shift + F12 is the shortcut key combination that saves in Word.

Explanation:

Shift + F12 is the shortcut key combination that saves in Word.

2 / 133

The device used to store data is called

Input device

Out put device

None of these

 Storage device

Explanation:

A storage device is used to store data.

Explanation:

A storage device is used to store data.

3 / 133

News Groups are...

provided only by large international news services

are online discussions about various topics

are only available from 9am to 5pm EST

Explanation:

News Groups are online discussions about various topics.

Explanation:

News Groups are online discussions about various topics.

4 / 133

In MS Excel data can be sorted as following ______.

Select the data, you need to sort. Go to File > Sort

None of Given

Select the data, you need to sort. Go to Edit > Sort

Select the data, you need to sort. Go to Data > Sort

Explanation:

In Microsoft Excel, you can sort data by selecting the data you want to sort and then going to the “Data” tab and choosing “Sort.” This allows you to sort your data based on the criteria you choose, such as alphabetically, numerically, or by date. The other options listed (File > Sort, None of Given, Edit > Sort) are not typically used to sort data in Excel.

Explanation:

5 / 133

Which one is a relative address?

$C$4

256

None of these

Explanation:

C4 is a relative address in Excel.

Explanation:

C4 is a relative address in Excel.

6 / 133

Relative reference is useful when we need to apply _______ types of calculations.

Striplin

Mathematical

Contigis

Same

Explanation:

7 / 133

The private combination of characters associated with a user name that allows access to certain computer resources is called a(n) ____.

audit trail

password

possessed object

biometric device

Explanation:

A password is the private combination of characters associated with a user name that allows access to certain computer resources.

Explanation:

A password is the private combination of characters associated with a user name that allows access to certain computer resources.

8 / 133

SMS stands for:

Short mail service

Short management system

Digital Angel

Short message service

Explanation:

SMS stands for Short Message Service.

Explanation:

SMS stands for Short Message Service.

9 / 133

A constant is another name for this type of data:

number

equation

formula

description

Explanation:

A constant refers to a value that does not change. In this context, it means a number.

Explanation:

A constant refers to a value that does not change. In this context, it means a number.

10 / 133

___________ will insert a new worksheet.

ALT+SHIFT+F1

ALT+SHIFT+F2

ALT+SHIFT+F3

None of these.

Explanation:

ALT+SHIFT+F1 will insert a new worksheet.

Explanation:

ALT+SHIFT+F1 will insert a new worksheet.

11 / 133

An unsolicited e-mail message sent to many recipients at once is known as ____.

Email-spyware

E-mail spam

junk mail

a Web bug

Explanation:

E-mail spam, also known as junk mail, is an unsolicited e-mail message sent to many recipients at once.

Explanation:

E-mail spam, also known as junk mail, is an unsolicited e-mail message sent to many recipients at once.

12 / 133

Spreadsheet can be used as:

Accounting

Data base

Ledger

All of above

Explanation:

Spreadsheet can be used as Accounting, Database, and Ledger.

Explanation:

Spreadsheet can be used as Accounting, Database, and Ledger.

13 / 133

The cell labeled F5 refers to

row F column 5

column F row 5

functions available in cells

Function key F4

Explanation:

The cell labeled F5 refers to column F row 5.

Explanation:

The cell labeled F5 refers to column F row 5.

14 / 133

To go to the end of the document use the following keys

Ctrl + home

Shift + Home

Shift + End

Ctrl + end

Explanation:

Ctrl + End is used to go to the end of the document.

Explanation:

Ctrl + End is used to go to the end of the document.

15 / 133

Uniform Resource Locator (URL) are...

the same as Search Engines

 the addresses of specific documents and resources on the WWW

never more than 11 characters long

All of these.

Explanation:

URLs are the addresses of specific documents and resources on the WWW.

Explanation:

URLs are the addresses of specific documents and resources on the WWW.

16 / 133

In Word which of the following shortcut key combination, decreases selected font -1pts if 12pt or lower, if above 12 decreases font by +2pt.

Ctrl + Shift + >

 Ctrl + Shift + <

Ctrl + ]

Ctrl + [

Explanation:

Ctrl + Shift + < decreases selected font -1pts if 12pt or lower, if above 12 decreases font by +2pt.

Explanation:

Ctrl + Shift + < decreases selected font -1pts if 12pt or lower, if above 12 decreases font by +2pt.

17 / 133

In Word which of the following shortcut key combination, changes the font.

Ctrl + Shift + F

Ctrl + Shift + I

Ctrl + F

Ctrl + I

Explanation:

Ctrl + Shift + F is the shortcut key combination that changes the font in Word.

Explanation:

Ctrl + Shift + F is the shortcut key combination that changes the font in Word.

18 / 133

There are three types of data found in a spreadsheet:

data, words, numbers

equations, data, numbers

words, numbers, labels

 numbers, formulas, labels

Explanation:

Numbers, formulas, and labels are the three types of data found in a spreadsheet.

Explanation:

Numbers, formulas, and labels are the three types of data found in a spreadsheet.

19 / 133

The process of converting readable data into unreadable characters to prevent unauthorized use is called ____

normalization

decryption

validation

 encryption

Explanation:

The process of converting readable data into unreadable characters to prevent unauthorized use is called encryption.

Explanation:

The process of converting readable data into unreadable characters to prevent unauthorized use is called encryption.

20 / 133

To safeguard personal information, ____

write your telephone number on credit receipts

use shopping club and buyer cards

do not reply to spam for any reason

complete all requested information on registration forms

Explanation:

Do not reply to spam for any reason to safeguard personal information.

Explanation:

Do not reply to spam for any reason to safeguard personal information.

21 / 133

A worksheet of MS Excel is divided into ______.

Figure

Objects

Rows and columns

Facts and figures

Explanation:

A worksheet in Microsoft Excel is divided into rows and columns. Rows are represented by numbers (1, 2, 3, etc.) and columns are represented by letters (A, B, C, etc.). The intersection of a row and a column is called a cell, and each cell can hold a unique piece of data, such as a number, text, or formula. The other options listed (Figure, Objects, Facts and figures) are not typically used to describe the structure of an Excel worksheet.

Explanation:

22 / 133

___________ will insert a new worksheet.

ALT+SHIFT+F1

ALT+SHIFT+F2

ALT+SHIFT+F3

None of these.

Explanation:

ALT+SHIFT+F1 will insert a new worksheet.

Explanation:

ALT+SHIFT+F1 will insert a new worksheet.

23 / 133

A ____ is a device that converts analog signals to digital signals, and vice versa.

Tablet PC

modem

microwave station

notebook computer

Explanation:

A modem is a device that converts analog signals to digital signals, and vice versa.

Explanation:

A modem is a device that converts analog signals to digital signals, and vice versa.

24 / 133

A constant is another name for this type of data:

number

equation

formula

description

Explanation:

A constant refers to a value that does not change. In this context, it means a number.

Explanation:

A constant refers to a value that does not change. In this context, it means a number.

25 / 133

Start button resides at the left side of the

Menu bar

Tool bar

Status bar

Task bar

Explanation:

The Start button resides at the left side of the Task bar.

Explanation:

The Start button resides at the left side of the Task bar.

26 / 133

Which number format option should be used in MS Excel to convert currency values from dollars to PKR?

A. General

B. Percentage

C. Scientific

D. More Number Formats

Explanation:

The "More Number Formats" option in MS Excel is used to convert currency values, such as from dollars to PKR. This option allows users to apply various custom number formats.

Explanation:

The "More Number Formats" option in MS Excel is used to convert currency values, such as from dollars to PKR. This option allows users to apply various custom number formats.

27 / 133

Which one is a relative address?

$C$4

256

None of these

Explanation:

A relative address in Excel changes when the formula is copied to another cell. C4 is an example of a relative address.

Explanation:

A relative address in Excel changes when the formula is copied to another cell. C4 is an example of a relative address.

28 / 133

A(n) ____ line typically costs $1,000 or more per month.

ISDN

ATM

 T1

Explanation:

A T1 line typically costs $1,000 or more per month.

Explanation:

A T1 line typically costs $1,000 or more per month.

29 / 133

_____ Edits the active cell and positions the insertion point at the end of the cell in Excel Sheet.

Explanation:

F2 edits the active cell and positions the insertion point at the end of the cell in Excel.

Explanation:

F2 edits the active cell and positions the insertion point at the end of the cell in Excel.

30 / 133

What do you use to create a chart?

Chart Wizard

Pie Wizard

Excel Wizard

Data Wizard

Explanation:

Chart Wizard is used to create a chart in Excel.

Explanation:

Chart Wizard is used to create a chart in Excel.

31 / 133

In excel the intersection of a row and a column is called:

data

a field.

a cell.

an equation.

Explanation:

A cell is the intersection of a row and a column in Excel.

Explanation:

A cell is the intersection of a row and a column in Excel.

32 / 133

How can you rename a worksheet in MS Excel?

A. Double-click on the worksheet tab

B. Right-click on the worksheet tab and select Rename

C. Go to the File menu and select Rename Sheet

D. Press F2 and type the new name

Explanation:

To rename a worksheet in MS Excel, right-click on the worksheet tab and select the "Rename" option from the context menu. Then, type the new name for the worksheet.

Explanation:

To rename a worksheet in MS Excel, right-click on the worksheet tab and select the "Rename" option from the context menu. Then, type the new name for the worksheet.

33 / 133

What do you use to create a chart?

Chart Wizard

Pie Wizard

Excel Wizard

Data Wizard

Explanation:

The Chart Wizard is a tool in Excel used to create charts.

Explanation:

The Chart Wizard is a tool in Excel used to create charts.

34 / 133

Which of the following describes how to select all the cells in a single column?

Right click on column and select Pick From List

Use the Data - Text to Columns menu item

Left click on the gray column title button

Pressing CTRL + A on the keyboard

Explanation:

Left click on the gray column title button to select all cells in a single column.

Explanation:

Left click on the gray column title button to select all cells in a single column.

35 / 133

Which type of chart shows the pattern or relationships between sets of data points?

Line

 Pie

Area

XY (Scatter)

Explanation:

A Pie chart shows the pattern or relationships between sets of data points.

Explanation:

A Pie chart shows the pattern or relationships between sets of data points.

36 / 133

To view properties of a folder

Press F4

Right click on folder and select properties

Double click on folder

None of the above

Explanation:

Right click on the folder and select properties to view the properties of a folder.

Explanation:

Right click on the folder and select properties to view the properties of a folder.

37 / 133

What is the purpose of saving an Excel workbook as a PDF?

A. To allow others to edit the workbook

B. To make the workbook smaller in size

C. To enable readers without MS Excel to view it

D. To convert it into a text file

Explanation:

Saving an Excel workbook as a PDF allows readers who do not have MS Excel to view the workbook. Additionally, PDFs prevent others from editing the content, ensuring the data is read-only.

Explanation:

Saving an Excel workbook as a PDF allows readers who do not have MS Excel to view the workbook. Additionally, PDFs prevent others from editing the content, ensuring the data is read-only.

38 / 133

Desktop Icon is a link to

Hardware

Software

Storage

None of these

Explanation:

Desktop Icon is a link to Software.

Explanation:

Desktop Icon is a link to Software.

39 / 133

In Word which of the following shortcut key combination, changes the font.

Ctrl + Shift + F

Ctrl + Shift + I

Ctrl + F

Ctrl + I

Explanation:

Ctrl + Shift + F is the shortcut key combination that changes the font in Word.

Explanation:

Ctrl + Shift + F is the shortcut key combination that changes the font in Word.

40 / 133

Which will select all the cells in a document?

Clicking three times with the right mouse button in the spreadsheet

Using the Edit - Select All menu item

ALT+SHIFT+F1

ALT+SHIFT+F2

Explanation:

Using the Edit - Select All menu item will select all the cells in a document.

Explanation:

Using the Edit - Select All menu item will select all the cells in a document.

41 / 133

Which will select all the cells in a document?

Clicking three times with the right mouse button in the spreadsheet

Using the Edit - Select All menu item

Pressing CTRL + A on the keyboard

None of these

Explanation:

Pressing CTRL + A on the keyboard will select all the cells in a document.

Explanation:

Pressing CTRL + A on the keyboard will select all the cells in a document.

42 / 133

Which will not select all the cells in a document?

Clicking three times with the right mouse button in the spreadsheet

Using the Edit - Select All menu item

Pressing CTRL + A on the keyboard

None of these

Explanation:

Clicking three times with the right mouse button in the spreadsheet will not select all the cells in a document.

Explanation:

Clicking three times with the right mouse button in the spreadsheet will not select all the cells in a document.

43 / 133

To remove the contents of several cells at once, you can ______.

Select the cells and drag the fill handle back up over them

Select the cells and choose Edit | Clear … | Contents

Select the cells and press DELETE

Press Esc button

Explanation:

In most spreadsheet software like Microsoft Excel or Google Sheets, if you want to clear the contents of multiple cells at once, you can select those cells and press the “DELETE” key. This will remove any data, formulas, or contents that are in the selected cells. The other options listed have different functions. For example, dragging the fill handle over cells copies the content or applies a pattern, choosing Edit | Clear … | Contents from the menu also clears the contents but involves more steps, and pressing the “Esc” button cancels the current cell entry.

Explanation:

44 / 133

Which will select all the cells in a document?

Clicking three times with the right mouse button in the spreadsheet

Using the Edit - Select All menu item

Pressing CTRL + A on the keyboard

None of these

Explanation:

Pressing CTRL + A on the keyboard will select all the cells in a document.

Explanation:

Pressing CTRL + A on the keyboard will select all the cells in a document.

45 / 133

Which one is not a relational operator in the given options?

()

Explanation:

In programming, relational operators are used to compare values and return a boolean result (either true or false). The operators “<=”, “=”, and “:” are all used in various programming languages for comparison or assignment. However, the “()” symbols are not a relational operator. They are typically used for grouping expressions or declaring function parameters, depending on the context. Therefore, they do not fit the category of relational operators.

Explanation:

46 / 133

What is the format of a spreadsheet?

Round

Rows and Columns

Square

Wide

Explanation:

Spreadsheets are organized into rows and columns to easily manage and analyze data.

Explanation:

Spreadsheets are organized into rows and columns to easily manage and analyze data.

47 / 133

Which formula can add all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell?

Count

Average

Sum

None of these

Explanation:

The SUM formula can add all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell.

Explanation:

The SUM formula can add all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell.

48 / 133

What is the keyboard shortcut (button or buttons to be pressed) for creating a Chart from the selected cells?

Explanation:

F3 is the keyboard shortcut for creating a Chart from the selected cells.

Explanation:

F3 is the keyboard shortcut for creating a Chart from the selected cells.

49 / 133

On an Excel sheet the active cell is indicated by ____.

a dark wide border

a dotted border

a blinking border

All of these

Explanation:

The active cell in Excel is indicated by a dark wide border.

Explanation:

The active cell in Excel is indicated by a dark wide border.

50 / 133

____ refers to the amount of data, instructions, and information that can travel over a communications channel.

Transfer rate

Bandwidth

Broadband

Explanation:

Bandwidth refers to the amount of data, instructions, and information that can travel over a communications channel.

Explanation:

Bandwidth refers to the amount of data, instructions, and information that can travel over a communications channel.

51 / 133

Columns of MS Excel are represented by ______.

Names

Numbers

Alphabets

Marks

Explanation:

52 / 133

Which function calculates the largest value in a set of numbers?

Average

Count

Min

Max

Explanation:

The MAX function calculates the largest value in a set of numbers in Excel.

Explanation:

The MAX function calculates the largest value in a set of numbers in Excel.

53 / 133

Which of the following is primary storage?

Hard disk

Floppy disk

 RAM

Optical disk

Explanation:

RAM is primary storage.

Explanation:

RAM is primary storage.

54 / 133

The act of defecting or destroying computer equipment is known as ____

hardware vandalism

software piracy

hardware theft

information theft

Explanation:

Hardware vandalism is the act of defecting or destroying computer equipment.

Explanation:

Hardware vandalism is the act of defecting or destroying computer equipment.

55 / 133

What is the format of a spreadsheet?

Round

Rows and Columns

Square

Wide

Explanation:

The format of a spreadsheet is rows and columns.

Explanation:

The format of a spreadsheet is rows and columns.

56 / 133

In excel the intersection of a row and a column is called:

data

a field.

a cell.

an equation.

Explanation:

A cell is the intersection of a row and a column in Excel.

Explanation:

A cell is the intersection of a row and a column in Excel.

57 / 133

A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of events that will do this?

Go to FILE - SAVE AS - SAVE AS TYPE - Excel 4.0 Work Sheet

 Right click on the spreadsheet tab and select DELETE

Right click on the spreadsheet and select INSERT - ENTIRE COLUMN

None of these

Explanation:

Right click on the spreadsheet tab and select DELETE to remove a spreadsheet from a workbook.

Explanation:

Right click on the spreadsheet tab and select DELETE to remove a spreadsheet from a workbook.

58 / 133

In MS Excel, how can you delete the contents of a cell without removing the cell itself?

A. Press Backspace

B. Right-click the cell and select Delete

C. Select the cell and press DELETE

D. Click on Clear and select Clear Contents from the drop-down list

Explanation:

To delete the contents of a cell without removing the cell itself, you can click on the Clear option from the Home tab and then select Clear Contents from the drop-down list. Pressing DELETE or Backspace also deletes cell contents, but the correct procedure as described in the content involves using the Clear Contents option.

Explanation:

59 / 133

Which of the following is NOT a part of the MS Excel interface?

A. Quick Access Toolbar

B. Ribbon Bar

C. Start Menu

D. Name Box

Explanation:

The Start Menu is part of the operating system interface, not specific to MS Excel. The Quick Access Toolbar, Ribbon Bar, and Name Box are all components of the MS Excel interface, providing access to various commands and functions within the software.

Explanation:

60 / 133

What is the keyboard shortcut (button or buttons to be pressed) for creating a Chart from the selected cells?

Explanation:

F3 is the keyboard shortcut for creating a Chart from the selected cells.

Explanation:

F3 is the keyboard shortcut for creating a Chart from the selected cells.

61 / 133

____ refers to the amount of data, instructions, and information that can travel over a communications channel.

Latency

Transfer rate

Bandwidth

Broadband

Explanation:

Bandwidth refers to the amount of data, instructions, and information that can travel over a communications channel.

Explanation:

Bandwidth refers to the amount of data, instructions, and information that can travel over a communications channel.

62 / 133

What feature in MS Excel allows you to view the complete content of a cell even if it overflows beyond the cell boundaries?

A. Text Wrap

B. Merge Cells

C. Alignment

D. Format Painter

Explanation:

63 / 133

The cell labeled F5 refers to

row F column 5

column F row 5

functions available in cells

Explanation:

The cell labeled F5 refers to column F row 5.

Explanation:

The cell labeled F5 refers to column F row 5.

64 / 133

In excel the intersection of a row and a column is called:

data

a field.

a cell.

an equation.

Explanation:

The correct term is a cell, which is the intersection of a row and a column in Excel.

Explanation:

The correct term is a cell, which is the intersection of a row and a column in Excel.

65 / 133

Which one is a relative address?

$C$4

256

None of these

Explanation:

C4 is a relative address in Excel.

Explanation:

C4 is a relative address in Excel.

66 / 133

Storage is also referred as

Data

Instructions

Files

Memory

Explanation:

Storage is also referred as Memory.

Explanation:

Storage is also referred as Memory.

67 / 133

____ is the transmission of messages and files via the Internet.

FTP

Video conferencing

E-mail

Instant messaging

Explanation:

E-mail is the transmission of messages and files via the Internet.

Explanation:

E-mail is the transmission of messages and files via the Internet.

68 / 133

What program do you use to create a spreadsheet?

Word

 Excel

Access

PowerPoint

Explanation:

Excel is the program used to create a spreadsheet.

Explanation:

Excel is the program used to create a spreadsheet.

69 / 133

In Word which of the following shortcut key combination moves the cursor to the beginning of the document.

Ctrl + Backspace

Ctrl + Page Up

Ctrl + Home

Ctrl + End

Explanation:

Ctrl + Home moves the cursor to the beginning of the document in Word.

Explanation:

Ctrl + Home moves the cursor to the beginning of the document in Word.

70 / 133

____ are shortcuts to a location on a Web server to which users publish documents and other files.

Chat rooms

Newsgroups

Video conferences

Web folders

Explanation:

Web folders are shortcuts to a location on a Web server to which users publish documents and other files.

Explanation:

Web folders are shortcuts to a location on a Web server to which users publish documents and other files.

71 / 133

How can you modify the Ribbon or Quick Access Toolbar in MS Excel?

A. Click on the File tab and select Options

B. Right-click on the Ribbon and select Customize the Ribbon

C. Use the Save As option

D. Open the Format Cells dialog box

Explanation:

72 / 133

Which of the following describes how to select all the cells in a single column?

Right click on column and select Pick From List

Use the Data - Text to Columns menu item

Left click on the gray column title button

Pressing CTRL + A on the keyboard

Explanation:

Left click on the gray column title button to select all cells in a single column.

Explanation:

Left click on the gray column title button to select all cells in a single column.

73 / 133

How do you print a worksheet in landscape style in MS Excel?

A. Select Print from the File menu, then choose Landscape under Page Layout

B. Go to the Home tab, then select Landscape from the Layout options

C. Click on File, then Print, and choose Landscape from the Page Setup options

D. Click on Insert, then choose Landscape from the Page Orientation options

Explanation:

74 / 133

News Groups are...

provided only by large international news services

are online discussions about various topics

are only available from 9am to 5pm EST

All of these

Explanation:

News Groups are online discussions about various topics.

Explanation:

News Groups are online discussions about various topics.

75 / 133

What is the default file format for MS Excel 2010?

A. .XLS

B. .XLSX

C. .CSV

D. .TXT

Explanation:

The default file format for MS Excel 2010 is .XLSX. This format is used for storing Excel workbooks and supports more advanced features compared to the older .XLS format.

Explanation:

The default file format for MS Excel 2010 is .XLSX. This format is used for storing Excel workbooks and supports more advanced features compared to the older .XLS format.

76 / 133

On an Excel sheet the active cell is indicated by ____.

a dark wide border

a dotted border

a blinking border

All of these

Explanation:

A dark wide border indicates the active cell on an Excel sheet.

Explanation:

A dark wide border indicates the active cell on an Excel sheet.

77 / 133

A(n) ____ line has transfer rates of 128 Kbps to 8.45 Mbps.

DSL

ISDN

ATM

Fractional T1

Explanation:

A DSL line has transfer rates of 128 Kbps to 8.45 Mbps.

Explanation:

A DSL line has transfer rates of 128 Kbps to 8.45 Mbps.

78 / 133

The act of defecting or destroying computer equipment is known as ____.

hardware vandalism

software piracy

hardware theft

information theft

Explanation:

Hardware vandalism refers to the act of defecting or destroying computer equipment.

Explanation:

Hardware vandalism refers to the act of defecting or destroying computer equipment.

79 / 133

Tab key is a

Non-typing key

 Typing key

Toggle key

Application key

Explanation:

The Tab key is a typing key.

Explanation:

The Tab key is a typing key.

80 / 133

Pressing the key once and releasing it is called a

Key stroke

Key strike

Key action

None of these

Explanation:

A keystroke refers to pressing the key once and releasing it.

Explanation:

A keystroke refers to pressing the key once and releasing it.

81 / 133

_______Displays the Help task pane.

None of these

Explanation:

F1 displays the Help task pane.

Explanation:

F1 displays the Help task pane.

82 / 133

What is the format of a spreadsheet?

Round

Rows and Columns

Square

Wide

Explanation:

The format of a spreadsheet is rows and columns.

Explanation:

The format of a spreadsheet is rows and columns.

83 / 133

What is the keyboard shortcut (button or buttons to be pressed) for creating a Chart from the selected cells ?

 F5

Explanation:

F5 is the keyboard shortcut for creating a Chart from the selected cells.

Explanation:

F5 is the keyboard shortcut for creating a Chart from the selected cells.

84 / 133

Which of the following operations is performed using the caret (^) symbol in MS Excel?

A. Addition

B. Subtraction

C. Multiplication

D. Exponentiation

Explanation:

In MS Excel, the caret (^) symbol is used for exponentiation, which means raising a number to the power of another number. For example, 2^3 calculates 2 raised to the power of 3.

Explanation:

In MS Excel, the caret (^) symbol is used for exponentiation, which means raising a number to the power of another number. For example, 2^3 calculates 2 raised to the power of 3.

85 / 133

E-mail stands for

electronic mail

the print out from a fax machine

a letter printed from a computer

Explanation:

E-mail stands for electronic mail.

Explanation:

E-mail stands for electronic mail.

86 / 133

In MS Excel, what command should you use when saving a file for the first time or saving it in a different version?

A. Save

B. Save As

C. Export

D. Backup

Explanation:

87 / 133

Which key displays the Help task pane in MS Excel?

Explanation:

In Microsoft Excel, and most other software, pressing the “F1” key opens the Help pane. This is a standard convention across many applications and operating systems. The Help pane provides access to all available documentation and resources to assist users in using the software effectively. The other keys listed (F4, F3, F2) have different functions in Excel. For example, “F2” is used for editing the active cell, “F3” is used to display the Paste Name dialog box, and “F4” repeats the last command or action, if possible.

Explanation:

88 / 133

To safeguard personal information, ____

write your telephone number on credit receipts

use shopping club and buyer cards

do not reply to spam for any reason

complete all requested information on registration forms

Explanation:

To safeguard personal information, do not reply to spam for any reason.

Explanation:

To safeguard personal information, do not reply to spam for any reason.

89 / 133

What do you use to create a chart?

Chart Wizard

Pie Wizard

Excel Wizard

Data Wizard

Explanation:

The Chart Wizard is a tool in Excel used to create charts.

Explanation:

The Chart Wizard is a tool in Excel used to create charts.

90 / 133

How does MS Excel typically represent a date like ¼?

A. 1/4

B. April 1

C. 4-Jan

D. January 4

Explanation:

In MS Excel, when entering a fraction like ¼, it is typically interpreted as 4-Jan by default. This is due to Excel's automatic conversion of certain inputs to date formats.

Explanation:

In MS Excel, when entering a fraction like ¼, it is typically interpreted as 4-Jan by default. This is due to Excel's automatic conversion of certain inputs to date formats.

91 / 133

Which is an absolute address?

$C$4

10700 - 105 Ave.

None of these

Explanation:

An absolute address in Excel is denoted by the dollar sign before both the column letter and the row number, such as $C$4.

Explanation:

An absolute address in Excel is denoted by the dollar sign before both the column letter and the row number, such as $C$4.

92 / 133

A network that uses the same lines that bring electricity into a house is called a(n) ____.

Ethernet network

Powerline cable network

Phoneline network

HomeRF network

Explanation:

A Powerline cable network uses the same lines that bring electricity into a house.

Explanation:

A Powerline cable network uses the same lines that bring electricity into a house.

93 / 133

What is the function of the Formula Bar in MS Excel?

A. It shows the name of the selected cell

B. It is used to insert charts and graphs

C. It is used to edit or change data by using formulas or text

D. It displays the number of cells in a worksheet

Explanation:

94 / 133

Windows is software developed by

Sun

Java

Html

Microsoft

Explanation:

Windows is software developed by Microsoft.

Explanation:

Windows is software developed by Microsoft.

95 / 133

In Word which of the following shortcut key combination, Save.

Shift + F12

Ctrl + Shift + F12

Alt + Shift + T

Alt + Shift + S

Explanation:

Shift + F12 is the shortcut key combination that saves in Word.

Explanation:

Shift + F12 is the shortcut key combination that saves in Word.

96 / 133

Windows is software developed by

Sun

Microsoft

Explanation:

Windows is software developed by Microsoft.

Explanation:

Windows is software developed by Microsoft.

97 / 133

If you press ____________, the cell accepts your typing as its contents.

Tab

Esc

Enter

Back-Space

Explanation:

In most spreadsheet or data entry software, pressing the “Enter” key will finalize your input into a cell. This means that whatever you have typed into the cell will be accepted as its contents. The “Enter” key essentially tells the software that you have finished typing and are ready to move on to the next cell or task. The other keys listed (Tab, Esc, Back-Space) have different functions. For example, “Tab” usually moves the cursor to the next cell, “Esc” cancels the current entry, and “Back-Space” deletes the character before the cursor.

Explanation:

98 / 133

The process of converting readable data into unreadable characters to prevent unauthorized use is called ____

normalization

decryption

validation

encryption

Explanation:

Encryption is the process of converting readable data into unreadable characters to prevent unauthorized use.

Explanation:

Encryption is the process of converting readable data into unreadable characters to prevent unauthorized use.

99 / 133

How do you create a formula using cell references in MS Excel?

A. Select the cell and type the values directly

B. Select the cell and write the cell name followed by its value

C. Write the cell name directly in the Name Box

D. Press Enter and then type the values

Explanation:

100 / 133

To copy data in MS Excel, you can ______.

Press Ctrl+Y

Press Ctrl+C

Press Alt+C

Press Ctrl+D

Explanation:

In Microsoft Excel, and most other software, the keyboard shortcut to copy data is “Ctrl+C”. This command copies the selected data onto the clipboard, allowing it to be pasted elsewhere with the “Ctrl+V” command. The other options listed have different functions. For example, “Ctrl+Y” is typically used to redo an action, “Alt+C” may not have a predefined function in Excel, and “Ctrl+D” is used to fill down.

Explanation:

101 / 133

The process of converting readable data into unreadable characters to prevent unauthorized use is called ____

normalization

decryption

validation

encryption

Explanation:

Encryption is the process of converting readable data into unreadable characters to prevent unauthorized use.

Explanation:

Encryption is the process of converting readable data into unreadable characters to prevent unauthorized use.

102 / 133

Which is an absolute address?

$C$4

10700 - 105 Ave.

None of these

Explanation:

An absolute address in Excel is denoted by the dollar sign before both the column letter and the row number, such as $C$4.

Explanation:

An absolute address in Excel is denoted by the dollar sign before both the column letter and the row number, such as $C$4.

103 / 133

Which of the following is intangible?

 Software

Hard disk

Optical disk

Computer Mouse

Explanation:

Software is intangible.

Explanation:

Software is intangible.

104 / 133

To safeguard personal information, ____

write your telephone number on credit receipts

use shopping club and buyer cards

do not reply to spam for any reason

complete all requested information on registration forms

Explanation:

Do not reply to spam for any reason to safeguard personal information.

Explanation:

Do not reply to spam for any reason to safeguard personal information.

105 / 133

What is the purpose of freezing panes in an Excel worksheet?

A. To prevent changes to the worksheet

B. To highlight certain cells

C. To keep rows or columns visible while scrolling

D. To change the color of the worksheet tab

Explanation:

106 / 133

In Word which of the following shortcut key combination repeats the last action performed (Word 2000+)

Explanation:

F4 repeats the last action performed in Word (Word 2000+).

Explanation:

F4 repeats the last action performed in Word (Word 2000+).

107 / 133

Which will not select all the cells in a document?

Clicking three times with the right mouse button in the spreadsheet

Using the Edit - Select All menu item

Pressing CTRL + A on the keyboard

None of these

Explanation:

Clicking three times with the right mouse button in the spreadsheet will not select all the cells in a document.

Explanation:

Clicking three times with the right mouse button in the spreadsheet will not select all the cells in a document.

108 / 133

The ____ assigns and controls top-level domains.

DNS server

Internet Corporation for Assigned Names and Numbers (ICANN)

World Wide Web Consortium (W3C)

National Science Foundation

Explanation:

The Internet Corporation for Assigned Names and Numbers (ICANN) assigns and controls top-level domains.

Explanation:

The Internet Corporation for Assigned Names and Numbers (ICANN) assigns and controls top-level domains.

109 / 133

Which button on the standard toolbar gives you quick access to the Sum, Average, Count, Min, and Max functions?

Sum Button

Explanation:

The Sum button on the standard toolbar gives you quick access to the Sum, Average, Count, Min, and Max functions.

Explanation:

The Sum button on the standard toolbar gives you quick access to the Sum, Average, Count, Min, and Max functions.

110 / 133

_______Displays the Help task pane.

None of these

Explanation:

F1 displays the Help task pane.

Explanation:

F1 displays the Help task pane.

111 / 133

Which tab on the Ribbon bar do you use to access the Merge and Center option in MS Excel?

A. File

B. Home

C. Insert

D. View

Explanation:

The Merge and Center option is found under the Home tab on the Ribbon bar in MS Excel. This feature allows users to merge selected cells into one cell and center the content within the new cell.

Explanation:

The Merge and Center option is found under the Home tab on the Ribbon bar in MS Excel. This feature allows users to merge selected cells into one cell and center the content within the new cell.

112 / 133

_______Repeats the last command or action, if possible in excel.

 F4

Explanation:

F4 repeats the last command or action in Excel.

Explanation:

F4 repeats the last command or action in Excel.

113 / 133

What is the purpose of the Name Box in MS Excel?

A. To insert a new worksheet

B. To show the address of the selected cell

C. To create a chart

D. To save the workbook

Explanation:

The Name Box in MS Excel shows the address of the selected cell. It displays the reference of the active cell and can also be used to name cell ranges for easier navigation and reference.

Explanation:

The Name Box in MS Excel shows the address of the selected cell. It displays the reference of the active cell and can also be used to name cell ranges for easier navigation and reference.

114 / 133

What do you use to create a chart?

Chart Wizard

Pie Wizard

Excel Wizard

Data Wizard

Explanation:

Chart Wizard is used to create a chart in Excel.

Explanation:

Chart Wizard is used to create a chart in Excel.

115 / 133

To enter capital characters use

Num lock

Pause lock

Caps lock

Scroll lock

Explanation:

Use Caps lock to enter capital characters.

Explanation:

Use Caps lock to enter capital characters.

116 / 133

An assault on a computer whose purpose is to disrupt access to the Web is called a ____.

virus

DoS attack

worm

DDoS attack

Explanation:

A DoS attack is an assault on a computer whose purpose is to disrupt access to the Web.

Explanation:

A DoS attack is an assault on a computer whose purpose is to disrupt access to the Web.

117 / 133

The act of defecting or destroying computer equipment is known as ____

hardware vandalism

software piracy

hardware theft

information theft

Explanation:

Hardware vandalism is the act of defecting or destroying computer equipment.

Explanation:

Hardware vandalism is the act of defecting or destroying computer equipment.

118 / 133

What displays the contents of the active cell?

Name Box

Row Headings

Formula Bar

Task Pane

Explanation:

The Formula Bar in Excel displays the contents of the active cell.

Explanation:

The Formula Bar in Excel displays the contents of the active cell.

119 / 133

In Word which of the following shortcut key combination opens the Task Pane.

Ctrl + F1

Ctrl + F2

Ctrl + F3

Ctrl + F4

Explanation:

Ctrl + F1 opens the Task Pane in Word.

Explanation:

Ctrl + F1 opens the Task Pane in Word.

120 / 133

On an Excel sheet the active cell is indicated by ____.

a dark wide border

a dotted border

a blinking border

All of these

Explanation:

A dark wide border indicates the active cell on an Excel sheet.

Explanation:

A dark wide border indicates the active cell on an Excel sheet.

121 / 133

The ____ standard defines how data transmits across telephone lines or other means.

TCP/IP

EDI (Electronic Data Interchange)

Electronic funds transfer (EFT)

 Ethernet

Explanation:

Ethernet defines how data transmits across telephone lines or other means.

Explanation:

Ethernet defines how data transmits across telephone lines or other means.

122 / 133

A ____ is a device that converts analog signals to digital signals, and vice versa.

Tablet PC

modem

microwave station

notebook computer

Explanation:

A modem is a device that converts analog signals to digital signals, and vice versa.

Explanation:

A modem is a device that converts analog signals to digital signals, and vice versa.

123 / 133

Spreadsheet can be used as:

Accounting

Data base

Ledger

All of above

Explanation:

Spreadsheet can be used as Accounting, Database, and Ledger.

Explanation:

Spreadsheet can be used as Accounting, Database, and Ledger.

124 / 133

Which symbol is used to begin all formulas in MS Excel?

A. +

B. =

C. *

D. /

Explanation:

All formulas in MS Excel begin with an equal sign (=). This tells Excel that the following characters constitute a formula or function.

Explanation:

All formulas in MS Excel begin with an equal sign (=). This tells Excel that the following characters constitute a formula or function.

125 / 133

____ refers to the amount of data, instructions, and information that can travel over a communications channel.

Latency

Transfer rate

Bandwidth

Broadband

Explanation:

Bandwidth refers to the amount of data, instructions, and information that can travel over a communications channel.

Explanation:

Bandwidth refers to the amount of data, instructions, and information that can travel over a communications channel.

126 / 133

A device that contains surge protection circuits and one or more batteries that can provide power during a temporary or permanent loss of power is called a(n) ____.

surge protector

generator

surge suppressor

uninterruptible power supply (UPS)

Explanation:

An uninterruptible power supply (UPS) contains surge protection circuits and one or more batteries that can provide power during a temporary or permanent loss of power.

Explanation:

An uninterruptible power supply (UPS) contains surge protection circuits and one or more batteries that can provide power during a temporary or permanent loss of power.

127 / 133

Desktop Icon is a link to

Hardware

Software

Storage

None of these

Explanation:

Desktop Icon is a link to Software.

Explanation:

Desktop Icon is a link to Software.

128 / 133

The spelling can be verified using the Spelling option in ______ tab.

Home

Review

Data

File

Explanation:

129 / 133

What is the main purpose of a spreadsheet in Microsoft Excel?

A. To create text documents

B. To design web pages

C. To calculate numeric data and apply different formats on data

D. To edit photos

Explanation:

The main purpose of a spreadsheet in Microsoft Excel is to calculate numeric data and to apply various formats to that data. Excel provides tools for data analysis, calculation, and visualization, making it ideal for handling numerical information. The other options (creating text documents, designing web pages, editing photos) are not primary functions of Excel.

Explanation:

130 / 133

To enter capital characters use

Num lock

Pause lock

Caps lock

Scroll lock

Explanation:

Use Caps lock to enter capital characters.

Explanation:

Use Caps lock to enter capital characters.

131 / 133

What does the Compatibility View in MS Excel do?

A. Enables all new and advanced features of MS Excel

B. Disables old features and enables new features

C. Enables all old features and disables new and advanced features

D. Creates a backup of the Excel file

Explanation:

132 / 133

A(n) ____ line has transfer rates of 128 Kbps to 8.45 Mbps.

DSL

ISDN

ATM

Fractional T1

Explanation:

A DSL line has transfer rates of 128 Kbps to 8.45 Mbps.

Explanation:

A DSL line has transfer rates of 128 Kbps to 8.45 Mbps.

133 / 133

Storage is also referred as

Data

Instructions

Files

Memory

Explanation:

Storage is also referred as Memory.

Explanation:

Storage is also referred as Memory.

Your score is

START READING