Introfinal

Welcome to your Microsoft Intro Final Test 55 Questions

1. Excel is a _____ that allows you to storeorganize, and analyze information.

2.   To access Backstage view: Click the ___ tab on the Ribbon

3. Excel files are called _____ .

4. Instead of using long formula to add big number of cells together you can use _____, that performs calculations using specific values in a particular order.

5.   To access functions go to ____ tab.

6.  To organize your worksheet alphabetically go to ____ tab and click sort command.

7. From options below choose types of charts available in Excel

  

8.  To crate the table on your worksheet all you have to do is select the cells you want to include, then click _____ command.

9. Design tab appears every time when you have table selected.

10.  To sort data on your worksheet you can choose _____ types of sorting. Select all what apply.

11.  If your worksheet contains a lot of content, it can be difficult to find information quickly. _____ can be used to narrow down the data in your worksheet, allowing you to view only the information you need.

12.  You can apply multiple filters to help narrow down your results.

13. You can share your workbook right within Excel. Go to Share command in the ______ corner of your interface.

14.  To insert row or column in your workbook you can on the ____ tab.

15.  If you working with different types of data in excel (like currency or percentage) you have to know correct format. From options below choose INCORRECT format of Dates.

16. There may be times when you're working on a workbook and find that you need the help of others. Excel offers two powerful features that allow you to work with others on the same spreadsheet: ______ and _____.

1.  Web browsers: A web browser is the tool you use to access the Internet. Most computers come with a web browser pre-installed, but you can also download a different one if you prefer. Examples of browsers include ____________.

2.  Which internet browser is rarely used?

3. What are some examples of an app?

1.  On the Home tab, click the drop-down arrow next to the ________ command. A menu of ____ styles will appear.

Clicking the Bullets drop-down arrow

4. If you have a laptop, setup should be easy: Just open it and press the power button. If the battery isn't charged, you'll need to plug in the _________. You can continue using the laptop while it charges.

2.  On the _______ tab, click the Line and Paragraph Spacing command, then select the desired line spacing.

3.  When you need to organize text into a numbered list, Word offers several numbering options. You can format your list with

4.  Adding hyperlinks, also known as ________, to text can provide access to websites and email addresses directly from your document.

5. Select the _____ tab, then click the Link command.

6.  Word offers two page orientation options: _______and _______.

7.  Landscape means the page is oriented horizontally.

Landscape orientation

28.   Select the _______ tab, then click the Margins command.

16.  What is the Order or Operations?

17. Click on the ______tab to print or make copies.

9.  On the ________ tab, click the Page Break command.

10.  Select the ________ tab, then click the Header or Footer command.

11. ____________ can be used to automatically number each page in your document.

12.  On the ________ tab, click the Page Number command.

13.   Navigate to the ________ tab, then click the Table command.

36.    To delete a row or column:

  1. Place the insertion point in the row or column you want to delete.
  2. Right-click, then select ______________ from the menu.

14.   In the Styles group on the _________ tab, click the More drop-down arrow.

clicking the More button in the Styles group

15.  To check spelling and grammar go to ____ tab

16.  Which of the following best describes the Ribbon?

17.  You can change the line spacing to

41. How would you change the words in Excel if you made a mistake in spelling?

42.  Excel includes many common functions that can be used to quickly find the ______________________for a range of cells.

43.  Use _________ to insert a function that calculates the lowest score in cells B3:B17.

44. The Insert Function dialog box will appear on

45. By  _______-clicking the mouse the column width will change automatically to fit the content.

46. To modify row height:

  1. Position the cursor over the row line so the cursor becomes a _________ arrow.
    hovering over a row line

47. On the ________ tab, click the drop-down arrow next to the Font Size command, then select the desired font size. In our example, we will choose 24 to make the text larger.

Selecting a font size in the dropdown menu

48. If you want to copy formatting from one cell to another, you can use the ____________ command on the Home tab. When you click the ________, it will copy all of the formatting from the selected cell. You can then click and drag over any cells where you want to paste the formatting.  
excel image

49. 

  1. Select the cell containing the formula you want to copy. Click and drag the __________ over the cells you want to fill.
    Drag the fill handle
  2. After you release the mouse, the formula will be copied to the selected cells.

50.  All formulas in Excel must begin with an _________. This is because the cell contains, or is equal to, the formula and the value it calculates.

51. A JPEG uses the .jpg or .jpeg extension for _____.

52. Downloading means receiving data or a file from ______________.

53. A Word document uses _________ extension.

54. Excel spreadsheet uses the ____________ extension.

55. Uploading means sending data or a file from your computer to somewhere on ________________.

wpChatIcon
wpChatIcon
Skip to content