Mastering Microsoft Excel Quiz

What is the purpose of Microsoft Excel?

• Word processing

• Data analysis and visualization

• Presentation design

• Email management

Which function in Excel can be used to calculate the sum of a range of cells?

• SUM()

• TOTAL()

• ADD()

• PLUS()

How can you apply a formula to an entire column in Excel?

• Drag the fill handle down the column

• Copy and paste the formula

• Type the formula in each cell

• Excel does not allow formulas to be applied to entire columns

What is the shortcut key to save an Excel document?

• Ctrl + S

• Ctrl + C

• Ctrl + V

• Ctrl + X

Which of the following is NOT a basic function in Excel?

• Sort

• Filter

• Animate

• Format cells

How do you insert a new row in an Excel spreadsheet?

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

• Go to the "Insert" tab and select "Row"

• Press Ctrl + R

• Type a new row number into the row number area

What does the function =AVERAGE(B1:B10) do?

• Sums up the values in cells B1 to B10

• Finds the highest value in cells B1 to B10

• Calculates the average value of the cells B1 to B10

• Counts the number of cells in the range B1 to B10

Which feature in Excel allows you to view different parts of the same workbook at the same time?

• Freeze Panes

• Split

• New Window

• Zoom

How can you make a cell's content bold in Excel?

• Press Ctrl + B

• Go to the "Home" tab and click on the "Bold" button

• Both A and B

• It is not possible to make cell content bold in Excel

What is the purpose of conditional formatting in Excel?

• To automatically format cells based on specific criteria

• To change the background color of the entire spreadsheet

• To add formulas to cells automatically

• To protect cells from being edited