1.
Tables in spreadsheets are better than tables in word processors because they
Correct Answer
C. Can be easily updated.
Explanation
Tables in spreadsheets can be easily updated because spreadsheets are designed to handle numerical data and perform calculations. Unlike word processors, spreadsheets provide built-in functions and formulas that allow users to manipulate and update data effortlessly. Additionally, spreadsheets offer features like sorting, filtering, and conditional formatting, which make it easier to organize and update data in a table format. This flexibility and functionality make tables in spreadsheets a preferred choice for managing and updating data compared to tables in word processors.
2.
All changes to value, labels, or formulas in a spreadsheet are made in the
Correct Answer
A. Formula bar.
Explanation
In a spreadsheet, the formula bar is where you can make changes to the value, labels, or formulas of a cell. It is a designated area where you can input or edit the content of a cell. This allows you to easily modify the data within the cell without directly altering the cell itself. The formula bar provides a convenient and organized way to manage and update the information in a spreadsheet.
3.
Values, by default, are aligned
Correct Answer
B. To the right.
Explanation
By default, values in a cell are aligned to the right. This means that the numbers or text will be positioned towards the right side of the cell. This alignment is commonly used for numerical data or when the text is expected to be read from left to right.
4.
How does an Excel spreadsheet know that =10/12 is a formula and not the date October 12?
Correct Answer
A. The equal sign (=) signals it.
Explanation
The equal sign (=) is used to indicate that a formula is being entered in an Excel spreadsheet. This is a convention established by Excel to differentiate formulas from other types of data. Therefore, when Excel encounters the equal sign followed by numbers or mathematical operators like division (/), it recognizes it as a formula and performs the calculation accordingly.
5.
Operations are carried out in the following order:
Correct Answer
D. P - E - M - D - A - S
Explanation
The given operations are carried out in a specific order: A, D, E, M, P, S. The correct answer is P - E - M - D - A - S, which means that the operations are performed in the order of P, E, M, D, A, S.
6.
It is best to write formulas using cell references so that a spreadsheet
Correct Answer
C. Can be updated easily.
Explanation
Writing formulas using cell references allows for easy updating of a spreadsheet because if the values in the referenced cells change, the formulas automatically recalculate based on the new values. This eliminates the need to manually update each formula whenever there is a change in the underlying data. By using cell references, the spreadsheet can be easily modified and maintained, ensuring accuracy and efficiency in data analysis and calculations.
7.
What are the two essential macro languages used in Ms. Excel?
Correct Answer
C. XLM and VBA (Visual Basic Applications)
Explanation
XLM (Excel Macro Language) and VBA (Visual Basic for Applications) are the two essential macro languages used in Ms. Excel. XLM is an older macro language that was used in earlier versions of Excel, while VBA is a more modern and powerful macro language that is widely used in current versions of Excel. These macro languages allow users to automate tasks, create custom functions, and enhance the functionality of Excel.
8.
Which formula can be used for date and time functions?
Correct Answer
A. DATEVALUE()
Explanation
The formula that can be used for date and time functions is DATEVALUE(). This function converts a date string into a date value that can be used in calculations or comparisons. It is useful when working with dates that are stored as text or when data needs to be manipulated based on specific dates.
9.
How is the pivot table used in Ms Excel?
Correct Answer
B. To summarize a large data set
Explanation
The pivot table in MS Excel is used to summarize a large data set. It allows users to analyze and condense extensive amounts of data into a more manageable and organized format. With a pivot table, users can easily group and categorize data, calculate totals and averages, and generate meaningful insights from the data. It is a powerful tool for data analysis and reporting purposes.
10.
What are the two reports formats used in Excel?
Correct Answer
D. Tabular and Compact
Explanation
The two report formats used in Excel are tabular and compact. Tabular format refers to organizing data in rows and columns, making it easier to analyze and compare information. Compact format, on the other hand, refers to condensing the data to fit more information in a smaller space, usually by using smaller fonts or eliminating unnecessary elements. These formats help users present and view data in a clear and concise manner.