wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Quiz 2: Quiz: Data Input in Excel

Total questions: 5

Worksheet time: 3mins

Name
Class
Date
1.

What’s the keyboard shortcut to edit the content of a cell?

a)

F1

b)

F2

c)

F4

d)

Shift+Enter

2.

Which statement is correct when it comes to inputting dates in Excel?

Excel मध्ये date टाकण्याच्या बाबतीत कोणते statement बरोबर आहे?

a)

Month always comes first

b)

Day always comes first

c)

Whether you type in the month or day first depends on your regional settings

3.

True or False? You can use Autofill to get a list of weekdays?


a)

TRUE

b)

FALSE

4.

How can you add a Screentip to your cells?

a)

From the Insert Tab, select Link

b)

From the Data Tab, select Data Validation

c)

From the Home Tab, select Fill – Flash Fill

5.

You receive a new workbook from your colleague. The workbook contains a worksheet with lots of data. You’d like to color all the cells that have formulas in them in yellow. What do you do?

a)

You highlight the cells, right-mouse click and Format Cells

b)

You go to Home > Find & Select

c)

You check each cell one by one