Computer Gk For All Competitive Exams Series #45

Hello readers,

If you are doing preparation for SSC, BANKS, LIC,HSSC Exams, come to us regularly. COMPUTER Gk  for SSC, BANKS, LIC,HSSC Exams like SSC CGL, SSC CHSL, BANK PO, BANK CLERK, LIC AO, haryana police, gram sachiv, clerk, canal patwari, HPSC etc. Computer General Knowledge  Computer General Knowledge Questions । haryana general knowledge and current affairs ।. । haryana Samanyagyan

MS- EXCEL

  1. Which would you choose to create a bar diagram?

(1) Edit, Chart

(2) Insert, Chart√

(3) Tools, Chart

(4) Format, Chart

(5) None of these

Computer Gk For All Competitive Exams Series #46

Computer Gk For All Competitive Exams Series #44

  1. Which setting you must modify to print a worksheet

using letterhead?

(1) Paper (2) Margin√

(3) Layout

(4) Orientation

(5) None of these

  1. What do you call the chart that shows the proportions of

how one or more data elements relate to another data

element?

(1) XY Chart

(2) Line Chart

(3) Pie Chart√

(4) Column Chart

(5) None of these

  1. The spelling dialog box can be involved by choosing

spelling from ___ menu.

(1) insert

(2) file

(3) tools√

(4) view

(5) None of these

  1. Which key do you press to check spelling?

(1) F3 (2) F5

(3) F7√ (4) F9

(5) None of these

886.To record a sequence of keystrokes and mouse

actions to play back later we use:

(1) Media player

(2) Sound Recorder

(3) Calculator

(4) Macro Recorder√

(5) None of these

  1. We can save and protect 1he workbook by

(1) Write Reservation Password

(2) Protection Password

(3) Read-only Recommended

(4) Any of the above√

(5) None of these

  1. The first cell in EXCEL worksheet is labeled as

(1) A (2) A1√

(3) Aa (4) AO

(5) None of these

889.What happens when dollar signs (S) are entered In a

cell address?

(1) An absolute eel I address is created. √

(2) Cell address will change when it is copied to another cell.

(3) The sheet tab is changed.

(4) The status bar does not display the eel I address.

(5) None of these

  1. What are the tabs that appear at the bottom of each

workbook called?

(1) Reference tabs

(2) Position tabs

(3) Location tabs

(4) Sheet tabs√

(5) None of these

891.What is represented by the small, black square in the

lower-right corner of an active cell or range?

(1) Copy handle

(2) Fill handle√

(3) Insert handle

(4) Border

(5) None of these

  1. In Excel, a Data Series is defined as

what?

(1) A type of chart.

(2) A eel I reference.

(3) A collection of related data√

(4) Adivision of results

(5) None of these

  1. In Excel, the Fill Color button on the Formatting toolbar

is used for what?

(1) To insert a background.

(2) To add borders.

(3) To select a distribution of figures.

(4) To add shading or color to a cell range. √

(5) None of these

  1. In help menu of Excel, which of the following tabs are

found?

(1) Contents tab

(2) Answer Wizard tab

(3) Index tab

(4) all of the above√

(5) None of these

  1. A ______is a grid with labeled

columns and rows.

(1) Dialog box (2) Worksheet√

(3) Clipboard

(4) Toolbar

(5) None of these

  1. The active cell:

(1) is defined by a bold border around the ceil.

(2) Receives the data the user enters.

(3) It is the formula bar.

(4) Only A and B√

(5) None of these

897.Which function Is used to calculate depreciation, rates of

return, future values and loan payment amounts?

(1) Logical (2) Math & Trigonometry

(3) Statistical

(4) Financial√

(5) None of these

  1. B7:B9 indicates:

(1) Cells B7 and cell B9 only.

(2) Cells B7 through B9. √

(3) Cell BSonly.

(4) None of the a bove.

(5) None of these

Computer Gk For All Competitive Exams Series #46

Computer Gk For All Competitive Exams Series #44

  1. The Cancel and Enter buttons appear In the:

(1) Title bar (2) Formula bar√

(3) Menu bar

(4) Sheet tabs

(5) None of these

  1. MS-EXCEL can be used to automate

(1) Financial statements. Business forecasting

(2) Transaction registers, inventory control

(3) Accounts receivable, accounts payable

(4) Any of the above√

(5) None of these

Thank you for reading the Computer gk questions answers for SSC, BANK, HSSC exams.

Comments

comments

Leave a Comment

error: