Spreadsheet

• What is the symbol for addition in a spreadsheet?

  +
• What is the symbol for subtraction in a spreadsheet?


  • 
    
• What is the symbol for division in a spreadsheet?

  /
• What is the symbol for multiplication in a spreadsheet?

  *
• What does cell formatting allow a user to do?

  Control the contents and appearance of a cell
• What happens in conditional formatting?

  The cell shading or font changes if a specific condition is met
• What is the purpose of data validation in a spreadsheet?

  To control the data input similarly to databases
• How can data entry be limited in a spreadsheet?

  By setting a range, e.g., between 1-10
• What is a worksheet presentation?

  A document formatted using a predetermined layout
• How is data imported into a spreadsheet?

  From another software source using a wizard
• What are some examples of cell formatting options?

  Centre, Merge, Centred merged, Bold
• What is the function of the Sum() function in spreadsheets?

  To calculate the total of a range of numbers
• What does the min() function do in spreadsheets?

  It finds the minimum value in a range
• What does the max() function do in spreadsheets?

  It finds the maximum value in a range
• What does the average() function do in spreadsheets?

  It calculates the average of a range of numbers
• What does the count() function do in spreadsheets?

  It counts the number of entries in a range
• What does the countif() function do in spreadsheets?

  It counts the number of entries that meet a specific condition
• What are the different data types available in spreadsheets?

  General, Currency, Number, Date, Time, Percentage, Text
• What does shading do in a spreadsheet?

  It changes the background color of a cell
• What does the underline feature do in a spreadsheet?

  It adds a line beneath the text in a cell
• What does the wrap text feature do in a spreadsheet?

  It allows text to be displayed on multiple lines within a cell
• What does the italic feature do in a spreadsheet?

  It slants the text to the right
• What does the IF statement do in a spreadsheet?

  It checks if a value is true or false
• How is the IF statement structured in a spreadsheet?

  =IF(cell < number, "True", "False")
• What does the VLOOKUP function do in a spreadsheet?

  It looks up a value in a column of a table and returns a value from a specified column
• What is the active cell in a spreadsheet?

  The cell that has a border around it
• What are the key features of a spreadsheet?

  • Active cell
  • Formula
  • Function
  • Cell formatting
  • Cell reference
  • Row reference
  • Column reference
  • Tool bar