Spreadsheet 1
A function is used to add values in MS Excel.
What is the sum function?
Which flowchart symbol is used to represent a decision?
The diamond symbol.
The vertical lines of a spreadsheet are called what?
Column
How many worksheets are there in a spreadsheet by default?
Three (3)
State THREE examples of validation checks.
Range, Consistency, data type
A statement that performs a calculation in a spreadsheet.
What is Formula or function?
Name the TWO main components required for mail merge
Main document
Data source
True or false, we can have more than one active cell at a time?
False
Which function would should be use to find the highest value in a range?
The Maximum Function
A Spreadsheet is made up of two lines what are they?
Vertical and horizontal lines
A collection or group of two or more cells on a spreadsheet.
What is a range?
Explain how mail merge improves efficiency in an organization
Mail merge improves efficiency by allowing a single document to be automatically personalized and sent to many recipients, saving time and reducing repetitive typing.
John type a a formula but later realized it's incorrect, where should he click to adjust the formula?
The formula Bar
Name TWO methods of data verification
Double entry
Proofreading
Excel is a book called ___________ which consist of many pages called worksheet
A workbook
A single page in a Workbook is called a _______?
What is Worksheet?
John wants to find the smallest value from A1:A5, Which function should he use?
The Minimum function i.e. =min(A1:A5)
Distinguish between a FOR loop and a WHILE loop
A FOR loop repeats a set of instructions a fixed number of times, while a WHILE loop repeats instructions as long as a condition remains true.
List four (4) things we can use Microsoft Excel to do
1.Store and organize data,
2.Analyze data
3. Represent data graphically (e.g., in bar graphs, pie charts etc)
4.Do Simply and complex calculations
Fill in the blank........Rows are represented by ___________ While ____________ are represented by letters.
numbers
columns
Distinguish between system software and application software, giving ONE example of each
System software controls the operation of the computer and manages hardware (e.g. an operating system like Windows), while application software is designed to perform specific user tasks (e.g. Microsoft Word).
A computer powers on but displays a blank screen. State TWO possible causes of this problem
The monitor cable is loose or disconnected
The monitor is faulty or turned off
what's the difference between the active cell and the cell address?
The active cell is the cell selected or in use, while cell address is the column letter and row number