AD cbt practice imp questions

How do formatting styles impact on the appearance of business letters?

• A.      They create a professional look to the document
• B.      They allow the document name to be changed
• C.      They create an easy to read document template
• D.     They allow the document to be saved security

What file type is best used for creating an online document?

• A.      TXT.
• B.      HTML.
• C.      PDF.
• D.     JPEG.

What sequence places items in order based on the names of items?

• A.      Operational
• B.      Numerical
• C.      Chronological
• D.     Alphabetical

What design feature improves the readability of an electronic presentation?

• A.      SmartArt
• B.      Animations
• C.      Themes
• D.     Charts

What skill ensures a presentation screen layout supports the text structure?

• A.      Communication
• B.      Problem solving
• C.      Numeracy
• D.     Literacy

What function will check if the value in row 2 is over budget (B2)?

• A.      =IF(A2>B2,”Over Budget”, “OK”)
• B.      =IF(A2<B2,”Over Budget”, “OK”)
• C.      =IF(R2>B2,”Over Budget”, “OK”)
• D.     =IF(R2<B2,”Over Budget”, “OK”)

What is an impact of having blank rows and columns in a spreadsheet?

• A.      Split screen is not possible
• B.      Data is difficult to read
• C.      Formulae do not work correctly
• D.     Images are not in the workbook

What formula adds cells A1, A2, and A3 divides the total cells by 2?

• A. 2/A3
• B =SUM(A1,A3)/2
• C =SUM(A1:A3)/2
• D =(A1:A3)/(2)

What is the most portable method for storing spreadsheets?

• A. Server
• B. Tape
• C. CD-ROM
• D. USB

How is the size of a graph in a spreadsheet reduced?

• A. Using the clipboard in a new worksheet
• B. Using the object handles in the chart area
• C. Using a graphics program
• D. Using an electronic ruler