Spreadsheet Questions 1

Which of the following is NOT a common function in spreadsheets?

• a) SUM

• b) CONCATENATE

• c) PIVOT

• d) SPLIT

In spreadsheet software, what does the term "cell" refer to?

• a) A single point of data in a table

• b) A range of cells

• c) A group of charts

• d) A type of formula

What is the shortcut key for saving a spreadsheet in most spreadsheet applications?

• a) Ctrl + A

• b) Ctrl + S

• c) Ctrl + Z

• d) Ctrl + P

Which of the following best describes a "pivot table"?

• a) A table that remains stationary

• b) A data summarization tool

• c) A feature for entering data

• d) A type of chart

What symbol is used to start a formula in most spreadsheet programs?

• a) @

• b) #

• c) $

• d) =

Which function would you use to find the average of a range of numbers?

If you want to freeze the top row of your spreadsheet, which option should you use?

• a) Split

• b) Freeze Panes

• c) Lock Cells

• d) Protect Sheet

What does the VLOOKUP function do?

• a) Looks up and returns a value from a vertical range

• b) Summarizes data in a table

• c) Creates a vertical list

• d) Finds and replaces text

Which of the following is a file extension for Microsoft Excel files?

• a) .docx

• b) .xlsx

• c) .pptx

• d) .txt

What is conditional formatting in a spreadsheet?

• a) Formatting based on cell content

• b) A function to calculate averages

• c) A feature to combine cells

• d) A tool to import data