Excel Worksheet Quiz 2

As data is keyed in an Excel worksheet, in which of the following locations is it visible?

• Formula bar

• Status bar

• Name box

• Ribbon

Which of the following keyboard keys completes a cell entry in an Excel worksheet and moves the pointer one cell below?

• [Enter]

• [Tab]

• Right arrow

• Left arrow

Which command tab in the Ribbon includes buttons to change the font style and the font size in an Excel worksheet?

• Home

• Page Layout

• Formulas

• View

Which of the following Excel commands displays a white cross with a paintbrush as its pointer?

• Brush Paint

• Copy and Paste

• Cell Styles

• Format Painter

Which of the following addresses is a valid cell range address in an Excel worksheet?

• A1

• A1-C4

• A1:C4

• C4:A1

In an Excel worksheet, which of the following pointers displays a thick white cross shape?

• Move pointer

• Selection pointer

• Command selector

• Font selector

Which key, when pressed, starts Extend Selection mode in an Excel worksheet?

• [F6]

• [F7]

• [F8]

• [F9]

What should be your first step in developing a new Excel workbook?

• Create its folder

• Estimate its size in bytes

• Identify its purpose

• Calculate its arithmetic

If you key 1.000 in a cell with the General format applied, what appears in the cell?

• 1

• 1.0

• 1.00

• 1.000

In an Excel worksheet, which of the following happens when you press [Ctrl]+[1]?

• Format Cells dialog box opens

• Backstage view opens

• Current cell style is applied

• Workbook is saved with the same file name