FBLA Spreadsheet Application

Excel is a:

• database application

• word processing application

• spreadsheet application

• none of the above

What is the primary function of a spreadsheet application like Excel?

• Data storage

• Word processing

• Numerical calculations

• Graphic design

Which of the following is a common feature of spreadsheet applications?

• Spell check

• Pivot tables

• Photo editing

• Video playback

In spreadsheet applications, what is a 'cell'?

• A type of chart

• A single data point

• An intersection of a row and a column

• A formatting style

What is the file extension for Excel spreadsheets?

• .docx

• .xlsx

• .pptx

• .pdf

Which formula in Excel would you use to add up a range of cells?

• =SUM(A1:A10)

• =ADD(A1:A10)

• =TOTAL(A1:A10)

• =COMBINE(A1:A10)

What is the purpose of a 'pivot table' in Excel?

• To create a chart

• To summarize and analyze data

• To format text

• To insert images

Which of the following is NOT a type of chart available in Excel?

• Bar chart

• Line chart

• Pie chart

• Flowchart

What does 'conditional formatting' allow you to do in Excel?

• Change cell color based on value

• Insert a new worksheet

• Protect a workbook

• Create a chart

Which function would you use to find the average of a set of numbers in Excel?

• =SUM()

• =AVERAGE()

• =MEAN()

• =MEDIAN()