Homework answers / question archive / 1) Excel provides the ability to create new worksheets and new ____ sheets A) documentation B) chart C) workbook D) reference 2

1) Excel provides the ability to create new worksheets and new ____ sheets A) documentation B) chart C) workbook D) reference 2

Computer Science

Share With

---

1)

Excel provides the ability to create new worksheets and new ____ sheets

A) documentation
B) chart
C) workbook
D) reference

2.

To go to column A of the current row, click ____.

A) Ctrl + Home
B) Home
C) Shift + Tab
D) Tab + Enter

3.

 

In the figure above, “Documentation” and “Customer Orders” are names of ____.

 

A) worksheets
B) files
C) workbooks
D) folders

 

4.

The contents of an active cell are displayed in the ____.

A) toolbar
B) menu bar
C) name box
D) formula bar

5.

From formula view, press ____ to switch the worksheet back to Normal view.

A) Ctrl + >
B) Ctrl + <
C) Ctrl + ?
D) Ctrl + `

6.

The default column width is 8.43 standard-sized ____.

A) letters
B) pixels
C) characters
D) numbers

7.

The formula used to multiply cell A1 by cell C1 is ____.

A) =A1*C1
B) C1*A1
C) =A1/C1
D) A1*C1

8.

To change the order of operations, enclose part of the formula in ____.

A) brackets
B) italics
C) parentheses
D) quotation marks

9.

By default, Excel starts with a ____ maximized to fill the Excel window.

A) sample workbook with calculations
B) sample workbook with formulas
C) sample workbook with text, formulas, can calculations
D) blank workbook

 

10.

Excel makes reading formulas simpler by ____ each cell reference in the formula and its corresponding cell in the worksheet.

A) color coding
B) bolding
C) highlighting
D) italicizing

 

11.

To make A1 the active cell, you should press which of the following keys?

A) Page Up
B) Page Down
C) Home
D) Ctrl+Home

12.

____ a printout reduces the width and the height of the printout to fit the number of pages you specify by shrinking the text size as needed.

A) Autofitting
B) Scaling
C) Shrinking
D) Resizing

13.

To insert a new column, select a column, then click the Insert button in the ____ group on the Home tab.

A) Insert
B) Cells
C) Number
D) Editing

14.

An Excel worksheet can have a maximum of ____ columns in a worksheet.

A) 156
B) 256
C) 16,385
D) 17 million

 

15.

Which of the following takes precedence over multiplication?

A) division
B) exponentiation
C) addition
D) subtraction

 

16.

 

None of the data shown in the figure above is ____.

 

A) aligned
B) truncated
C) formatted
D) formulated

 

17.

To select a large range of cells, click the first cell in the range, press and hold ____, and then click the last cell in the range.

A) Esc
B) Ctrl
C) Shift
D) F3

18.

To view formulas, rather than the resulting values in a worksheet, switch to ____.

A) formula view
B) normal view
C) editing mode
D) AutoSum view

19.

Press the ____ key to switch to editing mode.

A) ` (grave key)
B) Num Lock
C) F2
D) F9

20.

What is the result of the expression =50/(10*5)?

A) 1/5
B) 1
C) 25
D) 50