MS-Excel MCQ Set-4

MS-Excel MCQ Set-4 1. The programming language in which Excel keeps the macro code record. A) Java B) Visual Basic C) Basic D) Video Basic Answer : B 2. What is the shortcut key to replace in MS-Excel? A) Ctrl+R B) Ctrl+E C) Ctrl+H D) Ctrl+L Answer : C 3. Which of the following menu …

MS-Excel MCQ Set-3

MS-Excel MCQ Set-3 1. A function does have inside the function is called______ A) Nested Function B) Round Function C) Sum Function D) Text Function Answer : A 2. The cell address in the Microsoft Office Excel document is _________ A) Column Name B) Row Name C) First Row then Column Name D) First Column …

MS-Excel MCQ Set-2

MS-Excel MCQ Set-2 1. A typical worksheet has …. Number of columns A) 128 B) 256 C) 512 D) 1024 Answer : B 2. How many characters can be typed in a single cell in Excel? A) 256 B) 1024 C) 32,000 D) 65,535 Answer : D 3. A worksheet can have a maximum of …

MS-Excel MCQ Set-1

MS-Excel MCQ Set-1 1. Which of the following is an absolute cell reference? A) !A!1 B) $A$1 C) #a#1 D) A1 Answer : B 2. What symbol is used before a number to make it a label? A) “ (quote) B) = (equal) C) _ (underscore) D) ‘ (apostrophe) Answer : B 3. Which symbol …