wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Excel Fun Time

Total questions: 25

Worksheet time: 42mins

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.
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
4.
Provides easy access to frequently used commands:
a)
group
b)
Quick Access Toolbar
c)
cell
d)
none of the above
5.

Microsoft Excel is categorized as a ________________ software.

a)

Database

b)

Spreadsheet

c)

Presentation

d)

Word Processing

6.

?

a)

B1

b)

B2

c)

B3

7.

Name of the workbook is displayed in the ___________

a)

Menu bar

b)

Title bar or ribbon

c)

Tool bar

d)

option bar

8.

Identify the person in the image

a)

Jeff Bezos

b)

Mark Zuckerberg

c)

Bill Gates

d)

Sundar Pichai

9.
12) What is the keyboard shortcut to select a row of active cells?

   
 
 
a)
 a) Shift + Spacebar 
b)
b) Ctrl + Spacebar
c)
c) Shift + End 
d)
d) Ctrl + End 
10.

A column is represented by numbers.

a)

true

b)

false

11.
A combination of numbers and symbols used to express a calculation. Always begins with an = sign.
a)
Cell address
b)
Worksheet
c)
Formula
12.
What is a file which contains one or more spreadsheets?
a)
spreadsheet
b)
workbook
c)
cell 
d)
cell range
13.

What is a range in Excel?

a)

An individual space

b)

A group of cells

c)

A graph

d)

A formula

14.

What is the file extension for Excel worksheets?

a)

.png

b)

.pptx

c)

.xlsx

d)

.docx

15.

Which of the following is a function in Excel

a)

Count

b)

Cell

c)

Chart

d)

Conditional

16.

Which of the following is not a type of Conditional Formatting

a)

Colour Scale

b)

Gradient Fill

c)

Font Effects

d)

Data bars

17.
When entering text in Excel, it is automatically (by default):
a)
Left Justified
b)
Right Justified
c)
Center Justified
d)
Full Justified
18.
What button will add up a group of numbers
a)
Equals button
b)
Plus symbol button
c)
Auto-sum button
19.

SHORT CUT FOR CUT

a)

CTRL+C

b)

CTRL+V

c)

CTRL+D

d)

CTRL+X

20.

Which of the following is not a type of Conditional Formatting

a)

Colour Scale

b)

Gradient Fill

c)

Font Effects

d)

Data bars

21.

Name of the workbook is displayed in the ___________

a)

Menu bar

b)

Title bar or ribbon

c)

Tool bar

d)

option bar

22.

One Can Edit the Existing Cell or Data in a cell by Pressing the

a)

F5 Key

b)

F1 Key

c)

F2 Key

d)

F9 Key

23.

To edit or delete a range name already given in an Excel spreadsheet.

a)

Define Name

b)

Name Box

c)

Name Manager

d)

All are correct

24.

In MS Excel, Ctrl+S can be used to______

a)

Start New Workbook

b)

Save

c)

Switch between opened tab

d)

Switch to Sheet

25.

Choose the correct answer matching the picture

a)

Steve Jobs - Founder of Microsoft

b)

Steve Jobs - Founder of Flipkart

c)

Steve Jobs - Founder of Google

d)

Steve Jobs - Founder of Apple