9th Computer Revision Test - 2 (9th-SN)
Hi AMBIKESH, when you submit this form, the owner will be able to see your name and email address.
1.List the features of spreadsheet. Single choice.
(1 Point)
Maintaining records
Analysing data
Creating MIS
All of the above
2.Which of the given belong to the spreadsheet softwares?. Multiple choice.
(1 Point)
MS Excel
Open office - calc
MS Word
All of the above
3.What is the extension of MS Excel workbook?. Single choice.
(1 Point)
.xlsx
. Docx
.xls
.pptx
4.This is a grid of horizontal rows and vertical columns.. Single choice.
(1 Point)
Row
Column
Worksheet
Workbook
5.Name the fundamental element of worksheet.. Single choice.
(1 Point)
Column
Cell
Row
Workbook
6.The address of the cell displayed in?. Single choice.
(1 Point)
Formula bar
Name box
Column header
Row header
7.The wrap text option is available under which tab in MS Excel?. Single choice.
(1 Point)
Page layout
Formula tab
View tab
Home tab
8.The process of combining two or more cells into a single cell is called as?. Single choice.
(1 Point)
Wrap text
Sorting
Merging
Filtering
9.________________ is a feature in many spreadsheet applications that allow you to apply specific formatting to cells that meet certain criteria.. Single choice.
(1 Point)
Wrap text
Sorting
Merging
Conditional formatting
10.Steps for deleting a column. Single choice.
(1 Point)
Select any cell within the column then go to home tab > insert >delete sheet columns
Select any cell within the column then go to Page layout tab > insert >delete sheet columns
Both
None of these
11.Which chart is used to compare several items in a specific range of values?. Single choice.
(1 Point)
Line chart
Column chart
Pie chart
Area chart
12.If you wanted to print a specific area on a worksheet, which option you need to use?. Single choice.
(1 Point)
Print titles
Printarea
Print
None of these
13.This feature enables you to print particular row and column headings on each page of the report?. Single choice.
(1 Point)
Print area
Print preview
Print titles
None of these
14.Which of the following formulas are not present in MS Excel?. Multiple choice.
(1 Point)
AVG
MIN
MAX
SUM
15.Which formula can be used to remove extra spaces?. Single choice.
(1 Point)
Upper()
Lower()
Trim ()
None of these
16.______________ tool automatically fills your data when it senses a pattern.. Single choice.
(1 Point)
Autofill
Flash fill
Column fill
None of these
17.In which cell referencing the cells are referred by the relative position in worksheet relative to a particular cell?. Single choice.
(1 Point)
Absolute cell referencing
Relative referencing
Mixed cell referencing
18.Cell referencing in which the cells are referred by their fixed position in the worksheet is known as?. Single choice.
(1 Point)
Fixed cell referencing
Absolute cell reference
Mixed cell referencing
Relative cell reference
19.It is a combination of relative and absolute referencing?. Single choice.
(1 Point)
Mixed referencing
Wrap text
Merging
20.________________ is the small black square in the corner of the selection.. Single choice.
(1 Point)
Cursor
Fill handle
Flash fill
Auto fill
21.The general arrangement of data is known as?. Single choice.
(1 Point)
Formatting
Sorting
Filtering
All of the above
22.___________ of data means arranging data in a particular order. Single choice.
(1 Point)
Formatting
Sorting
Filtering
All of the above
23.Which of the following belongs to the components of a chart?. Single choice.
(1 Point)
Data series
Chart area
Legend
All of the above
24.These are horizontal and vertical lines in the plot area.. Single choice.
(1 Point)
X-axis
Y-axis
Grid lines
All of the above
25."To keep an area of worksheet visible, while you scroll to another area of worksheet." which option we need to use for this?. Single choice.
(1 Point)
Print area
Print title
Freeze panes
All of the above
26.Which option in excel I used to create a named range?. Single choice.
(1 Point)
Data validation
Name manager
Consolidation
None of these
27.Which option can be used to restrict the type of data on the values that user enters into a cell?. Single choice.
(1 Point)
Data consolidation
Data validation
Data filtering
Data sorting
28.Which option is used to gather your data from separate worksheets into a master worksheet.. Single choice.
(1 Point)
Data consolidation
Data validation
Data filtering
Data sorting
29.What is the shortcut key for editing a cell. Single choice.
(1 Point)
F1
F2
F3
F4
30.Which formula returns one of two values depending on a test condition?. Single choice.
(1 Point)
If formula
Sum formula
Average formula
All of the above
Answers
Answered by
6
Answer:
OMG!!!!
Explanation:
use short answer questions....moderators will be spammed for very long answers
Answered by
1
Answer:
if u want to join the classes
first tell me your from and syllabus
Similar questions