1959. In the formula, which symbol specifies the fixed columns or rows?
A. $
B. *
C. %
D. &
✅ The correct answer is option A.
1962. When you insert an excel file into a word document. The data are
A. Hyperlinked placed in a word table
B. Linked
C. Embedded
D. Use the word menu bar and toolbars
✅ The correct answer is option B.
1965. Which of following is Not one of Excel’s what-if function?
A. Goal seek
B. Solver
C. Scenario manager
D. Auto Outline
✅ The correct answer is option D.
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.
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.
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.
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.
1941. What is the short cut key to highlight the entire column?
A. Ctrl + C
B. Ctrl + Enter
C. Ctrl + Page Up
D. Ctrl + Space Bar
✅ The correct answer is option D.
1943. How can you remove borders applied in cells?
A. Choose None on Border tab of Format cells
B. Open the list on Border tool in Format Cell toolbar then choose first tool (none)
C. Both of above
D. None of above
✅ The correct answer is option C.