Basic Computer Knowledge :: MS Office Tools Question And Answers































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

26. To open the Format Cells dialog box, press

A. Alt + 1 B. Ctrl + 1
C. Ctrl + Shift + 1 D. F1
View Answer Discuss in Forum

27. How can you break the current column and start a new column immediately?

A. Press Ctrl + Shift + Enter B. Press Alt + Enter 
C. Press Ctrl + Enter D. Press Alt + Shift + Enter
View Answer Discuss in Forum

28. To move the cursor page to page of document 

A. Ctrl+PgDn B. Ctrl+PgUp
C. Both of above D. Ctrl+Delete
View Answer Discuss in Forum

29. On which toolbar can you find Format Painter tool?

A. Standard toolbar  B. Formatting toolbar
C. Drawing Toolbar  D. Picture Toolbar
View Answer Discuss in Forum

30. How can you increase the font size of selected text by one point every time? 

A. By pressing Ctrl + ] B. By pressing Ctrl + [
C. By pressing Ctrl + } D. By pressing Ctrl + { 
View Answer Discuss in Forum



Related Topics

Basic Computer Quiz
Ms Excel For IBPS LIC AAO
Computer Knowledge Bank
abbreviations
Computer Networking Basics
MS Office Tools






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.