Quiz 2: Quiz: Data Input in Excel

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

• F1

• F2

• F4

• Shift+Enter

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

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

• Month always comes first

• Day always comes first

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

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

• TRUE

• FALSE

How can you add a Screentip to your cells?

• From the Insert Tab, select Link

• From the Data Tab, select Data Validation

• From the Home Tab, select Fill – Flash Fill

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?

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

• You go to Home > Find & Select

• You check each cell one by one