Basic Word and Excel

profilemeggielovezz

Please answers questions 1-20 correctly and send it back to me asap

 

1.   You've been asked to find the average of a range of numbers. Which of the following could you use to find the average of cells A1:A10?
    

 

 

2.   Helga needs to lay out her newly created pivot table. What are the two ways she can set up a pivot table?
    

 

3.   Which of the following keys on a keyboard allows you to select multiple cells located in different parts of your worksheet?
    

 

4.   What is the purpose of OneDrive?
    

 

5.   In Word, a red wavy underline indicates a/an
    

 

 

6.   Default tab stops are set in Word every ___________ inch.
    

 

 

7.   How do you access the dictionary and thesaurus in Word?
    

 

 

8.   To reveal paragraph markers—such as spaces, hard returns, and tabs—in your document, what should you do?
    

 

9.   How would you insert a section break in a document?
    

 

 

10.   You send a report to your boss for feedback, and it's returned to you with the edits noted in the electronic file. This Word feature is called
    

 

 

11.   A feature in Excel that allows you to graphically display in a single cell the trend across a range of cells is called a
    

 

 

12.   Arthur needs to copy the formula in cell C13 to cell D13. He needs cell D13 to have the same formula but referenced with a new location. Which type of cell reference should he use?
    

 

 

13.   Which of the following identifies the patterns used for each data series in a chart?
    
14.   You're working in a table that has three columns and five rows. Since the first row will be a header row, you want it to span all three columns. What formatting feature should you use?
    

 

15.   After inputting a formula or a piece of data into a cell, what happens to the cell pointer when you press Enter?
    

 

 

16.   You just finished creating an expense report table, but your boss tells you to create an extra column representing non-production costs. How do you insert this column?
    
 

 

 

17.   What category of predefined formulas in Excel contains the Boolean functions?
    

 

18.   If you want to have certain icons available regardless of what tab you're using, you should add them to the
    
19.   To recover a deleted document, what would you choose in the Info window?
    

 

20.   Which of the following is an example of a complex formula?
    

 

 

 

 

 

    • 10 years ago
    • 7
    Answer(1)

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      basic_word_and_excel__.docx
    Bids(1)