Category 1
What is a spreadsheet?
A digital tool for organizing, analyzing, and storing data in tabular form.
What is a workbook?
A file that contains one or more spreadsheets.
What is a row?
A horizontal line of cells in a spreadsheet.
What is an absolute reference?
A cell reference that remains constant when a formula is copied to another cell (e.g., $A$1).
What are spreadsheets used for?
For managing and analyzing data, budgeting, and financial calculations.
What is a cell?
The intersection of a row and column in a spreadsheet where data is entered.
How do you save a file?
By clicking on "File" and then "Save" or using the shortcut Ctrl + S.
What is a column?
A vertical line of cells in a spreadsheet.
What is a relative reference?
A cell reference that changes when a formula is copied to another location (e.g., A1).
How do you insert a row ?
By right-clicking on the row number and selecting "Insert."
What is a formula?
An equation in a spreadsheet that performs calculations using cell references.
What is formatting?
The process of changing the appearance of data in a spreadsheet, such as font size or color.
What is a range?
A selection of two or more cells in a spreadsheet.
What is a data series?
A group of related data points in a spreadsheet, often used in charts.
What is a filter?
A feature that allows users to display only data that meets certain criteria.
What is a function?
A predefined calculation in a spreadsheet, such as SUM or AVERAGE.
What is data validation?
A feature that restricts the type of data that can be entered into a cell.
How do you create a new sheet in Google Sheets ?
By clicking on the "+" icon at the bottom of the spreadsheet.
What is merging cells?
The process of combining multiple cells into one larger cell.
What is sorting data?
The process of arranging data in a specific order, such as ascending or descending.
What is a Chart?
A visual representation of data in a spreadsheet, such as a bar graph or pie chart.
What is conditional formatting?
A feature that changes the appearance of cells based on specific conditions.
What is a pivot table?
A data processing tool used to summarize and analyze data in a spreadsheet.
What is the purpose of a header?
To label columns or rows in a spreadsheet for clarity and organization.
What is a function argument?
Answer: The values or inputs that a function uses to perform its calculations.