Mastering Excel Basics

Luna is trying to enter data quickly in Excel for her school project. What is the best way for her to do this?

• Use keyboard shortcuts and the Fill Handle.

• Copy and paste data from other applications.

• Use only mouse clicks for data entry.

• Enter data one cell at a time.

Benjamin wants to create a pie chart in Excel to represent his survey results.

• Highlight your data, click on 'Data' > 'Chart Options'.

• Choose your data, navigate to 'View' > 'Chart Wizard'.

• Select your data, go to 'Insert' > 'Pie Chart'.

• Select your data, go to 'File' > 'New Chart'.

Maya wants to calculate the total score of her assignments from A1 to A5. What formula would she use to add the numbers in those cells?

• =TOTAL(A1:A5)

• =ADD(A1:A5)

• =SUMMATION(A1:A5)

• =SUM(A1:A5)

Avery wants to organize a list of her friends' names in alphabetical order. How can she do this?

• Reverse the list.

• Use a sorting function like 'sorted()' in Python.

• Sort the names by their length.

• Shuffle the list randomly.

James is working on a spreadsheet and wants to format a cell to display currency. What is the shortcut to format a cell as currency?

• Ctrl + Shift + $

• Shift + F1

• Ctrl + Alt + C

• Alt + 4

How does James print a worksheet in Excel?

• Go to View > Print Layout and select Print.

• Click on Home > Print.

• Use Ctrl + P to print.

• Go to File > Print and click Print.

Sophia is analyzing her test scores and wants to find the average score of her math exams. What function would she use to find the average of numbers?

• COUNT

• MAX

• AVERAGE

• SUM

How can William filter data to show only certain values?

• Use a random selection method.

• Sort data in ascending order.

• Display all data without filters.

• Use filtering methods like SQL WHERE clause.

Zoe is working on a project in Excel and wants to make her data more readable. What is the purpose of using cell borders in Excel?

• To enhance the color of the cells.

• To protect the data from being edited.

• To add formulas to the cells.

• To visually separate and organize data for better readability.

Elijah wants to create a bar graph from his science project data set. How should he proceed?

• Create a pie chart with the data set

• Use one category for the graph

• Organize data into categories, label axes, and plot bars according to values.

• Plot points without labeling the axes