Spreadsheet Lesson 3 Quiz

What is a formula in spreadsheets?

• A formula in spreadsheets is a tool used to create charts and graphs.

• A formula in spreadsheets is a function that changes the formatting of cells.

• A formula in spreadsheets is a mathematical expression or equation that performs calculations or manipulates data in a cell or range of cells.

• A formula in spreadsheets is a feature that allows you to insert images into cells.

How do you create a formula in spreadsheets?

• Start with a dollar sign ($) followed by the formula expression.

• Begin with a plus sign (+) followed by the formula expression.

• Start with an equals sign (=) followed by the formula expression.

• Use a hashtag (#) followed by the formula expression.

What are functions in spreadsheets?

• Functions in spreadsheets are predefined formulas that perform calculations or manipulate data in a spreadsheet.

• Functions in spreadsheets are used to import data from external sources.

• Functions in spreadsheets are used to create charts and graphs.

• Functions in spreadsheets are used to format text and cells.

Give an example of a function used in spreadsheets.

• MAX

• SUM

• AVERAGE

• COUNT

How do you format cells in spreadsheets?

• Use the formula bar to apply formatting to cells.

• Formatting cells is not possible in spreadsheets.

• Use the formatting options available in the toolbar or menu.

• Right-click on the cell and select the formatting option.

What are some common formatting options in spreadsheets?

• sorting, filtering, merging cells

• text color, cell size, page orientation

• font styles, cell alignment, borders and shading, conditional formatting, numbers and dates

• chart types, data validation, formulas

What is sorting data in spreadsheets?

• Randomly rearranging data in a spreadsheet.

• Arranging data in a specific order based on certain criteria.

• Grouping data in a specific order based on certain criteria.

• Deleting data from a spreadsheet.

How do you sort data in spreadsheets?

• Select range of cells, go to Insert tab, click Sort, choose column and order, click OK.

• Select range of cells, go to Format tab, click Sort, choose column and order, click OK.

• Right-click on a cell, go to Sort, choose column and order, click OK.

• Select range of cells, go to Data tab, click Sort, choose column and order, click OK.

What is filtering data in spreadsheets?

• The process of deleting all rows or columns in a spreadsheet.

• The process of selectively displaying specific rows or columns based on certain criteria or conditions.

• The process of merging multiple spreadsheets into one.

• The process of randomly rearranging rows or columns in a spreadsheet.

How do you filter data in spreadsheets?

• Use the filter function or the filter tool.

• Use the search function or the search tool.

• Use the conditional formatting function or the conditional formatting tool.

• Use the sort function or the sort tool.