Year Five Information & Communication Technology
You’re five years deep into your studies of Information and Communication Technology, but what do you have to show for it? You might think that you did well in your year-end examinations for the first four years, but it’s time to see if you’ve been paying attention to year five! Do you know as much as you should about computers and particular applications of them? Let’s find out in this quiz!
- 1.
Which sort of a program is the Microsoft Excel 2007 ?
- A.
Word Processing Package.
- B.
Graphics Package
- C.
Spreadsheets Package
- D.
Multimedia Package
- E.
Non of the above
Correct Answer
C. Spreadsheets PackageExplanation
Microsoft Excel 2007 is a spreadsheets package. It is a powerful tool used for creating, editing, and analyzing data in the form of spreadsheets. Excel allows users to perform calculations, create charts and graphs, and organize data efficiently. It is widely used in various industries for financial analysis, data management, and reporting purposes.Rate this question:
-
- 2.
The user while using this program works on a ---------------------------------- .
- A.
Slide
- B.
Document
- C.
Sheet
- D.
Non of the above.
Correct Answer
C. SheetExplanation
The correct answer is "Sheet" because it is the most appropriate term to describe a single page or tab within a program, such as in spreadsheet software or graphic design software. A sheet is commonly used to organize and present data or information in a structured manner. It is different from a slide, which is typically used in presentation software, and a document, which usually refers to a file or collection of pages. Therefore, "Sheet" is the most suitable option for the user's activity within the program.Rate this question:
-
- 3.
The spreadsheet is divided into rows and columns. The ----------------------- is the group of cells that are arranged vertically next to each other.
Correct Answer
rowExplanation
The correct answer is "row". In a spreadsheet, the data is organized into rows and columns. Rows are horizontal lines of cells that run across the spreadsheet. They are used to categorize and organize data in a horizontal manner. Each row contains a different set of data, and they are arranged vertically next to each other.Rate this question:
- 4.
When a formula is written in a cell. It appears in the the active cell in which it is being written and in the ------------------------------------ bar as well.
Correct Answer
formulaExplanation
When a formula is written in a cell, it appears in the active cell where it is being written and in the formula bar as well.Rate this question:
- 5.
You can use a spreadsheets package like the Microsoft Excel To --------------------------------- .
- A.
Design speadsheets models.
- B.
Create charts.
- C.
Perform mathematical operations
- D.
All of the above.
Correct Answer
D. All of the above.Explanation
The given correct answer is "All of the above". This means that a spreadsheets package like Microsoft Excel can be used to design spreadsheet models, create charts, and perform mathematical operations. This indicates that the software has the capability to handle various tasks related to organizing and analyzing data, making it a versatile tool for data manipulation and visualization.Rate this question:
-
- 6.
To format a cell like an already formated one you can use ------------------------------- .
- A.
The Fill down command
- B.
The Autosum command
- C.
The Format Painter command
- D.
Non of the above.
Correct Answer
C. The Format Painter commandExplanation
The Format Painter command allows you to copy the formatting of a cell and apply it to another cell or range of cells. This is useful when you want to quickly format multiple cells with the same formatting as another cell without manually applying each formatting option.Rate this question:
-
- 7.
The formula starts with the -------------------------------- sign.
Correct Answer
=
equalExplanation
The given answer is correct because the formula in question starts with the equal sign (=). In most spreadsheet programs, the equal sign is used to indicate the beginning of a formula, which allows the software to recognize and calculate mathematical operations or functions. Therefore, the equal sign is an essential component when writing formulas in spreadsheets.Rate this question:
- 8.
You can copy a formula saved inside a cell to another cell or group of cells by highlighting the cell that contains the fomula together with the empty ones and selecting the --------------------------.
- A.
Autosum command
- B.
Fill Down command
- C.
Format Painter
- D.
Non of the above.
Correct Answer
B. Fill Down commandExplanation
To copy a formula from one cell to another, including empty cells, you can use the Fill Down command. This command allows you to replicate the formula in the selected cell to the cells below it, automatically adjusting the cell references in the formula. This is useful when you want to apply the same formula to a range of cells without manually entering it in each cell. The Autosum command is used to quickly calculate the sum of a range of cells, while the Format Painter is used to copy formatting from one cell to another.Rate this question:
-
- 9.
To join a group of cells together to form one big cell. You have to highlight these cells and select the ---------------------------------------.
- A.
Borders command.
- B.
Merge command
- C.
Page Beak Preview.
- D.
Non of the above.
Correct Answer
B. Merge commandExplanation
To join a group of cells together to form one big cell, you need to use the Merge command. This command allows you to combine multiple cells into a single cell, making it easier to manage and format data. By selecting the Merge command, you can merge the highlighted cells and create a larger cell that spans across multiple columns or rows in the spreadsheet. This can be useful for organizing and presenting data in a more concise and visually appealing manner.Rate this question:
-
- 10.
The name of the active cell appeares in the -----------------------.
- A.
Formula Bar.
- B.
Name box
- C.
Column
- D.
All of the above
Correct Answer
B. Name boxExplanation
The name of the active cell appears in the Name box. The Name box is located next to the Formula Bar in most spreadsheet programs. It displays the address or name of the selected cell, allowing users to easily identify the active cell and navigate to specific cells by entering their address or name directly into the Name box.Rate this question:
-
- 11.
After writting the formula you have to press --------------------------------- key from the keyboard to see the answer.
Correct Answer
enterExplanation
After writing the formula, the user needs to press the "enter" key from the keyboard to see the answer.Rate this question:
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 20, 2023Quiz Edited by
ProProfs Editorial Team -
Feb 17, 2010Quiz Created by
Mrs. Garana
Back to top