FBLA Computer Applications Quiz

Which of the following is a formula to find the sum of the numbers in cells A1 through A10 in Excel?

• =SUM(A1:A10)

• =ADD(A1:A10)

• =SUM(A1+A10)

• =A1+A2+A3+A4+A5+A6+A7+A8+A9+A10

In Microsoft Word, what is the default margin setting for a new document?

• 1 inch on all sides

• 1.25 inches on all sides

• 0.75 inches on all sides

• 2 inches on all sides

In PowerPoint, what is the purpose of the "Slide Master"?

• It is used to add animations to individual slides.

• It allows you to design and change the layout of all slides in a presentation.

• It displays the slides in a thumbnail view.

• It converts slides into a video presentation.

Which of the following Excel functions is used to calculate the average of a set of numbers?

• =MEAN(A1:A10)

• =AVERAGE(A1:A10)

• =SUM(A1:A10)/COUNT(A1:A10)

• Both b and c

What is the correct order of steps to create a new table in Microsoft Word?

• Insert > Table > Choose number of rows and columns

• Layout > Table > Create New Table

• Design > Table Tools > Insert Table

• File > New > Table Wizard

In Excel, which of the following tools allows you to analyze data using categories and subcategories of data (e.g., a sales report by region and product)?

• Pivot Table

• Lookup function

• VLOOKUP

• Conditional Formatting

Which of the following is NOT a feature of PowerPoint's "Transitions"?

• Slide effects that occur when moving from one slide to the next

• Customizable animations for text and objects

• Changes to the layout of a single slide

• Special effects applied to the entire presentation's slide change

In Microsoft Word, which of the following styles is typically used for the title of a document?

• Heading 1

• Normal

• Heading 2

• Title

If you need to ensure that data entered in an Excel cell follows a certain format (for example, a date), which feature would you use?

• Data Validation

• Conditional Formatting

• Cell Formatting

• Pivot Table

In Excel, which of the following will allow you to quickly sort a column of data in ascending order?

• Data > Sort > Ascending

• Home > Sort > Alphabetically

• Data > Sort & Filter > A to Z

• Insert > Sort