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 usColumn Charts are useful to visually compare values a few categories or for showing data changes over a period of time. A Column Chart typically displays the categories along the horizontal (Category) axis and the values along the vertical (Value) axis.
Use the COUNT function to get the number of entries in a number field that is in a range or array of numbers. For example, you can enter the following formula to count the numbers in the range A1:A10 [=count(A1:A10)]. In this example, if five of the cells in the range contain numbers, the result will be 5.
EXCEL is typically use to organize data, perform financial analysis, statistical calculations, prepration of table and graph etc. It is used across all business functions and at companies from small to large.
Filter features enables you to view only data that meets certain criteria.
By default, Row run horizontally across worksheet & ranges from 1 to 1048576. A row is generally identified by the number that is on the left side of the row from where the originates.
The basic unit of a worksheet into which you enter data in excel is called cell. A Cell is the intersection of rows and columns. Columns are identified by letters (A, B, C...), while rows are identified by numbers (1,2,3...). Each cell has its own name or cell address based on its colum and row.
The Chart wizard is a series of dialog boxes which lets you make decisions regarding the chart you want to create. There are four steps in the wizard which allow you to change the chart type, source data, chart options and location of your chart.
A Database is an organized collection of data, generally stored and accessed electronically from a computer system.
An excel file is generally called a workbook because like pages in the book, this also contains different sheets called worksheets and worksheets are stored in a file called a workbook.
When you open an excel workbook, there are three sheets by default, and the default name on the tabs are Sheet1, Sheet2, and Sheet3.
0 Comments:
Post a Comment
Please don't enter any spam link in the comment box.