Y9 Spreadsheets

What is csv (comma-separated values) file?

• It is a Word file.

• It is an Excel file.

• It is a text file.

• It is a source file.

CSV is a plain text file format used to store tabular data, such as a

______ and ______.

• Word processor

• Spreadsheet

• Multimedia

• Database

When a program stores tabular data, it delimits each item of data with a predefined character. CSV file delimits each item of data with _____.

• semicolons

  ;

• slashes

  / or \

• pipes

  |

• commas

  ,

Why does Excel not save my formulae and formatting changes?

Because the file is saved as _____ or _____.

• txt

• csv

• xlsx

• pdf

Which of the following is the correct steps for adding header?

• Home >

  Page Setup >

  Header/Footer >

  Custom Header

• Page Layout >

  Page Setup >

  Header/Footer >

  Custom Header

• Insert >

  Page Setup >

  Header/Footer >

  Custom Header

• View >

  Page Setup >

  Header/Footer >

  Custom Header

Which of the following format NOT applied to cell A1?

• Font color

  & fill color

• Font size

• Merge & center

• Border

To format all currency value to dollars, you can select the cells and right click to choose

• Conditional formatting

• Page Layout

• Format cells

• Insert $

Choose the formulae in cell B3.

• =MAX()

• =HIGH()

• =LOW()

• =MIN()

Choose the formulae in cell B5.

• =AVERAGE()/12

• =AVERAGE()/4

• =B3/12

• =AVERAGE()

Choose the formulae in cell B6.

• =AVERAGE()/12

• =AVERAGE()/4

• =B5*3

• =AVERAGE(B4)