COLLEGE COMPUTER APPS - SEM 1 FINAL - EXCEL

What would be a correct formula for SUM in excel?

• =SUM(B3:B9)
• =SUMB3+B9
• SUM(B3:B9)
• =ADD(B3:B9)

Which button can you click to add up a series of numbers?

• The autosum button
• The Formula button
• The quicktotal button
• The total button

If the cell contains hashtags (#), what do you need to do?

• Expand the column
• Expand the row
• Change the formula

Each Excel file is called a workbook because

• It can contain text and data
• It can be modified
• It can contain many sheets including worksheets and chart sheets
• You have to work hard to create it

You can edit a cell by...

• Clicking the formula button
• Double clicking the cell
• Selecting Edit>Edit Cell from the menu
• None of above

Which formula gets the biggest value of a range of cells?

• MAX
• MIN
• LARGE
• SUM

Which formula gets the smallest value of a range of cells?

• MAX
• MIN
• SMALL
• SUM

Which symbol must all formula begin with?

• =
• +
• (
• @

Which of the following formulas is not entered correctly?

• =10+50
• =B7+B8
• =B7+14
• 10+50

Columns go...

• Across
• Down