wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Gr X IT Excel

Total questions: 60

Worksheet time: 32mins

Name
Class
Date
1.

How is the COLUMN in a MS Excel Spreadsheet named?

a)

Numbers

b)

Letters

c)

Cells

d)

Columns

2.

How are ROWS in MS EXCEL spreadsheet named?

a)

numbers

b)

letters

c)

cells

d)

columns

3.

What is a rectangular box in a MS EXCEL Spreadsheet called?

a)

row

b)

column

c)

cell

4.

What does every formula in MS EXCEL start with?

a)

+

b)

-

c)

=

d)

*

5.

What is one way to ADD a Range of rows and columns in MS EXCEL other than using the + symbol.

a)

SUMMING

b)

SUM

c)

ALL

d)

None at all

6.

What is an example of a RANGE in MS Excel.

a)

B2-F5

b)

F5:B2

c)

B2:5F

d)

(B2:F5)

7.

When is a MS Excel Spreadsheet used?

a)

Making a Drawing

b)

When Reading

c)

For Collecting Information

d)

For Baking a Cake

8.
Located on the left side or the entry bar, displays the active cell reference:
a)
entry bar
b)
cell reference
c)
name box
d)
none of the above
9.
This is the:
a)
title bar
b)
entry bar
c)
group
d)
none of the above
10.
The cell in a spreadsheet application in which data may be entered:
a)
cell reference
b)
name box
c)
active cell
d)
none of the above
11.
Unique address of a cell that is the coordinate of the intersection of a row and a column:
a)
entry bar
b)
cell reference
c)
name box
d)
none of the above
12.
What is this:
a)
tab
b)
ribbon
c)
view choices
d)
none of the above
13.
The bar that displays the data being entered in the active cell:
a)
status bar
b)
entry bar
c)
Windows Task Bar
d)
none of the above
14.
This is a:
a)
cell
b)
row
c)
column
d)
none of the above
15.
This is a:
a)
Windows Task Bar
b)
Quick Access Toolbar
c)
worksheet tab
d)
none of the above
16.

In Excel, Columns are labelled as ___

a)

A, B, C, etc

b)

1,2,3 etc

c)

A1, A2, etc

d)

$A$1, $A$2, etc.

17.

Which area in an Excel window allows entering values and formulas?

a)

Standard tool Bar

b)

Title bar

c)

Formula Bar

d)

None of the above

18.

In Microsoft Excel, the file you create and edit is called:

a)

A form

b)

A ledger

c)

A table

d)

A workbook

e)

A record

19.
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
20.
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
21.
To create a formula, you first:
a)
Select the cell you want to place the formula into
b)
Type the equals sign (=) to tell Excel that you're about to enter a formula
c)
Enter the formula using any input values and the appropriate mathematical operators that make up your formula
d)
Choose the new command from the file menu
22.
What would be a correct formula for SUM in excel?
a)
=SUM(B3:B9)
b)
=SUMB3+B9
c)
SUM(B3:B9)
d)
=ADD(B3:B9)
23.
How can you find specific information in a list?
a)
Select Tools > Finder from the menu
b)
Click the Find button on the standard toolbar
c)
Select Insert > Find from the menu
d)
Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button
24.
Which button can you click to add up a series of numbers?
a)
The autosum button
b)
The Formula button
c)
The quicktotal button
d)
The total button
25.
To copy formatting from one area in a worksheet and apply it to another area you would use:
a)
The Edit>Copy Format and Edit>Paste Format commands form the menu.
b)
The Copy and Apply Formatting dialog box, located under the Format>Copy and Apply menu.
c)
There is no way to copy and apply formatting in Excel � You have to do it manually
d)
The Format Painter button on the standard toolbar
26.
If the cell contains hashtags (#), what do you need to do?
a)
Expand the column
b)
Expand the row
c)
Change the formula
27.
Each Excel file is called a workbook because
a)
It can contain text and data
b)
It can be modified
c)
It can contain many sheets including worksheets and chart sheets
d)
You have to work hard to create it
28.
You can edit a cell by...
a)
Clicking the formula button
b)
Double clicking the cell
c)
Selecting Edit>Edit Cell from the menu
d)
None of above
29.
Which formula gets the biggest value of a range of cells?
a)
MAX
b)
MIN
c)
LARGE
d)
SUM
30.
Which formula gets the smallest value of a range of cells?
a)
MAX
b)
MIN
c)
SMALL
d)
SUM
31.
Which symbol must all formula begin with?
a)
=
b)
+
c)
(
d)
@
32.
Which of the following formulas is not entered correctly?
a)
=10+50
b)
=B7+B8
c)
=B7+14
d)
10+50
33.
Which of the following formulas will Excel not be able to calculate?
a)
=SUM(Sales)-A3
b)
=SUM(A1:A5)*0.5
c)
=SUM(A1:A5)/(10-10)
d)
=SUM(A1:A5)-10
34.
Columns go...
a)
Across
b)
Down
35.
Rows go...
a)
Across
b)
Down
36.
In a cell reference, for example A1, what does the letter refer to?
a)
The column
b)
The cell
c)
The row
37.
Which of these symbols is used for divide on a computer?
a)
\
b)
*
c)
/
d)
|
38.
A cell name contains
a)
Cell name
b)
Column numbers and row letters
c)
Column letters and row numbers
d)
Cell locator coordinates
39.
Which of these formulas will find the correct average of the cells?
a)
=AVERAGE(A1:A10)
b)
=MEAN(A1:A10)
c)
AVERAGE(A1:A10)
d)
=(A1+A2+A3+A4+A5+A6+A7+A8+A9+A10)/10
40.

Option to print the document so that the height of the page is less than its width

a)

Portrait

b)

Landscape

41.

In Word Processing text formatting is available

a)

True

b)

False

42.

What is the column header name for 14th Column

a)

D

b)

E

c)

X

d)

N

43.

In a spreadsheet, Rows move in ___________ direction.

a)

Vertical

b)

horizontal

c)

diagonal

44.

A _________ is the intersection of a row and column.

a)

box

b)

cell

c)

pointer

45.

_____________displays the contents of active cell.

a)

Tool bar

b)

Address bar

c)

Formula bar

d)

Alignment bar

46.

Columns in MS Excel ranges from _____ to ______

a)

A to XFD

b)

A to Z

c)

A to BZ

d)

A to WFD

47.

What is the file extension for MS Excel worksheet file ?

a)

.doc

b)

.html

c)

.exl

d)

.xlsx

48.

A __________ is a collection of multiple worksheets.

a)

Workbook

b)

Interface

c)

Cell

49.

What will be the cell address of the cell formed by the intersection of the 5th Column and 8th Row

a)

F8

b)

E8

c)

D8

d)

A8

50.

In a spreadsheet, a column is denoted by ___________

a)

symbols

b)

numbers

c)

letters

51.

In a spreadsheet, all formulae must begin with _______ sign.

a)

#

b)

=

c)

$

d)

&

52.

To count only numerical data's, _________ function is used.

a)

COUNTIF

b)

COUNTA

c)

COUNTBLANK

d)

COUNT

53.

To count both numbers and text based data's, _________ function is used.

a)

COUNT

b)

COUNTIF

c)

COUNTA

d)

COUNTBLANK

54.

What is the column header name for 27th Column

a)

Z

b)

AB

c)

AA

d)

BA

55.

In a Spreadsheet(MS Excel), Column next to column "AZ" is ___________

a)

AA

b)

BB

c)

BA

d)

A

56.

In a spreadsheet, Rows are denoted by Letters ?

a)

True

b)

False

57.

In Text Editor Text formatting is available

a)

True

b)

False

58.

Notepad is an example of Word Processor

a)

True

b)

False

59.

The most widely used word processing software in late 1970s was

a)

MS Word

b)

Libre office

c)

AppleWorks

d)

WordStar

60.

What type of chart is displayed in the picture?

a)

BAR

b)

LINE

c)

STOCK

d)

COMBO

Similar Resources on Wayground

Storia - Hardware 1_ Tallini

63 questions

Storia - Hardware 1_ Tallini

quiz

Worksheet

•

1st Grade - University

Quis SMA Part II

65 questions

Quis SMA Part II

quiz

Worksheet

•

9th - 12th Grade

Unit 1 A2 Peripheral devices and media

65 questions

Unit 1 A2 Peripheral devices and media

quiz

Worksheet

•

11th Grade