Spreadsheet
Which function counts the number of numeric values in a range?
COUNT
Which of the following can be termed ‘application software’?
DOS
Linux
Mac Os
Internet Explorer
Internet Explorer
Which secondary storage device has no moving parts and is more resistant to physical shock?
What is SSD (Solid State Drive)
Name any two pointing input devices
What are Mouse, trackball, touchpad
What is the primary purpose of the CPU
To process data
Which symbol MUST be placed in front of the column letter and row number to create an absolute reference?
$
Which of the following could NOT be classified as a cloud- based application?
Gmail
One Drive
Google Drive
Windows OS
Windows OS
Which type of memory is considered volatile memory
RAM
Name Two devices that produce soft copy output
Name a type of computer that is portable
Laptop
What type of cell addressing must be used to keep the cell address in a formula the same, when the cell address is copied to another cell?
Absolute
Which of the following are NOT categorized as system software?
Microsoft Office
Operating Systems
Utility software
Device Drivers
Microsoft Office
Which of the following is an example of an optical device?
Hard disk
DVD
USB flash drive
Magnetic Tape
DVD
The device used for printing industrial quality architectural drawings is the __________
Plotter
Data that has been processed and has meaning is termed___________
information
What is the purpose of a pie chart in a spreadsheet?
To compare individual parts of a whole
What is software?
A set of instructions that tells the computer how to perform tasks
Name the smallest unit of data storage
Bit
Which of the following types of technologies is commonly used by banks to read data on cheques?
POS
OCR
OMR
MICR
MICR
Which of the following is NOT a hardware component of the computer system?
Data file
Main Memory
Peripheral Device
Central processing unit
Data file
What is the primary purpose of the IF function in a spreadsheet?
To test a condition and return different results based on the outcome
Which type of software is used to manage the hardware of a computer?
Application
System
System
The primary storage device that holds the data currently being processed by the computer is known as the _____________
RAM
Name a device that can be used for both input and output?
Touchscreen
Which of the following are considered computer hardware?
Data
Programs
Output devices
Operating systems
Output devices