Basic Computer Knowledge :: MS Office Tools Question And Answers



































16. When you are typing an equation into a cell the first thing that must be entered is

A. first cell referenced B. parenthesis
C. quotation marks D. an equal sign
View Answer Discuss in Forum

17. Using the AutoSum button will replace in the selected cell ..........

A. sum of values  in the cell's column B. nothing until you select a range of cells
C. sum of the cell’s row unless you change the range D. formula which will add values in the range Excel guesses you want to add
View Answer Discuss in Forum

18. Book1 is an example of how … are numbered and named during each work session

A. Active cell B. Formula bar
C. Menu bar D. Name box
View Answer Discuss in Forum

19. Which of the following displays the contents of the active cell?

A. Active cell B. Formula bar
C. Name box D. Menu bar
View Answer Discuss in Forum

20. Graphics objects on a chart are used to

A. Add emphasis to chart data B. Add interest to a chart
C. Help explain the chart data D. a, b, and c
View Answer Discuss in Forum

21. What does SUMIF function do?

A. Adds up cell values based on a condition B. Adds all the numbers in a range of cells
C. Returns a subtotal in a list or database D. All of above
View Answer Discuss in Forum

22. You can insert labels for

A. All the data markers on a chart B. A data series
C. A selected data marker D. All
View Answer Discuss in Forum

23. Tab scrolling buttons

A. Allow you to view a different worksheet B. Allow you to view additional worksheet row down
C. Allow you to view additional worksheet columns to the righ D. Allow you to view additional sheet tabs
View Answer Discuss in Forum

24. You can add a hyperlink to your worksheet by pressing

A. Alt + K B. Ctrl + H
C. Ctrl + K D. Ctrl + Shift + K
View Answer Discuss in Forum

25. All macro keyboard shortcuts include the ........ key

A. Alt B. Ctrl
C. F11 D. Shift
View Answer Discuss in Forum



Related Topics

Computer Networking Basics
MS Office Tools
Basics of Computers
LIC AAO Exam Computer
Computer Model Paper 10
Keyboard Shortcuts






Who are all can get the advantages from this MS Office Tools Question and Answers section?

Those are all planning for any competitive examinations can use this segment to enhance their abilities.