Let's check your Excel Knowledge_Sanwar

What is default alignment of Date in cell in MS Excel?

• Right

• Left

• Center

• It can be anywhere

What all data types require double quotes (") in the case of manual input?

• Text, Date & Time

• Text, Numbers

• Numbers & Logicals

• Text & Logicals

How can we get the quick access to any of the option in Excel?

• Via Status Bar

• Via Quick Access Toolbar

• Via Formula Bar

• All of the Above

Which function is used in Excel to find the 4th Largest Number?

• Max

• Large

• Len

• Average

What is the shortcut Key of Format Cells?

• Alt +1

• Control +1

• Window +1

• Control+T

Which input way is used in this formula? =Count(C1:C20)

• Manual Input

• Reference Input

• Formula Input

• Text Input

What is the shortcut key to change a table in "Table Design"?

• CTRL+L

• CTRL+SHIFT+L

• CTRL+K

• CTRL+E

How can we apply the multiple criteria filters in one Go?

• Filter

• Advance Filter

• Multiple Sorting

• Validation

Which of the following functions can control the error?

• ISERROR

• ERRORTYPE

• IFERROR

• ERRORVALUE

Which function key is used to “Save As” an Excel file?

• F1

• F4

• F5

• F12