1.
Which is CORRECT about spreadsheet ??
Correct Answer
C. This is a piece of software that make it easy for you to carry out calclations
Explanation
The correct answer is "This is a piece of software that makes it easy for you to carry out calculations." This answer accurately describes a spreadsheet as a software that allows users to perform calculations easily. Spreadsheets are commonly used for organizing and manipulating data, performing mathematical operations, and creating charts and graphs. They are not a game, nor are they solely used for booting up tasks.
2.
ALL is a part of Microsoft excel EXCEPT ?
Correct Answer
C. Window file
Explanation
The correct answer is "Window file" because in Microsoft Excel, there is no specific feature or component called "Window file." Excel does have features such as active cell, column headings, and formula bar, which are all essential elements of the software. However, a "Window file" is not a recognized term or function within Excel.
3.
Which is correct about CHARTS in Microsoft excel?
Correct Answer
A. they are visual representation of the worksheet data
Explanation
Charts in Microsoft Excel are used to visually represent the data present in a worksheet. They provide a clear and concise way to analyze and interpret the data by displaying it in various graphical formats such as bar charts, line charts, pie charts, etc. Charts help in identifying trends, patterns, and relationships between different data points, making it easier for users to understand and make informed decisions based on the data. Therefore, the statement "they are visual representation of the worksheet data" accurately describes the purpose and functionality of charts in Microsoft Excel.
4.
Row heading are rows labeled with numbers, starting with 1
Correct Answer
A. True
Explanation
Row headings are indeed rows labeled with numbers, starting with 1. This means that each row in a table or spreadsheet is assigned a number as its label, with the first row being labeled as 1, the second row as 2, and so on. This labeling system helps to easily identify and refer to specific rows in a table or spreadsheet, especially when working with large amounts of data.
5.
A Range is a group of books of calls in a workstation
Correct Answer
B. False
Explanation
The statement is false because a range is not a group of books of calls in a workstation. A range typically refers to a series or sequence of numbers or values within a specified range or interval. It can be used in various contexts such as mathematics, statistics, or programming to define a set of values within a specific range.
6.
Value contains numbers and can be used in calculations
Correct Answer
A. True
Explanation
The statement suggests that the value contains numbers and can be used in calculations. This means that the value is numeric and can be manipulated mathematically. Therefore, the correct answer is True.
7.
Start a formula with ___________________________ ?
Correct Answer
N/A
8.
One box in a spreadsheet. The place where a row and a column intersect
Correct Answer
A. Cell
Explanation
A cell in a spreadsheet refers to the specific location where a row and a column intersect. It is the smallest unit of data in a spreadsheet and can contain text, numbers, formulas, or functions. Cells are used to organize and store data in a structured manner, allowing users to perform calculations, analyze data, and create visual representations such as charts and graphs.
9.
A computer program with Rows, columns, cells that lets you organize information and do math
Correct Answer
A. Autosum
Explanation
A spreadsheet is a computer program that allows users to organize information and perform mathematical calculations. One of the features commonly found in spreadsheets is the autosum function, which automatically calculates the sum of a selected range of cells. Therefore, the correct answer in this case is "autosum."
10.
The horizontal space (across) that has numbers on the left side
Correct Answer
D. Row
Explanation
The correct answer is "row". In a table or grid, a row is a horizontal line that contains information or data. It is identified by the numbers or labels on the left side of the grid. The other options, such as column, cell, and alignment, refer to different aspects of a table or grid but do not specifically relate to the horizontal space with numbers on the left side.
11.
Tell how you would open Microsoft excel ?
Correct Answer
N/A
12.
AVERAGE is used to find the size of the smallest class
Correct Answer
B. False
Explanation
The statement that "AVERAGE is used to find the size of the smallest class" is false. The AVERAGE function is used to calculate the average value of a set of numbers, not to determine the size of a class. The size of a class is typically determined by counting the number of students or individuals in the class.
13.
MAX is used to show the size of the largest class
Correct Answer
A. True
Explanation
The statement is true because the MAX keyword is commonly used in programming languages to determine the size of the largest class or data type. It allows programmers to allocate the necessary memory or define the appropriate boundaries for their variables or arrays. By using MAX, they can ensure that their program can handle the largest possible value or object within the specified constraints.
14.
MIN is used to show the average class size
Correct Answer
B. False
Explanation
The given statement is incorrect. MIN is not used to show the average class size. MIN is a function used to find the minimum value in a set of numbers. It returns the smallest value from a given range of values. Therefore, the correct answer is False.