NEW
Font size
WorksheetsMONTHLY TEST (IT-402)
Total questions: 20
Worksheet time: 16mins
Excel refers to files as
Documents
Workbooks
data bases
File
If I want to find an average of cells A1 through A25, which formula would I use?
=average(A1:A25)
=avg(A1:A25)
=average(A1-A25)
=avg(A1-A25)
What is the best formula for finding the total value for cells B2 through B5?
=13.5+6.08+7.53+45.1
=B2+B3+B4+B5
=SUM(B2:B5)
=B1++B5
Look at the image. What is the range that is selected?
A1:A9
A1:C9
A2:C9
B1:C9
These can be used to connect almost any type of device, including mice, keyboards, printers, and digital cameras.
Audio In
Audio Out
USB Port
Monitor Port
The ______ is where your software, documents, and other files are stored. It long-term storage, which means the data is still saved even if you turn the computer off or unplug it.
RAM
USB
Hard Drive
Storage Drive
An _____________ is the most important software that runs on a computer. It manages the computer's memory and processes, as well as all of its software and hardware.
Banana
Hardware
Software
Operating System
To guard against malware, you will need to have ________.
antivirus software
a word processor
a can of compressed air
spyware
