Spreadsheet Package
Computer Studies · 50 practice questions
General concept of spreadsheets; creating, saving, editing, formatting and printing spreadsheet documents; MS Excel - features, launching, basic terms (worksheet, workbook, cells, cell ranges), data types (number, label, formula), basic operations (data entry, saving, retrieving, copying), arithmetic calculations using formulas and functions, and other operations (formatting, drawing charts).
- Define a spreadsheet and give examples of spreadsheet packages.
- Identify features and application areas of spreadsheet packages.
- Launch MS Excel and perform its basic and other operations, including calculations with formulas and functions.
Try a few questions
- Practice question 1
Inserting a new row or column in a spreadsheet shifts existing data to make room for
- A.a permanently deleted row or column
- B.the newly added row or column
- C.a completely different, unrelated worksheet
- D.a chart or graph exclusively
Show the answer
B. the newly added row or column
Insertion automatically shifts surrounding data to accommodate the newly added row or column.
- Practice question 2
Spreadsheets remain a fundamental tool for organizing and analyzing quantitative data across
- A.no industries at all, since spreadsheets are now obsolete
- B.many industries
- C.only a single, extremely narrow industry
- D.industries that specifically avoid any numerical data
Show the answer
B. many industries
Spreadsheets continue to be broadly relied upon for organizing and analyzing quantitative data across many fields.
- Practice question 3
Functions in a spreadsheet, such as SUM or AVERAGE, are predefined formulas that perform
- A.specific calculations on a range of cells
- B.only text formatting operations
- C.no actual calculations at all
- D.only image editing operations
Show the answer
A. specific calculations on a range of cells
Built-in functions like SUM and AVERAGE provide ready-made calculations that can be applied to selected cell ranges.
More UTME Computer Studies topics
Practise with instant feedback
Answer questions one at a time and see the right answer and the reason straight away. Free to start.
Start practising