Spreadsheet Management Past Questions May/June 2022
Enhance your knowledge of spreadsheet management with this comprehensive past questions resource from Armstrong Computers. Compiled from the May/June 2022 exam, this resource includes theoretical and practical questions and solutions to help you gain a deeper understanding of the topic.
What You'll Find
Our past questions collection provides a comprehensive overview of spreadsheet management, covering key concepts and common question types. This resource is designed to be user-friendly and accessible on both desktops and mobile devices.
INFORMATION AND COMMUNICATION TECHNOLOGY
ICT LEVEL TWO
SUBJECT: Spreadsheet Management
May/June 2022
ANSWER ALL THE QUESTIONS
SECTION A
(50 MARKS)
Excel can be used in the following circumstances:
- Budgeting and financial forecasting
- Data analysis and visualization
- Inventory tracking and management
- Creating schedules and timetables
- Managing customer and sales data
a. A range in Excel is a collection of two or more cells that can be adjacent or non-adjacent.
b. A table in Excel is a structured range that has been designated to hold related data, making it easier to manage and analyze.
c. The Quick Access Toolbar is a customizable toolbar in Excel that provides easy access to frequently used commands and features.
a. Microsoft Excel is a spreadsheet application developed by Microsoft that allows users to organize, format, and calculate data with formulas using a spreadsheet system.
b. MS Excel is good to use because it offers powerful data analysis tools, extensive formatting options, and the ability to automate tasks with macros, making it a versatile tool for both personal and professional use.
The three margins that can be found in a spreadsheet are:
- Top Margin
- Bottom Margin
- Side Margins (Left and Right)
a. Text alignment in Excel refers to the way text is positioned within a cell. It can be aligned horizontally and vertically.
b. The text alignments in MS Excel are:
- Left Align
- Center Align
- Right Align
- Top Align
- Middle Align
- Bottom Align
- Justify
a. The shortcut keys are:
- Copy: Ctrl + C
- Cut: Ctrl + X
- Paste: Ctrl + V
b. The Name box in Excel displays the address of the currently selected cell or range of cells. It can also be used to name and navigate to specific cells or ranges in a worksheet.
a. Auto fill in Excel is a feature that allows users to automatically fill cells with a series of data, such as numbers, dates, or text.
b. Auto fill is useful because it saves time and effort by reducing the need to manually enter repetitive data, ensuring consistency and accuracy in data entry.
Five common formulas in Excel are:
- SUM
- AVERAGE
- COUNT
- IF
- VLOOKUP
The steps to launch MS Excel are:
- Click on the Start menu or press the Windows key on your keyboard.
- Type "Excel" in the search bar.
- Select "Microsoft Excel" from the search results.
- Alternatively, if you have a shortcut on your desktop, double-click the Excel icon to launch the application.
SECTION B
PRACTICAL (50 MARKS)
You are required to create a spreadsheet using MS Excel, by following the instructions given below.
- Create a blank workbook in MS Excel and save it as (Your Name)
- Create a table with 7 rows and 9 columns in the cell range A3:I9
- Insert a title “DAVECOS SYSTEMS” and subtitle “PRACTICAL TRAINING”, by centering it with the table, making the text bold and changing the font size to 19 for the main title and 15 for the subtitle.
- Key in the following data below:
- Calculate the total marks for each student.
- By making good use of the IF function, any student that gets a total mark more than 50 should be marked as PASS else should be marked as FAIL.
| Name Statement | Class | Maths | Eng. | Total | If Statement |
|---|---|---|---|---|---|
| Yakubu | 4 | 79 | 45 | ||
| Abena | 5 | 15 | 20 | ||
| Yawba | 6 | 20 | 10 | ||
| Kwasi | 4 | 90 | 80 | ||
| John | 5 | 80 | 71 | ||
| Seth | 4 | 66 | 90 |
Created by Armstrong Computers
At Armstrong Computers, we are committed to providing top-notch educational materials to help students excel. Our Spreadsheet Management Past Questions May/June 2022 is an essential tool for any student looking to master the subject.
Download Past QuestionsStart preparing today and boost your confidence for your exams. Just click on the questions, study the answers, and watch the video tutorials. Happy studying!
