MS EXCEL LEVEL 1

Which area in an Excel window allows entering values and formulas?

• Title Bar

• Formula Bar

• Menu Bar

• Standard Tool

An Excel Workbook is a collection of …….

• Worksheets

• Workbooks

• Worksheets and Charts

• Charts

In EXCEL, you can sum a large range of data by simply selecting a tool button called …..?

• Auto correct

• Auto format

• Auto sum

• AutoFill

Which is not the function of "Edit, Clear" command?

• Delete cells

• Delete notes

• Delete formats

• Delete contents

By default, Microsoft Excel automatically saves a copy of your spreadsheet every 10 minutes.

• True

• False

The Subtotals command adds numbers in a designated column.

• True

• False

Alex needs to add three cells and then divide the sum by 4. Which of the following is an example of the correct formula to do this?

• =A1+A2+A3^4

• =(A1+A2+A3)/4

• A1+A2+A3/4

• (A1+A2) + A3/4

What is the above image called as?

• Cell

• Column

• Row

• Command Group

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

• Data, Form

• Data, Table

• Data, Subtotals

• Data, Sort

How do you wrap the text in a cell?

• Format cells > Font

• Format cells > Protection

• Format cells > Number

• Format cells > Alignment