Quiz : How Well Aware Are You With MS Spreadsheets?
(576).jpg "Quiz : How Well Aware Are You With MS Spreadsheets? - Quiz")
Working on MS has become an integral part of office life. Are you curious to know how well aware-you are of MS spreadsheets? Take this quiz to see if you can answer all the technical and theoretical questions in excel. All the questions given in the quiz are in MCQ format & you are expected to choose the correct option. Your score will be reflected after you've attempted all the questions in the quiz. We challenge you a get a high score. We are sure that you'll love it! All the best!
- 1.
Tables in spreadsheets are better than tables in word processors because they
- A.
Use numbers only.
- B.
Will have unchanging formats.
- C.
Can be easily updated.
- D.
Have accurate data.
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.Rate this question:
-
- 2.
All changes to value, labels, or formulas in a spreadsheet are made in the
- A.
Formula bar.
- B.
Cell.
- C.
Frame.
- D.
Function line.
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.Rate this question:
-
- 3.
Values, by default, are aligned
- A.
To the left.
- B.
To the right.
- C.
Centered in the cell.
- D.
At the top of the cell.
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.Rate this question:
-
- 4.
How does an Excel spreadsheet know that =10/12 is a formula and not the date October 12?
- A.
The equal sign (=) signals it.
- B.
The division (/) sign signals it.
- C.
Dates cannot be shown that way.
- D.
It would not know.
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.Rate this question:
-
- 5.
Operations are carried out in the following order:
- A.
A - D - E - M - P - S
- B.
M - D - E - P - S - A
- C.
P - M - D - A - S - E
- D.
P - E - M - D - A - S
Correct Answer
D. P - E - M - D - A - SExplanation
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.Rate this question:
-
- 6.
It is best to write formulas using cell references so that a spreadsheet
- A.
Has no hidden information.
- B.
Has all correct values.
- C.
Can be updated easily.
- D.
Can be more easily graphed.
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.Rate this question:
-
- 7.
What are the two essential macro languages used in Ms. Excel?
- A.
Tally and C#
- B.
ZNM and oracle
- C.
XLM and VBA (Visual Basic Applications)
- D.
None of the above
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.Rate this question:
-
- 8.
Which formula can be used for date and time functions?
- A.
DATEVALUE()
- B.
INDEX MATCH
- C.
RAND()
- D.
VLOOKUP
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.Rate this question:
-
- 9.
How is the pivot table used in Ms Excel?
- A.
To delete a large set of data
- B.
To summarize a large data set
- C.
To add new tabular data
- D.
None of the above
Correct Answer
B. To summarize a large data setExplanation
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.Rate this question:
-
- 10.
What are the two reports formats used in Excel?
- A.
Landscape and A4
- B.
Horizontal and Vertical
- C.
Still and Moving
- D.
Tabular and Compact
Correct Answer
D. Tabular and CompactExplanation
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.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
-
Jan 31, 2023Quiz Edited by
ProProfs Editorial Team -
Oct 23, 2009Quiz Created by
Jhangen
Back to top