A spreadsheet is best described as an interactive computer application software used for:
- aComposing music
- bOrganisation, analysis and storage of data in tabular form
- cEditing photographs
- dBrowsing the Internet
122 questions · 26 sections
A spreadsheet is best described as an interactive computer application software used for:
In which sector is a spreadsheet used to analyse exam results?
Which of the following is NOT mentioned as a use of a spreadsheet in the textbook?
Salaries of employees are maintained in a spreadsheet because the data are:
Which task related to airlines is mentioned as a use of spreadsheet?
Calculation and analysis of income tax can be done conveniently by means of a:
Election-time vote counting is mentioned as a spreadsheet use because spreadsheets allow:
Performances of players can be analysed and evaluated by using a:
The textbook says spreadsheets allow data to be:
Different functions in a spreadsheet are mainly used for:
Every formula in a spreadsheet must always start with the sign:
To multiply two cells the formula is written in the:
After typing the multiplication formula in the result cell, the result appears when the user presses:
Which built-in spreadsheet function is used to multiply a range of cells?
The textbook lists how many kinds of multiplying processes in a spreadsheet?
To use the PRODUCT function on multiple cells, the user must give:
The advantage of multiplying with the PRODUCT function over a plain =A1*B1 formula is that:
To multiply price (column B) by quantity (column C) for the first product row, a typical formula in the result cell is:
=B2/C2=B2*C2=B2+C2=B2-C2After writing =PRODUCT( the user typically supplies a range such as:
A1..B1A1:A3A1#A3A1->A3The activity in the multiplying section asks the student to:
To divide A1 by B1 in a spreadsheet, the formula written in the result cell is:
=A1+B1=A1-B1=A1/B1=A1*B1In a spreadsheet division formula, the sign used as the division operator is:
\/÷|The dividing activity asks the student to find the result by using:
Like every other formula, the division formula must begin with:
+=*:To find 15% of 400, where 400 is in cell A3 and 15 is in cell B3, the formula is:
=A3+B3%=A3*B3%=A3-B3%=A3/B3%The keyboard combination to type the % sign while writing a percentage formula is:
To calculate the selling price at a 16% profit on a purchasing cost in cell A3 with profit rate in B3, the formula is:
=A3*B3%=A3+B3%=A3*B3%+A3=A3-B3%In the formula =A3*B3%+A3, the final +A3 term represents the:
After typing the percentage formula in the result cell, the result is shown by pressing the:
Click-based entry of the percentage formula uses which gesture to fill cell references?
Mr. Chowdhury's monthly basic salary as given in the worked problem is Tk:
The residential allowance rate in Mr. Chowdhury's problem is:
Mr. Chowdhury's residential allowance in taka equals 55% of his basic salary, which is:
Mr. Chowdhury's medical allowance is:
The amount Mr. Chowdhury subscribes to the benevolent fund is:
Mr. Chowdhury's monthly net salary, computed from , equals Tk:
The benevolent-fund subscription is:
The textbook warns that menu bars and titles may differ because of differences in the:
According to the sample question, a document is saved as a template mainly:
Which option is used to save a document for the first time?
Spreadsheet analysis helps with:
Soumitra writes for a newspaper about nature as a hobby and inserts pictures of flowers, birds and rivers. Which software does he need for this hobby?
As an accounting officer Soumitra manages employee salaries and submits monthly reports. In his professional work he needs to:
A word processor is software primarily used for:
One advantage of a word processor over a typewriter is the ability to:
A "font" in a word processor refers to a particular:
To select a font in a word processor, the user typically opens the:
Adding an image to a document is generally done from the menu:
A spreadsheet is software used for tabular:
The "process of multiplying" section is part of which broader topic?
Multimedia is best defined as the integration of:
Writing, sound and image are all examples of:
In which year, in the last phase of the 19th century, was the cinema invented?
Cinema is called the earlier invention of multimedia because it combined:
Multimedia which can connect with users and respond is specifically called:
The three core media a human uses to express ideas, as listed in the chapter, are:
Which of the following is given in the chapter as an example of interactive multimedia?
Which of the following is mentioned as plain (non-interactive) multimedia?
Multimedia is usually captured by a:
With the evolution of civilisation and digital technology, the analogue media of an earlier age have:
The integration of programming ability with combined media has enhanced the potential of:
According to the textbook, multimedia is also called interactive multimedia because of its multiple dimensions and:
Which of the following is NOT listed by the textbook as one of the main mediums of multimedia?
Six core mediums of multimedia given by the chapter include text, graphics, video, animation, sound or audio, and:
In computing, all kinds of writing tasks worldwide are now done with:
Before the spread of computers, written text was typed on:
Computers are used in fine arts, packaging and printing for:
The use of computers in graphics design in Bangladesh started in the:
The first widespread use of computers in Bangladeshi graphics work was for editing scanned photos with:
According to the chapter, computer-based graphics are widely used in Bangladesh in:
Video, in the chapter, is described as a kind of:
The chapter says video is a well-established medium in TV, Home Video, Web and:
The phrase used in the textbook for video is:
Animation, according to the chapter, can be:
In Bangladesh, animation is reported as a favourite medium in:
Animation is never used as a single medium; it is usually combined with:
The chapter states that the use of animation in Bangladesh is:
For sound recording and editing today, the world depends mainly on:
In sound engineering, the analogue system has been:
Mere addition of Microsoft Word scroll style or flash animation effects to text/video does NOT make the content:
Powerful authoring software named in the chapter — that makes user-computer interaction possible — includes Flash, Director and:
According to the chapter, "interactivity" is created by software that enables interaction between:
Which of the following is NOT named as authoring software for interactivity?
Computers tend to replace which kind of machine in modern offices?
Computers are widely used in offices and professional printing houses for:
The use of multimedia as a teaching aid is described as:
With multimedia in the classroom, the teacher can make a lesson more:
The chapter says that for educational purposes there are various kinds of:
Which of the following is mentioned as a multimedia software developed in Bangladesh?
Which of the following is NOT named in the chapter as Bangladeshi multimedia software?
Bangladeshi multimedia software named in the textbook are described as:
The chapter expresses the expectation that multimedia software in Bangladesh will be:
Multimedia is widely used in most genres of:
Cinemas and plays are made livelier by multimedia through:
Advertisements have become attractive because multimedia can show:
Computer or video games look very realistic mainly because of the use of:
Animation, restated in the "Use of Multimedia in ICT" section, is the:
According to the chapter, animation can be:
Animation is usually created by combining:
The use of animation in advertising images is described as a:
Multimedia includes combinations of:
Examples of paper / electronic media discussed in the chapter include:
Software-supported multimedia tasks on a computer include:
Authoring software that can build interactive multimedia includes:
Bangladeshi multimedia titles mentioned in the chapter include:
Multimedia is used in ICT for purposes such as:
A spreadsheet is suitable for:
To multiply numbers in a spreadsheet a user can:
=A1*B1 and press EnterThe percentage problem of Mr. Chowdhury demands:
A teacher who shows a topic with text, video, sound and animation in class is using:
A student designs a poster combining a photo, decorative text and a logo. The most suitable software type is:
A shop owner wants to keep daily sales (price × quantity) and find totals automatically. He should use:
To compute house rent at 55% of basic salary in cell A2 with rate in B2, the formula is:
=A2/B2%=A2*B2%=A2+B2%=A2-B2%A formula =PRODUCT(B2:B6) returns the:
The result of =A1/B1 when A1 = 100 and B1 = 4 is:
The result of =A3*B3% when A3 = 1200 and B3 = 16 is:
The result of =A3*B3%+A3 when A3 = 1200 and B3 = 16 is:
Computer-based interactive multimedia gives users the ability to:
The chapter highlights that interactive multimedia uses the programming ability of:
With multimedia integrated into the computer, ICT now offers experiences that are: