Data Entering in EXCEL:

Tab 
 

Shift + Tab
 

 Spacebar
 

Enter

Type the date in the format mm/dd/yyyy

 

 Use the date formula =DATE(yyyy, mm, dd)
 

 Use the date picker button in the ribbon
 

All of the above

 To organize and analyze data in a structured format 
 

To create charts and graphs
 

To insert images and shapes
 

 To apply formatting to cells

Go to the "Insert" tab and select "Table" 

 

Use the keyboard shortcut Ctrl + T
 

Go to the "Data" tab and select "Table"
 

All of the above

A) To add visual aids to a worksheet, such as images and shapes 
 

B) To organize data into tables
 

C) To calculate numerical values based on cell data
 

All of the above

 Go to the "Insert" tab and select "Picture" 
 

 Use the keyboard shortcut Ctrl + Shift + P

 

Right-click on a cell and select "Insert Picture"
 

D) All of the above

To quickly fill in a series of data, such as dates or numbers 

To apply formatting to cells

 

 To calculate numerical values based on cell data
 

To insert objects, such as pictures or shapes

A) Go to the "File" tab and select "Options" and "Edit Custom Lists"
 

B) Go to the "Home" tab and select "AutoFill Options" 
 

C) Right-click on the worksheet and select "Create Custom AutoFill List"
 

D) None of the above

To quickly find and replace specific data in a worksheet 
 

To apply formatting to cells
 

To calculate numerical values based on cell data
 

 To insert objects, such as pictures or shapes

Go to the "Home" tab and select "Find & Select" 
 

 Use the keyboard shortcut Ctrl + F
 

 Right-click on the worksheet and select "Find & Replace"
 

All of the above