wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

XII Unit 3 ICT Skills Spreadsheet

Total questions: 50

Worksheet time: 8mins

Name
Class
Date
1.
Cells that run horizontally on a spreadsheet
a)
Row
b)
Column
c)
Workbook
d)
Range
2.
Cells that run vertically on a spreadsheet
a)
Row
b)
Workbook
c)
Worksheet
d)
Column
3.
The location of a cell on a spreadsheet. It is a column letter followed by a row number.
a)
Cell range
b)
Cell reference
c)
Active cell
d)
Row
4.
The letter at the top of each column is called a:
a)
cell reference
b)
row header
c)
column header
d)
range
5.
The number to the left of a row is called a:
a)
cell reference
b)
column header
c)
row header
d)
range
6.
All functions and formulas begin with which symbol?
a)
#
b)
/
c)
:
d)
=
7.
The intersection of a column and a row is called a ______.
a)
gridline
b)
cell
c)
value
d)
formula
8.
Horizontal and vertical lines in a spreadsheet are called ____.
a)
rows
b)
graphs
c)
labels
d)
gridlines
9.
The cell that is currently selected
a)
Cell reference
b)
Cell range
c)
Label
d)
Active cell
10.
A group of cells in a spreadsheet
a)
Cell reference
b)
Cell range
c)
Active cells
d)
Formulas
11.
A single page in Excel is called a:
a)
worksheet
b)
workbook
c)
spreadsheet
12.
Multiple pages in Excel is called a:
a)
worksheet
b)
workbook
c)
spreadsheet
13.
Which of the following is a FORMULA that will add cells c9 and c10?
a)
=c9+c10
b)
c9+c10
c)
sum(c9:c10)
d)
=sum(c9:c10)
14.
Which is an example of a cell reference is a spreadsheet?
a)
6C
b)
B9
c)
45
d)
fall
15.
Format cells as ______________ when working with amounts of money.
a)
currency
b)
percent
c)
number
d)
scientific
16.
Double-clicking between two columns will ____________ the column.
a)
delete
b)
copy
c)
resize
d)
fill
17.

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.

18.

Define Cell?

a)

The dark bordered box in excel.

b)

A box in Excel that has formulas.

c)

The intersection of a column or row in a worksheet or table.

d)

Fx Bar where you input data.

19.

Define Formula Bar?

a)

I don't know

b)

I don't care

c)

Don't miss this one!

d)

An element in Excel that appears below the Ribbon and to the right of the Insert command that shows the contents of the active cell so that you edit the text, value, date, formula, or function.

20.

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.

21.

What is a sheet in Excel?

a)

A single document that typically contains labels, values, formulas, functions, and graphical representations of data.

b)

A single spreadsheet that typically contains labels, values, formulas, functions, and graphical representations of data.

c)

A single template that typically contains labels, values, formulas, functions, and graphical representations of data.

d)

A single file that typically contains labels, values, formulas, functions, and graphical representations of data.

22.

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

a)

+

b)

-

c)

%

d)

=

23.

When you open Excel you are viewing Excel in the ____ View?

a)

Backstage

b)

Frontstage

c)

Spreadsheet

d)

Template

24.

Excel spreadsheets that are already created and ready for you to edit are known as?

a)

spreadsheets

b)

templates

c)

data inputs

d)

pages

25.

What is the green bar at the top of Excel referred to as?

a)

the data bar

b)

the function bar

c)

the ribbon

d)

the row

26.

The letters in Excel represent the _______?

a)

columns

b)

rows

c)

data

d)

functions

27.

The numbers in Excel represent the _____?

a)

columns

b)

rows

c)

data

d)

functions

28.

Where is the zoom function located in Excel?

a)

Bottom right of spreadsheet document

b)

Bottom left of spreadsheet document

c)

Top right of spreadsheet document

d)

Top left of spreadsheet document

29.

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

30.

What version of Excel are we using in class?

a)

Excel 2016

b)

Excel 2017

c)

Excel 2018

d)

Excel 2015

31.
If you see a series of "######" in a cell, that means the following:
a)
You keyed in an incorrect number
b)
The row height is too high
c)
The text is incorrectly spelled
d)
The column width is not wide enough
32.
What is the name of this cell?
a)
B10
b)
5B
c)
B5
d)
A5
33.
How do you select an entire column?
a)
Select Edit > Select > Column from the menu
b)
Click the column heading letter
c)
Hold down the shift key as you click anywhere in the column.
d)
Hold down the Ctrl key as you click anywhere in the column
34.
How do you insert a new row?
a)
Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu
b)
Select the row heading where you want to insert the new row and select Edit >Row from the menu
c)
Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar
d)
All of the above
35.
Completes previously typed words when you begin to repeat the typing. 
a)
AutoFill
b)
#Name?
c)
Column charts
d)
Pie Charts
36.
Completes previously typed words when you begin to repeat the typing. 
a)
AutoFill
b)
#Name?
c)
Column charts
d)
Pie Charts
37.
Which feature enables you to preview headers and footers, page breaks, and other features that will print?
a)
Page preview
b)
Print Layout
c)
Synchronous Scrolling
d)
Window View
38.
2) What is the purpose of the Quick Access Toolbar (circled in orange in the image below)?  
 
   
a)
a) It provides shortcuts to functions you may use frequently as well as functions that may not be on the Ribbon.
b)
b) You can only use it to save, redo and undo, create new documents, open documents and print. 
c)
c) It displays functions you have recently used as well as frequently used functions.
d)
 d) None of the above options are correct. 
39.
3) Which of the following functions are you likely to find under the Insert tab on the Ribbon?
 
 
 
a)
a) Insert a page break. 
b)
 b) Insert a formula. 
c)
c) Insert a table. 
d)
d) Insert track changes. 
40.
In Excel, the electronic spreadsheet you work in is called a ____.
a)
tablet
b)
databook
c)
numericsheet
d)
worksheet
41.
In Excel, a worksheet is contained in a file called a ____.
a)
workbook
b)
workpad
c)
notebook
d)
datapad
42.
All Excel formulas begin with the ____.
a)
plus sign(+)
b)
asterisk(*)
c)
equal sign(=)
d)
slash(/)
43.
The Excel operator for exponent is ____.
a)
/
b)
\
c)
%
d)
^
44.
The Excel operator for division is ____.
a)
/
b)
\
c)
%
d)
^
45.
A(n) ____ is a built-in formula that uses arguments to calculate information.
a)
label
b)
function
c)
template
d)
indicator
46.
Excel recognizes an entry as a value if it is a number or it begins with 
a)
+
b)
=
c)
$
d)
all of the above
47.
Microsoft Excel is what type of software?
a)
Word Processing
b)
Spreadsheet
c)
Presentation
d)
Drawing
48.
Excel allows you to
a)
read stories
b)
work with data
c)
invent ideas
49.
What is the name of this cell?
a)
B10
b)
5B
c)
B5
d)
A5
50.
A ______________ is an equation in a worksheet.
a)
Range
b)
Argument
c)
Formula
d)
Excel

Similar Resources on Wayground

KUIS Jaringan Komputer dan Internet

50 questions

KUIS Jaringan Komputer dan Internet

quiz

Worksheet

•

7th Grade - University

City & Guilds Certificate in Network & Architecture Assessment

50 questions

City & Guilds Certificate in Network & Architecture Assessment

quiz

Worksheet

•

12th Grade

Coding Units 5-10

46 questions

Coding Units 5-10

quiz

Worksheet

•

9th - 12th Grade

Adobe Animate 2015

46 questions

Adobe Animate 2015

quiz

Worksheet

•

9th - 12th Grade

Latihan USPBK Simulasi dan Komunikasi Digital

46 questions

Latihan USPBK Simulasi dan Komunikasi Digital

quiz

Worksheet

•

12th Grade

Basic Java with CodeHS

50 questions

Basic Java with CodeHS

quiz

Worksheet

•

9th - 12th Grade

Comptia Network+ chapter 1-3 exam

45 questions

Comptia Network+ chapter 1-3 exam

quiz

Worksheet

•

11th Grade - University

Networking - Practice Test #1

47 questions

Networking - Practice Test #1

quiz

Worksheet

•

9th Grade - University