Are you finding the computer general knowledge questions for competitive exams? Here I am sharing computer general knowledge quiz questions and answers covering important topics in computer awareness, which is common for all the competitive exams.
These are the selective and important questions of the computer. You can increase your knowledge by learning these computer questions which help you while solving computer questions in SSC, Bank exams and many other competitive exams.
Learning Zone About us
In Excel, you can use shortcut key (Ctrl + F9) together to minimize current workbook window.
In MS-Excel, press Ctrl + " (quotes) to copy the above cell contents into the current cell.
Excel logical operators (>) - overview. A logical operator (>) is used in Excel to compare two values. Logical operators are sometimes called Boolean operators because the result of the comparison in any given case can only be either TRUE or FALSE.
Sorting in Excel is arranging data according to our requirements. It can be done alphabetically or numerically. Basic Sorting works when sorting is to do on only one column. Advanced Sorting is used in multi-level sorting viz sorting required in 2 or more than 2 columns.
Excel has a feature that helps you automatically enter data. If you are entering a predictable series (e.g. 1, 2, 3…; days of the week; hours of the day) you can use the AutoFill command to automatically extend the sequence.
Pie charts can convert one column or row of spreadsheet data into a pie chart. Each slice of pie (data point) shows the size or percentage of that slice relative to the whole pie. Pie charts work best when: You have only one data series. None of the data values are zero or less than zero.
A line chart is a graph that shows a series of data points connected by straight lines. It is a graphical object used to represent the data in your Excel spreadsheet. You can use a line chart when: You want to show a trend over time (such as days, months or years).
Pie charts can convert one column or row of spreadsheet data into a pie chart. Each slice of pie (data point) shows the size or percentage of that slice relative to the whole pie. Pie charts work best when: You have only one data series. None of the data values are zero or less than zero.
Explanation: By using Pie chart we can graphically represent expenditure in different departments. The type of chart which is good for single series of data is Pie chart. The basic unit of a worksheet into which we enter data in excel is called a Cell.
There are three wildcard characters in Excel:
- * (asterisk) – It represents any number of characters. For example, Ex* could mean Excel, Excels, Example, Expert, etc.
- ? (question mark) – It represents one single character.
- ~ (tilde) – It is used to identify a wildcard character (~, *, ?) in the text.
Computer quiz for competitive exams | Bank, PO, SCC and many more...