WorksheetsSpreadsheet Terminologies
Total questions: 20
Worksheet time: 11mins
What is a spreadsheet primarily used for?
Designing graphics
Writing code
Organizing data
Creating presentations
Which of the following is a feature of spreadsheets?
3D modeling
Automatic calculations
Web development
Video editing
What does a cell in a spreadsheet represent?
A chart
A type of formula
A box where a row and column intersect
A row of data
What is the purpose of a cell range?
To save the spreadsheet
To create a chart
To format text
To select multiple cells for calculations
Which of the following is NOT a spreadsheet application
None of the above
Google doc
Google Sheets
Microsoft Excel
What does the term 'cell address' refer to?
The unique location of a cell
The name of the spreadsheet
The color of a cell
The size of a cell
What is a workbook?
A type of formula
The entire spreadsheet file
A single page within a spreadsheet
A chart type
Which of the following is an example of predefined formula in spreadsheets?
SUM
Label
Cell Range
Cell Address
What is the function of a formula in a spreadsheet?
To save data
To create charts
To perform calculations
To format cells
What does the term 'label' refer to in a spreadsheet?
A type of formula
A chart title
A cell range
Any text entered in a cell
Which of the following is true about Google Sheets?
It requires a paid subscription
It is only available on Windows
It is accessible online for free
It cannot be used for real-time collaboration
What is the purpose of visualizing data in spreadsheets?
To increase file size
To create complex formulas
To save time
To make data easy to understand
What does a column in a spreadsheet represent?
A group of selected cells
Runs vertically and is labeled with letters
Runs horizontally across the sheet
A type of chart
What is the first step in writing a formula?
Select a cell
Choose a function
Start with an equal sign
Enter a cell range
What is the purpose of the 'Value' in a cell?
To hold text
To create a label
To represent any number
To perform calculations
How is a cell range represented?
By two cell references separated by a colon
By two cell references separated by a comma
By a single cell reference
By a formula
What is the main advantage of using spreadsheets over paper ledgers?
They are easier to read
They take up less space
They allow for automatic calculations
They are more colorful
What is the purpose of the 'Function' in a spreadsheet?
To save the workbook
To format cells
To perform common calculations
To create a new worksheet
Susan collects the names and ages of people in a community survey for record-keeping purposes using a form. What is being collected in this case — data or information?
(a)
The (a) shows the location of your active cell.
