wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

EXCEL EDITING AND FORMATTING

Total questions: 17

Worksheet time: 9mins

Name
Class
Date
1.

The process of making changes to the existing content of the document.

a)

Printing

b)

Retrieving

c)

Editing

d)

Formatting

2.

It is the process of changing the appearance of the document.

a)

Formatting

b)

Editing

c)

Retrieving

d)

Saving

3.

The.................... feature lets you quickly enter a pre-defined series of data.

a)

AutoFill

b)

FlashFill

c)

CustomFill

d)

Copy

4.

..................recognizes the data fill pattern in a worksheet and fills the remaining series according.

a)

AutoFill

b)

Custom Fill

c)

Flash fill

d)

None of These

5.

The Conditional Formatting button is present in the ____________ group on the Home Tab.

a)

Styles

b)

Cells

c)

Editing

d)

Alignment

6.

What are the numbers in spreadsheet called?

a)

Rows

b)

Alphabet

c)

Column

d)

Symbols

7.

Among these AutoFill options which one is used to fill the cell with the next items in the series

a)

Copy Cells

b)

Fill Formatting only

c)

Fill series

d)

Fill without Formatting

8.

Chris wants to update the default Title Style by changing the font color and font style. To accomplish this, on the Home tab, in the Styles Group, Chris should click on the Cell Styles icon, right-click the Title Style, and select which option?

a)

Modify

b)

Apply

c)

Delete

d)

Duplicate

9.

In Excel, Rows are labelled as ______

a)

A, B, C, etc

b)

A1, A2, etc.

c)

1,2,3 etc

d)

1A,2B,3C, etc

10.

How many sheets are there, by default, when we

create a new Excel file ?

a)

3

b)

5

c)

1

d)

10

11.

An Excel file is generally called a / an :

a)

E-Spreadsheet

b)

Worksheet

c)

NoteBook

d)

Workbook

12.

Excel files have a default extension of

a)

.xlsx

b)

.docx

c)

.pptx

d)

.wk1

13.

Which tool you will use to join some cells and place the content at the middle of joined cell?

a)

From Format Cells dialog box click on Merge Cells check box

b)

From Format Cells dialog box select the Centered alignment

c)

From Format Cells dialog box choose Merge and Center check box

d)

Click on Merge and Center tool on formatting toolbar

14.

The Name

box on to the left of formula bar

a)

Shows the name of workbook currently working on

b)

Shows the name of worksheet currently working on

c)

Shows the name of cell or range currently working on

d)

None of above

15.

Which of

the following is not the correct method of editing the cell content?

a)

Press the Alt key

b)

Press the F2 key

c)

Click the formula bar

d)

Double click the cell

16.

Intersection of a row and a column in excel is called a_____________

a)

Value

b)

Address

c)

Cell

d)

None of the above

17.

_____________________refers to the rotation of the text at different angles inside the cell

a)

Indentation

b)

Alignment

c)

Orientation

d)

Merging