SOTI Computer Quiz-4
Quiz-summary
0 of 100 questions completed
Questions:
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- 37
- 38
- 39
- 40
- 41
- 42
- 43
- 44
- 45
- 46
- 47
- 48
- 49
- 50
- 51
- 52
- 53
- 54
- 55
- 56
- 57
- 58
- 59
- 60
- 61
- 62
- 63
- 64
- 65
- 66
- 67
- 68
- 69
- 70
- 71
- 72
- 73
- 74
- 75
- 76
- 77
- 78
- 79
- 80
- 81
- 82
- 83
- 84
- 85
- 86
- 87
- 88
- 89
- 90
- 91
- 92
- 93
- 94
- 95
- 96
- 97
- 98
- 99
- 100
Information
Computer operator Quiz Game. Play and Learn (Soti Computer)
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading...
You must sign in or sign up to start the quiz.
You have to finish following quiz, to start this quiz:
Results
0 of 100 questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 points, (0)
Categories
- Not categorized 0%
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- 37
- 38
- 39
- 40
- 41
- 42
- 43
- 44
- 45
- 46
- 47
- 48
- 49
- 50
- 51
- 52
- 53
- 54
- 55
- 56
- 57
- 58
- 59
- 60
- 61
- 62
- 63
- 64
- 65
- 66
- 67
- 68
- 69
- 70
- 71
- 72
- 73
- 74
- 75
- 76
- 77
- 78
- 79
- 80
- 81
- 82
- 83
- 84
- 85
- 86
- 87
- 88
- 89
- 90
- 91
- 92
- 93
- 94
- 95
- 96
- 97
- 98
- 99
- 100
- Answered
- Review
-
Question 1 of 100
1. Question
You can detect spelling and grammar errors by
Correct
F7 Commonly used to spell check and grammar check a document in Microsoft programs such as Microsoft Word, Outlook, etc.
Incorrect
F7 Commonly used to spell check and grammar check a document in Microsoft programs such as Microsoft Word, Outlook, etc.
-
Question 2 of 100
2. Question
To View Header and footer, you must switch to
Correct
Headers and footers appear only in print layout view, print preview, and in printed documents.
Incorrect
Headers and footers appear only in print layout view, print preview, and in printed documents.
-
Question 3 of 100
3. Question
Ctrl + C is used to
Correct
Ctrl + C is used to copy the text or image we have selected and stores it on your virtual clipboard, until it is overwritten by the next “cut” or “copy” command.
Incorrect
Ctrl + C is used to copy the text or image we have selected and stores it on your virtual clipboard, until it is overwritten by the next “cut” or “copy” command.
-
Question 4 of 100
4. Question
Ctrl + Q is used to
Correct
Incorrect
-
Question 5 of 100
5. Question
Background color or effect applied on a document is not visible in
Correct
Background color or effects applied on a document is not visible in Print Preview area.
Incorrect
Background color or effects applied on a document is not visible in Print Preview area.
-
Question 6 of 100
6. Question
Short cut Ctrl + R is used to
Correct
Ctrl + R is used to right align the selected Paragraph.
Incorrect
Ctrl + R is used to right align the selected Paragraph.
-
Question 7 of 100
7. Question
When a word flags a possible spelling or grammar error, it also changes the mark on the spelling and grammar status icon to a _________________
Correct
If we typed a word not in the dictionary (misspelled or proper name), a wavy red line appears. Word flags a possible error and changes the Status icon to a red X.
Incorrect
If we typed a word not in the dictionary (misspelled or proper name), a wavy red line appears. Word flags a possible error and changes the Status icon to a red X.
-
Question 8 of 100
8. Question
Which of the following is not a font style?
Correct
A superscript is a character, symbol or number set slightly above the normal line of text. It is always smaller than the usual font and is typically found in mathematical or scientific formulas. it is effective on the font.
Incorrect
-
Question 9 of 100
9. Question
From where you can access the save command?
Correct
From Office Button we can access Save command in Word 2007.
From 2010 and higher versions from File we can access Save command.Incorrect
From Office Button we can access Save command in Word 2007.
From 2010 and higher versions from File we can access Save command. -
Question 10 of 100
10. Question
How can you remove tab stop markers from the ruler?
Correct
The easiest way to change and remove tab stops is to work with them directly on the Ruler. We can drag a tab stop to the right or left to shift its position, or we can drag it off the Ruler entirely (up or down) to remove it. To change a tab stop’s type, double-click the tab stop on the Ruler to open the Tabs dialog box and make our changes there.
Incorrect
The easiest way to change and remove tab stops is to work with them directly on the Ruler. We can drag a tab stop to the right or left to shift its position, or we can drag it off the Ruler entirely (up or down) to remove it. To change a tab stop’s type, double-click the tab stop on the Ruler to open the Tabs dialog box and make our changes there.
-
Question 11 of 100
11. Question
Ctrl + M is used to
Correct
CTRL + M is used to Indent a paragraph from the left.
Incorrect
CTRL + M is used to Indent a paragraph from the left.
-
Question 12 of 100
12. Question
Which of the following is not available on the ruler of MS word Screen?
Correct
Center Indent is not available on the Ruler of MS Word screen.
Incorrect
-
Question 13 of 100
13. Question
In MS Word, Ctrl + S is used to
Correct
In MS Word, Ctrl+S is used to Save the document.
Incorrect
In MS Word, Ctrl+S is used to Save the document.
-
Question 14 of 100
14. Question
Ctrl + W is used to
Correct
Ctrl + W is used to Save and Close document.
Incorrect
Ctrl + W is used to Save and Close document.
-
Question 15 of 100
15. Question
Which of the following format you can decide to apply or not in AutoFormat dialog box?
Correct
AutoFormat option in excel is a unique way of formatting data quickly, the first step is we need to select the entire data we need to format and then the second step we need to click on auto-format from the QAT and third step we need to choose the format from the different options.
Incorrect
AutoFormat option in excel is a unique way of formatting data quickly, the first step is we need to select the entire data we need to format and then the second step we need to click on auto-format from the QAT and third step we need to choose the format from the different options.
-
Question 16 of 100
16. Question
How can you remove borders applied in cells?
Correct
On the Home tab, in the Font group, click the arrow next to Borders Button, and then click No Border Button.
–OR–
Click Home > the Borders arrow > Erase Border, and then select the cells with the border you want to erase.Incorrect
On the Home tab, in the Font group, click the arrow next to Borders Button, and then click No Border Button.
–OR–
Click Home > the Borders arrow > Erase Border, and then select the cells with the border you want to erase. -
Question 17 of 100
17. Question
Where can you set the shading color for a range of cells in excel?
Correct
The formatting and Drawing toolbar is a toolbar in Microsoft Office 2003 and earlier applications, that gives the user the ability to change the formatting of selected text or cell.
Incorrect
The formatting and Drawing toolbar is a toolbar in Microsoft Office 2003 and earlier applications, that gives the user the ability to change the formatting of selected text or cell.
-
Question 18 of 100
18. Question
You can set page border in excel from
Correct
There is no option to set the page border in Excel.
Incorrect
There is no option to set the page border in Excel.
-
Question 19 of 100
19. Question
When all the number between 0 100 in a range should be displayed in Red Color, apply
Correct
A conditional format changes the appearance of cells on the basis of conditions that you specify. If the conditions are true, the cell range is formatted; if the conditions are false, the cell range is not formatted.
Incorrect
A conditional format changes the appearance of cells on the basis of conditions that you specify. If the conditions are true, the cell range is formatted; if the conditions are false, the cell range is not formatted.
-
Question 20 of 100
20. Question
Which of the following is not the correct method of editing the cell content?
Correct
A cell can be edited through Press the F2 key or Click the formula bar or Double click the cell.
Incorrect
A cell can be edited through Press the F2 key or Click the formula bar or Double click the cell.
-
Question 21 of 100
21. Question
You Can merge the main document with the data source in excel. In mail merge operation, the word is usually
Correct
You can merge the main document with data source in Excel. In mail merge operation, Word is usually Client
Incorrect
You can merge the main document with data source in Excel. In mail merge operation, Word is usually Client
-
Question 22 of 100
22. Question
How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
Correct
Manual calculation mode means that Excel will only recalculate all open workbooks when we request it by pressing F9. It allows to choose whether we want to update formulas in worksheets or entire workbook.
Incorrect
Manual calculation mode means that Excel will only recalculate all open workbooks when we request it by pressing F9. It allows to choose whether we want to update formulas in worksheets or entire workbook.
-
Question 23 of 100
23. Question
Which of the following Excel screen Components can not be turned on or off?
Correct
Show Formula bar option by clicking the File (or Office button) > Options > Advanced > Display > Show Formula bar.
In earlier versions of Excel, you could hide the status bar if you wanted more space available for your worksheets. However, that capability was removed starting with Excel 2007.
In earlier versions of Excel, you could hide the tool bar as per requirement. However, that capability was removed starting with Excel 2007 and introduced Ribbon.Incorrect
Show Formula bar option by clicking the File (or Office button) > Options > Advanced > Display > Show Formula bar.
In earlier versions of Excel, you could hide the status bar if you wanted more space available for your worksheets. However, that capability was removed starting with Excel 2007.
In earlier versions of Excel, you could hide the tool bar as per requirement. However, that capability was removed starting with Excel 2007 and introduced Ribbon. -
Question 24 of 100
24. Question
What happens when you press Ctrl + X after selecting some cells in excel?
Correct
When we pressing the ctrl+x in the Microsoft excel sheet it means we cut the content from that cell simply means the cells selected are marked for cutting and the user has need to move the content from one cell to another cell.
Incorrect
When we pressing the ctrl+x in the Microsoft excel sheet it means we cut the content from that cell simply means the cells selected are marked for cutting and the user has need to move the content from one cell to another cell.
-
Question 25 of 100
25. Question
Which of the following options is not available in the paste special dialog box?
Correct
To use options from the Paste Special box, click Home > Paste > Paste Special.
Incorrect
To use options from the Paste Special box, click Home > Paste > Paste Special.
-
Question 26 of 100
26. Question
Which command will you choose to convert a column of data into row?
Correct
Transpose (rotate) data from rows to columns or vice versa. To use options from the Paste Special box, click Home > Paste > Paste Special > Transpose
Incorrect
Transpose (rotate) data from rows to columns or vice versa. To use options from the Paste Special box, click Home > Paste > Paste Special > Transpose
-
Question 27 of 100
27. Question
you can auto fit the width of the column by
Correct
You can auto fit the width of column by double clicking on column right border on column header.
Incorrect
You can auto fit the width of column by double clicking on column right border on column header.
-
Question 28 of 100
28. Question
Long text can be broken down into many lines within a cell. you can do this through
Correct
Microsoft Excel can wrap text so it appears on multiple lines in a cell. We can format the cell so the text wraps automatically, or enter a manual line break.
On the Home tab, in the Alignment group, click Wrap Text.Incorrect
Microsoft Excel can wrap text so it appears on multiple lines in a cell. We can format the cell so the text wraps automatically, or enter a manual line break.
On the Home tab, in the Alignment group, click Wrap Text. -
Question 29 of 100
29. Question
Ms Excel provides the default value for step in fill series dialog box
Correct
The default value for any series is 1 in Excel.
Incorrect
The default value for any series is 1 in Excel.
-
Question 30 of 100
30. Question
When a row of data is to be converted into columns
Correct
Transpose (rotate) data from rows to columns or vice versa. To use options from the Paste Special box, click Home > Paste > Paste Special > Transpose
Select the cells then place the cell pointer on new cell and choose Paste Special, mark Transpose check box and click OKIncorrect
Transpose (rotate) data from rows to columns or vice versa. To use options from the Paste Special box, click Home > Paste > Paste Special > Transpose
Select the cells then place the cell pointer on new cell and choose Paste Special, mark Transpose check box and click OK -
Question 31 of 100
31. Question
Ctrl + D shortcut key in excel will
Correct
Ctrl+D fills the cell beneath with the contents of the selected cell in a column. To fill more than one cell, select the source cell and press Ctrl+Shift+Down to select all cells. Then press Ctrl+D to fill them with the contents of the original cell.
Incorrect
Ctrl+D fills the cell beneath with the contents of the selected cell in a column. To fill more than one cell, select the source cell and press Ctrl+Shift+Down to select all cells. Then press Ctrl+D to fill them with the contents of the original cell.
-
Question 32 of 100
32. Question
The Shortcut key Ctrl + R is used in excel to
Correct
Ctrl+R fills the row cell to the right with the contents of the selected cell. To fill more than one cell, select the source cell and press Ctrl+Shift+Right arrow to select multiple cells. Then press Ctrl+R to fill them with the contents of the original cell.
Incorrect
Ctrl+R fills the row cell to the right with the contents of the selected cell. To fill more than one cell, select the source cell and press Ctrl+Shift+Right arrow to select multiple cells. Then press Ctrl+R to fill them with the contents of the original cell.
-
Question 33 of 100
33. Question
Which of the following series type is not valid for fill series dialog box?
Correct
Time series type is not valid for Fill Series dialog box in excel.
https://www.examveda.com/images/solution-image/computer-fundamentals/ms-excel/1589642750-Examveda_8444.GIFIncorrect
Time series type is not valid for Fill Series dialog box in excel.
https://www.examveda.com/images/solution-image/computer-fundamentals/ms-excel/1589642750-Examveda_8444.GIF -
Question 34 of 100
34. Question
Paste special allows some operation while you paste to a new cell. Which of the following operation is valid?
Correct
Paste Special allows Divide operation while you paste to new cell.
https://www.examveda.com/images/solution-image/computer-fundamentals/ms-excel/1589643023-Examveda_8445.GIFIncorrect
Paste Special allows Divide operation while you paste to new cell.
https://www.examveda.com/images/solution-image/computer-fundamentals/ms-excel/1589643023-Examveda_8445.GIF -
Question 35 of 100
35. Question
Edit > Delete Command
Correct
Deletes selected cells through Edit > Delete command was available in Excel 2003 and earlier versions.
Incorrect
Deletes selected cells through Edit > Delete command was available in Excel 2003 and earlier versions.
-
Question 36 of 100
36. Question
To remove the content of selected cells you must issue ______________ command
Correct
To remove the content of selected cells we must issue Clear Contents command. Clear Contents will clear only the data, will not clear any formats.
Incorrect
To remove the content of selected cells we must issue Clear Contents command. Clear Contents will clear only the data, will not clear any formats.
-
Question 37 of 100
37. Question
The delete key of the keyboard is assigned to which command in excel?
Correct
The Delete key of keyboard is assigned to Clear Contents command in Excel. Clear Contents will clear only the data, will not clear any formats.
Incorrect
The Delete key of keyboard is assigned to Clear Contents command in Excel. Clear Contents will clear only the data, will not clear any formats.
-
Question 38 of 100
38. Question
Which of the following action removes a sheet from workbook?
Correct
To removes a sheet from workbook select the sheet, then choose Edit > Delete Sheet these options available in excel 2003 and earlier version.
In Microsoft Excel 2007 onward Choose Home > Delete > Delete Sheet on the Ribbon.Incorrect
To removes a sheet from workbook select the sheet, then choose Edit > Delete Sheet these options available in excel 2003 and earlier version.
In Microsoft Excel 2007 onward Choose Home > Delete > Delete Sheet on the Ribbon. -
Question 39 of 100
39. Question
Which of the following is not true about find and replace in excel
-
Question 40 of 100
40. Question
you can move a sheet from one workbook into new book by
Correct
From Edit menu choose Move or Copy then select (new book) from To Book list and click OK
Incorrect
From Edit menu choose Move or Copy then select (new book) from To Book list and click OK
-
Question 41 of 100
41. Question
What is the Shortcut key to replace a data with another in sheet?
Correct
Ctrl + H shortcut key is usedto replace a data with another in sheet.
Incorrect
Ctrl + H shortcut key is usedto replace a data with another in sheet.
-
Question 42 of 100
42. Question
Comments can be added to cells using
Correct
Comments can be added to cells using Insert > Comment.
Incorrect
Comments can be added to cells using Insert > Comment.
-
Question 43 of 100
43. Question
Which menu option can be used to split windows into two?
Correct
View > Window > Split option can be used to split windows into two.
Incorrect
View > Window > Split option can be used to split windows into two.
-
Question 44 of 100
44. Question
Getting data from a cell located in a different sheet is called
Correct
Getting data from a cell located in a different sheet is called Cell reference.
There are Three types of Cell reference in Excel
Relative
Absolute
MixedIncorrect
Getting data from a cell located in a different sheet is called Cell reference.
There are Three types of Cell reference in Excel
Relative
Absolute
Mixed -
Question 45 of 100
45. Question
Which of the following is not valid data type in excel?
Correct
There are Three types of data in cells: labels, values, and formulas. Labels (text) are descriptive pieces of information, such as names, months, or other identifying statistics, and they usually include alphabetic characters. Values (numbers) are generally raw numbers or dates. Formulas are instructions for Excel to perform calculations.
Incorrect
There are Three types of data in cells: labels, values, and formulas. Labels (text) are descriptive pieces of information, such as names, months, or other identifying statistics, and they usually include alphabetic characters. Values (numbers) are generally raw numbers or dates. Formulas are instructions for Excel to perform calculations.
-
Question 46 of 100
46. Question
which element of the worksheet can be protected from accidental modification?
Correct
All elements of a worksheet can be protected from accidental modification.
To protect a worksheet in Excel 2007 and higher versions, click the Review tab, click Protect Worksheet (or Protect Sheet), and click OK.
Excel 2003 and Earlier Versions click Tools > Protection, click Protect Sheet, and click OK.Incorrect
All elements of a worksheet can be protected from accidental modification.
To protect a worksheet in Excel 2007 and higher versions, click the Review tab, click Protect Worksheet (or Protect Sheet), and click OK.
Excel 2003 and Earlier Versions click Tools > Protection, click Protect Sheet, and click OK. -
Question 47 of 100
47. Question
A numeric value can be treated as label value if ______________ precedes it.
Correct
An apostrophe before a cell value forces Excel to interpret the value as text. This is mostly useful for values that look like a number or date.
Incorrect
An apostrophe before a cell value forces Excel to interpret the value as text. This is mostly useful for values that look like a number or date.
-
Question 48 of 100
48. Question
Concatenation of text can be done using
Correct
The ampersand (&) calculation operator allow us join text items without using a function. For example, =A1 & B1 will return the same value as =CONCATENATE(A1,B1). In many cases, using the ampersand operator is quicker and simpler than using CONCATENATE to create strings.
Incorrect
The ampersand (&) calculation operator allow us join text items without using a function. For example, =A1 & B1 will return the same value as =CONCATENATE(A1,B1). In many cases, using the ampersand operator is quicker and simpler than using CONCATENATE to create strings.
-
Question 49 of 100
49. Question
Which area in an excel window allows entering values and formulas?
Correct
Formula Bar area in an Excel window allows entering values and formulas. Formula Bar is a toolbar at the top of the Microsoft Excel spreadsheet window that we can use to enter or copy an existing formula in to cells or charts. It is labeled with function symbol (fx). By clicking the Formula Bar, or when you type an equal (=) symbol in a cell, the Formula Bar will activate.
Incorrect
Formula Bar area in an Excel window allows entering values and formulas. Formula Bar is a toolbar at the top of the Microsoft Excel spreadsheet window that we can use to enter or copy an existing formula in to cells or charts. It is labeled with function symbol (fx). By clicking the Formula Bar, or when you type an equal (=) symbol in a cell, the Formula Bar will activate.
-
Question 50 of 100
50. Question
Multiple Calculations can be made in single formula using
Correct
An array formula is a formula that can perform multiple calculations on one or more of the items in an array. We can think of an array as a row of values, a column of values, or a combination of rows and columns of values. Array formulas can return either multiple results or a single result. For example, we can create an array formula in a range of cells and use the array formula to calculate a column or row of subtotals. We can also place an array formula in a single cell and calculate a single amount. An array formula that includes multiple cells is called a multi-cell formula, and an array formula in a single cell is called a single-cell formula.
Incorrect
An array formula is a formula that can perform multiple calculations on one or more of the items in an array. We can think of an array as a row of values, a column of values, or a combination of rows and columns of values. Array formulas can return either multiple results or a single result. For example, we can create an array formula in a range of cells and use the array formula to calculate a column or row of subtotals. We can also place an array formula in a single cell and calculate a single amount. An array formula that includes multiple cells is called a multi-cell formula, and an array formula in a single cell is called a single-cell formula.
-
Question 51 of 100
51. Question
An Excel Workbook is a collection of __________________
Correct
A workbook is a collection of one or more spreadsheets and charts in a single file.
Incorrect
A workbook is a collection of one or more spreadsheets and charts in a single file.
-
Question 52 of 100
52. Question
What do you mean by a workspace?
Correct
The term workspace refers to all the open workbooks and their exact screen position and window sizes.
A workspace contains pointers to your other Excel files that you had open during your session.
When you open an Excel workspace all the other files are opened as well
Workspaces are particularly useful if you frequently work with the same set of files and need to have them all open at once.Incorrect
-
Question 53 of 100
53. Question
Ms Excel is based on ________________
Correct
MS-Excel is based on Windows. MS-Excel is a spreadsheet developed by Microsoft for Windows and few other operating systems. It is a program that stores and retrieves numerical data in rows and columns of grid format.
Incorrect
MS-Excel is based on Windows. MS-Excel is a spreadsheet developed by Microsoft for Windows and few other operating systems. It is a program that stores and retrieves numerical data in rows and columns of grid format.
-
Question 54 of 100
54. Question
In excel you can sum a large range of data by simply selecting a tool button called
Correct
AutoSum is a Microsoft Excel function that adds together a range of cells and displays the total in the cell below the selected range.
Incorrect
AutoSum is a Microsoft Excel function that adds together a range of cells and displays the total in the cell below the selected range.
-
Question 55 of 100
55. Question
To select an entire column in ms excel, press?
Correct
To select an entire column in MS-EXCEL, Click the column heading letter or press CTRL + Space Bar key.
Incorrect
To select an entire column in MS-EXCEL, Click the column heading letter or press CTRL + Space Bar key.
-
Question 56 of 100
56. Question
Which function is not available in the consolidate dialog box?
-
Question 57 of 100
57. Question
Which is not the function of Edit clear command?
-
Question 58 of 100
58. Question
Microsoft Excel is a powerful ____________________
Correct
Microsoft Excel is Microsoft’s general-purpose spreadsheet program for Windows, used for data analysis and display. It is commonly used in a business environment since it is part of the Microsoft Office package. Microsoft Excel is an extremely powerful tool, which is used by millions of people everyday. Functions tailored to a specific task can be programmed into Excel to extend its capabilities with customised analysis tools.
Incorrect
Microsoft Excel is Microsoft’s general-purpose spreadsheet program for Windows, used for data analysis and display. It is commonly used in a business environment since it is part of the Microsoft Office package. Microsoft Excel is an extremely powerful tool, which is used by millions of people everyday. Functions tailored to a specific task can be programmed into Excel to extend its capabilities with customised analysis tools.
-
Question 59 of 100
59. Question
How do you rearrange the data in ascending or descending order?
Correct
Sorting data in MS Excel rearranges the rows based on the contents of a particular column. We can also sort a table to put names in alphabetical order or ascending or descending order. Or, maybe we want to sort data by Amount from smallest to largest or largest to smallest.
Incorrect
Sorting data in MS Excel rearranges the rows based on the contents of a particular column. We can also sort a table to put names in alphabetical order or ascending or descending order. Or, maybe we want to sort data by Amount from smallest to largest or largest to smallest.
-
Question 60 of 100
60. Question
Which Chart can be Created in excel?
Correct
Excel offers the following major chart types −
Column Chart
Line Chart
Pie Chart
Doughnut Chart
Bar Chart
Area Chart
XY (Scatter) Chart
Bubble Chart
Stock Chart
Surface Chart
Radar Chart
Combo ChartIncorrect
Excel offers the following major chart types −
Column Chart
Line Chart
Pie Chart
Doughnut Chart
Bar Chart
Area Chart
XY (Scatter) Chart
Bubble Chart
Stock Chart
Surface Chart
Radar Chart
Combo Chart -
Question 61 of 100
61. Question
How do you display current data only in MS Excel?
Correct
DATE – returns the serial date value for a date
TODAY – returns today’s date
NOW – returns the current date and time
TIME – assemble a proper time.Incorrect
DATE – returns the serial date value for a date
TODAY – returns today’s date
NOW – returns the current date and time
TIME – assemble a proper time. -
Question 62 of 100
62. Question
How do you wrap the text in a cell?
Correct
Microsoft Excel can wrap text so it appears on multiple lines in a cell. We can format the cell so the text wraps automatically, or enter a manual line break.
On the Home tab, in the Alignment group, click Wrap Text.Incorrect
Microsoft Excel can wrap text so it appears on multiple lines in a cell. We can format the cell so the text wraps automatically, or enter a manual line break.
On the Home tab, in the Alignment group, click Wrap Text. -
Question 63 of 100
63. Question
What does CONUNTA() function do?
Correct
COUNTA function counts cells containing any type of information, including error values. COUNTA function does not count empty cells.
Incorrect
COUNTA function counts cells containing any type of information, including error values. COUNTA function does not count empty cells.
-
Question 64 of 100
64. Question
what is the shortcut key to highlight the entire column?
Correct
Ctrl + Space Bar is the short cut key to highlight the entire column.
Incorrect
Ctrl + Space Bar is the short cut key to highlight the entire column.
-
Question 65 of 100
65. Question
In the formula, Which symbol specifies the fixed column or rows?
Correct
The absolute cell reference in excel is a cell address that contains a dollar sign ($). It can precede the column reference, the row reference or both.
Incorrect
The absolute cell reference in excel is a cell address that contains a dollar sign ($). It can precede the column reference, the row reference or both.
-
Question 66 of 100
66. Question
Excel displays the current cell address in the _______________________
Correct
Name Box refers to an input box directly to the left of the formula bar. The Name Box normally displays the address of the “active cell” on the worksheet. You can also use the name box to quickly create a named range.
Incorrect
Name Box refers to an input box directly to the left of the formula bar. The Name Box normally displays the address of the “active cell” on the worksheet. You can also use the name box to quickly create a named range.
-
Question 67 of 100
67. Question
What is the correct way to refer the cell A10 on Sheet3 from Sheet1?
Correct
First we use the name of sheet, then put an exclamation mark, at the end give the cell reference.
It would be look like =Sheet3!A10Incorrect
First we use the name of sheet, then put an exclamation mark, at the end give the cell reference.
It would be look like =Sheet3!A10 -
Question 68 of 100
68. Question
Which language is used to create macro in excel?
Correct
VBA (Visual Basic for Applications) is the programming language of Excel with VBA we can automate tasks in Excel by writing so called macros.
Incorrect
VBA (Visual Basic for Applications) is the programming language of Excel with VBA we can automate tasks in Excel by writing so called macros.
-
Question 69 of 100
69. Question
Which of the following is not a term of MS-Excel?
Correct
A worksheet in Excel is made up of Rows and Columns. Intersection of a Row and column in an Excel worksheet is a rectangle called as a Cell. Cells store a value, a formula, or text.
Incorrect
A worksheet in Excel is made up of Rows and Columns. Intersection of a Row and column in an Excel worksheet is a rectangle called as a Cell. Cells store a value, a formula, or text.
-
Question 70 of 100
70. Question
How many worksheets can a workbook have?
Correct
Excel does not limit the number of sheets, so it is only limited by available memory on your computer (RAM). This means the max number of sheets is higher on computers with more memory.
Incorrect
Excel does not limit the number of sheets, so it is only limited by available memory on your computer (RAM). This means the max number of sheets is higher on computers with more memory.
-
Question 71 of 100
71. Question
Which would you choose to create a bar diagram?
Correct
Click the Insert > Chart
Incorrect
Click the Insert > Chart
-
Question 72 of 100
72. Question
Which setting you must modify to print a worksheet using letterhead?
Correct
We need to set margins in Excel worksheets before printing, open the “Page Setup” dialog box. To open the “Page Setup” dialog box, click the “Page Layout” tab in the Ribbon.
Incorrect
We need to set margins in Excel worksheets before printing, open the “Page Setup” dialog box. To open the “Page Setup” dialog box, click the “Page Layout” tab in the Ribbon.
-
Question 73 of 100
73. Question
What do you call the chart that shows the proportions of how one or more data elements relate to another data element?
Correct
Scatter plot (XY chart) used to show scientific XY data. Scatter plots are often used to find out if there’s a relationship between variable X and Y.
Line charts are used to display trends over time. Use a line chart if you have text labels, dates or a few numeric labels on the horizontal axis.
Pie charts are used to display the contribution of each value (slice) to a total (pie). Pie charts always use one data series.
Column charts are used to compare values across categories by using vertical bars.
14.
A.Insert
B.File
C.Tools
D.View
Answer & Solution Discuss in Board Save for Later
15.
A.F3
B.F5
C.F7
D.F9
Answer & Solution Discuss in Board Save for Later1234567891011121314
Read More Section(MS Excel)
Each Section contains maximum 70 questions. To get more questions visit other sections.MS Excel – Section 1
MS Excel – Section 3Incorrect
Scatter plot (XY chart) used to show scientific XY data. Scatter plots are often used to find out if there’s a relationship between variable X and Y.
Line charts are used to display trends over time. Use a line chart if you have text labels, dates or a few numeric labels on the horizontal axis.
Pie charts are used to display the contribution of each value (slice) to a total (pie). Pie charts always use one data series.
Column charts are used to compare values across categories by using vertical bars.
14.
A.Insert
B.File
C.Tools
D.View
Answer & Solution Discuss in Board Save for Later
15.
A.F3
B.F5
C.F7
D.F9
Answer & Solution Discuss in Board Save for Later1234567891011121314
Read More Section(MS Excel)
Each Section contains maximum 70 questions. To get more questions visit other sections.MS Excel – Section 1
MS Excel – Section 3 -
Question 74 of 100
74. Question
The spelling dialog box can be involved by choosing spelling from ___________________menu
Correct
In Excel 2003 and earlier version Tools > Spelling
From Excel 2007 and higher version Ribbon > Review tab > Proofing group > SpellingIncorrect
In Excel 2003 and earlier version Tools > Spelling
From Excel 2007 and higher version Ribbon > Review tab > Proofing group > Spelling -
Question 75 of 100
75. Question
Which key do you press to check spelling?
Correct
In most Microsoft Office apps (including Word, Excel, PowerPoint and Outlook), tap F7 to begin the spellcheck process.
Incorrect
In most Microsoft Office apps (including Word, Excel, PowerPoint and Outlook), tap F7 to begin the spellcheck process.
-
Question 76 of 100
76. Question
To record a sequence of keystrokes and mouse actions to playback later we use :
Correct
Macro Recorder records your mouse movements, mouse clicks and keyboard input. Just like a tape recorder for your computer.
Incorrect
Macro Recorder records your mouse movements, mouse clicks and keyboard input. Just like a tape recorder for your computer.
-
Question 77 of 100
77. Question
We can save and protect the workbook by?
Correct
We can save and protect the workbook by Encrypt a Workbook with a Password, Make a Workbook Read-Only, Protect a Workbook’s Structure, Protect a Worksheet from Editing, Protect Specific Cells From Editing.
Incorrect
We can save and protect the workbook by Encrypt a Workbook with a Password, Make a Workbook Read-Only, Protect a Workbook’s Structure, Protect a Worksheet from Editing, Protect Specific Cells From Editing.
-
Question 78 of 100
78. Question
The first cell in EXCEL worksheet is labeled as
Correct
The first cell in EXCEL worksheet is labeled as A1.
Incorrect
The first cell in EXCEL worksheet is labeled as A1.
-
Question 79 of 100
79. Question
What is represented by the small black square in the lower right corner of an active cell or range?
Correct
Fill handle is a feature to extend (and fill) a series of numbers, dates, or even text to a desired number of cells in Excel. In the active cell of the spreadsheet, the fill handle is a small black box at the bottom right corner,
Incorrect
Fill handle is a feature to extend (and fill) a series of numbers, dates, or even text to a desired number of cells in Excel. In the active cell of the spreadsheet, the fill handle is a small black box at the bottom right corner,
-
Question 80 of 100
80. Question
In Excel, a Data Series is defined as what?
Correct
In Excel, a Data Series is defined as a collection of related data. A data series is just a fancy name for a collection of related numbers in the same row, or the same column.
Incorrect
In Excel, a Data Series is defined as a collection of related data. A data series is just a fancy name for a collection of related numbers in the same row, or the same column.
-
Question 81 of 100
81. Question
In Excel, the fill color button on the formatting toolbar is used for what?
Correct
Fill Color is used to add or change the background color or pattern of cells.
Incorrect
Fill Color is used to add or change the background color or pattern of cells.
-
Question 82 of 100
82. Question
In help menu of excel, which of the following tabs are found?
Correct
In help menu of Excel 2003, Contents tab, Answer Wizard tab, Index tab are available.
Incorrect
In help menu of Excel 2003, Contents tab, Answer Wizard tab, Index tab are available.
-
Question 83 of 100
83. Question
A ______________ is a grid with labeled columns and rows?
Correct
A worksheet in Excel is made up of Rows and Columns grids. Intersection of a Row and column in an Excel worksheet is a rectangle called as a Cell. Cells store a value, a formula, or text.
Incorrect
A worksheet in Excel is made up of Rows and Columns grids. Intersection of a Row and column in an Excel worksheet is a rectangle called as a Cell. Cells store a value, a formula, or text.
-
Question 84 of 100
84. Question
Which of the following line spacing is invalid ?
Correct
Incorrect
-
Question 85 of 100
85. Question
From which Tab you can insert header and footer ?
Correct
Incorrect
-
Question 86 of 100
86. Question
Which operation you will perform if you need to move a block of text ?
Correct
Incorrect
-
Question 87 of 100
87. Question
MS Office provides help in many ways, which of these is one of theme ?
Correct
Incorrect
-
Question 88 of 100
88. Question
Which of the following is not a logical operator ?
Correct
Incorrect
-
Question 89 of 100
89. Question
Which of the following is an absolute call referene ?
Correct
Incorrect
-
Question 90 of 100
90. Question
Getting data from a cell located in a different sheet is called :
Correct
Incorrect
-
Question 91 of 100
91. Question
Conditional count can be performed using
Correct
Incorrect
-
Question 92 of 100
92. Question
Multiple Calculations can be made in a single formula using :
Correct
Incorrect
-
Question 93 of 100
93. Question
Formatting a cell in currency, you can specify :
Correct
Incorrect
-
Question 94 of 100
94. Question
This key uniquely identifies each record in a table of a database is a ;
Correct
Incorrect
-
Question 95 of 100
95. Question
Access method in Hard Disk is ;
Correct
Incorrect
-
Question 96 of 100
96. Question
Which of the connector is used to plug a telephone line into a modem ?
Correct
Incorrect
-
Question 97 of 100
97. Question
Which of the following is a file attribute ?
Correct
Incorrect
-
Question 98 of 100
98. Question
RJ-45 UTP cable has ____________ Cables.
Correct
Incorrect
-
Question 99 of 100
99. Question
Short-cut key combination for for closing windows is _____________
Correct
Incorrect
-
Question 100 of 100
100. Question
Which of the following is not a font style ?
Correct
Incorrect