WorksheetsCOMPUTER QUIZ
Total questions: 20
Worksheet time: 3mins
________ is the combination of its column letter and row number.
Cell Reference
Cell Range
Mixed Cell Reference
Cell Address
_________ refers to a single cell or a range of cells.
Cell Reference
Cell Range
Adjacent Range
Non-Adjacent Range
Renaming a sheet
A selected cell is called an - ___________ .
Cell Reference
Active Cell
Cell Range
Non-Adjacent Range
_________ refers to selecting a cell instead of typing the cell address in the Name Box or the Formula Bar.
Pasting
Selecting
Copying
Pointing
________ can have multiple groups of cells separated by rows or columns.
Plot area
Renaming a sheet
Non- Adjacent Range
Chart Area
_________ enable an easy visual representation of data and its inter-relationships.
Charts
Legend
Data Points
Data Series
_________ refers to the border that appears around the selected cell or range of cells.
Formula Bar
Name Box
Marquee
Adjacent Range
________ reference maintains the values of a row and/or column.
Absolute Cell
Mixed Cell
Functions
AutoFill
________ reference is the default type of reference.
Marquee
AutoFill
Mixed Cell
Relative Cell
_________ is a feature that automatically fills contiguous cell with data that is in a particular pattern
Pie Chart
Bar Chart
AutoFill
Cell References
There are 7 types of Chart.
TRUE
FALSE
Is this line is correct-
In a Bar Chart, the Data is Plotted in vertical Bars horizontally across the chart.
True
False
There are 10 types of Chart Elements.
False
True
Is this Line is correct-
DataPoints- The data that is plotted on the chart and represented using data points.
False
True
Charts Enable the feature to automatically fills data in a particular pattern.
True
False
Which of the following is not the operators ?
Arithmetic.O
Marquee
Comparison .O
Reference.O
Which is the Correct Example of Comparison operators ?
A2 > A5
B5 = D5
A2 + A5
B5 = D5
B4:B7
(A2= Akash B2= Sinha)
A2 and B2 = AkashSinha
Which is not the operators of Reference Operators?
Colon (:)
Ampersand (&)
Comma (,)
Space ( )
Which is the operators of Arithmetic Operators?
(&),=,*,%
(:),=,^,*
+,-,%,*
( ),-,>,<
How Formulas are used ?
To expression containing cell References and operators that is used to perform calculations.
To specify the type of calculation that are performed on the elements of a formula.
To performed based on the precedence of the operators.
To predefined formula in a spreadsheet.
