Question Bank - Computer Awareness

Here's the question bank on all the computer awareness topics.

In an Excel spreadsheet, the contents of cells are as follows:a) A1 contains the value 3b) A2 contains the value 5c) A3 contains the formula: = A$1+A2Contents of cell A3 are copied to Cell A4. The value displayed in Cell A4 will be:

A.
11
B.
5
C.
8
D.
13

Solution:

The answer is 11.The Cell value of A1 is 3.The Cell value of A2 is 5.A3 contains the formula: = A$1+A2 then the value of A3 will be 8.The Cell value of A3 is 8.The formula in cell A3 is copied to cell A4.So, the value in cell A4 is "10".Additional InformationExcel:Excel is a spreadsheet programme for Windows, macOS, Android, and iOS that was created by Microsoft.It includes calculation, graphing methods, pivot tables, and a macro programming language called Visual Basic for Applications.Download Solution PDFShare on Whatsapp

For more questions,

Click Here

Download Gyanm App

free current affairs for competitive exams

Scan QR code to download our App for
more exam-oriented questions

free current affairs for competitive exams

OR
To get link to download app

Thank you! Your submission has been received. You will get the pdf soon. Call us if you have any question: 9117343434
Oops! Something went wrong while submitting the form.