Understanding Microsoft Excel For Grade: 9mj
Class test
Questions and Answers
- 1.
Which is CORRECT about spreadsheet ??
- A.
A game we play in class
- B.
Fill with lines and we just play with them
- C.
This is a piece of software that make it easy for you to carry out calclations
- D.
A software used for many task that are important to the boot up
Correct Answer
C. This is a piece of software that make it easy for you to carry out calclationsExplanation
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.Rate this question:
-
- 2.
ALL is a part of Microsoft excel EXCEPT ?
- A.
Active cell
- B.
Column heading
- C.
Window file
- D.
Formula bar
Correct Answer
C. Window fileExplanation
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.Rate this question:
-
- 3.
Which is correct about CHARTS in Microsoft excel?
- A.
they are visual representation of the worksheet data
- B.
Maps to the world
- C.
Graphics
- D.
Designs
Correct Answer
A. they are visual representation of the worksheet dataExplanation
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.Rate this question:
-
- 4.
Row heading are rows labeled with numbers, starting with 1
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
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.Rate this question:
-
- 5.
A Range is a group of books of calls in a workstation
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
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.Rate this question:
-
- 6.
Value contains numbers and can be used in calculations
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
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.Rate this question:
-
- 7.
Start a formula with ___________________________ ?
Correct Answer
N/A - 8.
One box in a spreadsheet. The place where a row and a column intersect
- A.
Cell
- B.
Row
- C.
Column
- D.
Alignment
Correct Answer
A. CellExplanation
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.Rate this question:
-
- 9.
A computer program with Rows, columns, cells that lets you organize information and do math
- A.
Autosum
- B.
Descending
- C.
Format
- D.
Spreadsheet
Correct Answer
A. AutosumExplanation
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."Rate this question:
-
- 10.
The horizontal space (across) that has numbers on the left side
- A.
Column
- B.
Cell
- C.
Allignment
- D.
Row
Correct Answer
D. RowExplanation
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.Rate this question:
-
- 11.
Tell how you would open Microsoft excel ?
Correct Answer
N/A - 12.
AVERAGE is used to find the size of the smallest class
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
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.Rate this question:
-
- 13.
MAX is used to show the size of the largest class
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
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.Rate this question:
-
- 14.
MIN is used to show the average class size
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
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.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 17, 2023Quiz Edited by
ProProfs Editorial Team -
Mar 31, 2014Quiz Created by
Sean_yungprezi
Back to top