Microsoft Excels: Formulas and Functions

The command used for reading the table for a particular row is?

• IF

• VLOOKUP

• HLOOKUP

• SUM

If we write the formula = 8 + 5 * 3 in Ms Excel, the result is?...

• 39

• 29

• 23

• 43

The portion of Microsoft Excel that is used as the screen scroll button is..

• Ribbon

• Tab Menu

• Scroll

• Formula Bar

Ordering data in Ms. Excel from small to large is called...

• Ascending

• Descending

• Fescending

• Sescending

The command used to set the column width is ...

• Row height

• Column width

• Insert row

• Insert column

The document file management button on the Office Excel Microsof is round in shape with the Office logo in the middle called.… office button

• Excel Options

• Office Button

• Ribbon

• Tittle Bar

• Toolbar

To change the unit of measure in Excel, use the command….

• Start–Setting–Control Panel–Regional–Currency

• Tools–Options–Print

• Office Button–Open

• Office Button–Excel Options–Save–Default File Location

• Office Button–Excel Options–Advanced–Display–Ruler Units

To move or copy a worksheet, the menu that should be selected after right-clicking on the sheet tab is….

• Delete

• Rename

• Select all sheet

• Move or Copy

• Paste

The menu that should be selected to widen or narrow the column size on the worksheet is...

• Insert Sheet Column

• Insert Sheet

• Borders

• Row Height

• Column Width

To add a line in Excel, the command that is clicked on the Insert menu is….

• Insert Cells

• Insert Sheet Rows

• Insert Sheet Column

• Insert Sheet

• Insert Name