Font size
WorksheetsY9 Spreadsheets
Total questions: 15
Worksheet time: 5mins
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
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)
To copy the formatting without changing the content in the cell, you can use...
Print your spreadsheet by showing formulae, you need to follow these steps...
Page Layout >
Headings >
Page Layout >
Print Area >
Set Print Area
File >
Print >
Formulas
Formulas >
Show Formulas
Print your spreadsheet by showing headings, you need to follow these steps...
Page Layout >
Headings >
Page Layout >
Print Area >
Set Print Area
File >
Print >
Headings
Formulas >
Show Formulas
Which of the printout shows formulae and headings?
Which of the following save the file as word-processed document?
Save as
CSV
(comma delimited)
(*.cvs)
Save as
Excel workbook
(*.xlsx)
Save as
(*.pdf)
Save as
Word Document
(*.docx)
