Excel Basics Quiz

What is the purpose for Excel?

• Divides a series of numbers

• Subtracts one number from another

• Add all the numbers in a range of cells

• Summarize, sort, group, and reorganize data

How can you make text bold in Excel?

• Press Ctrl + B

• Type "BOLD" before your text

• It cannot be done

• Use the SUM function

Which chart type is best for showing parts of a whole?

• Line chart

• Pie chart

• Column chart

• Scatter plot

What is the purpose of merging cells in Excel?

• To add values together

• To create a larger cell for titles

• To divide the cell into smaller cells

• To calculate the average of cell values

How do you insert a new row in Excel?

• Press Ctrl + N

• Right-click on a row number and select "Insert"

• Use the SUM function

• It cannot be done

What does the AVERAGE function do?

• Finds the highest number in a range

• Adds all numbers in a range

• Finds the middle value in a range

• Calculates the average of numbers in a range

How can you change the color of text in a cell?

• Home > Font > Font Color

• Insert > Text Color

• Page Layout > Colors

• It cannot be done

To quickly add a column of numbers, you would:

• Use the AVERAGE function

• Manually add each number

• Use the SUM function

• Write each number on a new line

What is the shortcut for saving an Excel document?

• Ctrl + S

• Ctrl + C

• Ctrl + V

• Ctrl + X

How do you resize a column to fit the contents?

• Drag the column border

• Double-click the right border of the column header

• Use the MAX function

• It cannot be done