Spreadsheet Software

Total Questions: 25

1 - A worksheet is made of

A ) Rows and columns ✅
B ) Rows only
C ) Columns only
D ) None of these

2 - Each worksheet contains columns

A ) 255
B ) 254
C ) 257
D ) 256 ✅

3 - The sign for formula or function is

A ) £
B ) = ✅
C ) &
D ) ?

4 - Sort ascending/descending option exist in

A ) Insert menu
B ) Tool menu
C ) Alignment menu
D ) Home menu ✅

5 - Shortcut key to save command is

A ) Ctrl+S ✅
B ) Ctrl+P
C ) Ctrl+H
D ) Ctrl+X

6 - The keyboard shortcut for closing current workbook is

A ) Ctrl+F4 ✅
B ) Ctrl+F2
C ) Ctrl+F1
D ) Ctrl+F5

7 - The keyboard shortcut for closing current workbook is

A ) Ctrl+F4 ✅
B ) Ctrl+F2
C ) Ctrl+F1
D ) Ctrl+F5

8 - Web page option exist in

A ) Format menu
B ) Data menu
C ) File menu ✅
D ) Tool menu

9 - The cell range A2 through C2 should be keyed as

A ) A2-C2
B ) A2 to C2
C ) A2:C2 ✅
D ) A2...C2

10 - Each worksheet contains rows

A ) 65,000
B ) 66,000
C ) 65,536 ✅
D ) 65,500

11 - Texts are entered in

A ) Cells ✅
B ) Bells
C ) Jells
D ) Hells

12 - Shortcuts for select entire worksheet is

A ) Ctrl+B
B ) Ctrl+A ✅
C ) Ctrl+C
D ) Ctrl+D

13 - Shortcut key for format cell is

A ) Ctrl+F2
B ) Alt+F2
C ) Ctrl+F1 ✅
D ) Alt+F1

14 - To move to the next worksheet in a workbook press

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

15 - To move to the previous worksheet in a workbook press

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

16 - To combine two or more cells into one is called

A ) Split
B ) Joining
C ) Merge ✅
D ) Center

18 - Shortcut key to open old workbook is

A ) Ctrl+F
B ) Ctrl+O ✅
C ) Ctrl+N
D ) Ctrl+Y

19 - Shortcut key to move next workbook is

A ) Ctrl+Pg dn ✅
B ) Shift+pg dn
C ) Shift+F6
D ) F6

20 - Conditional formatting option exists is

A ) Edit menu
B ) Data menu
C ) Home menu ✅
D ) File menu

21 - What is the shortcut key to close a spreadsheet

A ) Ctrl+C
B ) Ctrl+Y
C ) Ctrl+W ✅
D ) Ctrl+O

22 - Shortcut key to paste a cell is

A ) Ctrl+P
B ) Ctrl+X.
C ) Ctrl+V ✅
D ) Ctrl+Z

23 - The name of option to select all worksheets is

A ) Select selector
B ) Select All ✅
C ) Choose sheet
D ) Select sheet

24 - The function that is used to get date and time simultaneously

A ) Today ()
B ) Now() ✅
C ) Date()
D ) Date/Time

25 - Which of the following is not a type of chart

A ) Pie-chart
B ) Area chart
C ) T-graph ✅
D ) Line graph