1931. Which of the following is not information you can specify using the solver?
A. Input cells
B. Constraints
C. Target cell
D. Changing cells
✅ The correct answer is option A.
Computer
Prepare with the best Computer MCQs with answers and explanations for exams and job tests. Our question bank covers computer fundamentals, hardware, software, networking, operating systems, databases, programming, internet, and information technology. These Computer multiple-choice questions are helpful for students, competitive exam aspirants, and professionals preparing for NTS, PPSC, FPSC, CSS, PMS, university entry tests, IT certifications, and job interviews. Practice online to improve your knowledge and score higher with our updated and comprehensive Computer MCQs.
1932. When a range is selected, how can you activate the previous cell?
A. Press the Alt key
B. Press Tab
C. Press Enter
D. None of above
✅ The correct answer is option D.
1933. A numeric value can be treated as a label value if it precedes with
A. Apostrophe (‘)
B. Exclamation (!)
C. Hash (#)
D. Ampersand (&)
✅ The correct answer is option A.
1934. A circular reference is
A. Geometric modeling tool
B. A cell that points to a drawing object
C. A formula that either directly or indirectly depends on itself
D. Always erroneous
✅ The correct answer is option C.
1935. Which elements of worksheet can be protected from accidental modification
A. Contents
B. Objects
C. Scenarios
D. All of above
✅ The correct answer is option D.
1936. You can convert existing excel worksheet data an charts to an HTML document by using
A. FTP wizard
B. Internet assistant wizard
C. Intranet wizard
D. Import wizard
✅ The correct answer is option B.
1937. Excel uniquely identifies cells within a worksheet with a cell name
A. Cell names
B. Column numbers and row letters
C. Column letters and row numbers
D. Cell locator coordinates
✅ The correct answer is option C.
1938. Where can you set the shading color for a range of cells in Excel?
A. Choose required color form Patterns tab of Format Cells dialog box
B. Choose required color on Fill Color tool in Formatting toolbar
C. Choose required color on Fill Color tool in Drawing toolbar
D. All of above
✅ The correct answer is option D.
1939. What does COUNTA () function do?
A. Counts cells having alphabets
B. Counts empty cells
C. Counts cells having number
D. Counts non-empty cells
✅ The correct answer is option D.
1940. Which area in an excel window allows entering values and formulas
A. Title bar
B. Menu bar
C. Formula bar
D. Standard toolbar
✅ The correct answer is option C.