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:
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
Scan QR code to download our App for
more exam-oriented questions
OR
To get link to download app