wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Microsoft Excel

Total questions: 80

Worksheet time: 40mins

Name
Class
Date
1.

Microsoft Excel is an electronic __________program.

a)

spreadsheet

b)

word

c)

paint

d)

spead

2.

The tearm worksheet refers to the row and column ______sheet

a)

intersection

b)

matrix

c)

cross

d)

many

3.

______________is the standard Excel document with many sheets.

a)

worksheet

b)

workbook

c)

spreadsheet

d)

cell

4.

The intersection of a row and column is a rectangular area called a _______

a)

workbook

b)

cell pointer

c)

worksheet

d)

cell

5.

Cell address are the combination of column _______ and row _____.

a)

Number,Letter

b)

Number,Number

c)

Letter ,Number

d)

Letter,Letter

6.

The _________shows what you are typing in a cell.

a)

Title bar

b)

Name box

c)

Formula Bar

d)

Address bar

7.

All formulae must begin with an____

a)

plus sign

b)

equal sign

c)

dollar sign

d)

colon

8.

To move through your worksheet,you can use the ________

a)

arrow keys

b)

number keys

c)

Space bar

d)

control + arrow

9.

____________are used to perform all or part of a formula.

a)

function

b)

party

c)

wizard

d)

button

10.

AutoSum button ,inserts a _____ function in the active cell.

a)

ADD()

b)

PLUS()

c)

SUM()

d)

AUTO()

11.

A cell is _______when the border is highlighted in blue.

a)

Good

b)

Slow

c)

Auto

d)

Active

12.

__________ helps to insert the formula step by step.

a)

Wizard

b)

Function

c)

Display

d)

Formula

13.

A cell contains a value,____or a text entry.

a)

a text

b)

a formula

c)

excel

d)

string

14.

Cell address of the fifth row and seventh column is

a)

G6

b)

E4

c)

G5

d)

G7

15.

A cell is active when the border is highlighted in ____

a)

yellow

b)

green

c)

red

d)

black

16.

Ms Excel can do calculations.

a)

True

b)

False

17.

Ms Excel is a spread sheet Program.

a)

True

b)

false

18.

A workbook contains Four sheets by default.

a)

True

b)

False

19.

A formula starts with a @ sign.

a)

True

b)

False

20.

To select the entire worksheet we can use Ctrl + O keys.

a)

False

b)

True

21.

Ms -Excel saves files with .exl extension.

a)

False

b)

True

22.

The term _________ will refers to the book of pages that is the stansard Excel document.

a)

Workbook

b)

Logbook

c)

Spreadsheet

23.

Ms Excel can represent data in the form of ____

a)

Chart

b)

Graph

c)

Tabular Form

d)

All of these

24.

Ms Excel is a window based based application.

a)

True

b)

False

25.

The entire worksheet is ___________in size.

a)

very big

b)

very small

c)

colourful

26.

The default name of worsheets are untitled1,untitled2 and untitled3

a)

True

b)

False

27.

Worksheets can be added but cant be renamed.

a)

True

b)

False

28.

A cell address starts with the ______________

a)

column number

b)

row number

c)

either a or b

29.

Intersection of each row and column creates a ______

a)

cell

b)

tissue

c)

grid

30.

The cell ______identifies the location of each cell.

a)

address

b)

color

c)

pointer

31.

A cell address starts with alphabet.

a)

True

b)

False

32.

The __________toolbar gives access to commands we frequently use,

a)

Address bar

b)

Title bar

c)

Quick access toolbar

d)

Formula bar

33.

__________Means Rollback an action and ____________ means reapply a rolled back action.

a)

Und0,Redo

b)

Redo,Undo

c)

Delete ,Backspace

34.

_______bar displays the name of the workbook.

a)

Title

b)

Address

c)

Name

35.

The _________displays the cell address of the cell you are in.

a)

Name box

b)

Address bar

c)

URL

36.

The ________________ provides quick information such as the count ,sum,average,minimum and maximum value of selected numbers.

a)

Status bar

b)

title bar

c)

quick launch toolbar

37.

The number of worksheets in a workbook can go upto

a)

3

b)

1048576

c)

16384

d)

any limit

38.

The number of columns in a worksheets are

a)

16386

b)

16384

c)

16385

d)

16584

39.

The number of rows in the worksheet are ______

a)

1048876

b)

1038576

c)

1048576

d)

1026576

40.

Column runs horizontally on a worksheet.

a)

True

b)

False

41.

Rows runs horizontally on a worksheet.

a)

True

b)

False

42.

Pressing the ______key anchors the cursor.

a)

F6

b)

F5

c)

F8

d)

F9

43.

By Default ,numbers are ________aligned in a cell.

a)

left

b)

right

c)

center

44.

By Default ,text data are ________aligned in a cell.

a)

left

b)

right

c)

center

45.

Formulas are usually considered to be _______

a)

Text

b)

Numbers

c)

Seperate type of data

d)

numbers or seperate type of date

46.

To save a workbook,

a)

Ctrl + C

b)

Ctrl + S

c)

Ctrl + O

d)

Ctrl + P

47.

To copy the cell or data,

a)

Ctrl + V

b)

Ctrl + X

c)

Ctrl + C

d)

Ctrl + O

48.

To select an entire worksheet,

a)

Ctrl + V

b)

Ctrl + C

c)

Ctrl + O

d)

Ctrl + A

49.

To paste data or cells

a)

Ctrl + X

b)

Ctrl + C

c)

Ctrl + V

d)

Ctrl + Y

50.

To undo an action

a)

Ctrl + X

b)

Ctrl + Z

c)

Ctrl + Y

d)

Ctrl + V

51.

To redo an action

a)

Ctrl + A

b)

Ctrl + Z

c)

Ctrl + X

d)

Ctrl + Y

52.

To open Save As dialog box ,

a)

F12

b)

Ctrl + S

c)

C1trl + F12

d)

F5

53.

To print a worksheet

a)

Ctrl + Q

b)

Ctrl + P

c)

Ctrl + Pr

d)

Ctrl + prtscr

54.

To insert a new row

a)

click on

Home tab->insert->insert sheet rows

b)

right click the selected rows and the click insert

c)

both a and b

55.

When deleting an entire row,

a)

other rows automatically shift up

b)

other rows automatically shift down

c)

no change

56.

If we delete an entire column,then

a)

other columns automatically shift to the right

b)

other columns automatically shift to the left

c)

No change

57.

The AutoFit Column width will change the column width to automatically fit the contents,

a)

True

b)

False

58.

Adding all numbers in a contiguous row,the select all cells in the rows,then click on _________button present under the Editing group

a)

+ Add

b)

+ Sum

c)

Σ AutoSum

59.

To add all the values from B4 to F4,WE neeed to type _______ in G4 cell and then press enter key.

a)

B4+C4+D4+E4+F4

b)

=Sum(B4:F4)

c)

=B4+C4+D4+E4+F4

d)

both b and c

60.

You can undo upto ______actions in Excel.

a)

100

b)

1000

c)

10

d)

1k

61.

You can also ________actions that have been undone.

a)

Autosum

b)

Undo

c)

Redo

62.

_______________are predefined formulas that perform calculations by using specific values.

a)

Wizard

b)

Functions

c)

Formula

63.

________Function has been used to find the average of numbers in a given range.

a)

AVG()

b)

AVERAGE()

c)

RANGE()

64.

________Function has been used to RETURN the largest value in a set of values.

a)

MAXIMUM()

b)

MAX()

c)

BIG()

d)

NONE OF THE ABOVE

65.

________Function has been used to RETURN the smallest value in a set of values.

a)

SMALL()

b)

MINIMUM()

c)

MIN()

d)

SMALLEST()

66.

The default font size in Excel sheet is

a)

11

b)

12

c)

13

d)

10

67.

The default font name in Excel sheet is

a)

Ariel

b)

Times New Roman

c)

Calibri

d)

none of the above

68.

MS-Excel can be used for data analysis.

a)

True

b)

False

69.

The size of a Worksheet which is visible on the opening screen of MS-Excel is the whole worksheet,

a)

True

b)

False

70.

A workbook is a collection of

a)

worksheets

b)

workbook

c)

cells

71.

When you are in the first cell,its location is __

a)

A

b)

1

c)

A1

d)

AA

72.

In A1,location address - A represents___

a)

Column number

b)

row number

c)

both

d)

none

73.

____________ key moves the active cell highlight to column A without changing rows

a)

HOME

b)

CTRL + HOME

c)

pg up

74.

____________ key moves the active cell highlight to cell A 1

a)

HOME

b)

Ctrl + HOME

c)

pg up

75.

____________ key moves one column right.

a)

->

b)

<-

c)

pg up

d)

pg down

76.

____________ key moves one column left

a)

pg up

b)

pg dn

c)

<-

d)

->

77.

________keys moves the active cell highlight to the first row of the spread sheet.

a)

pg up

b)

pg dn

c)

->

d)

<-

78.

_____moves the active cell highlight to the next sheet.

a)

pg dn

b)

pg up

c)

->

d)

<-

79.

Cell address is called cell reference.

a)

True

b)

False

80.

__________allow us to save an existing file in a new name.

a)

Save

b)

Save As

c)

Both a and B