Microsoft Excel Questions 1.Which shows the address of the current selection or active cell?
A. Title bar
B. Name box
C. Scroll bar
d. Ribbon
2.Which appears at the intersection of a column and row?
A. Cell
b. Sheet tab
C. Zoom slider
D. View button
3.Choose the answer
To apply formatting changes to text in Excel, use the controls in the Font group on the ___ tab.
A. insert
b. data
c. file
d. home
4.which refers to a reusable sample that serves as the basis for new files you create?
a. template
b. selection
c. formula
d. spell checker
5.Which identifies an Excel range that spans the cells from A4 through G7
a. A4..G7
b. A4:G7
c. A4=G7
D. A4[G7]
6.Which elements in a worksheet are dragged to use the Auto Fill feature?
a. fill handle
b. scroll bar
c. name box
d. marquee
7.which is the first step to delete a column in a worksheet?
a. select the column to the left of the column you want to delete.
b. change the width of the column to zero
c. select the column you want to delete
d. select the column to the right of the column you want to delete
8.Which is the name of the dialog box used to insert a cell or group of cells in a worksheet
a. insert range
b. insert
c. insert cells
d. insert data
9.which is a command that rearranges data by switching the columns and rows in pasted data?
a. paste values
b. auto fill
c. flash fill
d. transpose
10.which is an invalid range name?
a. Q1 sales
b. Q1_sales
c. Q1?sales
d. Q1.sales