1951. Which of the following format you can decide to apply or not in AutoFormat dialog box?
A. Number format
B. Border format
C. Font format
D. All of above
✅ The correct answer is option D.
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.
1952. To view a cell comment
A. Click the edit comment command on the insert menu
B. Click the display comment command on the window menu
C. Position the mouse pointer over the cell
D. Click the comment command on the view menu
✅ The correct answer is option C.
1953. You can copy data or formulas
A. With the copy, paste and cut commands on the edit menu
B. With commands on the shortcut menu
C. With buttons on the standard toolbars
D. All of the above
✅ The correct answer is option D.
1954. When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply
A. Use =if() function to format the required numbers red
B. Apply Conditional Formatting command on Format menu
C. Select the cells that contain number between 0 and 100 then click Red color on Text Color tool
D. All of above
✅ The correct answer is option B.
1955. Getting data from a cell located in a different sheet is called ________
A. Accessing
B. Referencing
C. Updating
D. Functioning
✅ The correct answer is option B.
1956. The Paste Special command lets you copy and paste:
A. Multiply the selection by a copied value
B. Cell comments
C. Formatting options
D. The resulting values of a formula instead of the actual formula
✅ The correct answer is option D.
1957. An Excel Workbook is a collection of ________
A. Workbooks
B. Worksheets
C. Charts
D. Worksheets and Charts
✅ The correct answer is option D.
1958. Which of the following is an absolute cell reference?
A. !A!1
B. $A$1
C. #a#1
D. A1
✅ The correct answer is option B.
1959. In the formula, which symbol specifies the fixed columns or rows?
A. $
B. *
C. %
D. &
✅ The correct answer is option A.
1960. Which menu option can be used to split windows into two?
A. Review > Window
B. View > Window > Split
C. Window > Split
D. View > Split
✅ The correct answer is option B.