Subject: Microsoft Excel 2016

General knowledge questions please select and reply with 100% correct answer of all questions.

1. How is a cell named?

A. Column letter then row number

B. Column number then row letter

C. Row letter then column number

D. Row number then column letter

2. How many worksheets display in the Excel window when you create a new blank workbook?

A. 3

B. 2

C. 4

D. 1

3. What is entered into a cell that is typically numeric and can be used for calculations?

A. Label

B. Function

C. Tab

D. Value

4. An inserted graphic in Excel is

A. inserted in the active cell

B. a nonmovable object

C. inserted in cell A1

D. a freely moving object

5. Alan is a mathematical statement that calculates a value.

A. function

B. formula

C. argument

D. order of operations

6. Press the key to move to the next cell in a row.

A. Home

B. Tab

C. Page Down

D. Enter

7. When considering changing the content of a cell which button should you press to leave the cell as it originally was?

A. Enter

B. Backspace

C. Delete

D. Cancel

8. To add a new blank row to the end of a table, click on the

A. last table cell and press Tab.

B. last table cell and press Enter.

C. first table cell and press Enter.

D. first table cell and press Tab.

Select the best answer for the question no. 9 below.

Jacksonville Florida $212,048

Charlotte North Carolina $109,341

Memphis Tennessee $204,010

Washington _District of Columbia $221,873

Nashville Tennessee $138,453

Baltimore Maryland $82,742

9. If you wanted to only view the sales of $200,000+ in the table above, which number filter would you select?

A. Greater Than, and then 200,000

B. Equal, and then 200,000

C. Does Not Equal, and then 200,000

D. Greater Than Or Equal To, and then 200,000

10. The most efficient way to perform data entry is to keep your hands on the keyboard and press to move to the next cell in the row or

press to move to the next cell in the column.

A. Tab; Enter

B. Tab; Home

C. Home; Tab

D. Enter; Tab

11. What does it mean when #DIV/0! is displayed and a green triangle is added to the upper-left corner of a cell?

A. The formula cannot be calculated because there is an error.

B. The formula doesn't start with a = sign.

C. The formula can be calculated but there is an error.

D. The Error Checking feature is disabled.

12. A table can be changed back to cell data by clicking the button.

A. Resize Table

B. Quick Analysis

C. Number Filters

D. Convert to Range

13. Which of these charts has only one data series?

A. Pie

B. Area

C. Line

D. Bar

14. What would be a situation in which you could use an Excel chart to present your data?

A. Compiling survey questions and answers from business clients.

B. What percentage of customer 101 buys product A, and what percentage of the same customer buys product B?

C. Listing team members on a soccer team with their address information

D. Required ingredients for three different kinds of cake

15. What feature could you use to automatically shade cells containing a negative value in red?

A. Orientation

B. Sort & Filter

C. Conditional Formatting

D. Fill Color

16. Adding around calculations indicates which calculations should be performed first before following the typical order of operations.

A. addition symbols

B. the equal sign

C. parentheses

D. division symbols

17. If you want to learn how to perform an action, which feature of the Excel window should you use?

A. File tab

B. Tell Me box

C. Status bar

D. Quick Access Toolbar

18. When planning the structure of a spreadsheet, columns are for items and rows are for items.

A. single; single

B. group; single

C. single; group

D. group; group

19. Which function should be used to display a value based on a comparison?

A. MIN

B. IF

C. COUNT

D. AVERAGE

20. When you enter a formula into a cell, the results of that calculation displays in the cell. How do you view the formula in the cell after entering it?

A. Press Ctrl+~.

B. Click the cell and view the contents of the Formula bar.

C. Press Ctrl+Home.

D. Click the cell and enter the equal sign.

General knowledge questions please select and reply with 100% correct answer of all questions.