Information Technology Final Quiz

Which type of user interface requires typing commands to perform tasks?

• Command line interface

• Graphical user interface

• Menu-driven interface

• Touch interface

Which function would you use to find the average of a range of numbers?

• SUM

• MAX

• MIN

• AVERAGE

Which of the following is NOT a part of the IPOS cycle?

• Input

• Processing

• Output

• Compression

Which command line interface feature requires precise syntax to execute commands?

• Menu-driven options

• Point-and-click functionality

• Text-based commands

• Voice recognition

What does the VLOOKUP function do?

• Finds the largest number in a range

• Searches for a value in a table and returns a corresponding value

• Counts the number of cells in a range

• Adds all the numbers in a range

Which term refers to a collection of related worksheets in a spreadsheet program?

• Cell

• Column

• Workbook

• Range

Which storage option is more likely to require a continuous internet connection?

• Local storage

• External hard drive

• USB flash drive

• Cloud storage

Which of the following is least important for web browsing?

• High processing speed

• Fast internet connection

• Large memory (RAM)

• High-quality graphics card

What type of software is an operating system?

• Application software

• System software

• Utility software

• Custom software

Which type of storage is typically faster but more expensive per gigabyte?

• Cloud storage

• Hard disk drive (HDD)

• Solid-state drive (SSD)

• USB flash drive