Learn Key Excel 2007?

Can Someone Answer These Questions For Me

1: True Or False:It is possible to change or delete row and column headings.

2: Which are ways to add color to worksheet tabs?

A - Sheet tab colors cannot be changed

B - Right-click on a sheet tab and select Tab Color

C - Sheet tab colors change automatically when edited

3:What are problems a user might encounter when inserting photos into the background? Choose all that apply.

A - Pixilation

B - Seams showing

C - Screen resolution

D - Contrast colors overshadowing text

4:What is the keyboard shortcut for insert?

A - CTRL+INSERT

B - CTRL+SHIFT+INSERT

C - CTRL+ALT+PLUS SIGN

D - CTRL+SHIFT+PLUS SIGN

5:Which function key is the Repeat key?

A - F1

B - F4

C - F6

D - F12

6:How can an entire row or column be formatted in the Accounting format?

A - Each selected cell must be formatted individually

B - Select the column or row, right-click, and select Format Cells from the menu that appears. Choose the Number tab, and then select Currency.

C - Select the column or row, right-click, and select Format Cells from the menu that appears. Choose the Number tab, and then select Accounting

7:True Or False:Applying a currency format to an entire column will affect the header.

8:What does Format Painter do?

A - Auto-format cells

B - Delete cell format

C - Format numbers within cells

D - Copy format from one cell to other cells

9: Which are special number formats of Excel 2007? Choose all that apply.

A - Zip Code

B - Phone Number

C - Social Security Number

D - Driver's License Number

10:Which symbol, when preceding a number, can make that number into a text entry?

Number to Text

11:Which symbol, when preceding a number, can make that number into a text entry?

A - Comma

B - Asterisk

C - Apostrophe

D - Quotation mark

12:True Or False:Cells can be merged and centered by clicking the Merge and Center button within the Alignment group of the Home tab.

13:True or False:Excel has added contextual tabs that appear when the user needs them and then disappear when the user is finished.

14:What happens when the user clicks outside of the table? Choose all that apply.

A - The table disappears

B - Table options disappear

C - The contextual tab disappears

D - The document is not in table mode

15:Which are options in the Summary Function drop-down menu? Choose all that apply.

A - Sum

B - Multiply

C - Average

D - Dividends

16:In which group is the Convert to Range button located?

A - Data

B - View

C - Tools

D - Insert

17: What does the equal sign signify when entered into a cell?

A - Textual relationship

B - Numerical relationship

C - Dependent relationship

D - Independent relationship

18:What is the keyboard shortcut for revealing all operations on the worksheet simultaneously?

A - CTRL+`

B - CTRL+'

C - CTRL+!

D - CTRL+*

19:Which items can be placed in a formula list? Choose all that apply.

A - Numbers

B - Cell addresses

C - Function names

D - Range of named numbers

Thanks Everyone:)

Please enter comments
Please enter your name.
Please enter the correct email address.
You must agree before submitting.

Answers & Comments


Copyright © 2024 VQUIX.COM - All rights reserved.