wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Non Standardize

Total questions: 65

Worksheet time: 45mins

Name
Class
Date
1.
A spreadsheet is a document that stores data in a grid of horizontal rows and vertical columns.
a)
Row
b)
Spreadsheet
c)
Minus
d)
Plus
2.
In Excel it means Add
a)
Plus sign
b)
sort 
c)
Forward slash 
d)
asterisk 
3.
the largest number =MAX(the first cell address:then the second cell address) For Example: =MAX(C1:C33)
a)
Average
b)
Minimum 
c)
Filter
d)
Maximum 
4.
Completes previously typed words when you begin to repeat the typing. 
a)
AutoFill
b)
#Name?
c)
Column charts
d)
Pie Charts
5.
2 or more cells that are selected to create a source to be used in a formula
a)
Range
b)
Max
c)
Filter
d)
Colums 
6.
Error in your formula
a)
#div/0!
b)
AutoFill
c)
#name?
d)
Columns 
7.
A Graphic representation of data. A circle is divided into sectors which shows a percentage of a whole.
a)
Line Chart
b)
Pie Chart
c)
Bar Chart
d)
Graphs
8.
A Graphic representation of data. The bar can be VERTICAL or Horizontal, but a vertical graph is also known as a column chart.
a)
Bar Chart
b)
Pie Chart
c)
Graphs
d)
Line Chart
9.
A type of chart which displays information as a series of data points called 'markers' connected by straight line segments. 
a)
Pie chart
b)
Line Chart
c)
Bar Graphs
d)
Graphs
10.
the sum of all numbers divided by the amount of numbers. 
a)
Maximun
b)
Minimum 
c)
Median
d)
Average
11.
What does this mean "######'?
a)
column is not wide enough
b)
column is missing numbers
c)
column is showing an error
d)
column is too narrow
12.
In an excel formula, it means substract
a)
Add sign
b)
Minus sign
c)
Divide sign
d)
Average Sign 
13.
In an excel forumula it means divide
a)
Forwardslash 
b)
Backwards
c)
Skip
d)
Multiply 
14.
Horizontal line of cells
a)
Row
b)
Column
c)
Cell
d)
Spreadsheet
15.
a vertical line of cells
a)
Maximum
b)
Minimum 
c)
Column 
d)
Formulas
16.
You can only work in one cell at a time. The actual cell that you are working in is called what?
a)
Column
b)
Name Box
c)
Active Cell
d)
Row
17.
When entering text in Excel, it is automatically (by default):
a)
Left Justified
b)
Right Justified
c)
Center Justified
d)
Full Justified
18.
Columns in a spreadsheet are:
a)
Vertical
b)
Horizontal
c)
Upside down
d)
right side
19.
Rows in a spreadsheet are:
a)
Vertical
b)
Horizontal
c)
Upside Down
d)
Right Side
20.
What is the term used where a column and row intersect?
a)
Toolbar
b)
Cell
c)
Name Box
d)
Formula Bar
21.
The feature to center text across several cells is called:
a)
Wrap Text
b)
Merge and Center
c)
Shrink to Fit
d)
Number Formatting
22.
Cells are identified by the following:
a)
Column Letter followed by their Row Number
b)
Row Number followed by their Column Letter
c)
Row Number Only
d)
Column Letter Only
23.
Microsoft Excel is what type of software?
a)
Word Processing
b)
Spreadsheet
c)
Presentation
d)
Drawing
24.
In Excel rows are labeled by
a)
letters
b)
numbers
c)
rows and numbers
25.
In excel, columns are labeled by
a)
Letters
b)
Numbers
c)
Letters and numbers
26.
What button will add up a group of numbers
a)
Equals button
b)
Plus symbol button
c)
Auto-sum button
27.
Excel refers to files as
a)
Documents
b)
Workbooks
c)
data bases
28.
What kind of chart should you use to show the pieces (percentages) of a whole
a)
Bar Chart
b)
Column Chart
c)
Pie Chart
29.
To see what math formulas are used in a cell, click on the
a)
Show formulas button
b)
Show the math button
c)
the auto sum button
30.
Excel is part of
a)
Access
b)
Microsoft Office
c)
PowerPoint
31.

What is the "Active Cell" in Excel?

a)

The Bottom cell in a worksheet. It is indicated by a dark border onscreen.

b)

The current cell in a worksheet. It is indicated by a dark border onscreen.

c)

The top cell in a worksheet. It is indicated by a dark border onscreen.

d)

The past cell in a worksheet. It is indicated by a dark border onscreen.

32.

What is a spreadsheet?

a)

An electronic file that contains a grid of columns and rows to organize related data and to display results of calculations.

b)

An electronic file that contains a grid of negatives and positives to organize related data and to display results of calculations.

c)

An electronic file that contains a grid of numbers and data to organize related data and to display results of calculations.

d)

An electronic file that contains a grid of pages and sheets to organize related data and to display results of calculations.

33.

What is the Sum formula?

a)

Sum( )

b)

Sum( )=

c)

=Sum( )

d)

=( )Sum

34.

When starting a formula what is the first thing you type in the cell?

a)

+

b)

-

c)

%

d)

=

35.

When making a graph whats the first thing you need to do?

a)

Pick the type of Graph

b)

Use the function = sign

c)

Highlight your data being used.

d)

Double click the active cell

36.

How would you write a cell reference formula for cell A1 subtracted by Cell C3?

a)

A1-C3

b)

A1-C3=

c)

=A1-C3

d)

=C3-A1

37.
What is the Formula sign for multiply? 
a)
\
b)
*
38.
How do you make a cell the active cell?
a)
Click the ACTIVE button
b)
Click INSERT CELL
c)
Click on the cell
d)
Cells are always active
39.
What is the name of this cell?
a)
B10
b)
5B
c)
B5
d)
A5
40.
Which tab in Excel has charts and tables?
a)
review
b)
home
c)
file
d)
insert
41.
What setting do you use to format numbers as dollar amounts
a)
Accounting
b)
Currency
c)
Accounting and Currency
42.
In this diagram what does the selected area represent?
a)
a Row
b)
a Cell
c)
a Column
d)
a Chart
43.
Which of the following is an absolute cell reference?
a)
A2
b)
$A$2
c)
#A#2
d)
A:2
44.
In this example, why does the value in cell G1 look slightly different from the value in the formula bar?
a)
A formula is being used in this cell.
b)
It's using the Currency number format.
c)
It's using the Date number format.
45.
Let's say you're trying to find your average grade in this spreadsheet. What's wrong with the formula in cell C11?
a)
It should use the COUNT function instead.
b)
There is nothing wrong with the formula.
c)
It should have an equals sign (=) at the beginning.
d)
It's referencing the wrong cell range.
46.
In this diagram the highlighted area represents:
a)
Columns
b)
a Graph
c)
Rows
d)
a Chart
47.
What is the cell range in this diagram?
a)
A1:F1
b)
A1:A8
c)
A1:F8
d)
A1:1A
48.
In the diagram a row has been selected. If we Insert a new row into the spreadsheet where will the new row appear?
a)
Beneath the heading
b)
Between row 4 and 5
c)
After row 5
d)
After row 6
49.
How would we type the formula to Add the June and July Budgets?
a)
=June+July
b)
=1200+1500
c)
=D10+D11
d)
=C10+C11
50.
What is the formula to find the lowest number in cells C1:C4?
a)
=average(C1:C4)
b)
=max(C1:C4)
c)
=min(C1:C4)
d)
=sum(C1:C4)
51.
What instructs the software to perform a calculation?
a)
value
b)
label
c)
formula
52.
What do you call a device or program which monitors network traffic to prevent attacks?
a)
Firewall
b)
Spam
c)
Trojan
d)
Cyber blocker
53.
Which one is an example of 'physical security'
a)
firewall
b)
spam filter
c)
locked door
d)
Anti-virus software
54.
Why is it important to update software?
a)
To save money
b)
For the computer to work
c)
To have the latest protection
d)
To avoid having to back up
55.

Which one of the following is a 'phishing' email?

a)

One that asks yo to click on the link and give details

b)

One from an employer giving details of a meeting

c)

One from a shop you have recently bought from

d)

One from your bank asking for your login details

56.

Which one of these is an example of malware?

a)

Warrior horse

b)

Trojan horse

c)

Racing horse

d)

War horse

57.

Which is the correct term? Software that monitors all data arriving and leaving your computer.

a)

Encryption

b)

Virus

c)

Backup

d)

Firewall

58.

This is installed to protect your pc from malicious material.

a)

Anti-virus software

b)

Web browser

c)

Password control

d)

Access levels

59.
What is phishing?
a)
scams through websites
b)
scams through emails
c)
scams through phone calls
d)
scams through text messages
60.
What is a virus?
a)
blocking access until money is paid
b)
A piece of code that can copy itself and attack a computer
c)
Sends information covertly 
d)
when someone steals your computer
61.

Malware is software that is specifically designed to disrupt, damage, or gain unauthorised access to a computer system.

a)

True

b)

False

62.
What is a good online password?
a)
Your birthday
b)
Your favorite pet's name
c)
A random combination of several words and some numbers
d)
Your social security number
63.

A person who uses computers to gain unauthorized access to data

a)

Saboteur

b)

Hacker

c)

Fraudster

d)

Criminal

64.

The accuracy, reliability and consistency of data

a)

Data integrity

b)

Data security

c)

Data archiving

d)

Data entry

65.

The illegal use of someone else's personal information (as a Social Security number) in order to obtain money or for some other personal gain

a)

Internet fraud

b)

Identity theft

c)

Credit card fraud

d)

Telemarketing schemes

Similar Resources on Wayground

IT Fundamentals 1

63 questions

IT Fundamentals 1

quiz

Worksheet

•

9th Grade - University

ÔN TẬP TIN HỌC 3

61 questions

ÔN TẬP TIN HỌC 3

quiz

Worksheet

•

3rd Grade - University

Test próbny EE.08 (hardware i inne)

62 questions

Test próbny EE.08 (hardware i inne)

quiz

Worksheet

•

9th - 12th Grade

Network and Topologies - Year 10F

61 questions

Network and Topologies - Year 10F

quiz

Worksheet

•

7th - 9th Grade

iGCSE Computer Science: Data

69 questions

iGCSE Computer Science: Data

quiz

Worksheet

•

9th - 12th Grade

Angleton JH Intro to Robotics Final Exam

60 questions

Angleton JH Intro to Robotics Final Exam

quiz

Worksheet

•

6th - 12th Grade

Quiz Informatika 9

60 questions

Quiz Informatika 9

quiz

Worksheet

•

9th Grade

TIN 7 Bài 1,2,3

60 questions

TIN 7 Bài 1,2,3

quiz

Worksheet

•

7th Grade - University