NEW
Font size
WorksheetsSpreadsheet Basics Quiz
Total questions: 30
Worksheet time: 15mins
Light gray lines that divide each of the cells, rows, and columns in a spreadsheet
Cell Location
Worksheet
Gridlines
Sparkline
To combine into one
Merge
Filter
Import
Sort
A formula or equation used to generate an answer
Autofill
Function
Cell Reference
AutoSum
A tool which fills in a field or cells automatically
AutoSum
Import
Merge
Autofill
The vertical parts of a spreadsheet denoted by capital letters
Rows
Cell Reference
Cell Location
Columns
The horizontal parts of a spreadsheet denoted by numbers
Cell
Rows
Relative Reference
Columns
Referring to a rectangle on a spreadsheet by naming the column and then row in which it lies
Sparkline
Absolute Reference
Cell Reference
Cell Location
The rectangular fields you can type in on a spreadsheet formed when a column and row intersect
Painter
Worksheet
Cell
Workbook
The entire spreadsheet file you are working in. It can contain one or more worksheets
Workbook
Painter
Cell Reference
Worksheet
A part/page on a spreadsheet file you are working in
Workbook
Sparkline
Cell Location
Worksheet
A small graphic designed to give a quick representation of numerical or statistical information taking the form of a graph without axes
Painter
Sparkline
Workbook
Gridlines
Automatically adds up values in a row or column
Autofill
AutoSum
Export
Import
To put in order
Sort
Filter
Merge
Function
To remove unwanted pieces of data from view in a table
Sort
Merge
Autofill
Filter
A spreadsheet cell that does not change regardless of its attributes
Cell Reference
Relative Reference
Cell Location
Absolute Reference
A spreadsheet cell that does change depending on what changes were made to the spreadsheet it is located on
Relative Reference
Absolute Reference
Cell Referenced
Cell Location
Refers to a cell or range of cells on a worksheet and can be used in a formula so the program can find the values or data you want a formula to calculate
Cell Reference
Relative Reference
Cell Location
Absolute Reference
A small graphic designed to give a quick representation of numerical or statistical information taking the form of a graph without axes
Chart
Graphline
Workbook
Gridlines
To automatically adjust the width of a column to fit the longest string in the column
AutoFit
AutoAdjust
AutoWidth
AutoColumn
A feature that allows data to be displayed in a visual representation such as a pie chart or bar graph
Data Visualization
Data Representation
Data Display
Data Graphing
Computer spreadsheet cell that is highlighted with heavy border is :
Active cell
Passive cell
Locked cell
Formatted cell
Rohan selected the 4th row and 3rd column in a spreadsheet. Then what is the cell address?
3C
C3
4C
C4
Data available in other sheets in a workbook , can be consolidate by :
Row label
Column Label
Both a & b
None of the mentioned
Which of the following is not a type of referencing in a spreadsheet?
Absolute
Physical
Relative
Mixed
Which options is available in Openoffice (Oo) Calc in which tab:
Insert
Data
Tools
Format
In Data consolidate what are the operations we can perform___
Sum
Average
Max
All of the above
In a Subtotal function what are the functions can be performed on the group of cells:
Sum
Count
Average
All of the above
To edit a Scenario, right click the name in the Navigator and select________.
Properties
Scenario
Window
Edit
A_________ is a What if Analysis tool that allows you to substitute set of values automatically in a worksheet.
Goal Seek
Navigator
Scenario
Subtotal
Goal Seek command is found in_________
Data
Tools
Format
Edit
