MS Excel
430 questions available
FILTER BY SUBTOPIC
Q141.What is IF function in excel?
Correct Answer: B
Q142.If you want to calculate maximum value in Excel sheet which command you select?
Correct Answer: B
Q143.Which one is application software?
Correct Answer: C
MS Excel is application software because it helps users create, calculate, analyze, and present spreadsheet data.
Q144.An excel workbook is a collection of?
Correct Answer: D
An excel workbook is a collection of Worksheets and Charts.
Q145.Which of these keys are used in MS Excel to insert the current time in workbook?
Correct Answer: B
Ctrl + Shift + ; is the keyboard command for the action described.
Q146.In MS Excel ready- made templates are available under the ____tab?
Correct Answer: B
In MS Excel ready- made templates are available under the Filetab.
Q147.You can edit existing Excel Data by pressing the key
Correct Answer: C
F2 key is the keyboard command for the action described.
Q148.When you insert an Excel File into a word document, the data are?
Correct Answer: A
When you insert an Excel File into a word document, the data are Embedded.
Q149.User-developed instructions for excel are called ____?
Correct Answer: C
User-developed instructions for excel are called Macros.
Q150.Which one of the following is presentation software?
Correct Answer: D
None of these is the correct factual response to “Which one of the following is presentation software”.
Q151.The ______function in Excel returns the highest value in a set of data that you specify?
Correct Answer: B
The AVGfunction in Excel returns the highest value in a set of data that you specify.
Q152.In MS Excel, which function automatically to a column or row of values?
Correct Answer: C
SUM is the correct factual response to “In MS Excel, which function automatically to a column or row of values”.
Q153.Which key is used to minimize Excel Worksheet?
Correct Answer: C
Ctrl+F9 is used to minimize Excel Worksheet.
Q154.MS Excel displays the address of the active cell in the?
Correct Answer: B
Name Box is the correct factual response to “MS Excel displays the address of the active cell in the”.
Q155.In Excel we added______ before fraction for not to enter date
Correct Answer: A
In Excel we addedSpace before fraction for not to enter date.
Q156._______is a spreadsheet program where one can record data in the form of tables
Correct Answer: A
MS Excelis a spreadsheet program where one can record data in the form of tables.
Q157.In Excel, a Data Series is defined as what
Correct Answer: C
A collection of related data is the correct factual response to “In Excel, a Data Series is defined as what”.
Q158.You cannot link excel worksheet data to a word document?
Correct Answer: D
With the copy and paste buttons on the standard toolbar is the correct factual response to “You cannot link excel worksheet data to a word document”.
Q159.Which key is used to create chart in excel?
Correct Answer: C
F11 is used to create chart in excel.
Q160.Which of the following software is used for presentation for communication purposes?
Correct Answer: B
PowerPoint is used to presentation for communication purposes.