Practice Pakistan's most useful MCQs for competitive exams

In Excel which key is used to open the excel formula window?

• (A)  Shift+F6
• (B)  Shift+F3
• (C)  Alt+Shift+F3
• (D)  Alt+Shift+F6

Answer

Submitted By :Ali Uppal

In Excel which key is used for create a formula to sum all of the above cells?

• (A)  Ctrl+=
• (B)  Alt+-
• (C)  Alt+=
• (D)  Ctrl+-

Answer

Submitted By :Ali Uppal

In Excel which key is used for format number in comma format?

• (A)  Ctrl+Shift+1
• (B)  Ctrl+Shift+4
• (C)  Ctrl+1
• (D)  Shift+1

Answer

Submitted By :Ali Uppal

In Excel which key is used for format number in currency format?

• (A)  Ctrl+Shift+1
• (B)  Ctrl+Shift+4
• (C)  Ctrl+1
• (D)  Shift+1

Answer

Submitted By :Ali Uppal

In Excel which key is used for format number in date format?

• (A)  Ctrl+Shift+6
• (B)  Ctrl+Shift+4
• (C)  Ctrl+Shift+3
• (D)  Shift+1

Answer

Submitted By :Ali Uppal

In Excel which key is used for format number in percentage format?

• (A)  Ctrl+Shift+6
• (B)  Ctrl+Shift+3
• (C)  Ctrl+Shift+5
• (D)  Ctrl+1

Answer

Submitted By :Ali Uppal

In Excel which key is used for format number in scientific format?

• (A)  Ctrl+Shift+6
• (B)  Ctrl+Shift+3
• (C)  Ctrl+Shift+5
• (D)  Ctrl+Shift+4

Answer

Submitted By :Ali Uppal

In Excel which key is used for format number in time format?

• (A)  Ctrl+Shift+6
• (B)  Ctrl+Shift+3
• (C)  Ctrl+Shift+5
• (D)  Ctrl+Shift+2

Answer

Submitted By :Ali Uppal

Which of the following methods cannot be used to enter data in a cell

• (A)  Pressing an arrow key
• (B)  Pressing the Tab key
• (C)  Pressing the Esc key
• (D)  Clicking on the formula bar

Answer

Submitted By :Ali Uppal

Which option is not available in Insert Table Autofit behavior?

• (A)  Fixed Column Width
• (B)  AutoFit to Contents
• (C)  Autofit to Window
• (D)  Autofit to Column

Answer

Submitted By :Ali Uppal