Shortcuts for select entire worksheet is:
- (A) Ctrl + B
- (B) Ctrl + A
- (C) Ctrl + C
- (D) Ctrl + D
- (B) Ctrl + A
Shortcut key for format cell is:
- (A) Ctrl + F2
- (B) Alt + F2
- (C) Ctrl+1
- (D) Alt + F1
- (C) Ctrl+1
To move to the next worksheet in a workbook press:
- (A) Ctrl+ page down
- (B) Ctrl+ page up
- (C) Ctrl + Home
- (D) Ctrl + End
- (A) Ctrl+ page down
To move to the previous worksheet in a workbook press:
- (A) Ctrl + page down
- (B) Ctrl + page up
- (C) Ctrl + Ins
- (D) Ctrl + Del
- (B) Ctrl + page up
To combine two or called more cells into one is:
- (A) Split
- (B) Joining
- (C) Merge
- (D) Center
- (C) Merge
The function that is used to count the number of entries in the given range is:
- (A) Counter
- (B) Count
- (C) Counting
- (D) Sorting
- (B) Count
Shortcut key to open old workbook is:
- (A) Ctrl + F
- (B) Ctrl + O
- (C) Ctrl + N
- (D) Ctrl + Y
- (B) Ctrl + O
Shortcut key to move next workbook is:
- (A) Ctrl + F6
- (B) Alt+F6
- (C) Shift + F6
- (D) F6
- (A) Ctrl + F6
Conditional Formatting option exist in:
- (A) Edit menu
- (B) Data menu
- (C) Format menu
- (D) File menu
- (C) Format menu
Web Page option exist in:
- (A) Format menu
- (B) Data menu
- (C) File menu
- (D) Tool menu
- (C) File menu