Excel basic Lab1

An Excel Workbook is a collection of …….

• Workbooks

• Worksheets

• Charts

• Worksheets and Charts

To select an entire column in MS-EXCEL, press?

• CTRL + Arrow key

• SHIFT + Arrow key

• CTRL + SPACE

• SHIFT + SPACE

In EXCEL, you can sum a large range of data by simply pressing a combo....

• CTRL + =

• Alt + =

• CTRL + SHIFT + Spacebar

• CTRL + SHIFT + Enter

How do you rearrange the data in ascending or descending order?

• Data, Sort

• Data, Form

• Data, Table

• Data Subtotals

What is the keyboard shortcut key to lock cell references in a formula?

• F2

• F3

• F4

• F5

What are the shortcut keys to open up the Find and Replace window?

• ALT + H + F + R

• ALT + H + F

• ALT + H + R

• CTRL + F

What is the hotkey to open the edit box to change the value/information inside the cell?

• F2

• F3

• F5

• F6

What function was used to find the highest grade?

• average

• sum

• min

• max

Which of these number formats would you want to apply to a cell showing the total sales for the month?

• Percentage

• Date

• Currency

• Fraction

Hotkey to Text Wrapping a text within a cell

• Alt+ Enter

• Shift + Enter

• Ctrl + Enter

• Shift + Spacebar