wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

MS Excel (Spreadsheet) Class 10th MCQ

Total questions: 100

Worksheet time: 23mins

Name
Class
Date
1.

A program using a table comprising of rows, columns and cells.

a)

MS Word

b)

MS PowerPoint

c)

MS Outlook

d)

MS Excel

2.

The intersection of a row and a column is called this.

a)

Active Cell

b)

Chart

c)

Column

d)

Row

3.

In Excel, rows are identified by this

a)

Letters

b)

Numbers

4.

Which is NOT a term used in Excel?

a)

Workbook

b)

Worksheet

c)

Cell

d)

Document

5.
Provides easy access to frequently used commands:
a)
group
b)
Quick Access Toolbar
c)
cell
d)
none of the above
6.

Microsoft Excel is categorized as a ________________ software.

a)

Database

b)

Spreadsheet

c)

Presentation

d)

Word Processing

7.

The bar where information appears as you input data is called ______________.

a)

file bar

b)

help bar

c)

window bar

d)

formula bar

8.

What does every formula in MS EXCEL start with?

a)

+

b)

-

c)

=

d)

*

9.
This is the:
a)
tab
b)
title bar
c)
group
d)
none of the above
10.

Excel file is saved as a ____________

a)

Document

b)

workbook

c)

worksheets

d)

Presentation

11.

What is the Sum formula?

a)

Sum( )

b)

Sum( )=

c)

=( )Sum

d)

=Sum( )

12.

How is the COLUMN in a MS Excel Spreadsheet named?

a)

Numbers

b)

Letters

c)

Cells

d)

Columns

13.

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

a)

row

b)

column

c)

cell

14.

What is an example of a RANGE in MS Excel.

a)

B2-F5

b)

F5:B2

c)

B2:5F

d)

(B2:F5)

15.

When is a MS Excel Spreadsheet used?

a)

Making a Drawing

b)

When Reading

c)

For Collecting Information

d)

For Baking a Cake

16.
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
17.
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
18.
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
19.
This is a:
a)
cell
b)
row
c)
column
d)
none of the above
20.
This is a:
a)
Windows Task Bar
b)
Quick Access Toolbar
c)
worksheet tab
d)
none of the above
21.

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.

22.

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

23.

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

24.

A program using a table comprising of rows, columns and cells.

a)

MS Word

b)

MS PowerPoint

c)

MS Outlook

d)

MS Excel

25.

The intersection of a row and a column is called this.

a)

Active Cell

b)

Chart

c)

Column

d)

Row

26.

The first cell in a worksheet is what?

a)

A1

b)

1A

c)

FX

d)

Cell Name

27.

What is the name of the cell that is colored blue?

a)

A

b)

B

c)

2B

d)

B2

28.
The Quick Access Toolbar is:
a)
customizable
b)
found at the bottom of the screen
c)
found on the right side of the screen
d)
none of the above
29.
This is a:
a)
ribbon
b)
group
c)
tab
d)
none of the above
30.
The entry bar is also known as (AKA):
a)
name box
b)
formula bar
c)
status bar
d)
none of the above
31.
This is a:
a)
tab
b)
ribbon
c)
group
d)
none of the above
32.

A program using a table comprising of rows, columns and cells.

a)

MS Word

b)

MS PowerPoint

c)

MS Outlook

d)

MS Excel

33.

Microsoft Excel is categorized as a ________________ software.

a)

Database

b)

Spreadsheet

c)

Presentation

d)

Word Processing

34.
Provides easy access to frequently used commands:
a)
group
b)
Quick Access Toolbar
c)
cell
d)
none of the above
35.

?

a)

File

b)

save

c)

clear

36.

What is Data?

a)

The name for information that we type into the computer

b)

The graph we put into the spreadsheet.

c)

The cell reference

37.

A Column goes…

a)

across

b)

down

c)

cross

38.

1) A Row goes…

a)

across

b)

down

c)

cross

39.

What are Value?

a)

The words in a spreadsheet.

b)

The numbers in a spreadsheet.

c)

The words and the numbers in a spreadsheet.

40.

In Excel, Columns move in _________ direction

a)

Horizontal

b)

Vertical

c)

Diagonal

41.

In Excel, Rows move in _________ direction

a)

Vertical

b)

Diagonal

c)

Horizontal

42.

Combination of column letter and row number that identifies a cell.

a)

Cell Address

b)

Cell Range

43.

An excel file is saved with ______________ extension.

a)

.xlsx

b)

.pptx

44.

Thick border around the active cell is called the ______________________________.

a)

Cell pointer

b)

Active cell

45.

What is the symbol for division when using MS EXCEL.

a)

/

b)

+

c)

*

d)

-

46.

What is a multiplication formula for MS Excel using the picture ?

a)

=1Ax1B

b)

=B1*G1

c)

=C3xD3

d)

=B4*C4

47.

__________ is a area that holds all the elements of a chart.

a)

Plot Area

b)

Chart Title

c)

Chart Area

d)

Legends

48.

Vertical axis of a chart is _______

a)

X axis

b)

Y axis

c)

X axis

d)

B axis

49.

The lines that run across the plot area are known as _______

a)

Sparklines

b)

Slice

c)

Cross lines

d)

Gridlines

50.

The other name of X-axis is ______________

a)

Category axis

b)

Axes title

c)

Value axis

d)

Blocks

51.

What type of chart is this?

a)

Pie Chart

b)

Bar Chart

c)

Doughnut Chart

d)

Scatter Chart

52.

Click __________ tab to create a chart.

a)

CREATE

b)

INSERT

c)

FORMAT

d)

HOME

53.

What are the two additional tabs that appears after inserting a chart

a)

INSERT, FORMAT

b)

LAYOUT, DESIGN

c)

FORMAT, LAYOUT

d)

DESIGN, FORMAT

54.

To quickly create a chart press _______ function key.

a)

F8

b)

F9

c)

F10

d)

F11

55.

______________ resizing markers are present on the borders of chart to resize a chart.

a)

2

b)

4

c)

6

d)

8

56.

Click __________ group in DESIGN tab to move a chart to a new worksheet.

a)

Location

b)

Data

c)

Type

d)

Layouts

57.

Legends are added at the ________ of a chart by default.

a)

top

b)

bottom

c)

middle

d)

right

58.

We can add or modify the chart elements by using _________________ button present in the Chart Layout group.

a)

Quick Layout

b)

Add chat Element

c)

Select data

d)

Change data

59.

A Chart is a pictorial representation of data

a)

True

b)

False

60.

Once a type of graph is chosen it cannot be changed to other type

a)

True

b)

False

61.

An Excel spreadsheet is primarily used for calculating which of the following options

a)

A. Data

b)

B. Finances

c)

C. Numbers

d)

D. All of the above

62.

Which of the following option is a formula?

a)

A. =SUM(A1:A5)

b)

B. Add A1 - A5

c)

C. Subtract the numbers

d)

D. A1 = A5

63.

1. Which of the following is an absolute cell reference?

a)

a. !A!1

b)

b. $A$1

c)

c. #a#1

d)

d. A1

64.

A worksheet range is a

a)

a. A command used for data modeling

b)

b. A range of values such as from 23 to 234

c)

c. A group of cells

d)

d. A group of worksheets

65.

Which function can find the highest value in a cell range?

a)

a. MAXVALUE

b)

b. HIGHEST

c)

c. TOP

d)

d. MAX

66.

If you copy the formula =$B38 into another cell, the result will be:

a)

a. The column part will remain the same

b)

b. The row part will remain the same

c)

c. Both the column and row will remain the same

d)

d. Both will change

67.

Which of the following is not a function of MS - Excel?

a)

a. AVERAGE

b)

b. ADD

c)

C.MIN

d)

d. MAX

68.

What are predefined formulae in MS - Excel called?

a)

a.Range

b)

b.Parentheses

c)

c.Operators

d)

d.Function

69.

Which error is obtained when a formatted number does not fit within a cell?

a)

a.#####

b)

b.#DIV/0

c)

c.#DIV@

d)

d.#VALUE!

70.

What does the button in red mean?

a)

Align the text on the borders of the page

b)

Extend the content on the entire length of the cell.

c)

Group together the selected cells and center the content.

d)

None of the above

71.

What type of chart is this?

a)

Donut

b)

Radar

c)

Bar

d)

Pie

72.

What key is used to select multiple ranges of cells?

a)

Shift

b)

CTRL

c)

ALT

d)

Shift+ALT

73.

What function offers you the possibility to view different results depending on the entered condition?

a)

=if()

b)

=sumif()

c)

=sum()

d)

=TRUEFALSE()

74.

Which of the following cursor allows you to select a range of cells

a)
b)
c)
d)
75.

Appears at the border of the column letters. Drag to widen or narrow the width of a column.

a)
b)
c)
d)
76.

Used to select a whole row/column when positioned on the row number or column letter.

a)
b)
c)
d)
77.

The fill handle - used for copying formula or extending a data series.

a)
b)
c)
d)
78.

The wrap text feature is available under the menu of-

a)

Insert

b)

Edit

c)

Tools

d)

Format

79.

Macros option is avalable under:

a)

Review

b)

Insert

c)

Tools

d)

View

80.

The column of spreadsheet extends till from A

a)

XGD

b)

XFD

c)

XFE

81.

Shows content of the active cell

a)

Formula Bar

b)

Status Bar

c)

Task Bar

82.

What is the intersection of a column and a row on a worksheet called ?

a)

Cell

b)

Column

c)

Address

83.

Data in a cell is a

a)

Text

b)

Symbol

c)

Number

d)

Formula

84.

Name the Element where the mouse is pointed

a)

worksheet

b)

ribbon

c)

formula bar

85.

What is action of Tab key in Excel?

a)

One cell down in the column

b)

Next cell in the row

c)

Previous cell in the row

d)

One cell up in the column

86.

In your opinion, what is the best application to organise information?

a)

MS Excel

b)

MS PowerPoint

c)

MS Word

d)

Other

87.

(a)   points is default row height.

88.

(a)   characters is default column width.

89.

Which one is not a Function in MS Excel ?

a)

SUM

b)

AVG

c)

MAX

d)

MIN

90.

What is name of last column?

a)

XFD

b)

XDF

c)

XZ

d)

XF

91.

To quickly create a chart press _______ function key.

a)

F8

b)

F9

c)

F10

d)

F11

92.

Click __________ tab to create a chart.

a)

CREATE

b)

INSERT

c)

FORMAT

d)

HOME

93.

What type of chart is this?

a)

Pie Chart

b)

Bar Chart

c)

Doughnut Chart

d)

Scatter Chart

94.

Vertical axis of a chart is _______

a)

X axis

b)

Y axis

c)

X axis

d)

B axis

95.

What is the file extension for MS Excel worksheet file ?

a)

.doc

b)

.html

c)

.exl

d)

.xlsx

96.

_____________displays the contents of active cell.

a)

Tool bar

b)

Address bar

c)

Formula bar

d)

Alignment bar

97.

In a spreadsheet, Rows move in ___________ direction.

a)

Vertical

b)

horizontal

c)

diagonal

98.

What feature is particularly useful when you want to add all numbers in a row or column

a)

Autosum

b)

Product

c)

Operators

d)

Hierarchy

99.

What is a formulas in excel sheet

a)

The address of the cells

b)

The defined expression that contains values, constants, Call reference, functions and operators

c)

Numbers or text values that can be entered directly in a formula

100.

An Excel file is generally called a / an :

a)

E-Spreadsheet

b)

Woorksheet

c)

Workbook

d)

Sheet

Similar Resources on Wayground

Final Test Eng Tech

100 questions

Final Test Eng Tech

quiz

Worksheet

•

9th - 12th Grade