Document based Microsoft Excel Quiz

What is the main purpose of Microsoft Excel?

• To display, organize, and manipulate data

• To create presentations

• To browse the internet

• To edit photos

What is a cell in a spreadsheet?

• A row of data

• A type of formula

• A chart type

• A box for entering data

How can you rename a worksheet in Excel?

• By pressing the Enter key

• By dragging it to a new location

• By right-clicking and choosing Rename

• By double-clicking on it

What does the active cell indicate?

• The cell that contains a formula

• The cell that is locked

• The cell currently selected for data entry

• The cell with the highest value

Which key do you press to move to the next cell in a row?

• Space

• Tab

• Shift

• Enter

What is the purpose of the formula bar?

• To display the current time

• To show the function used in a cell

• To create charts

• To format text

How can you resize a row or column?

• By clicking and dragging between numbers or letters

• By selecting the row or column and pressing Delete

• By using the keyboard shortcuts

• By right-clicking and selecting Resize

What does the SUM function do?

• Finds the average of numbers

• Adds up a range of cells

• Sorts data in alphabetical order

• Displays data visually

What should you do before sorting data in a column?

• Change the font size

• Delete any empty cells

• Make sure each column has a title cell

• Select the entire spreadsheet

Which of the following is a way to create a chart?

• Clicking on the cell and pressing Enter

• Using the formula bar

• Dragging across the cells and selecting Insert

• Right-clicking on a cell