1._________________is a spreadsheet program that allows you to store, organize, and analyze information
1 point
A.Excel
B.Powerpoint
C.Word
D.Publisher
2.The______________________ lets you access common commands no matter which tab you are on
1 point
A.Quick Access toolbar
B.Ribbon
C.Tab
D.Group Category
3.All formula in excel starts with
1 point
A.@
B.=
C.*
D.&
4.Which function in Excel tells how many numeric entries are there ?
1 point
A. NUM
B. COUNT
C. SUM
D. CHKNUM
5.In Excel, Columns are labelled as.
1 point
A. A, B, C, etc
B. 1,2,3 etc
C. A1, A2, etc.
D. $A$1, $A$2, etc.
6.The process of arranging the items of a column in some sequence or order is known as :
1 point
A. Arranging
B. Auto fill
C. Sorting
D. Filtering
7.The ____ feature of MS Excel quickly completes a series of data
1 point
A. Auto Complete
B. Auto Fill
C. Fill Handle
D. Sorting
8.The basic unit of a worksheet into which you enter data in Excel is called a
1 point
A. cell
B. table
C. box
D. column
9.How many sheets are there, by default, when we create a new Excel file ?
1 point
A.four worksheets
B.one worksheets
C.two worksheets
D.three worksheets
10.An Excel file is generally called a / an :
1 point
A. E-Spreadsheet
B. Worksheet
C. Workbook
D. Sheet
11 .The ________________ tells you the location or the name of a selected cell.
1 point
A. Namebox
B. Worksheet
C. Workbook
D. Sheet
12.In the _______________bar, you can enter or edit data, a formula, or a function that will appear in a specific cell
1 point
A.formula
B. Worksheet
C. Workbook
D. Sheet
13.__________________ is selected by default and shows you an unlimited number of cells and columns
1 point
A.Normal view
B. Page Layout view
C. Page Break view
D. Outline View
14. _________________ lets you see an overview of your spreadsheet, which ishelpful when you're adding page breaks.
1 point
A.Normal view
B. Page Layout view
C. Page Break view
D. Outline View
15.The address of a cell or cell reference can be written by combining the letter representing a column and the number representing a row.
1 point
A.Cell reference
B. Cell
C. Row & Columns
D. Cell pointer
16.Aligns text to the left of the cell
1 point
A.Align Text Left
B. Ctrl + L
C. Left Arrow
D. Both A & B
17.Which displays the document name followed by a program name?
1 point
A.Title bar
B. Word pad
C. Scroll bar
D. All of the above
18.Click ____________ to create a new blank worksheet.
1 point
A.New
B. Save
C. Open
D.Save as
19.______________ allow you to quickly& easily find an average, highest number etc
1 point
A.Format
B. Functions
C. Both a& b
D.None of the above
20.Identifies the smallest number in a range of cells
1 point
A.Min
B. Max
C. Small
D.least
21.Calculates the number of days between two dates based on a360-day year
1 point
A.Date
B. Day of Week
C. Days360
360
22.. Sort ascending means ____________ order
1 point
A.A- Z
B. Z -A
C. Custom Sort
D.None of the above
23. A_______________ chart compares the aggregate values of a number of data series
1 point
A.Surface
B.Doughnut
C.Bubble
D.Radar
24.An __________________ is the cell range or cell references that are enclosed by parentheses.
1 point
A. argument
B.chart
C.Sorting
D.Printing
25.If there is more than one argument, separate each by a _____________
1 point
" "
' '
*
,
26.Each function has a specific order, called _______________,
1 point
A.Formula
B.Syntax
C. Symbol
D.Method
27.An _________________ is the cell range or cell references that are enclosed by parentheses
1 point
A.Formula
B.Syntax
C. Symbol
D.argument
28.________________ are predefined formulas and are already available in Excel.
1 point
A.Formula
B.Syntax
C. Symbol
D.Functions
29.If the result of a formula is too large to be displayed in a cell, it may appear as
30.Excel literally has hundreds of different ___________________ to assist with your calculations.
1 point
A.Function
B.argument
C.Operators
D.None of the above
Page 2 of 5
Answers
Answer:
1. Excel
2. Quick Access Toolbar
3. =
4. COUNT
5. A, B, C
6. Sorting
Explanation:
Bro, have you given the whole question, answer others yourself
1. Excel is a spreadsheet program that allows you to store, organize, and analyze information.
A. Excel
2. The Quick Access Toolbar lets you access common commands no matter which tab you are on.
A. Quick Access Toolbar
3. All formula in excel starts with =
B. =
4. COUNT function in Excel tells how many numeric entries are there.
B. COUNT
5. In Excel, Columns are labelled as A, B, C, etc.
A. A, B, C, etc.
6. The process of arranging the items of a column in some sequence or order is known as Sorting.
C. Sorting
7. The Auto Fill feature of MS Excel quickly completes a series of data.
B. Auto Fill
8. The basic unit of a worksheet into which you enter data in Excel is called a cell.
A. cell
9. There are three worksheets, by default, when we create a new Excel file.
D. three worksheets
10. An Excel file is generally called a / an Workbook
C. Workbook
11. The Namebox tells you the location or the name of a selected cell.
A. Namebox
12. In the formula bar, you can enter or edit data, a formula, or a function that will appear in a specific cell.
A. formula
13. Normal view is selected by default and shows you an unlimited number of cells and columns
A. Normal view
14. Page Break view lets you see an overview of your spreadsheet, which is helpful when you're adding page breaks.
C. Page Break view
15. The address of a cell or cell reference can be written by combining the letter representing a column and the number representing a row.
A. Cell reference
16. Align Text Left or Ctrl + L aligns text to the left of the cell
D. Both A & B
17. Title bar displays the document name followed by a program name?
A. Title bar
18. Click New to create a new blank worksheet.
A. New
19. Functions allow you to quickly & easily find an average, highest number, etc.
B. Functions
20. MIN identifies the smallest number in a range of cells
A. MIN
21. DAYS360 calculates the number of days between two dates based on a 360-day year.
C. DAYS360
22. Sort ascending means A-Z order.
A. A-Z
23. A Radar chart compares the aggregate values of a number of data series.
D. Radar
24. An argument is the cell range or cell references that are enclosed by parentheses.
A. argument
25. If there is more than one argument, separate each by a comma(,)
D. ,
26. Each function has a specific order, called Syntax.
B. Syntax
27. An argument is the cell range or cell references that are enclosed by parentheses
D. argument
28. Functions are predefined formulas and are already available in Excel.
D. Functions
29. If the result of a formula is too large to be displayed in a cell, it may appear as pound signs (#######) instead of a value.
30. Excel literally has hundreds of different functions to assist with your calculations.
A. function
Extra Information
In Excel, columns are named as A, B, C, D, E, F, and so on.
In Excel, rows are named as 1, 2, 3, 4, 5, 6, and so on.
Cells in an Excel sheet are made with intersections of rows and columns.
Cell Address is used to identify cell on an Excel Sheet and Cell Address comprises of a letter and a number. The letter shows the column and the number shows the row.
Example
A1
In this, it is the cell that is present in column A and row 1.
D6
In this, it is the cell that is present in column D and row 6.
Function is a predefined formula that allows users to perform mathematical, statistical, and logical operations.
There are various functions in Microsoft Excel some of them are:
1. SUM
2. AVERAGE
3. COUNT
4. IF
5. MAX
6. MIN
Format of writing a function in a cell of Excel Spreadsheet:
= Name of Function (Range of Cells)
Example
Suppose you want to add values present in cells from A1 to A5 and display the sum in A6.
First, write the values in A1 to A5 and then click on A6 cell and type=SUM(A1:A5)
After that press "Enter"
In the A6 cell, you will get the sum of values present in cells from A1 to A5.
In case you have typed the wrong formula or want to modify it then you can click on the cell where you have written the formula and there will be a Formula Bar available above the worksheet area which will show the formula which you have written in the cell and you can edit it.