NEW
Font size
WorksheetsData Security and Excel
Total questions: 50
Worksheet time: 28mins
Most viruses stay active until you turn___the computer.
Off
On
None of the above
A computer infected with a computer virus may run_____ than normal.
Slower
faster
normal
all of the above
______ is short for malicious software.
Malware
Trojan Horse
Spyware
A _______ is a program that appears useful, but is actually programmed to pass on the user’s data to someone else.
Trojan Horse
Macro
Data
Boot
An antivirus program should run in the background at all times
True
False
It is a software program that helps keep out hackers, viruses, and worms
Firewall.
Norton Antivirus and Quick Heal Total Security
What is an example of a firewall?
When someone tries to hack your computer
When a certain website might be blocked
Stealing a password
It's literally a wall on fire...easy
What is a Trojan virus?
A story from Greek mythology
Something that can break your computer
When you download an app and it's actually a virus
A virus only made by hackers
How are viruses made?
Computer programming that breaks into a computer's way of working
In factories
They are made by Apple and Microsoft
Computer germs
Malware is software that is specifically designed to disrupt, damage, or gain unauthorised access to a computer system.
True
False
What is Malware?
Bad computer equipment
Pop up adverts on your computer
Software designed to do harm to a computer
Fake web sites
What most defines a computer virus?
It crashes computers
It can copy itself and spread to other computers
It can spy on what you do
It cannot be fixed
What is Ransomware?
Software that sends scam emails
Software that copies itself
Software that you think is good software but isn't
Software that hides your data and demands payment to release it
How is a Worm different from other viruses
It does more harm
It can spread without a user doing anything
It can't spread without a user doing something
It doesn't do any harm
Microsoft Excel is what kind of software?
Word Processing Software
Spreadsheet Software
Database Software
Presentation Software
The letters in Excel represent the...
Rows
Columns
Cells
Data
The numbers in Excel represent the...
Rows
Columns
Cells
Data
Letters of the alphabet going across the top of the spreadsheet.
Title Bar
Column Labels
Row Labels
Status Bar
Numbers down the left side of the spreadsheet.
Status Bar
Formula Bar
Column Labels
Row Labels
What is this icon?
Zoom
Sort and Filter
Symbol
Merge and Center
The cell address of the highlighted cell is
C
4
A4
C4
These are known as
workbooks
worksheets
formula bar
cell
To alert Excel that you are entering a formula and not text, type a(n) ____________ preceding the formula.
&
=
#
*
What is the cell in the worksheet in which you can type data?
Main cell
Open cell
Active cell
Absolute cell
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)
Numbers in Excel are automatically aligned ____________?
Left
Right
Center
Justified
Which of these would multiply the numbers from A3 to A6
*(A3:A6)
=Multiplay(A3:A6)
=A3*A4*A5*A6
=Sum(a3*a6)
What do you call the blank boxes on a excel sheet
cell
info
Squares
Spots
How do you make a cell into the active cell
Cells are always active
Click INSERT Cell
Click on the Cell
Click the ACTIVE button
What is the name of this Cell ?
6B
A5
6A
B6
To sort names in a worksheet, we can use ____ button
Which of the following formulas below illustrates the correct function to create the Sum (Range)?
=SUM(
=SUM(Range)
SUM=(Range)
_____ (Range) function in Excel returns the number of cells that contain numbers in a given range.
COUNTA
COUNT
COUNTBLANK
COUNTIFS
1. Which of the following is an absolute cell reference?
a. !A!1
b. $A$1
c. #a#1
d. A1
A worksheet range is a
a. A command used for data modeling
b. A range of values such as from 23 to 234
c. A group of cells
d. A group of worksheets
Suppose you want to copy a formula while keeping one of the cell references locked on the same cell. Which of the following would you use?
a. Absolute reference
b. ReferenceLock
c. PivotTable
d. Relative reference
Which function can find the highest value in a cell range?
a. MAXVALUE
b. HIGHEST
c. TOP
d. MAX
What are predefined formulae in MS - Excel called?
a.Range
b.Parentheses
c.Operators
d.Function
Which error is obtained when a formatted number does not fit within a cell?
a.#####
b.#DIV/0
c.#DIV@
d.#VALUE!
A systems analyst:
a. tests and debugs the new system.
b. develops a visually stimulating website.
c. maintains and protects the company's programs and data.
d. performs routine equipment maintenance, such as cleaning drive-heads.
Computer programmers:
a. discuss program specifications with the systems analyst.
b. write programs.
c. test programs for correct operation and intended results.
d. all of the above.
Network administrators are responsible for:
a. inspecting programs, systems, operational procedures, documentation, control techniques, disaster plans, insurance protection and fire protection.
b. monitoring the network's performance to ensure it is working at its optimum.
c. identifying and evaluating potential hardware and software.
d. all of the above.
