Spreadsheets: Master the Basics for Public Services

Question 1

Which of the following is NOT a widely used spreadsheet software program?

Accepted Answer

Microsoft Word

Answer

Microsoft Excel

Answer

Google Sheets

Answer

LibreOffice Calc

Question 2

Which type of cell reference remains constant regardless of the cell's position in the spreadsheet, such as $A$1?

Accepted Answer

Absolute reference

Answer

Relative reference

Answer

Mixed reference

Answer

Circular reference

Question 3

What is the primary purpose of using a formula in a spreadsheet?

Accepted Answer

To perform calculations on cell data

Answer

To format cells

Answer

To create charts and graphs

Answer

To sort and filter data

Question 4

Which function is used to calculate the average value of a range of cells?

Accepted Answer

AVERAGE()

Answer

SUM()

Answer

MAX()

Answer

MIN()

Question 5

What is the main purpose of using a pivot table in a spreadsheet?

Accepted Answer

To summarize and analyze large amounts of data

Answer

To create charts and graphs

Answer

To perform calculations on cell data

Answer

To filter and sort data

Question 6

What is the purpose of using a data validation rule in a spreadsheet?

Accepted Answer

To restrict the data that can be entered into a cell

Answer

To calculate values based on entered data

Answer

To format cells based on entered data

Answer

To create charts and graphs based on entered data

Question 7

Which of the following is NOT a potential security risk associated with spreadsheets?

Accepted Answer

All of the above pose security risks

Answer

Sharing spreadsheets with unauthorized individuals

Answer

Leaving sensitive data unprotected

Answer

Using macros that contain malicious code

Question 8

Which of the following is NOT a fundamental capability of spreadsheet software?

Accepted Answer

Database creation and management

Answer

Data entry and manipulation

Answer

Formula and function application

Answer

Chart and graph generation

Question 9

Which function is used to determine the average of a group of cells?

Accepted Answer

AVERAGE

Answer

SUM

Answer

COUNT

Answer

MAX

Question 10

For which purpose is a line chart most appropriate?

Accepted Answer

Comparing data values over time

Answer

Displaying categorical data

Answer

Showing proportions of a whole

Answer

Exploring relationships between variables

Question 11

What is the primary function of a header row in a spreadsheet?

Accepted Answer

Identifying column content

Answer

Formatting specific data

Answer

Calculating row totals

Answer

Sorting data

Question 12

What is the term for a defined group of cells in a spreadsheet?

Accepted Answer

Range

Answer

Array

Answer

Table

Answer

Block

Question 13

Which of the following is NOT a common use of spreadsheets?

Accepted Answer

Designing brochures and advertisements

Answer

Financial planning and budgeting

Answer

Scientific data analysis

Answer

Inventory management

Question 14

Which chart type is best suited for showing data that changes or trends over time?

Accepted Answer

Line chart

Answer

Bar chart

Answer

Pie chart

Answer

Scatter plot

Question 15

Which of the following is NOT a common task performed using spreadsheet applications like Microsoft Excel or Google Sheets?

Accepted Answer

Performing complex programming

Answer

Data entry and manipulation

Answer

Creating charts and graphs

Answer

Performing statistical analysis

Question 16

Which spreadsheet feature enables multiple users to work together on the same file simultaneously, track changes, and manage different versions?

Accepted Answer

Shared Workbooks

Answer

Conditional Formatting

Answer

Data Validation

Answer

AutoSave

Question 17

Which advanced data validation technique enables you to establish a customized rule for validating user input?

Accepted Answer

Custom Validation

Answer

Input Message

Answer

Error Alert

Question 18

Which practice violates recommended spreadsheet best practices?

Accepted Answer

Sharing spreadsheets with unauthorized individuals

Answer

Protecting sensitive data with passwords

Answer

Naming cells clearly and descriptively

Answer

Backing up spreadsheet files regularly

Question 19

What is the purpose of a cell reference in a spreadsheet?

Accepted Answer

To uniquely identify the location of a specific cell within the spreadsheet

Answer

To store a particular value or data

Answer

To perform mathematical operations on multiple cells

Answer

To create a chart or graph

Question 20

Which function would you use to calculate the total sum of a range of cells?

Accepted Answer

SUM

Answer

AVERAGE

Answer

MAX

Answer

MIN

Question 21

What is the key difference between a relative and an absolute cell reference?

Accepted Answer

Relative references change when copied or moved, while absolute references remain constant.

Answer

Absolute references change when copied or moved, while relative references remain constant.

Answer

Both relative and absolute references change when copied or moved.

Question 22

Which chart type is most appropriate for comparing data values across different categories?

Accepted Answer

Bar chart

Answer

Line chart

Answer

Pie chart

Answer

Scatter plot

Question 23

What is the main purpose of data validation in a spreadsheet?

Accepted Answer

To restrict the type of data that can be entered into specific cells, ensuring data integrity

Answer

To automatically update the values in other cells based on user input

Answer

To create visual representations of data using charts and graphs

Answer

To protect sensitive data from unauthorized access

Question 24

Which file format is commonly used for sharing spreadsheets with users who may not have the same spreadsheet software installed?

Accepted Answer

CSV (Comma-Separated Values)

Answer

XLSX (Microsoft Excel's default format)

Answer

ODS (OpenDocument Spreadsheet)

Answer

PDF (Portable Document Format)

Question 25

What is a macro in the context of spreadsheet software?

Accepted Answer

A series of recorded actions that can be played back to automate repetitive tasks

Answer

A formula that performs complex calculations on data

Answer

A visual representation of data using charts or graphs

Answer

A pre-defined template that provides a structured layout for spreadsheets

Question 26

Which of the following is NOT a characteristic of spreadsheet software?

Accepted Answer

Video editing

Answer

Data manipulation

Answer

Formula creation

Answer

Chart creation

Question 27

What is the primary purpose of a chart in a spreadsheet?

Accepted Answer

To visually present data

Answer

To store raw data

Answer

To calculate complex formulas

Answer

To adjust cell formats

Question 28

Which file format is used to save Google Sheets spreadsheets?

Accepted Answer

.gsheet

Answer

.xlsx

Answer

.xls

Answer

.csv

Question 29

What is the purpose of using a named range in a spreadsheet?

Accepted Answer

To assign a label to a range of cells

Answer

To find the sum of a range of cells

Answer

To create a chart from a range of cells

Answer

To apply specific formats to a range of cells

Question 30

Which of the following is a conditional formatting option in Excel?

Accepted Answer

Highlight cells based on value

Answer

Add borders to cells

Answer

Change the font of cells

Answer

Merge cells

Question 31

What distinguishes a relative reference from an absolute reference in a spreadsheet formula?

Accepted Answer

Relative references adjust when copied, but absolute references do not.

Answer

Absolute references adjust when copied, but relative references do not.

Answer

Relative references are used for cell ranges, while absolute references are used for individual cells.

Answer

Absolute references are used for cell ranges, while relative references are used for individual cells.

Question 32

Which of the following is NOT an advantage of using spreadsheets for data management?

Accepted Answer

Unlimited data storage capacity

Answer

Efficient data organization and sorting

Answer

Quick and error-free calculations

Answer

In-depth data analysis

Question 33

What is the maximum number of rows in a Microsoft Excel spreadsheet?

Accepted Answer

1,048,576

Answer

1 million

Answer

100 thousand

Answer

Unlimited

Question 34

Which of the following is not a common use of spreadsheet software?

Accepted Answer

Word processing

Answer

Data analysis

Answer

Financial modeling

Answer

Chart creation

Question 35

What is the term for a set of cells in a spreadsheet that can be referenced as a group?

Accepted Answer

Range

Answer

Block

Answer

Grid

Answer

Table

Question 36

What is the process of enhancing the appearance of cells by adding borders and shading called?

Accepted Answer

Formatting

Answer

Styling

Answer

Decorating

Answer

Customizing

Question 37

Which type of chart is most suitable for displaying data distribution over time?

Accepted Answer

Line chart

Answer

Bar chart

Answer

Pie chart

Answer

Scatter plot

Question 38

What is the file extension commonly associated with Microsoft Excel spreadsheets?

Accepted Answer

.xlsx

Answer

.xls

Answer

.csv

Answer

.txt

Question 39

What is the primary purpose of a pivot table in a spreadsheet?

Accepted Answer

Summarizing and organizing data

Answer

Performing calculations

Answer

Creating charts and graphs

Answer

Importing data from external sources

Question 40

Which of the following is not a security feature available in spreadsheet software?

Accepted Answer

Customizing cell colors

Answer

Password protection

Answer

Cell locking

Answer

Data encryption

Question 41

Which of the following is a disadvantage of using spreadsheets?

Accepted Answer

Can be difficult to share and collaborate on

Answer

Support data visualization

Answer

Allow for easy data manipulation

Answer

Perform accurate calculations

Question 42

What is the main purpose of using a cell reference in a formula?

Accepted Answer

To utilize the value of another cell in the calculation

Answer

To apply formatting to the cell

Answer

To establish a named range

Question 43

What is the key difference between a relative and an absolute cell reference?

Accepted Answer

A relative reference adjusts when copied, while an absolute reference remains fixed

Answer

An absolute reference adjusts when copied, while a relative reference remains fixed

Answer

Both relative and absolute references adjust when copied

Question 44

Which of the following is a commonly used data type in spreadsheets?

Accepted Answer

Text, Number, Date

Answer

Hyperlink, Symbol, Formula

Answer

Audio, Video, Image

Question 45

What is the primary purpose of using a chart in a spreadsheet?

Accepted Answer

To visually represent data for enhanced comprehension

Answer

To store vast amounts of data

Answer

To perform complex calculations

Question 46

Which of the following is not a commonly used chart type?

Accepted Answer

Pie Chart of Time

Answer

Scatter Plot

Answer

Line Chart

Answer

Bar Chart

Question 47

What is the function of a filter in a spreadsheet?

Accepted Answer

To display only specific data meeting specific criteria

Answer

To create a pivot table

Answer

To arrange data in ascending or descending order

Question 48

What is the main purpose of using a pivot table?

Accepted Answer

To summarize and analyze data from a spreadsheet

Answer

To sort the data

Answer

To create a chart

Answer

To filter the data

Question 49

Which of the following is a best practice for formatting a spreadsheet?

Accepted Answer

Maintain consistency in font and cell styles, and avoid clutter

Answer

Employ bright and colorful fonts to enhance visual appeal

Answer

Fill every cell with data to maximize space utilization