Excel Test

Which of the following shows the loction of the cell which has been selected?

• formula bar

• cell name box

• worksheet tab

• dialog box

which of the following are composed of a grid system of rows and columns which cross to make cells?

• worksheets

• table guides

• graphs

• formulas

Which of the following is NOT a viewing option for a worksheet?

• normal

• page layout

• page break preview

• gridline

Backstage view can be reached by clicking on which tab on the ribbon?

• file

• home

• insert

• page design

Which tab and group on the ribbon holds the command to change the font of the text of the cells of the worksheet?

• home tab, paragraph group

• home tab, font group

• home tab, editing group

• page layout tab, paragraph group

Which of the following is correct formula to add cells A1 and B2?

• A1+B2

• =A1+B2

• SUM(A1:B2)

• =$A1+$B2)

Which of the following is an absolute cells reference?

• A1

• A$1

• $A1

• $A$1

Which of the followingfinishes an entry based on previous entries made in the column containing the active cell?

• autofinish

• FillComplete

• Conditionalformatting

• AutoComplete

Which of the following is NOT a type of conditional formatting?

• Data Bar

• Icon Set

• Highlight

• Comment

Which of the following can be used to copy the formatting applied to a cell?

• Format Bar

• Format Handle

• Format painter

• Format Cell