Spreadsheet Questions

Match List-I with List-II:List-I (Movement)List-II (Keystroke)(A) One cell down(I) Left arrow key(B) One cell up(II) Right arrow key or Tab key(C) One cell left(III) Down arrow key or Enter key(D) One cell right(IV) Up arrow keyChoose the correct answer from the options given below:

The following elements are important for salary computation and its payment:(A) Grade Pay (GP)
(B) Dearness Allowance (DA)
(C) Transport Allowance (TRA)
(D) Goods and Service Tax (GST)Choose the correct answer from the options given below:

Which combination is true in respect of using a graph/chart?(A) Quicker and easier to create a chart immediately to see the possible relationship of variables to one another, rather than paging through raw data.
(B) Provide information in as little time as possible.
(C) Graphs do not have the ability to take large amounts of information and make them into exhibitions that are easily used to persuade
(D) A graph may be either a single line graph or a multi-line graph.Choose the correct answer from the options given below:

Following are the steps related to preparation of charts, arrange them in a correct sequence.(A) Save a chart.
(B) Create a basic chart using the pattern from the panel available on top of the worksheet in 'Chart groups' option.
(C) Change the layout or style of chart
(D) Enter data on a worksheet with proper column and row titles.Choose the correct answer from the options given below: