MICROSOFT EXCEL

Shortcuts for select entire worksheet is:

• (A) Ctrl + B
• (B) Ctrl + A
• (C) Ctrl + C
• (D) Ctrl + D

Shortcut key for format cell is:

• (A) Ctrl + F2
• (B) Alt + F2
• (C) Ctrl+1
• (D) Alt + F1

To move to the next worksheet in a workbook press:

•  (A) Ctrl+ page down
• (B) Ctrl+ page up
• (C) Ctrl + Home
• (D) Ctrl + End

To move to the previous worksheet in a workbook press:

• (A) Ctrl + page down
• (B) Ctrl + page up
• (C) Ctrl + Ins
• (D) Ctrl + Del

To combine two or called more cells into one is:

• (A) Split
• (B) Joining
• (C) Merge
• (D) Center

The function that is used to count the number of entries in the given range is:

• (A) Counter
• (B) Count
• (C) Counting
• (D) Sorting

Shortcut key to open old workbook is:

• (A) Ctrl + F
• (B) Ctrl + O
• (C) Ctrl + N
• (D) Ctrl + Y

Shortcut key to move next workbook is:

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

Conditional Formatting option exist in:

• (A) Edit menu
• (B) Data menu
• (C) Format menu
• (D) File menu

Web Page option exist in:

• (A) Format menu
• (B) Data menu
• (C) File menu
• (D) Tool menu